PRKP-1011 error in RAC!!??

From: JZ <ibm_97_at_yahoo.com>
Date: 30 Sep 2003 21:08:19 -0700
Message-ID: <10bc841c.0309302008.39772bbb@posting.google.com>

Hi all:

Oracle 9.2.0.4 RAC on Red hat advanced server 2.1

Everything is ok. But, I got the following error:

[oracle_at_nfdb1]$srvctl start database -d nfdb PRKP-1011 : Failed to get all the listeners associated with instance nfdb1 on nodep4asus

I checked the PRKP-1011 note from metalink, but couldn't get any help. 2 nodes system. Host names are 'p4asus' and 'jackdell'. 'p4asus' is considered to be the primary node. Dtabase name is 'nfdb', ORACLE_SID are 'nfdb1' and 'nfdb2'. Domain is 'jackdomain.com'

Since I only get the error about 'p4asus' machine, does this mean 'jackdell' machine is fine? Both machines have the same 'tnsnames.ora' file. And the difference of 'listener.ora' is just ORACLE_SID and hostname.

BTW, I'm able to manually 'lsnrctl stop/start/status' on both machines. Also I cannot use X, so 'netca' and 'netmgr' cannot be used to config this.

Thanks a lot!

listener.ora file on 'p4asus':

SID_LIST_LISTENERS_NFDB =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(PROGRAM = extproc)

    )
    (SID_DESC =
(SID_NAME = nfdb2)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
    )
  )

LISTENERS_NFDB.JACKDOMAIN.COM =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = jackdell)(PORT = 1521))
      )

)
)

listener.ora in 'jackdell':

LISTENERS_NFDB.JACKDOMAIN.COM =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = jackdell)(PORT = 1521))
      )

)
)

tnsnames.ora in 'p4asus' and 'jackdell' (same file):

NFDB.JACKDOMAIN.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = p4asus)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = jackdell)(PORT = 1521))
(LOAD_BALANCE = yes)

    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nfdb)

    )
  )

NFDB1.JACKDOMAIN.COM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = p4asus)(PORT = 1521))     (CONNECT_DATA =
(SERVICE_NAME = nfdb)
(INSTANCE_NAME = nfdb1)

    )
  )

NFDB2.JACKDOMAIN.COM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jackdell)(PORT = 1521))     (CONNECT_DATA =
(SERVICE_NAME = nfdb)
(INSTANCE_NAME = nfdb2)

    )
  )

LISTENER_NFDB1.JACKDOMAIN.COM =
(ADDRESS = (PROTOCOL = TCP)(HOST = p4asus)(PORT = 1521))

LISTENERS_NFDB.JACKDOMAIN.COM =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = p4asus)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = jackdell)(PORT = 1521)) )

LISTENER_NFDB2.JACKDOMAIN.COM =
(ADDRESS = (PROTOCOL = TCP)(HOST = jackdell)(PORT = 1521)) Received on Tue Sep 30 2003 - 23:08:19 CDT