Home » SQL & PL/SQL » SQL & PL/SQL » ora-12516 ora-06512 after repair chained rows (oracle 8.1.6)
ora-12516 ora-06512 after repair chained rows [message #443891] Wed, 17 February 2010 22:43 Go to next message
s1970302
Messages: 6
Registered: November 2009
Location: seoul
Junior Member

On the weekend, I ran the repair chained rows in Toad and compile invalid objects in Toad.
I don't know this problem is associated with that job, it has no problem first day and today some problem was detected from customer side. It shows Ora-12516 and Ora-96512, I will attach package sql and error screen shot, could you interpret what is wrong with the Oracle?
Thank you.


------
I can post up screen shot cause I don't have right.
It was Korean and if I translate to English, kind of
"Server can't proceed - Ora-12516 TNS: listener can't find appropriate handler with protocol stack.
Ora-06512: "CWMED.PKG_MEDI_AS_TOCALL" line 226
Ora-06512: "CWMED.PKG_PDA_MEDI_AS" line 1765
Ora-06512: "line 1".

[Updated on: Wed, 17 February 2010 23:21]

Report message to a moderator

Re: ora-12516 ora-06512 after repair chained rows [message #443892 is a reply to message #443891] Wed, 17 February 2010 22:49 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
WHERE IS THE SCREEN SHOT ?

Quote:
ORA-12516: TNS:listener could not find available handler with matching protocol stack
Cause: None of the known and available service
handlers for the given SERVICE_NAME
support the client's protocol stack: transport, session, and presentation protocols.

Action: Check to make sure that the service handlers
(e.g. dispatchers)
for the given SERVICE_NAME are registered with the listener,
are accepting connections, and that they are properly configured to support the desired protocols.


No one do your job without giving specific information...

Where is the package body?

sriram Smile

[Updated on: Wed, 17 February 2010 22:49]

Report message to a moderator

Re: ora-12516 ora-06512 after repair chained rows [message #443893 is a reply to message #443891] Wed, 17 February 2010 22:52 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
12516, 00000, "TNS:listener could not find available handler with matching protocol stack"
// *Cause: None of the known and available service handlers for the given 
// SERVICE_NAME support the client's protocol stack: transport, session, 
// and presentation protocols.
// *Action: Check to make sure that the service handlers (e.g. dispatchers) 
// for the given SERVICE_NAME are registered with the listener, are accepting 
// connections, and that they are properly configured to support the desired 
// protocols.


what was done that produced the errors?

use CUT & PASTE to show us what you do & how Oracle responds

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: ora-12516 ora-06512 after repair chained rows [message #443897 is a reply to message #443891] Wed, 17 February 2010 23:28 Go to previous messageGo to next message
s1970302
Messages: 6
Registered: November 2009
Location: seoul
Junior Member

This is package body. Please download this one. not the first one.
I think it is related with Operating system, let me also lookup the system and oracle.

But right now from Oracle side, I knew only error code and error message.


Re: ora-12516 ora-06512 after repair chained rows [message #443898 is a reply to message #443897] Wed, 17 February 2010 23:32 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
Please explain what we can do with code when we do not have any tables the code uses & have no data to access.

It would be helpful if you provided DDL (CREATE TABLE ...) for tables involved.
It would be helpful if you provided DML (INSERT INTO ...) for test data.
It would be helpful if you provided expected/desired results & a detailed explanation how & why the test data gets transformed or organized.

[Updated on: Wed, 17 February 2010 23:33]

Report message to a moderator

Re: ora-12516 ora-06512 after repair chained rows [message #444444 is a reply to message #443891] Mon, 22 February 2010 00:53 Go to previous message
s1970302
Messages: 6
Registered: November 2009
Location: seoul
Junior Member

I looking for the answer and try to export what I can post here, but the too much table and data for you inconvinience.
At the same time, OS memory error was detected and we change whole
memory to new one and restart the Oracle.
After that this error was gone. I like to trace the listener and if same same error occured, I will post trace and DDL and DML files.
Thank you.
Previous Topic: Need help to optimize select-update
Next Topic: How to get left padded sequence values in pl/sql variable to insert it in table for ID creation (mer
Goto Forum:
  


Current Time: Sat Dec 03 14:09:27 CST 2016

Total time taken to generate the page: 0.14177 seconds