How to debug PL-SQL Program in RAC Database.

To debug PL-SQL code in RAC environment first create TNS in tnsnames.ora file using the only one instance. Connect into database using the new TNS name.


CBS_PROD_DB =
  (DESCRIPTION =
      (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.201.200)(PORT = 1521))
      )
      (CONNECT_DATA =
          (SERVICE_NAME = CBSDB)    
          (INSTANCE_NAME = CBSDB1)
      )
  )