Oracle connect failed

[TerryMcFall]

Okay, getting a little frustrated here...

Trying to setup a duplicate of our IL 3.4 server for backup/test purposes and finding that some (not all) clients encounter the dreaded "Oracle connect failed while loading IL schema" message when trying to login.

I've scoured PTC.com and found several suggestions that didn't work:

- on client remove sqlnet.ora
- on client verify correct server name in tnsnames.ora
- on client startup file verify settings for PDM_ORA_APPL, PDM_ORACLE_SERVER, TNS_ADMIN and ORACLE_HOME.

Has anyone else solved this problem, and if so how many beers would it take to persuade an answer?

Thanks,
-Ter

Terrence (Terry) McFall
CAD Systems Administrator

Varian Medical Systems
911 Hansen Way
Palo Alto, CA 94304
650-424-6039 desk
650-799-0179 cell

[pwilliams-3]

I agree that you must make sure that your tnsnames.ora file on the clients contain the correct connection information. Compare it with a client that is working. Also make sure that the PDM_ORA_APPL and PDM_ORACLE_SERVER variables in your startup batch file point to the entry in the tnsnames.ora file.

tnsnames.ora -----------------------------------------
INTRALINK = (DESCRIPTION = (SDU=32768)(TDU=32768)(ADDRESS_LIST = (ADDRESS = (PROTOCOL=TCP)(Host= orapw01pdb)(Port= 1530)))(CONNECT_DATA = (SID = pw01p)))

proilink3.4.bat ------------------------------------------
set PDM_ORA_APPL=INTRALINK
set PDM_ORACLE_SERVER=INTRALINK

Patrick Williams | Engineering Systems | Sr. Applications Engineer | Steelcase Inc. | 616.698.4078

[cid:image001.jpg@01CA376F.3C01F820]

[TheodoreMetz]

It may be as simple as renaming the .proi folder


Regards,

Ted Metz