CATATAN CORETAN CONTEKAN DAN COPASAN: Upgrade 10.2.0.1 to 11.2.0.3

Step Upgrade 10.2.0.1 to 11.2.0.3

1. Upgrade 10.2.0.1 to 10.2.0.4

2. upgrade 11.2.0.4 to 11.2.0.3

Backup database

RMAN> backup database format '/home/pstest/oradv1_t%t_s%s_p%p';

Shutdown database

[pstest@obasvr01 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 19 15:31:16 2012

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

Matikan Listener

[pstest@obasvr01 ~]$ lsnrctl stop TEST

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 19-SEP-2012 15:32:47

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=obasvr01.ssi.co.id)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TEST)(UR=A)))

The command completed successfully

Check service database

[pstest@obasvr01 ~]$ ps -ef | grep pstest

Upgrade 10.2.0.1 to 10.2.0.4

[pstest@obasvr01 Disk1]$ ./runInstaller

ERROR:

if any errors like "error in invoking ....." . compile the lib file manually as a oracle user using the following command.

[oracle@localhost bin]$ make -f /ora10gsoft/10.2.0/network/lib/ins_net_client.mkBuilding client shared library libclntsh.so ...
Call script /ora10gsoft/10.2.0/bin/genclntsh ...
/ora10gsoft/10.2.0/bin/genclntsh
genclntsh: genclntsh: Could not locate /ora10gsoft/10.2.0/network/admin/shrept.lst
make: *** [/ora10gsoft/10.2.0/lib/libclntsh.so] Error 1

Note : create a "/ora10gsoft/10.2.0/network/admin/shrept.lst" file manually with any content or blank

[oracle@localhost bin]$ make -f /ora10gsoft/10.2.0/network/lib/ins_net_client.mk
Building client shared library libclntsh.so ...
Call script /ora10gsoft/10.2.0/bin/genclntsh ...
/ora10gsoft/10.2.0/bin/genclntsh
Built /ora10gsoft/10.2.0/lib/libclntsh.so ... DONE

Then press retry in the ERROR showed in popup window

[root@obasvr01 ~]# sh /u03/TEST/oracle/product/10.2.0/db_1/root.sh

Running Oracle10 root.sh script...

The following environment variables are set as:

ORACLE_OWNER= pstest

ORACLE_HOME= /u03/TEST/oracle/product/10.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]: y

Copying dbhome to /usr/local/bin ...

The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]: y

Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)

[n]: y

Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Jalankan envirement

[pstest@obasvr01 ~]$ more db.env

ORACLE_BASE=/u03/TEST/; export ORACLE_BASE

ORACLE_HOME=/u03/TEST/oracle/product/10.2.0/db_1; export ORACLE_HOME

ORACLE_SID=TEST; export ORACLE_SID

PATH=/usr/sbin:$PATH; export PATH

PATH=/u03/TEST/oracle/product/10.2.0/db_1/bin:$PATH; export PATH

[pstest@obasvr01 ~]$ dbua

Compile Object

upgrade 11.2.0.4 to 11.2.0.3

SQL> CREATE TABLESPACE SYSAUX DATAFILE '/u03/TEST/oradata/TEST/sysaux01.dbf'SIZE 500M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE;

ATAU

Jika sudah ada tablespace SYSAUX di resize

SQL> shutdown immediate

[pstest@obasvr01 database]$ lsnrctl stop

Install Software Only

[pstest@obasvr01 database]$ ./runInstaller