Home » RDBMS Server » Networking and Gateways » ORA-12518: TNS:listener could not hand off client connection. (Oracle 10.2.0.4 installed in Win 2003)
ORA-12518: TNS:listener could not hand off client connection. [message #406024] Mon, 01 June 2009 13:43 Go to next message
padhuoracle
Messages: 26
Registered: March 2009
Location: Chennai
Junior Member
Hi,
Received database down alert.

Check in alert log , no error found.

From SAP application log found ORA-12518 error.

And Oracleservice<dbname> not started but tnslistener service is started.

tried to connect as sysdba, recevied tns protcol adaptor error-ora-12560

Then started the database by starting oracleservice.

What could be reason , kindly help in this issue.

padhu.
Re: ORA-12518: TNS:listener could not hand off client connection. [message #406025 is a reply to message #406024] Mon, 01 June 2009 13:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
12158, 00000, "TNS:could not initialize parameter subsystem"
// *Cause: Unable to locate parameter file.
// *Action: Verify that a valid parameter file exists, and is readable.
bcm@bcm-laptop:~$ oerr ora 12560
12560, 00000, "TNS:protocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors. For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.


Did Oracle crash & you restarted it?
Re: ORA-12518: TNS:listener could not hand off client connection. [message #406027 is a reply to message #406025] Mon, 01 June 2009 13:59 Go to previous messageGo to next message
padhuoracle
Messages: 26
Registered: March 2009
Location: Chennai
Junior Member
Database not crashed and its ORA-12518 error.

In SAP a import process was running, want to know why it occurred.

Oracle service alone stopped automatically.then I started the same, and increased large_pool_size from 16M to 64M.

Kindly suggest in finding the exact solution to avoid in future.
Re: ORA-12518: TNS:listener could not hand off client connection. [message #406029 is a reply to message #406027] Mon, 01 June 2009 15:04 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>Check in alert log , no error found.

>>Oracle service alone stopped automatically.then I started the same, and increased large_pool_size from 16M to 64M.

1/ Why database down? Check your complete alert log.

2/ Check your windows event viewer.

3/ What's the reason to increase your large pool size ??

Thanks

Babu
Previous Topic: Urgence,Issue about transparent gateway to MSSQLServer
Next Topic: error TNS-12170
Goto Forum:
  


Current Time: Thu Mar 28 05:58:45 CDT 2024