I recently installed Oracle 9i on Sun 5.8 with the user account 'oracle9i', with its own ORACLE_HOME directory. This machine already has Oracle 8i on a different ORACLE_HOME directory with user account 'oracle8i'. Now when I login into 9i account and issue
$lsnrctl startit starts all the databases on both 8i and 9i versions, and after some time (20 min), when I issue
$lsnrctl statusI get a message:
TNS-12541: TNS no listener. TNS 12560 TNS protocol adapter error TNS-00511: No listener.So, I have to manually start the command again. My questions to you are:
- What could be causing the problem above?
- How do I seperate out the two listeners (8i/9i), in the sense of start/stop options?
- How do I start the two listeners seperately, and how do I start both together?
By default, the listener is named "listener". Your 8i install originally created a "listener" and when you installed 9i you also created a "listener". You can have multiple listeners or you can configure one listener to handle requests to multiple databases. There's several excellent notes on Metalink that should help, particularly Doc: 149628.1 which we've created a copy of and posted it to the following link: Creating multiple listeners on Unix
If you do have a Metalink account, I'd suggest that you login there and do a search for "multiple listeners". You'll find a great deal of additional information.
I think reviewing the info should take care of your problems.
For More Information
- Dozens more answers to tough Oracle questions from Karen Morton are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database export, import and migration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.