• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7068
  • Last Modified:

SQLPLUS connect string

I'm connecting to a database with the following.
(oracle 8.0.5 on solaris 2.6)

sqlplus  user/pass@DB

The process hangs and I have to kill it.  I can connect using

sqlplus user/pass


On another machine, with 8.0.4 the connect string works fine:
sqlplus user/pass@DB

Is there anything wrong with the 8.0.5, or is there something else I need to do.

Thanks for any help.

1 Solution
DB as a connect string is different than your ORACLE_SID.  DB needs to be defined in your tnsnames.ora file on your client machine.  This can be done manually using a text editor or by using Oracle Net8 Easy Config or Net8 Assistant.  Find your tnsnames.ora file and post it here.
P.S. The process may appear to hang, but it will eventually come back with an error message.  You may want to wait and then post that message too.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now