Sponsored Content
Full Discussion: aix 61 and oracle 11
Operating Systems AIX aix 61 and oracle 11 Post 302424385 by bakunin on Tuesday 25th of May 2010 06:00:51 AM
Old 05-25-2010
From 5.3 to 6.1 there hasn't changed that much (in this regard), so everything said for tuning AIX 5.3 is valid for AIX 6.1 too. You might want to consult this link from our list of useful links here.

You certainly will need to configure asynchronous I/O. I don't know Oracle 11 all that well, but i suppose you need to configure both legacy aio as well as posix_aio.

<the original part dealing with Asynchronous I/O deleted because it was outdated information>

Regarding the volume group layout: i'm not sure if this makes sense at all. ou don't need to put logs and application data into a several volume groups, in fact it would be easier to administrate if you had only one VG. You could (and should!) still put logs and data on as many disks as possible simultaneously to enhance performance, but that doesn't mean they should go in different VGs. VGs are logical containers to group logical volumes (roughly: file systems) together because they belong together logically.

There is a case to be made to put the archive logs in a separate VG: if you regularly use the data in another server (for backup purposes, for instance) you might consider putting these into a separate volume group to handle this. You could then umount the filesystem with the archive logs, export the VG, import it on another server, backup the data and reimport/remount it on the DB server.

If you don't do such a thing then the archive logs should become part of the DB VG either.

Regarding optimization for disk I/O: as i have already written optimizing (physical) disk I/O is mostly about distributing the read/write-operations over as many physical disks as possible. Further, you should only optimize on one place, because optimizing on several places simultaneously is likely not to enhance anything but runs the (small) risk of having adverse effects (see here). If you still need disk I/O optimization after having employed all possible options at the SAN level you could - very carefully! - try to optimize further on the LVM level, but it is more likely than not that the SAN will give you all the performance you need without having to resort to other means.

I hope this helps.

bakunin

Last edited by bakunin; 05-25-2010 at 08:34 AM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

aix-oracle

what is the reason oracle is giving ora-600 space leak error? how to rectify this error? (6 Replies)
Discussion started by: varadakumar
6 Replies

2. UNIX for Advanced & Expert Users

Oracle and AIX

Hi @all Who's able to help me? I've a running Oracle DB on AIX 4.3.3. You've also an Oracle Client running for this. So however, how it's possible, that I can see the CURRENT VERSION of my Oracle CLIENT. I've tried several things, but it doesn't work. Thanks a lot! Regards Oliver :( :( (4 Replies)
Discussion started by: olli2002
4 Replies

3. AIX

oracle 9i on AIX 5.2

Hello, mornig can you help me whit this error: "Oracle Universal Installer cannot be run" and i can't start the installation of ORACLE 9i... see you later (1 Reply)
Discussion started by: joseantoniohv
1 Replies

4. AIX

AIX 6.1 and Oracle 9.2.0

Hi All, I need to update some AIX servers from 5.2 to 5.3 OR 6.1 . The management is pressing for 6.1, but on our systems runs Oracle 9.2.0 . I couldn't find any clear warning about the possibility of compatibility issues between AIX 6.1 and Oracle 9.2.0 but, on the other hand, I couldn't find... (0 Replies)
Discussion started by: padawan75
0 Replies

5. AIX

Aix, Oracle and Java

Hello Im trying to install oracle on my AIX 5.3 server. Im doing all things right as Oracle says... When im trying to run the instalation it gives me an error about JRE. But i already have JRE installed as you can see... Someone can help me or guide me? Im new in with this.. ... (1 Reply)
Discussion started by: gfca
1 Replies

6. AIX

oracle 10g on AIX 5

hi can anyone help me by telling step by stem oracle10g installation in AIX 5 . Munir mondolsoft Bangladesh (3 Replies)
Discussion started by: dbamunir
3 Replies

7. AIX

AIX to Windows Oracle DB

Dear All, I have a requirement where there are applicaions installed in Unix machine that has to update a set of Oracle data base installed in Windows machine, the question I have here is, which protocol alows Unix application to interact with Database in Windows env. and do we require some... (2 Replies)
Discussion started by: prav_06
2 Replies

8. AIX

Oracle 9.2.0.1.0 on AIX 5300-07

Seek help from all of the experts here. Database Oracle 9.2.0.1.0 run on AIX 5300-07. The system is running so slow that sometime 1 click of changing screen will take more than 5 minutes. The hardware in this LPAR is 6CPUs, 21GB-RAM, 42GB-Paging and run on p570 server POWER 5+. And the vmo... (2 Replies)
Discussion started by: kwliew999
2 Replies

9. UNIX for Advanced & Expert Users

Oracle RAC on AIX

I am setting this up on 5.3 and the problem is I cannot remember how to allocate two IP addresses to a NIC. I have setup an alias on EN0 but when I list it with ifconfig -a it still only shows 1 network address (after a reboot). I know there is something I must do but for the life of me cannot... (1 Reply)
Discussion started by: johnf
1 Replies

10. AIX

AIX and Oracle

Hello All, I was approached by DBAs, and they want me to create a large_page on AIX and also change oracle file systems to CIO. They are complaining the system is taking longer time for processing and we are unnecessary wasting memory and CPU for file system cache. To do that I have to change... (12 Replies)
Discussion started by: m6248m
12 Replies
vgchgid(1M)															       vgchgid(1M)

NAME
vgchgid - modify the Volume Group ID (VGID) on a given set of physical devices SYNOPSIS
PhysicalVolumePath [PhysicalVolumePath] ... DESCRIPTION
The command is designed to change the LVM Volume Group ID (VGID) on a supplied set of disks. will work with any type of storage, but it is primarily targeted at disk arrays that are able to create "snapshots" or "clones" of mirrored LUNs. accepts a set of raw physical devices and ensures that they all belong to the same volume group, before altering the VGID (see section). The same VGID is set on all the disks and it should be noted that in cases of multi-PV volume groups, all the physical volumes should be supplied in a single invocation of the command. Options recognizes the following options and arguments: PhysicalVolumePath The raw devices path name of a physical volume. Background Some storage subsystems have a feature which allows a user to split off a set of mirror copies of physical storage (termed or just as LVM splits off logical volumes with the command. As the result of the "split," the split-off devices will have the same VGID as the original disks. is needed to modify the VGID on the BCV devices. Once the VGID has been altered, the BCV disks can be imported into a new volume group by using WARNINGS
Once the VGID has been changed, the original VGID is lost until a disk device is re-mirrored with the original devices. If is used on a subset of disk devices (for example, two out of four disk devices), the two groups of disk devices would not be able to be imported into the same volume group since they have different VGIDs on them. The solution is to re-mirror all four of the disk devices and re-run on all four BCV devices at the same time, and then use to import them into the same new volume group. If a disk is newly added to an existing volume group and no subsequent LVM operations has been performed to alter the structures (in other words, operations which perform an automated vgcfgbackup(1M)); then it is possible a subsequent will fail. It will report that the disk does not belong to the volume group. This may be overcome by performing a structure changing operation on the volume group (for example, using It is the system administrator's responsibility to make sure that the devices provided in the command line are all Business Copy volumes of the existing standard physical volumes and are in the ready state and writable. Mixing the standard and BC volumes in the same volume group can cause data corruption. RETURN VALUE
returns the following values: 0 VGID was modified with no error 1 VGID was not modified EXAMPLES
An example showing how might be used: 1. The system administrator uses the following commands to create the Business Continuity (BCV or BC) copy: 1) For EMC Symmetrix disks, the commands are and 2) For XP disk array, the commands are and Three BCV disks are created. 2. Change the VGID on the BCV disks. 3. Make a new volume group using the BCV disks. This step can be skipped as the group file will be created automatically. If the file is manually created it will have different major and minor numbers (see lvm(7)). 4. Import the BCV disks into the new volume group. 5. Activate the new volume group. 6. Backup the new volume group's LVM data structure. 7. Mount the associated logical volumes. SEE ALSO
vgimport(1M), vgscan(1M), vgcfgbackup(1M). vgchgid(1M)
All times are GMT -4. The time now is 11:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy