DBCA 10.2.0.1 fails with ORA-12519 on adding a new RAC instance

Problem:
DBCA 10.2.0.1  tries to connect to RAC database with SID=RACT1 when adding a new RAC node
--> Dbca  fails with ORA-12519

Fix : Configure static listener configuration 
Add to your listener.ora
SID_LIST_LISTENER_RACT1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = RACT1)
      (ORACLE_HOME = /u01/app/oracle/product/10.2/rac_db1)
    )
  )

Restart listener 
[oracle@ract1 ~]$ lsnrctl stop LISTENER_RACT1
[oracle@ract1 ~]$ lsnrctl start  LISTENER_RACT1
..
Service "RACT1" has 1 instance(s).
  Instance "RACT1", status UNKNOWN, has 1 handler(s) for this service...
..
--> Service RACT1 is available now
Create a new tnsnames.ora with SID entry and test it 
R1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ract1vip.example.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = RACT1)
    )
  )
[oracle@ract1 ~]$  sqlplus scott/tiger@R1
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL>

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>