Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Closed TopicStart new topic
> Two different oracle versions in same server
PVVinod
post Feb 15 2012, 10:05 AM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 15-February 12
Member No.: 46,768



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.
Go to the top of the page
 
+Quote Post
burleson
post Feb 15 2012, 11:01 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,640
Joined: 26-January 04
Member No.: 13



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


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
PVVinod
post Feb 17 2012, 01:23 AM
Post #3


Newbie
*

Group: Members
Posts: 2
Joined: 15-February 12
Member No.: 46,768



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....



Go to the top of the page
 
+Quote Post
burleson
post Feb 17 2012, 09:54 AM
Post #4


Advanced Member
***

Group: Members
Posts: 11,640
Joined: 26-January 04
Member No.: 13



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!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 1st November 2014 - 05:17 AM