-
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
-
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)
)
)
-
relevant thread for your Q
[url]http://www.dbasupport.com/forums/showthread.php?threadid=6378[/url]
Reddy,Sam
-
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
-
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
-
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
-
maybe LSNRCTL> SET current_listener ?
after starting the right one
-
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....
-
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.
Reddy,Sam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|