OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Connection problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connection problem [message #66714]

Mon, 18 November 2002 01:51

Vijay Manickam
Messages: 4
Registered: November 2002

Junior Member

Hi,

Everyday when we start work, the following error appears:
ORA - 12516: TNS: listener could not find available handler with matching protocol stack
It seems to be working fine after the database is re-started. This is fine, till the end of day. But again the next morning the same error props up. Kindly let me know what may be the problem.

Report message to a moderator

Re: Connection problem [message #66717 is a reply to message #66714]

Mon, 18 November 2002 07:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

in your listener.ora file, check whether you have something like this.

Code: [Select all] [Show/ hide]

(DESCRIPTION = 
(PROTOCOL_STACK = 
(PRESENTATION = GIOP) 
(SESSION = RAW) 
) 
(ADDRESS = (PROTOCOL = TCP)(HOST = YOURHOST)(PORT = SOMEPORT)) 
)

if so, take a backup of listener.ora ( just in case if u want the old configuration?).
delete the above entries.
stop listener.
reload the listener.ora
start the listener.

Report message to a moderator

Re: Connection problem [message #66722 is a reply to message #66714]

Tue, 19 November 2002 07:46

Vijay Manickam
Messages: 4
Registered: November 2002

Junior Member

There are no entries such as those in the listener file we use.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT =
1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:oracleora90)
(PROGRAM = extproc)
)
)

*****
Now have added this also:
(SID_DESC =
(GLOBAL_DBNAME = DBNAME)
(ORACLE_HOME = D:oracleora90)
(SID_NAME = DBNAME)
)

Report message to a moderator

Re: Connection problem [message #67355 is a reply to message #66714]

Tue, 01 June 2004 02:05

Magalie DELEPINE
Messages: 1
Registered: June 2004

Junior Member

I have the same problem and i just want to know if you have found a solution.

Thanks.

Report message to a moderator

Re: Connection problem [message #67638 is a reply to message #67355]

Tue, 30 November 2004 02:32

Cyril MARKT
Messages: 1
Registered: November 2004

Junior Member

Hello,

I had the same problem after my 10g Server crashed.
To solve the ORA-12516 Problem, I deleted my LISTENER and recreated it using the "Net Configuration Assistant" of Oracle.

Good luck,

C.

Report message to a moderator

Previous Topic:	Port Listener for Oracle
Next Topic:	find oracle servers on network

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 21:31:24 CDT 2025