| Listner error ORA: 12500 [message #61279] |
Sat, 10 April 2004 15:35  |
gulshan
Messages: 19
Registered: January 2004
|
Junior Member |
|
|
Hi....
I am trying to connect the database through connection string but it give me an error :
TNS: listner failed to start a dedicated server process
I have created listner :
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = JAGJEET)(PORT = 1522))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = db1)
(ORACLE_HOME = D:oracleora90)
(SID_NAME = SIDDB1)
)
)
and then created service :
abc =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = JAGJEET)(Port = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = db1)
)
)
but i am continuously getting error.
One of my collegue has created a listner and a service. When I am trying to connect through his service then it is perfectly working.
Please tell me what is the problem.
Thanks.
|
|
|
|
| Re: Listner error ORA: 12500 [message #61280 is a reply to message #61279] |
Sun, 11 April 2004 00:28  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Looks like your listener is unable to start a
shadow process to process the incoming connection.
Please look at your listener.log file. You should see
the above error as well as a Windows operating system
error. Please post the OS error here so we can try to
assist you.
BTW: Next time, please post SQL*Net related questions
to the SQL*Net Forum.
Best regards.
Frank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
