| Listener crash [message #163373] |
Thu, 16 March 2006 08:28  |
fabiosax
Messages: 15
Registered: March 2006
|
Junior Member |
|
|
Hello there,
I just installed Oracle 9i on my old Solaris Server where I still have oracle 8i installed.
I tried to add the new Service Name (New DB created on Oracle9i) on the oracle 8i listener, but randomly my listener crashes.
So i tried to start the Oracle 9i Listener adding the Oracle 8i services getting the same result.
Can i have both on just one listener? are they compatible?
Hoping to have been clean i thank you in advance.
Regards,
Fabio
|
|
|
|
| Re: Listener crash [message #163924 is a reply to message #163373] |
Mon, 20 March 2006 17:54  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
You can put them both on one listener. But I generally seperate them and give them each a different port, like 1550 and 1560. I make each ORACLE_HOME be owned by a different O/S user. Your client will need to know which port to find the database it wants.
In the .profile, .bash_profile (or however you setup your environmentals) make sure the Oracle_home and Oracle_sid indicate the correct instance and product stack.
On each seperate ORACLE_HOME, go to the network/admin directory. edit the tnsnames.ora, sqlnet.ora, and listenre.ora file to indicate what port each one is on and name the instance and listener owned by that O/S user.
For each O/S user that owns an instance. Start/stop/reload the listener without effecting the other listeners.
'lsnrctl start' or 'lsnrclt stop'
Good luck.
Neil.
[Updated on: Mon, 20 March 2006 17:56] Report message to a moderator |
|
|
|
| Re: Listener crash [message #163989 is a reply to message #163924] |
Tue, 21 March 2006 02:39 |
fabiosax
Messages: 15
Registered: March 2006
|
Junior Member |
|
|
Thanks so much for your answer!!!!!
May i have just one oracle user for both the listener?
Please have a look to the following listener file:
LISTENER9 = LISTENER8 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = salis)( PORT = 1521)
)
)
)
SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(SID_NAME = LISPAG)
(GLOBAL_DBNAME = LISPAG)
(ORACLE_HOME = .......)
)
)
LISTENER8 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = salis)( PORT = 1522)
)
)
)
SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(SID_NAME = IMS)
(GLOBAL_DBNAME = IMS)
(ORACLE_HOME = .......)
)
)
any mistakes?
Thanks in advance for your help....
Regards,
FAbio
|
|
|
|
| Re: Listener crash [message #164071 is a reply to message #163373] |
Tue, 21 March 2006 11:30 |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
>LISTENER9 = LISTENER8 =
I am not sure that is correct
I have never done this so my answers should be taken with that in mind.
I think you are close.
I am not really clear how you want to set up your listener(s).
You want only one listener for both sid's?
You want to shut down one listener and have the other still run?
If you have both sid's on the same listener, then that is not an option.
I think it is eaiser to have two listeners, on different ports, owned by different O/S users for each sid, and log into the O/S as the user that owns that instance to start/stop the listener.
I think you can have mulitple sid's on the same port, using the same listener. I do not know if you can have muliple listeners on the same port.
Do you have Oracle Medalink support?
I would screw around with it a while, making sure not to effect a production listener more than a few seconds, then submit an e-tar to Oracle if I could not get things working.
I am not sure this helps you much, good luck. Post if you have additional questions.
Neil.
[Updated on: Tue, 21 March 2006 11:31] Report message to a moderator |
|
|
|
| Re: Listener crash [message #164203 is a reply to message #163373] |
Wed, 22 March 2006 05:30 |
fabiosax
Messages: 15
Registered: March 2006
|
Junior Member |
|
|
Thanks so much..
I managed to fix it patching my Oracle 9 end creating just one listener for both the SID.
I appreciated your help..
I wish you the best.
Regards,
Fabio
|
|
|
|
| Re: Listener crash [message #164912 is a reply to message #164203] |
Mon, 27 March 2006 09:35 |
Daxesh
Messages: 61
Registered: July 2004
|
Member |
|
|
Hello,
Yes you can have one listener for multiple oracle home. But the key point is ALWAYS run listener in higher Oracle Home. In you case you need to run in oracle 9i home.
Here is the listener file, Which I think you should have
LSNR_ORA9i =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = ORACLE9i_HOST_NAME)
(PORT = ORACLE9iPORT#)
(QUEUESIZE = 50)
)
)
LSNR_ORA8i =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = ORACLE8i_HOST_NAME )
(PORT = ORACLE8iPORT#)
(QUEUESIZE = 50)
)
)
#
SID_LIST_LSNR_ORA9i =
(SID_LIST =
(SID_DESC =
(SID_NAME =ORACLE9iSIDNAME )
(ORACLE_HOME=/home/oracle/product/9.2.0)
)
SID_LIST_LSNR_ORA8i=
(SID_LIST =
(SID_DESC =
(SID_NAME = ORACLE8iSIDNAME)
(ORACLE_HOME=/home/oracle/product/8.0)
)
===================================
Once this file is setup you can start and stop as follow
LSNRCTL> start LSNR_ORA9i
LSNRCTL> stop LSNR_ORA9i
same for 8i listener name.
HTH
Daxesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
