OraFAQ Forum: Security » Connect to Database

Home » RDBMS Server » Security » Connect to Database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connect to Database [message #172714]

Wed, 17 May 2006 13:26

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

Report message to a moderator

Re: Connect to Database [message #172724 is a reply to message #172714]

Wed, 17 May 2006 14:32

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Try:

DOS> SET ORACLE_SID=test2
DOC> sqlplus "sys/oracle as sysdba"

Report message to a moderator

Previous Topic:	radius configuration for oracle 9iR2/10g
Next Topic:	ORA-28000: the account is locke"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 01 22:57:13 CDT 2025