How to connect to different oracle instance as sysdba using sqlplus?

Question

When I run sqlplus it connect to orcl2 instance but I need to connect to orcl I can connect to my normal user using this:

sqlplus user/passowrd@//localhost:1521/orcl

but how can I connect as sysdba? I've try:

sqlplus / as sysdba@orcl

but it connect to orcl2 instance.

Also, assuming that orcl is a valid sid, you can set the ORACLE_SID environment variable to orcl, then you should be able to do sqlplus / as sysdba — sstan
– sstan, Commented Aug 3, 2016 at 13:23

sstan · Accepted Answer · 2016-08-03 13:30:17Z

9

Set the ORACLE_SID environment variable to orcl.

Then sqlplus / as sysdba will connect to orcl as expected.

answered Aug 3, 2016 at 13:30

sstan

36.8k7 gold badges54 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1