Skip to Main Content

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!

SQLPLUS / AS SYSDBA

grimrandApr 26 2016 — edited May 5 2016

Hello all

I have two solaris servers

server1 with orcl1

server2 with orcl2

Both startted

from server1

sqlplus system/manager@orcl1     OK

sqlplus system/manager@orcl2     OK

ORACLE_HOME, ORACLE_BASE correct

export ORACLE_SID=orcl1

sqlplus / as sysdba            - OK

export ORACLE_SID=orcl2

sqlplus / as sysdba            - Connected to an idle instance

from server2

sqlplus system/manager@orcl1     OK

sqlplus system/manager@orcl2     OK

export ORACLE_SID=orcl1

sqlplus / as sysdba            - Connected to an idle instance

export ORACLE_SID=orcl2

sqlplus / as sysdba            - OK

ORACLE_HOME, ORACLE_BASE correct

export ORACLE_SID=orcl1

sqlplus / as sysdba            - OK

export ORACLE_SID=orcl2

sqlplus / as sysdba            - Connected to an idle instance

Can anyone offer some advice, when I use connect / as sysdba where are the credentials, sid taken from.

Regards

Terry

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2016
Added on Apr 26 2016
12 comments
3,488 views