Translate

Tuesday, 20 December 2011

Moving between two Oracle Homes

I have two Oracle versions installed on my system. Oracle 11.2.0.1 and Oracle 11.2.0.2.

Here are the steps how to switch between them.

Make Oracle 11.2.0.1 as Oracle Home

oracle@suse32:~> cd /opt/oracle/product/11.2/db_1/bin/
oracle@suse32:/opt/oracle/product/11.2/db_1/bin> export ORACLE_HOME=/opt/oracle/product/11.2/db_1 product/11.2/db_1
oracle@suse32:/opt/oracle/product/11.2/db_1/bin> ./sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 7 23:47:37 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

SQL> exit;

oracle@suse32:/opt/oracle/product> ls
11.2 11.2.0.2

Make Oracle 11.2.0.2 as Oracle Home

oracle@suse32:/opt/oracle/product> cd 11.2.0.2/
oracle@suse32:/opt/oracle/product/11.2.0.2> cd db_1/bin/
oracle@suse32:/opt/oracle/product/11.2.0.2/db_1/bin> export ORACLE_HOME=/opt/oracle/product/11.2.0.2/db_1
oracle@suse32:/opt/oracle/product/11.2.0.2/db_1/bin> ./sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Mon Nov 7 23:58:40 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL>

No comments:

Post a Comment