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: TNSperation timed out

here's another:

PowerPlay Transformer(7.1.513.0 ) Wed Jun 07 06:33:53 2006
LogFileDirectory=\\servername\corprpt\Projects\Log s\
ModelSaveDirectory=\\servername\corprpt\Projects\S ource\Model\
DataSourceDirectory=C:\Program Files\Cognos\cer3\bin\
CubeSaveDirectory=\\servername\corprpt\Projects\So urce\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:
TNSperation 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