Inline error: ORA-12545: Connect failed...

During my upgrade to 6.5 whenever after pulling over my Inline perl scripts, they all give me the below error. I have the ODBC connection setup and it tests fine in windows 2003

here is the line its dying on:

$db = DBI->connect("dbi Smiley Surprised

DBC:$dsn", "$db_user_name", "$db_password")

Root cause:
DBI connect('metadata','metadata',...) failed: [Oracle][ODBC][Ora]ORA-12545: Connect failed because target host or object does not exist (SQL-HY000)(DBD: db_login/SQLConnect err=-1) at

/Interwoven/TeamSite/httpd/iw-bin/inline_get_uniqueid.ipl line 106 Unable to open database connection at

/Interwoven/TeamSite/httpd/iw-bin/inline_get_uniqueid.ipl line 106.

Details...

com.interwoven.ui.formspub.datacapture.dct.InlineCallout$InlineCalloutException: DBI connect('metadata','metadata',...) failed: [Oracle][ODBC][Ora]ORA-12545: Connect failed because target host or object does not exist
(SQL-HY000)(DBD: db_login/SQLConnect err=-1) at

/Interwoven/TeamSite/httpd/iw-bin/inline_get_uniqueid.ipl line 106
Unable to open database connection at

/Interwoven/TeamSite/httpd/iw-bin/inline_get_uniqueid.ipl line 106.

at com.interwoven.ui.formspub.datacapture.dct.InlineCallout.execute(InlineCallout.java:138)
at com.interwoven.ui.formspub.datacapture.dct.InlineCalloutProcessor.executeInline(InlineCalloutProcessor.java:151)
at com.interwoven.ui.formspub.datacapture.dct.InlineCalloutProcessor.evaluateInlineCallouts(InlineCalloutProcessor.java:110)
at com.interwoven.ui.formspub.datacapture.DCRPredicate.buildDCRDocument(DCRPredicate.java:173)
at com.interwoven.ui.formspub.datacapture.NewDCRPredicate.execute(NewDCRPredicate.java:67)
at com.interwoven.ui.formspub.datacapture.NewDCRCommand.execute(NewDCRCommand.java:309)
at com.interwoven.ui.base.impl.command.CommandHandler.doExecuteCommand(CommandHandler.java:865)
at com.interwoven.ui.base.impl.command.CommandHandler.tryRunCommandDescriptor(CommandHandler.java:713)
at com.interwoven.ui.base.impl.command.CommandHandler.tryRunCommandID(CommandHandler.java:596)
at com.interwoven.ui.base.impl.command.CommandHandler.runCommand(CommandHandler.java:425)
at com.interwoven.ui.base.impl.command.CommandCallbackContextImpl.callback(CommandCallbackContextImpl.java:45)
at com.interwoven.ui.base.wizard.WizardCommand.execute(WizardCommand.java:114)
at com.interwoven.ui.base.impl.command.CommandHandler.doExecuteCommand(CommandHandler.java:865)
at com.interwoven.ui.base.impl.command.CommandHandler.tryRunCommandDescriptor(CommandHandler.java:713)
at com.interwoven.ui.base.impl.command.CommandHandler.tryRunCommandID(CommandHandler.java:596)
at com.interwoven.ui.base.impl.command.CommandHandler.runCommandLoop(CommandHandler.java:240)
at com.interwoven.ui.base.impl.command.CommandServlet.doGet(CommandServlet.java:244)
at com.interwoven.ui.base.impl.command.CommandServlet.doPost(CommandServlet.java:335)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.interwoven.ui.base.impl.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:206)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.interwoven.ui.base.util.SetRequestEncodingFilter.doFilter(SetRequestEncodingFilter.java:105)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)

-------------------
World of Warcraft  Illidan/Horde

Find more posts tagged with

Comments

Migrateduser

Sounds like your TS box cannot connect to the Oracle Server. Try doing a "tnsping" from the TS box to check your connection to the Oracle server.

Migrateduser

seems to work...im also able to access the DB via sql plus on the Interwoven box. did the database callouts change in TS 6.5? i cant find any updated examples within the install or docs.

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = TCP
COM.XXXXXXXXX.COM) (PROTOCOL = TCP) (Host = sXXXXXXXXXXX) (Port = 1XXX))) (CON
NECT_DATA = (SID = ****)))
OK (30 msec)

-------------------
World of Warcraft  Illidan/Horde

Migrateduser

Check your ODBC settings on your Windows box. Have those settings changed?

Migrateduser

well we updated tsnames.ora to use the IP of the server (this was suggested via a google search) and now we are getting a new error:

Root cause:
DBI connect('metadata','metadata',...) failed: [Oracle][ODBC][Ora]ORA-12560: TNS Smiley Tongue

rotocol adapter error (SQL-HY000)(DBD: db_login/SQLConnect err=-1) at

/Interwoven/TeamSite/httpd/iw-bin/inline_get_uniqueid.ipl line 106 Unable to open database connection at

rotocol adapter error
(SQL-HY000)(DBD: db_login/SQLConnect err=-1) at

/Interwoven/TeamSite/httpd/iw-bin/inline_get_uniqueid.ipl line 106
Unable to open database connection at

Migrateduser

Have you checked your ODBC connection?

Go to "Start->Programs->Administrative Tools->Data Sources (ODBC)".

Make sure you actually have an ODBC connection to your Oracle DB.

Bob

Migrateduser

yeah its the first line in original post Smiley Wink

-------------------
World of Warcraft  Illidan/Horde

Migrateduser

So it is... my apologies Smiley Happy

Migrateduser

For your host name in your ADDRESS, can you try to put the IP address?

Migrateduser

ah we figured it out, i feel like a dummy. in windows 2003 the system root is changed to c:\windows, <b>not</b> c:\winnt. even tho c:\winnt is still created in the file system.

$ENV {SystemRoot} = 'C:\WINDOWS';

once i updated the script it was fine...gg microsoft

-------------------
World of Warcraft — Illidan/Horde