This content has been marked as final. Show 5 replies
can you send the error details cus without error details we cant help
try to connect user/pwd@sid
this should be the output when you get tnsping
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 10-JUL-2
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dscp328
2.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_
NAME = google)))
OK (20 msec)
well i guess your oracle home is not set properly.......
Thanks, it is working now. There was a problem in oracle_home.
I had to delete the ORACLE_HOME env variable to get the system working again. Surprisingly, it had been functioning fine for the past month. I had to explicitly add the ORACLE_HOME env var after installing Oracle 11.2.0 client on top of my already existing install of Oracle 10.2 client to prevent system referencing the older version.