Moving between two Oracle Homes


I have two Oracle versions installed on my system. Database Management Software Oracle 11.2.0.1 and Database Management Software 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
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>

1 comment:

  1. Thanks designed for sharing such a pleasant thought, post is pleasant, thats why i have read it
    fully

    Feel free to surf to my web blog - simply click the following internet site

    ReplyDelete