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

Stop listening (dual-node grid execution)

Lsnrctl stop

Check to see if the application is connected (dual-node root execution)

Ps-ef | grep rac | grep LOCAL=NO

Create a directory (dual-node root execution)

Mkdir-p / u01/app/11.2.0.4/

Chown-R grid:oinstall / u01/app/11.2.0.4/

Upload compressed package and decompress it (node-1 root execution)

Mkdir-p / tmp/update/

Chmod-R 777 / tmp/update/

Su-grid

Cd / tmp/update/

Unzip p13390677_112040_Linux-x86-64_3of7.zip

Cluster pre-upgrade check (dual-node root execution)

Node 1 (grid):

Cd / tmp/update/grid/

/ tmp/update/grid/runcluvfy.sh stage-pre crsinst-upgrade-n rac1,rac2-rolling-src_crshome / u01/app/11.2.0/-dest_crshome / u01/app/11.2.0.4/-dest_version 11.2.0.4.0-fixup-fixupdir / tmp

Su-root

/ tmp/CVU_11.2.0.4.0_grid/runfixup.sh

Node 2:

Su-root

/ tmp/CVU_11.2.0.4.0_grid/runfixup.sh

Upgrade cluster software (node 1 root execution)

Unset ORACLE_HOME ORACLE_BASE ORACLE_SID

Cd / tmp/update/grid/

. / runInstaller

1. Select Skip software updates

two。 Select Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management

3. Next step

4. Next step

5.software Location input / u01/app/11.2.0.4/grid

6. Installation

7.76% execution script is executed by two nodes in turn

Cluster software upgrade completed, modify environment variables (dual-node grid execution)

Vi .bash _ profile

ORACLE_HOME=/u01/app/11.2.0.4/grid

Check snooping (dual node grid execution)

Node one:

Lsnrctl status

Verify the upgraded version (dual-node grid execution)

Crsctl query crs softwareversion

Oracle Clusterware version on node [mailwwdb1] is [11.2.0.4.0]

Crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [11.2.0.4.0]

Crsctl query crs releaseversion

Oracle High Availability Services release version on the local node is [11.2.0.4.0]

Stop listening (dual-node grid execution)

Lsnrctl stop

Check to see if the application is connected (dual-node root execution)

Ps-ef | grep rac | grep LOCAL=NO

Create a directory (dual-node root execution)

Mkdir-p / u01/app/oracle/product/11.2.0.4

Chown-R oracle:oinstall / u01/app/oracle/product/11.2.0.4

Upload compressed package and decompress it (node-1 root execution)

Su-oracle

Cd / tmp/update/

Unzip p13390677_112040_Linux-x86-64_1of7.zip

Unzip p13390677_112040_Linux-x86-64_2of7.zip

Upgrade database software (node 1 oracle execution)

Cd / tmp/update/database/

. / runInstaller

1. Uncheck I wish to receive security...

two。 Select Skip software updates

3. Select Install database software only

4. Next step

5. Next step

6. Next step

7.software Location input / u01/app/oracle/product/11.2.0.4/db_1

8. Select dba/oinstall

9. Ignore the next step

10. Installation

Pre-check upgrades, new software scripts check old directories (node 1 oracle execution)

Sqlplus / as sysdba

@ / u01/app/oracle/product/11.2.0.4/db_1/rdbms/admin/utlu112i.sql

Modify as needed:

Alter system set cluster_database=FALSE scope=spfile

PURGE DBA_RECYCLEBIN

EXECUTE dbms_stats.gather_dictionary_stats

Events:

SELECT (translate (value,chr (13) | | chr (10),'') FROM sys.v$parameter2

WHERE UPPER (name) = 'EVENT' AND isdefault='FALSE'

Trace Events:

SELECT (translate (value,chr (13) | | chr (10),'') from sys.v$parameter2

WHERE UPPER (name) ='_ TRACE_EVENTS' AND isdefault='FALSE'

Check for invalid objects (node 1 oracle execution)

Select object_name,owner,object_type from dba_objects where status='INVALID'

Shut down the database (dual-node oracle execution)

Sqlplus / as sysdba

Shutdown immediate

Modify environment variables (dual-node oracle execution)

Vi .bash _ profile

ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db_1

Copy listening files and parameter files (dual-node oracle execution)

Cp-r / u01ActionActionActionProduct 11.2.0Uniplication1anddbsAction1According to * / u01/app/oracle/product/11.2.0.4/db_1/dbs/

Cp-r / u01According to an oracleproduct 11.2.0According to the networkAccord admin u01/app/oracle/product/11.2.0.4/db_1/network/admin/ *

Confirm that the environment variable is in effect (dual-node oracle execution)

Which sqlplus

/ u01/app/oracle/product/11.2.0.4/db_1/bin/sqlplus

Echo $ORACLE_HOME

/ u01/app/oracle/product/11.2.0.4/db_1

Modify / etc/oratab to a new directory (dual-node oracle execution)

Vi / etc/oratab

+ ASM1:/u01/app/11.2.0.4/grid:N # line added by Agent

Rac:/u01/app/oracle/product/11.2.0.4/db_1:N # line added by Agent

Execute the upgrade script (node 1 oracle execution)

Startup upgrade

Spool / tmp/oracle.txt

@ / u01/app/oracle/product/11.2.0.4/db_1/rdbms/admin/catupgrd.sql

Spool off

If you encounter permission problems:

(As the:

$cd / bin

$. / setasmgidwrap o=/bin/oracle

Grid user

Cd $ORACLE_HOME/bin

. / setasmgidwrap o=/u01/app/oracle/product/11.2.0.4/db_1/bin/oracle

Start the database in normal mode (node 1 oracle execution)

Sqlplus / as sysdba

Startup

@ $ORACLE_HOME/rdbms/admin/catuppst.sql

@ $ORACLE_HOME/rdbms/admin/utlrp.sql

Confirm database invalid objects and upgrade information (node 1 oracle execution)

Select object_name,object_type,owner from dba_objects where status='INVALID'

Select comp_name,version from dba_registry

Modify cluster_database and start the database (node 1 oracle execution)

Node one:

Show parameter cluster_database

Cluster_database Boolean FALSE

Alter system set cluster_database=TRUE scope=spfile

Shutdown immediate

Startup

Start the database (Node 2 oracle execution)

Sqlplus / as sysdba

Startup

Modify cluster information (node 1 oracle execution)

Srvctl upgrade database-d rac-o $ORACLE_HOME

Srvctl config database-d rac

Modify cluster information (node-grid execution)

Crsctl stat res-t

Srvctl start instance-d rac-I rac1

Srvctl start instance-d rac-I rac2

Crsctl stat res-t

Srvctl stop database-d rac

Crsctl stat res-t

Srvctl start database-d rac

Crsctl stat res-t

Check and verify GI version and cluster resource status (dual-node grid execution)

Node one:

Su-grid

Crsctl query crs softwareversion

Crsctl stat res-t

Check the database version (dual-node oracle execution)

Sqlplus / as sysdba

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.