Hi,
I have problem with my RAC, because the node01 does not connect (never) node02 using this configuration:
[oracle@node02 admin]$ cat tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
[oracle@node02 admin]$ ping node-scan
64 bytes from node-scan.corp.pgjdom001.com (192.168.0.181): icmp_seq=1 ttl=64 time=0.914 ms
[oracle@node02 admin]$ ping node-scan
64 bytes from node-scan.corp.pgjdom001.com (192.168.0.180): icmp_seq=1 ttl=64 time=0.037 m
[oracle@node03admin]$ ping node-scan
64 bytes from node-scan.corp.pgjdom001.com (192.168.0.180): icmp_seq=1 ttl=64 time=0.037 m
[oracle@node02 admin]$ ping node-scan
64 bytes from node-scan.corp.pgjdom001.com (192.168.0.180): icmp_seq=1 ttl=64 time=0.037 m
SQL> select instance_name from gv$instance;
INSTANCE_NAME
----------------
orcl2
orcl1
SQL> select inst_name from gv$active_instances;
INST_NAME
------------------------------------------------------------
node01.pgjdom001:orcl1
node02.pgjdom001:orcl2
but...
when I try:
[oracle@node02 admin]$ sqlplus / as sysdba@orcl
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl2
[oracle@node02 admin]$ sqlplus / as sysdba@orcl
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl2
....
[oracle@node01 admin]$ sqlplus / as sysdba@orcl
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
orcl1
What Happened?