Moving between two Oracle Homes

I have two Oracle versions installed on my system. Database Management Software Oracle and Database Management Software Oracle

Here are the steps how to switch between them.

Make Oracle 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 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

Make Oracle as Oracle Home 

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

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

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


1 comment:

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

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