LISTENER SID REGISTERATION
$ oerr ora 12505
12505, 00000, \"TNS:listener could not resolve SID given in connect descriptor\"
// *Cause: The SID in the CONNECT_DATA was not found in the listener\'s tables.
// *Action: Check to make sure that the SID specified is correct.
// The SIDs that are currently registered with the listener can be obtained by
// typing \"LSNRCTL SERVICES \". These SIDs correspond to
// SID_NAMEs in TNSNAMES.ORA, or db_names in INIT.ORA.
// *Comment: This error will be returned if the database instance has not
// registered with the listener; the instance may need to be started.
Try to dynamically register the database with your listener:
SQL> ALTER SYSTEM REGISTER;
Alternatively, use static registration (add your DB to the SID_LIST_LISTENER specification).
|
