Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
Hi All,
we are installing Windchill 10, first time installation abort due to LDAP connection failur, we start the DS and once agin start the installtion now this time it shows below error in method server log.
method server shutdown.
error as below.
2012-03-16 10:33:59,308 INFO [main] wt.pom.properties - JDBC Driver Version: major=11 minor=2
2012-03-16 10:33:59,402 INFO [main] wt.method.server.startup - MethodServer created - port 5003
2012-03-16 10:33:59,402 INFO [main] wt.method.server.startup - Starting services - class = wt.services.StandardServicesHandler
2012-03-16 10:34:01,027 INFO [main] wt.pom.properties - wt.pom.delete.triggerClassNames=
2012-03-16 10:34:04,277 ERROR [main] wt.method.server.startup.services - Failure to start manager wt.audit.StandardAuditService
wt.services.ManagerException: Could not initialize Auditing service.
Nested exception is: wt.ufid.UfidException: wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
wt.pom.ConnectionException: A SQL error has occurred. Database system message follows:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off client connection
Nested exception is: wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
Nested exception is: wt.pom.ConnectionException: A SQL error has occurred. Database system message follows:
Nested exception is: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off client connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:216)
Thanks,
Vivek
Hi,
are you connecting to a SQL Db or an oracle db?
From the error it looks like Oracle.
What version of oracle are you using?
We are using Oracle 11g as a database.
version : 11.2.0.
Thanks,
Vivek
Hi,
Is the Listener started. can you connect to the DB from the sqlplus command?
did you create the db beforehand?
regards,
Bryan
Vivek, just like what Bryan is trying to get acrossed. You need to make sure that your application server can successfully talk with your DB server. If the listner isn't started then all incomming connections are going to be refused.