Home » RDBMS Server » Server Administration » Oracle 8.1.7: set oracle_sid vs. connect u/p@remote
Oracle 8.1.7: set oracle_sid vs. connect u/p@remote [message #55142] Tue, 07 January 2003 04:29 Go to next message
Friedrich Pfeiffer
Messages: 1
Registered: January 2003
Junior Member
Hi all,

I’m running two instances on my machine (w2k, Oracle 8.1.7 EE), called o817 and demo. When I start svrmgrl/sql*plus, I use the connect-string “connect user/pass@demo”. Now my question: Is this sufficient for identifying the DB or do I have to specify the SID with set “oracle_sid=demo” too?

Thank you in advance
Friedrich Pfeiffer

Report message to a moderator

Re: Oracle 8.1.7: set oracle_sid vs. connect u/p@remote [message #55144 is a reply to message #55142] Tue, 07 January 2003 06:18 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
sufficient for general database operations.

Report message to a moderator

Previous Topic: Migrating Data from SQL SERVER 7 to ORACLE 8i
Next Topic: Oracle Server Classpath
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 28 06:57:43 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.