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 not working in RAC?

jack166Jul 20 2024

Oracle19c RAC.

I think I might miss some basic things here, but I don't know what.

Newly created RAC database is running well.

[oracle@orarac1 dbs]$ srvctl status database -d racdb
Instance racdb1 is running on node orarac1
Instance racdb2 is running on node orarac2

I can access RAC db using tnsnames entry like this:

[oracle@orarac2 admin]$ sqlplus /nolog
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jul 20 16:52:20 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
SQL> connect sys@racdb as sysdba
Enter password:
Connected.

But I can't use the regular sqlplus to connect the local instance (ORACLE_SID is set and right):

[oracle@orarac2 admin]$ echo $ORACLE_SID
racdb2
[oracle@orarac2 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jul 20 18:11:31 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to an idle instance.

What do I miss?

Thanks

This post has been answered by jack166 on Jul 21 2024
Jump to Answer
Comments
Post Details
Added on Jul 20 2024
4 comments
638 views