Home » RDBMS Server » Networking and Gateways » Two Oracle Installs 10G and 11G (Redhat 5.5)
Two Oracle Installs 10G and 11G [message #510574] Mon, 06 June 2011 10:51 Go to next message
jchiffons
Messages: 1
Registered: June 2011
Location: Arlington, VA
Junior Member
We're deploying a new product release however this build uses Oracle 11G. We want to perform a side by side install for testing purposes. These are low usage systems so installing another Oracle build will not hinder the system. We intend to test for a couple of weeks and migrate data, then uninstall the 10G. I'm in the process of installing 11G now, the 10G is up and running. I don't want to impact the 10G install. I'm installing 11G in /home/oracle/oracle11G directory. I would like to use 1 Listener.ora file. I've broken down the install bellow.

10G
SID "processing"
Oracle home /home/oracle/oracle10g
/mnt/Oracle/Oracle10GData
/mnt/Oracle/OracleRedoLog

11G
SID "processing11G"
Oracle home /home/oracle/oracle11g
/mnt/Oracle/Oracle11GData
/mnt/Oracle/Oracle11GRedoLog

I've copied the listener.ora file bellow.

LISTENER_PROCESSING =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST= X (PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.2)(PORT = 1521))
)
)
SID_LIST_LISTENER_PROCESSING=
( SID_LIST =
( SID_DESC =
( GLOBAL_DBNAME = processing )
( ORACLE_HOME = /home/oracle/OraHome10g )
( SID_NAME = processing )
)
)



LISTENER_PROCESSING2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = X (PORT = 1522))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.2)(PORT = 1522))
)
)
)
SID_LIST_LISTENER_PROCESSING2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = processing2)
(ORACLE_HOME = /home/oracle/OraHome11G)
)
)

Do I need to specify the databasename for Processing2? Also the front end boxes (managers) are two different servers so Processingweb1 and processingweb2.

Thanks, Jim

[Updated on: Mon, 06 June 2011 11:01]

Report message to a moderator

Re: Two Oracle Installs 10G and 11G [message #510579 is a reply to message #510574] Mon, 06 June 2011 11:44 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Do I need to specify the databasename for Processing2?

Yes or no. You can and you can omit it... if your database registers to the listener.
You can also use SERVICE_NAME or GLOBAL_NAME.
You can also use only one listener.
There are many optioons, please refer to the documentation.

Regards
Michel
Previous Topic: ORA-12155
Next Topic: ORA-02019: connection description
Goto Forum:
  


Current Time: Thu Mar 28 03:27:36 CDT 2024