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

DBCA  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_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 =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ract1vip.example.com)(PORT = 1521))
      (SID = RACT1)
[oracle@ract1 ~]$  sqlplus scott/tiger@R1
Connected to:
Oracle Database 10g Enterprise Edition Release - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

Leave a Reply

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