}Agoravamos para instalacao do Oracle 11.2.0.3, antes de iniciar criei o diretorio de destino dos binarios da release 11.2.0.3/db_1. p { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { }a:link { color: rgb(0, 0, 255); }[root@ora-rac01/]# mkdir p /u01/app/oracle/product/11.2.0.3/db_1[root@ora-rac01/]# chown R oracle:oinstall 11.2.0.3/db_1p { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { }a:link { color: rgb(0, 0, 255); }Emseguida alterei o meu bash_profile para carregar o novo caminho davariavel ORACLE_HOME, depois descompactei os binario do Oracle einiciei o instalador.p { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { }a:link { color: rgb(0, 0, 255); }[oracle@ora-rac01~]$ source dath.env [oracle@ora-rac01~]$ echo $ORACLE_BASE/u01/app/oracle[oracle@ora-rac01~]$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0.3/db_1[oracle@ora-rac01binarios]$ ls -lthortotal2,4G-rwxr-xr-x1 oracle 1,3G Mar 9 15:10 p10404530_112030_Linux-x86-64_1of7.zip-rwxr-xr-x1 oracle 1,1G Mar 9 15:11 p10404530_112030_Linux-x86-64_2of7.zip[oracle@ora-rac01binarios]$ unzip p10404530_112030_Linux-x86-64_1of7.zip [oracle@ora-rac01binarios]$ unzip p10404530_112030_Linux-x86-64_2of7.zip [oracle@ora-rac01binarios]$ ls -lthortotal2,4Gdrwxr-xr-x8 oracle 4,0K Set 22 2011 database-rwxr-xr-x1 oracle 1,3G Mar 9 15:10 p10404530_112030_Linux-x86-64_1of7.zip-rwxr-xr-x1 oracle 1,1G Mar 9 15:11 p10404530_112030_Linux-x86-64_2of7.zip[oracle@ora-rac01binarios]$ cd database/[oracle@ora-rac01database]$ lsdoc install readme.html response rpm runInstaller sshsetup stage welcome.html[oracle@ora-rac01database]$ ./runInstaller p { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { }a:link { color: rgb(0, 0, 255); }root@ora-rac01~]# cd /u01/app/oracle/product/11.2.0.3/db_1/[root@ora-rac01db_1]# ./root.sh Performingroot user operation for Oracle 11g Thefollowing environment variables are set as: ORACLE_OWNER=oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0.3/db_1Enterthe full pathname of the local bin directory: [/usr/local/bin]: Thecontents of "dbhome" have not changed. No need tooverwrite.Thecontents of "oraenv" have not changed. No need tooverwrite.Thecontents of "coraenv" have not changed. No need tooverwrite.Entrieswill be added to the /etc/oratab file as needed byDatabaseConfiguration Assistant when a database is createdFinishedrunning generic part of root script.Nowproduct-specific root actions will be performed.Finishedproduct-specific root actions.[root@ora-rac01db_1]# [root@ora-rac02~]# cd /u01/app/oracle/product/11.2.0.3/db_1/[root@ora-rac02db_1]# ./root.sh Performingroot user operation for Oracle 11g Thefollowing environment variables are set as: ORACLE_OWNER=oracle ORACLE_HOME= /u01/app/oracle/product/11.2.0.3/db_1Enterthe full pathname of the local bin directory: [/usr/local/bin]: Thecontents of "dbhome" have not changed. No need tooverwrite.Thecontents of "oraenv" have not changed. No need tooverwrite.Thecontents of "coraenv" have not changed. No need tooverwrite.Entrieswill be added to the /etc/oratab file as needed byDatabaseConfiguration Assistant when a database is createdFinishedrunning generic part of root script.Nowproduct-specific root actions will be performed.Finishedproduct-specific root actions.p { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; widows: 2; orphans: 2; }p.western { }a:link { color: rgb(0, 0, 255); }Comovoces mesmo visualizaram, instalei somente o software de banco dedados e nao iniciei ainda o upgrade do banco. No proximo passo vouexecutar o upgrade do banco de dados manualmente, ou seja efetuaremosvia script. [oracle@ora-rac01 dbs]$ lshc_dath1.dat hc_DBUA0.dat initdath1.ora init.ora orapwdath1 snapcf_dath1.f[oracle@ora-rac01 dbs]$ cp orapwdath1 /u01/app/oracle/product/11.2.0.3/db_1/dbs/[oracle@ora-rac01 dbs]$ cd /u01/app/oracle/product/11.2.0.3/db_1/dbs/[oracle@ora-rac01 dbs]$ lsinit.ora orapwdath1[oracle@ora-rac01 dbs]$[oracle@ora-rac01 dbs]$ cd /u01/app/oracle/product/11.2.0.2/db_1/network/admin/[oracle@ora-rac01 admin]$ lssamples shrept.lst tnsnames.ora[oracle@ora-rac01 admin]$ cp tnsnames.ora /u01/app/oracle/product/11.2.0.3/db_1/network/admin/[oracle@ora-rac01 admin]$ cd /u01/app/oracle/product/11.2.0.3/db_1/network/admin/[oracle@ora-rac01 admin]$ lssamples shrept.lst tnsnames.ora[oracle@ora-rac01 admin]$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.2/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.DATH = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora-rac-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dath) ) )SQL> show parameter spfileNAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string +DATA/dath/spfiledath.oraSQL> create pfile='/home/oracle/initdath1.ora' from spfile;File created.SQL> #*.cluster_database=true*.compatible='11.2.0.0.0'*.control_files='+DATA/dath/controlfile/current.261.850748285','+DATA/dath/controlfile/current.260.850748285'*.db_block_size=8192*.db_create_file_dest='+DATA'*.db_domain=''*.db_name='dath'*.db_recovery_file_dest_size=4227858432*.db_recovery_file_dest='+RECO'*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=dathXDB)'#dath1.instance_number=1#dath2.instance_number=2*.nls_language='BRAZILIAN PORTUGUESE'*.nls_territory='BRAZIL'*.open_cursors=300*.pga_aggregate_target=104857600*.processes=200*.remote_listener='ora-rac-scan:1521'*.remote_login_passwordfile='exclusive'*.sessions=225*.sga_target=524288000#dath2.thread=2#dath1.thread=1#dath2.undo_tablespace='UNDOTBS2'[oracle@ora-rac01 ~]$ srvctl stop database -d dath -o immediate[grid@ora-rac01 ~]$ cd $ORACLE_HOME/bin[grid@ora-rac01 bin]$ pwd/u01/app/11.2.0.3/grid/bin[grid@ora-rac01 bin]$ ./setasmgidwrap o=/u01/app/oracle/product/11.2.0.3/db_1/bin/oracle[grid@ora-rac01