Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-12535: TNS:operation timed out errors for over a year now...
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