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.
Set the ORACLE_SID
environment variable to orcl
.
Then sqlplus / as sysdba
will connect to orcl
as expected.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With