| Two Oracle Installs 10G and 11G [message #510574] |
Mon, 06 June 2011 10:51  |
 |
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  |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
