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

(My ORACLE_SID = DB)

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.

Chris
sadsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bkowalskiCommented:
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.
-Brad
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.