Home » RDBMS Server » Security » Connect to Database
icon5.gif  Connect to Database [message #172714] Wed, 17 May 2006 13:26 Go to next message
armid1
Messages: 1
Registered: May 2006
Junior Member
Hi every body!

I have two database on my server.for example test1,test2
my default database is test1(in my regedit -> ORACLE_SID=test1)
who can tell me that How can I connect to test2 from command prompt ?
because when i run : connect / as sysdba
Oracle connect to test1 automatically

Thank You
Re: Connect to Database [message #172724 is a reply to message #172714] Wed, 17 May 2006 14:32 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Try:

DOS> SET ORACLE_SID=test2
DOC> sqlplus "sys/oracle as sysdba"
Previous Topic: radius configuration for oracle 9iR2/10g
Next Topic: ORA-28000: the account is locke"
Goto Forum:
  


Current Time: Tue Nov 30 02:06:14 CST 2021