Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-12535: TNS:operation timed out errors for over a year now...

ORA-12535: TNS:operation timed out errors for over a year now...

From: Scott <swilson_at_shaw.ca>
Date: 21 Jun 2006 20:32:05 -0700
Message-ID: <1150947125.039517.268420@r2g2000cwb.googlegroups.com>


Hi Cognos and Oracle gurus,

First off, I'm a network guy. I don't speak cognos or oracle. Speak servers of any flavour on any switch and I'll understand all but sql stuff boggles my small brain.

Problem:

For over a year our business analysts have been complaining of returned TNS errors. They are convinced it is a network issue. I have done everything from rebuilding the servers to tweaking the routers and switches. I am convinced that it is an application issue.

This is a typical error we receive on a daily basis.

DS-DBMS-E306: UDA driver error connecting to 'CMIS'. [PROGRESS - 06:25:26] pid 2164 DimBuild Node 25
'D_INVENTORY_LOCATION'; reported the following:
DS-DBMS-E402: UDA driver reported the following: DMS-E-GENERAL, A general exception has occurred during operation
'attach database'.

ORA-12535: TNS:operation timed out

here's another:

PowerPlay Transformer(7.1.513.0 ) Wed Jun 07 06:33:53 2006 LogFileDirectory=\\servername\corprpt\Projects\Logs\ ModelSaveDirectory=\\servername\corprpt\Projects\Source\Model\ DataSourceDirectory=C:\Program Files\Cognos\cer3\bin\ CubeSaveDirectory=\\servername\corprpt\Projects\Source\Cube\Stage\ DataWorkDirectory=d:\temp\;d:\temp1\
ModelWorkDirectory=d:\temp\
MaxTransactionNum=500000
ReadCacheSize=32768
WriteCacheSize=65536
Temporary UDA directory=C:\WINNT\Temp
06-06-07 06:34:17 AM 2 00000000 DMS-E-GENERAL, A general exception has occurred during operation 'attach database'. 06-06-07 06:34:17 AM 2 00000000 ORA-12535: TNS:operation timed out
06-06-07 06:34:17 AM 2 00000000 PowerPlay Transformer Wed Jun 07 06:34:19 2006

I have edited the actual name of our servers with "servername".

Can anyone out there help us figure this one out??

Thank you,

Scott Received on Wed Jun 21 2006 - 22:32:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US