Two different oracle versions in same server Options

[PVVinod]

I had installed Oracle 11g R1 on windows system where Oracle 10g R2 also installed. As I required both versions parallel on same server, both are installed on different Oracle homes.

Configured listener.ora & tnsnames.ora files on 11g (path) with 10g details also in same file, checked the listener status, its “READY” & windows services also started but now only I am able to connect Oracle 11g & not able to connect Oracle 10g.

Could you please help me, how to configure so that I can able to connect both VERSIONS separately on the same server.

[burleson]

Hi Vinod,

>> both are installed on different Oracle homes

That's how you do it. You can have dozens of instances on a large server, all on different releases . . .

PLease read, all answers are here!

http://dba-oracle.com/googlesearchsite_pro...s&sa=Search

[PVVinod]

Hi Donald,

Thank you very much for your prompt reply.

As advised, installed 10g & 11g on separate Oracle Homes as given below paths

OraDb10g_home1 : D:\oracle\product\10.2.0\db_1

OraDb11g_home1 : D:\app\vinodp\product\11.1.0\db_1


Listener.ora configured as given below

-----------------------------------------

# listener.ora Network Configuration File: D:\app\vinodp\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\app\vinodp\product\11.1.0\db_1)
(PROGRAM = extproc)
)
)


# For LISTENER 11g

ORCL11 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = D-113009644)(PORT = 1522))
)
)


# For LISTENER 10g

ORCL =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = D-113009644)(PORT = 1521))
)
)



tnsnames.ora configured as given below

---------------------------------------------

# tnsnames.ora Network Configuration File: D:\app\vinodp\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


# ORCL11



ORCL11 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = D-113009644)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl11)
)
)


# LISTENER_ORCL11 =

ORCL11 =
(ADDRESS = (PROTOCOL = TCP)(HOST = D-113009644)(PORT = 1522))



# LISTENER_ORCL10

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = D-113009644)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)



ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = D-113009644)(PORT = 1521))



--------------


After above, given following settings in parameter file


SQL>alter system set LOCAL_LISTENER="(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=D-113009644)(PORT=1522))
(ADDRESS=(PROTOCOL=TCP)(HOST=D-113009644)(PORT=1521)))" scope=BOTH;


Listeners started separately as given below;
-------------------------------------------------

lsnrctl start orcl11

lsnrctl start orcl


listeners started successfully..

----------

After above things try connecting both DB's as given below


sqlplus system/orcl@//D-113009644:1521/orcl - for 10g (not able to connect - status)



sqlplus system/orcl11@//D-113009644:1522/orcl11 - for 11g (able to connect successfully)


Even I tried connecting Oracle 10g DB (instance: orcl) thru Oracle 11g connection - but not able to connect 10g db

Could you please analyze above:

Hope I can expect advice on this, so that i can able to get connect both db's

Your immediate response is very much appreciated

Thank you very much in advance....

[burleson]

Hi

>> Could you please analyze above:

No, sorry I don;t have the time!

This forum is only for answering specific questions.

Like you, I have a job and I'm on my break!

If you have Oracle support you can open a service request here:

http://support.oracle.com

Good Luck!