ITPub博客

root # mkdir /tmp/1root # mkdir /tmp/2root # mkdir /tmp/3root # mkdir /tmp/4 /tmp/5root # pwd/mnt/inst/RHEL4-U4-x86_64/rhel4u4root # lofiadm -a /mnt/inst/RHEL4-U4-x86_64/rhel4u4/RHEL4-U4-x86_64-AS-disc1.iso /dev/lofi/1root # lofiadm -a /mnt/inst/RHEL4-U4-x86_64/rhel4u4/RHEL4-U4-x86_64-AS-disc2.iso /dev/lofi/2root # lofiadm -a /mnt/inst/RHEL4-U4-x86_64/rhel4u4/RHEL4-U4-x86_64-AS-disc3.iso /dev/lofi/3root # lofiadm -a /mnt/inst/RHEL4-U4-x86_64/rhel4u4/RHEL4-U4-x86_64-AS-disc4.iso /dev/lofi/4root #

1. 创建用户名,组2. 创建相同的目录Datafile redo log arch bdump cdump create udump配置tnsnames.ora listener.ora拷贝pfile 修改,创建spfile3. SQL> startup nomount; ORACLE instance started.Total System Global Area 504856256 bytesFixed Size 741056 bytesVariable Size 167772160 bytesDatabase Buffers 335544320 bytesRedo Buffers 798720 bytes-bash-3.00$ rman target / catalog system/system@inst1002RMAN> set dbid=3157572766executing command: SET

1. install 9208 patch set2. alter system set java_pool_size='150M' scope=spfile;3. shutdown immediate startup4.spool log @?/rdbms/admin/catpatch.sql shutdown immediate startup5. @?/rdbms/admin/utlrp.sql6.cd $ORACLE_HOME/install ./changePerm.sh[@more@]

System Information Source systemOracle: 9.2.0.7Destination SystemOracle: 10.2.0.2 1. run check script on source DB p copy $ORACLE_HOME_10g/rdbms/utlu102i.sql to temporary locationchange to temporary locationrun sqlplus> @utlu102i.sql 2. deactivate jobs p sqlplus '/ as sysdba'>show parameter job>alter system set job_queue_processes = 0;stop all backup jobs 3. create pfile p create pfile=’…’ from spfile; 4. shutdown database p ShutdownCold Data

1.Check package OS AS4 update 4rpm 版本必须高于下面的版本，使用rpm –qa | grep 查询compat-db-4.1.25-9 compat-gcc-32-3.2.3-47.3 compat-gcc-32-c++-3.2.3-47.3 compat-libgcc-296-2.96-132.7.2 compat-libstdc++-296-2.96-132.7.2 compat-libstdc++-33-3.2.3-47.3 gcc-3.4.3-9.EL4 gcc-c++-3.4.3-9.EL4 gnome-libs-1.4.1.2.90-44 gnome-libs-devel-1.4.1.2.90-44 libaio-devel-0.3.102-1 libaio-0.3.102-1 make-3.80-5 openmotif21-2.1.30-11 xorg-x11-deprecated-libs-devel-6.8.1-23.EL xorg-x11-deprecated-libs-6.8.1-23.EL 打

1.Check OS packageSUNWarc SUNWlibms SUNWi1of　SUNWbtool 　SUNWsprotSUNWi1cs　SUNWhea SUNWi15cs SUNWlibm　SUNWtoo SUNWxwfnt# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWsprot SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt2. vi /etc/systemset semsys:seminfo_semmni=100#set semsys:seminfo_semmns=1024set semsys:seminfo_semmsl=256#set semsys:seminfo_semvmx=32767set shmsys:shminfo_shmmax=34359738368set shmsys:shminfo_shmmni=1003. #/usr/sbin/groupadd oinstall#/usr/sbin/groupadd dba# /usr/