Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle upgrade on mscg

mark yeo
Advisor

oracle upgrade on mscg

Hi. I am upgrading my SAP Oracle from 8.1.7 to 9.2.0.5. My instance is on a MSCG with one package. The productive node is PRD while the adoptive node is UAT. Currently,there is a check of disk space required and i have concerns with the below

1) $ORACLE_HOME 3000MB
2) /oracle/stage 3000MB
3) /oracle 500MB

In additional, both (2) and (3) are on root filesystem. I planned to move them out on separate filesystems. My understanding is that for extending, its a normal way of command based. However, for new filesystems, i will have to do more stuff.

My steps are as belows (for filesystem /oracle/stage ) :

1) In PRD, Create new filesystem
lvcreate -L 3200 -n lv92064 /dev/pvg70
newfs -F vxfs /dev/vg01/rpvg70
mount /dev/vg01/rpvg70 /oracle/stage/920_64


2) In PRD, Create a new volume group map file and copy to my UAT.
vgexport -pvs -m /etc/lvmconf/pvg70.map.oracle pvg70
rcp /etc/lvmconf/pvg70.map.oracle UAT:/etc/lvmconf

3) In UAT, record the VG minor number
ll /dev/pvg70/group
crw-rw-rw- 1 root sys 64 0x020000
vgexport -v pvg70

4) In UAT, Recreate the /dev directroy and 'group' file, using the minor number recorded previously
mkdir /dev/pvg70
mknod /dev/pvg70/group c 64 0x020000

5) In UAT, Re-import the volume group, using the map file transferred to the host:
vgimport -vs -m /etc/lvmconf/pvg70.map.oracle pvg70

6) In UAT, make mount directory is Item (1) which is /oracle/stage/920_64

7) In PRD, modify my package control script to add new lvol and mount and distribute.
increment the array number.

8) Copy this to UAT

9) Cheers!


Any other advise?

Cheers!