Home » RDBMS Server » Networking and Gateways » tnsping works fine but sqlplus only works if current directory is $ORACLE_HOME/network/admin
tnsping works fine but sqlplus only works if current directory is $ORACLE_HOME/network/admin [message #399290] Tue, 21 April 2009 07:56 Go to next message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
The following works from the command prompt and returns OK
{{{
tnsping dsa22
}}}

The following works and i can connect to the database only if i am in the $ORACLE_HOME/network/admin directory

{{{
sqlplus user/pass@dsa22 (if run from $ORACLE_HOME/network/admin)
}}}

The following does not work if i am outside of $ORACLE_HOME/netowrk/admin
{{{
sqlplus user/pass@dsa22
}}}

The database is installed on a Unix box the client is on an NT box. The above commands fail on the client. The work fine if i try them on another client.
I think it is not picking up $ORACLE_HOME but this is configured in the registry so i dont know why its not picking it up.

There is no other oracle home on the client

Thanks
Re: tnsping works fine but sqlplus only works if current directory is $ORACLE_HOME/network/admin [message #399313 is a reply to message #399290] Tue, 21 April 2009 10:09 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post output from following command
SET

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Previous Topic: User Disconnected after 5min (merged)
Next Topic: Maximum DBLink Connection
Goto Forum:
  


Current Time: Tue Mar 19 01:20:56 CDT 2024