HI,
Currently iam facing this issue on my local (weblogic) server. Am not able to run any application due to this.
Its says
ce has property needsSeparateUserInfo set true, and property database set non-null. The value for property database will not be passed to DriverManager.getConnection unless it is explicitly encoded as part of
--- CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: atg.service.resourcepool.ResourcePoolException: java.sql.SQLException: Listener refused the connection with the following erro
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
at atg.adapter.gsa.GSAItemDescriptor.executeQuery(GSAItemDescriptor.java:8347)
at atg.adapter.gsa.GSAView.executeUncachedQuery(GSAView.java:362)
at atg.repository.query.QueryCache.executeUncachedQuery(QueryCache.java:719)
at atg.repository.query.QueryCache.populateEntry(QueryCache.java:1011)
at atg.repository.query.QueryCache.executeCachedCountQuery(QueryCache.java:547)
at atg.adapter.gsa.GSAView.executeCachedCountQuery(GSAView.java:800)
at atg.adapter.gsa.GSAView.executeCountQuery(GSAView.java:688)
at atg.adapter.gsa.GSAView.executeCountQuery(GSAView.java:666)
at atg.multisite.SiteManager.getSiteCount(SiteManager.java:1049)
at atg.multisite.session.MultisiteComponentSessionManager.hasSites(MultisiteComponentSessionManager.java:352)
at atg.multisite.session.MultisiteComponentSessionManager.createSessionNameContext(MultisiteComponentSessionManager.java:206)
at atg.servlet.NameContextManager.getSessionNameContext(NameContextManager.java:199)
at atg.servlet.ServletUtil.getSessionNameContext(ServletUtil.java:825)
at atg.servlet.pipeline.HeadPipelineServlet.service(HeadPipelineServlet.java:874)
at atg.servlet.pipeline.PipelineableServletImpl.service(PipelineableServletImpl.java:272)
at atg.filter.dspjsp.PageFilter.innerDoFilter(PageFilter.java:348)
at atg.filter.dspjsp.PageFilter.doFilter(PageFilter.java:206)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by :java.sql.SQLException: atg.service.resourcepool.ResourcePoolException: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
----------------------------------------------------------------------------------------------------------------------------------------
I checked with lisener status. its absolutely fine,
FYI
C:\Users\ADMIN>lsnrctl
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-MAR-2014 18:25:45
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
----------------------------------------------------------------------------------------------------------------------------------------
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ADMINIB-K09AMO5.in.ibm.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 06-MAR-2014 13:47:03
Uptime 0 days 4 hr. 39 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle11G\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File c:\oracle11g\diag\tnslsnr\ADMINIB-K09AMO5\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ADMINIB-K09AMO5)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ORCLXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
---------------------------------------------------------------------------------------------------------------------------------------------------
And sqldeveloper is working absolutely fine. iam able to create, update, insert data's
---------------------------------------------------------------------------------------------------------------------------------------------------
i just pinged lsnrctl in command prompt. I got below error
C:\Users\ADMIN> tnsping lsnrctl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-MAR-2014 18:29:39
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\oracle11G\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
Sqlnet.ora file :
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
----------------------------------------------------------------------------------------------------------------------------------------------------
tnsnames.ora
# tnsnames.ora Network Configuration File: C:\oracle11G\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ADMINIB-K09AMO5)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
-----------------------------------------------------------------------------------------------------------------------------------------------------
listner.ora
# listener.ora Network Configuration File: C:\oracle11G\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle11G\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\oracle11G\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ADMINIB-K09AMO5)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = C:\oracle11G
--------------------------------------------------------------------------------------------------------------------------------------------------
I have tested the connection pool. its working fine too.. Can anyone please help me on this issue.
Thanks
Muraliraj S