From metalink
Subject: ORA-12516: Connection to 8.1.7 Instance Fails Using Oracle9i Listener
Doc ID: Note:156467.1 Type: PROBLEM
Last Revision Date: 10-APR-2003 Status: PUBLISHED
Problem Description
-------------------
You are attempting to connect via SQL*Plus or some other tool
to a version 8.1.7 instance via a 9.0.1 listener. You receive the
following error:
ORA-12516 "TNS:listener could not find instance with matching protocol
stack "
Solution Description
--------------------
This is most likely Bug 1880986. Listener blocks 8.1.7 service
handler after first connection. This error will occur when you rely
on the automatic instance registration feature to register the 8.1.7
instance with the version 9.0.1 listener. The recommended workaround
is to run an 8.1.7 listener to listener for the 8.1.7 instances.
This BUG is fixed by the 9.0.1.1 patchset release.
Explanation
-----------
The 9i listener is unable to handoff a connection to the 8.1.7
service handler registered against it.
-----Original Message-----
From: Gek Eng
[mailto:oracledba-ezmlmshield-x98618436.[Email address protected]
Sent: Wednesday, March 01, 2006 2:10 AM
To: LazyDBA Discussion
Subject: ORA 12516 Error
Hi,
My Users keep getting the following error message when they use the 9ias portal.
The page which they are opening consist of a combo box and this is the error they get.
After refreshing the page, they are able to view the combo box.
May I know whether any one of you encounter with this error?
COMBOBOX LOV ERROR:
LOV: "SI_DB_PROVIDER.LOV_STOCKS"
Parse Message: Parse as pre-set global: "PORTAL_PUBLIC".
Find Message: LOV is of type DYNAMIC (LOV based on SQL query).
Query: "SELECT DISTINCT RTRIM(STOCK_NAME)||','||STOCK_ID, STOCK_ID FROM SGX_STOCKS WHERE STOCK_NAME IS NOT NULL AND MARKET_ID = 'R'"
wwv_parse.parse_as_user: ORA-12516: TNS:listener could not find available handler with matching protocol stack wwv_parse.parse_as_user: Failed to parse as PORTAL_PUBLIC - SELECT DISTINCT RTRIM(STOCK_NAME)||','||STOCK_ID, STOCK_ID FROM SGX_STOCKS WHERE STOCK_NAME IS NOT NULL AND MARKET_ID = 'R' wwv_security.check_comp_privilege: Insufficient privileges. wwpre_utl.get_path_id: The preference path does not exist: ORACLE.WEBVIEW.PARAMETERS.40023_FORM_STOCKS_FUNDA_193047549
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
Oracle LazyDBA home page