one listener multiple database

[kburrows]

Hi everyone,

I have two versions 8.0.6 and 8.1.7 on one unix machine. At startup the 8.0.6 listener starts and the only way i can get the 8.1.7 listener to start is lsnrctl stop and lsnrctl start, which starts the 8.1.7 listener. How can I configure only the 8.1.7 listener to listen for both db's and auto start on startup?

Thanks in advance,
kathy

[m_d_marian]

just start only 8.1.7. listener,
and the second database can be configured on the SID description of the listener.ora file:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\home for 8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = db_8.1.7)
(ORACLE_HOME = D:\home_8.1.7)
(SID_NAME = sid_8.1.7)
)
(SID_DESC =
(GLOBAL_DBNAME = db_8.6)
(ORACLE_HOME = D:\home_8.6)
(SID_NAME = sid_8.6)
)
)

[sreddy]

[url]http://www.dbasupport.com/forums/showthread.php?threadid=6378[/url]

[kburrows]

thank you for the helpful information, but can you explain what the

(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\home for 8.1.7)
(PROGRAM = extproc)

PLSExtProc and extproc represents.

And where can I find my global db_name, I dont' have a services_name parameter in my init file?
Thanks

[m_d_marian]

If you don't need, you don't have to use this block:
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\home for 8.1.7)
(PROGRAM = extproc)

This is only for external procedures, I guess, when you have to call external procedures.

And db_name must be on the top of your init.ora file

[kburrows]

Great, I got two services from my 8.1.7 listener, one for each db. Thanks

Now, I am still having a problem because when I reboot the server the 8.0.6 listener gets started automatically. I need the 8.1.7 listener to start on reboot.

I can start the 8.1.7 manually lsnrctl stop, lsnrctl start. But I need it to start on startup. I can't find the file that tells the listener to start? Any ideas?

Thanks

[m_d_marian]

maybe LSNRCTL> SET current_listener ?
after starting the right one

[scorpio4u]

did u put the dbstart file path in the rc2.d directory....? in the same file mention the path of the listenere and mention start...it will start up....or mail me i will give u the complete script....word by word...good luck....sethijagdeep@usa.net....

[sreddy]

What OS ?If its Unix What Shell you are using ?

C Shell:

Go to Profile of Oracle userid thats .cshrc and make an entry like this
And/OR
at the end of Oracle provided file "/usr/bin/coraenv" under local modifications

setenv TNS_ADMIN=/O_H_817/network/admin

K Shell:

Go to Profile of Oracle userid thats .cshrc and make an entry like this
And/OR
at the end of Oracle provided file "/usr/bin/oraenv" under local modifications

set TNS_ADMIN=/O_H_817/network/admin

Rename(prefix) Oracle 806 binaries to say .old

lsnrctl as lsnrctl.old so that it never gets invoked and always 817 binaries will be invoked.