Search This Blog

Tuesday, February 26, 2008

Managing multiple ORACLE_HOME on same machine

1. Can we install different oracle version on same machine.
like Oracle 8i,9i or 10g.


Answer: Yes you can install.


2. Can we create multiple database/instance on single machine
like :db1,db2,db3 and so on.


Answer: Yes you can create multiple database on same/single machine.



3. Suppose we install oracle 8i,9i or 10g on same machine then how we use set ORACLE_SID,ORACLE_HOME,PATH variable?


Answer: if your using multiple oracle version on same machine then you need to set oracle enviourment variable to point LATEST VERSION.
like
ORACLE_SID=SIDNAME
ORACLE_HOME=10ORACLECHOME
PATH=$ORACHOME/bin(10G)
TNS_ADMIN=$ORACLE_HOME/network/admin(10g)


4.How we can configure LISTENER.ORA or which listener.ora file we use for three different version.


Answer: There is two option for this.
1. create separate listener.ora file for all three version
like
listener with default port(1521)
listener1 with separate port
listener2 with separate port

or

2. Use only one listener.ora file for all three oracle home.
Stop listener services of Oracle 8i,9i database
and create listener.ora file for 10g. and edit 10g listener.ora file and configure for oracle 8i or 9i database.
like below

LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=sale-server)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))

SID_LIST_LISTENER=
(SID_LIST=

(SID_DESC=
(GLOBAL_DBNAME=Ora8i)
(ORACLE_HOME=/oracle8i)
(SID_NAME=Ora8i))

(SID_DESC=
(GLOBAL_DBNAME=Ora9i)
(ORACLE_HOME=/oracle9i)
(SID_NAME=Ora9i))

(SID_DESC=
(GLOBAL_DBNAME=Ora10g)
(ORACLE_HOME=/oracle10g)
(SID_NAME=Ora10g))

(SID_DESC=
(SID_NAME=plsextproc)
(ORACLE_HOME=/oracle10g)
(PROGRAM=extproc)))

4 comments:

Anonymous said...

Keep on posting such themes. I like to read stories like this. BTW add more pics :)

robbie said...

I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.

Lucy

http://cellularaccessoriess.com

Anonymous said...

If I want to have two instances of same version, in two HOMES, how do I do that?
I have /app01/app/oracle/product/10.2.0/db_1 as HOME for the instance1. I want to have /app01/app/oracle/product/10.2.0/db_2 as HOME for the instance2. DO I have to run the oui again? If not how to do this? I am a newbie (only 3 months ) Please help.

Anonymous said...

On your solaris server 5.8 we have 9.2.0 and 10.2.0 oracle databases.now we got a problem that 9i database is working fine and we are unable to access 10g database.ORACLE_HOME is pointing to 9i.By changing the ORACLE_HOME variable to 10g we started the database ,we are connecting to it through sqlplus.but we are unable to connect through service name. The listener is pointing to 9i listener.ora file and the oracle_home entries for 10g and 9i databases are pointing to 9i oracle home.I changed the oracle_home entries in the listener file but still iam unable to acess the database .In profile file we find the entry for oracle_home as 9i oracle_home .Is this the problem due to setting of oracle_home to 9i? please give me suggestions.