Shulou(Shulou.com)06/01 Report--

1. Back up the database

Either RMAN or expdp is fine.

2. Backup software directory (node1/2)

Tar-czvf / u01/grid.tar.gz / u01/app/11.2.0/grid-exclude=/u01/app/11.2.0/grid/rdbms/audit/*tar-czvf / u01/database.tar.gz / u01/app/oracle/-- exclude=/u01/app/oracle/admin/orcl/adump/*

3. Backup OCR (node1/2)

[grid@vastdata01 ~] $cd $ORACLE_HOME/ bin [grid @ vastdata01 bin] $pwd/u01/app/11.2.0/grid/bin./crsctl query css votedisk./ocrcheck./ocrconfig-manualbackup./ocrconfig-export ocr.bak

4. Backup OLR (node1/2)

[grid@vastdata01 ~] $tar-cf / home/oracle/backup/ocr/olr.tar / u01/app/11.2.0/grid/cdata

5. Database object check before upgrade

Check for failed objects select object_name,object_type from dba_objects where status='INVALID'; check running job select job,this_date,last_date,instance from dba_jobs_running; stop crontab task about database crontab-l crontab-e check plan job col job_name for A10; col owner for A10; col start_date for A20; col end_date for A20; col repeat_interval for A10 Set linesize 2000 set pagesize 2000 select job_name,owner,start_date,end_date,repeat_interval from dba_scheduler_jobs; View Plan dba Plan job col interval for A20 col what for A30 set linesize 2000 pagesize 2000 select schema_user,job,interval,what from dba_jobs; show parameter job_queue View Automated Task select client_name,job_name,task_name from dba_autotask_client_job

6. Close the database and cluster

Stop listening to lsnrctl stop stop database shutdown immediate; stop cluster crsclt stop crs

7. Close the EM agent process (oracle, each node)

Cd $ORACLE_HOME/bin./emctl stop dbconsole

8. Create an OCM file (node1/2)

[grid@vastdata01 ~] $cd / u01/app/11.2.0/grid/OPatch/ocm/bin/ [grid@vastdata01 bin] $. / emocmrsp

9. Set up a patch storage directory

10. Backup and replace OPatch

11. Patch change permissions

Chown-R grid:oinstall psups-ef | grep zjprd1 | grep LOCAL=NO | grep-v grep | awk'{print $2}'| xargs kill-9/usr/sbin/slibclean-AIX needs to be cleaned manually Note: / tmp and / directory have at least 10 GB of space

12. Apply patches

Root/oracle/grid/crs/install/rootcrs.pl-unlockGI/oracle/grid/OPatch/opatch napply-oh / oracle/grid/-local / quest/psu/17592127/ oracle/grid/OPatch/opatch apply-oh / oracle/grid/-local / quest/psu/20760997DBsu-oracle/quest/psu/17592127/custom/server/17592127/custom/scripts/prepatch.sh-dbhome / oracle/app/oracle/product/11.2.0/db_1//oracle/app/oracle/product / 11.2.0/db_1/OPatch/opatch napply-oh $ORACLE_HOME-local / quest/psu/17592127/custom/server/17592127/oracle/app/oracle/product/11.2.0/db_1/OPatch/opatch apply-oh $ORACLE_HOME-local / quest/psu/20760997/quest/psu/17592127/custom/server/17592127/custom/scripts/postpatch.sh-dbhome / oracle/app/oracle/product/11.2.0/db_1/root/oracle/ Grid/rdbms/install/rootadd_rdbms.sh/oracle/grid/crs/install/rootcrs.pl-patchchown oracle:asmadmin $ORACLE_HOME/bin/oraclechmod 6751 $ORACLE_HOME/bin/oracle

13. Inspection

Su-grid$ORACLE_HOME/OPatch/opatch lspatchesexitsu-oraclecd $ORACLE_HOME/rdbms/adminsqlplus / as sysdba@catbundle.sql psu applyselect * from registry$history

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.