Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

newbie question- what is connect identifier?

485313Jan 24 2006 — edited Jan 26 2006

Hi, all

I have installed 10g. and I have 2 databases installed ( the Global Database Name is db1.mydomain, SID is db1 and db2.mydomain / db2 ). I am trying to create some tables in one of them and I am trying sqlplus. The OS is XP. I also create a user called root in one database (db2. My questions are like these:

in the command line windows, when I log on, how should I say the sqlplus command such that the database will be 'db2'?

I tried "sqlplus root/password@db2", "sqlplus root/password@db2.mydomain", both failed saying "could not resolve the connect identifier specified".

What's the "connect identifier"? Where did I defined when I first installed a database?

Thanks for your help!

X.Chen

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 23 2006

Added on Jan 24 2006

#general-database-discussions

8 comments

405 views