| Bishal |
Posted: May 05, 2008 01:36:32 AM |
Total Post: 160
Joined: Apr, 2008
|
I AM GETTING FOOLLOWING ERROR:
ORA-12523: TNS:listener could not find instance appropriate for the client connection
WHAT SHOULD BE DONE TO FIX IT? |
|
|
 Murtuja |
| Posted: May 05, 2008 02:12:29 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
what is output of "lsnrctl services "
|
|
|
|
|
| Bishal |
| Posted: May 05, 2008 02:32:04 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
OUTPUT IS
THE SERVICE THAT I AM TRYING TO RUN ie. JEFFDUP
THE STATUS IS BLOCKED FOR IT
|
|
|
|
|
| Murtuja |
| Posted: May 05, 2008 02:37:26 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
in listener.ora file..check SID_NAME
It should like this
(SID_DESC =
(GLOBAL_DBNAME = global_database_name)
(ORACLE_HOME = /oracle_home_path)
(SID_NAME = database_sid_name)
)
then reload listener "lsnrctl reload"
|
|
|
|
|
| Bishal |
| Posted: May 05, 2008 02:48:00 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
the status for it is still blocked...
|
|
|
|
|
| Murtuja |
| Posted: May 05, 2008 02:57:19 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Increase the number of processes in your parameter file. (init.ora or spfile)
ALTER SYSTEM SET processes=250 SCOPE=SPFILE;
|
|
|
|
|
| Bishal |
| Posted: May 05, 2008 03:15:42 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
there is no progress
still the same
|
|
|
|
|
| Bishal |
| Posted: May 05, 2008 03:22:21 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
now
lsnrctl services
it shows my aux database name ie. JEFFDUP
has 2 instance
out of which 1 is unknown and one is blocked
|
|
|
|
|
| Bishal |
| Posted: May 05, 2008 03:58:31 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
LSNRCTL SERVICES SHOWS
THE STATUS IS UNKNOWN FOR JEFFDUP
|
|
|
|
|
| Gitesh |
| Posted: May 05, 2008 05:28:50 AM | |
|
Total Post: 322
Joined: May, 2005
|
Unix is case sensitive. Kindly check.
|
|
|
|
|
| Mohammed Taj |
| Posted: May 05, 2008 09:48:42 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Can you post your listner.ora file.
or
did you try to register manually instance to listner.
SQL> alter system register;
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
