DYNAMIC_REGISTRATION_LISTENER = OFF cause listener not work correctly

     Several my Oracle databases suddenly has invalid objects due to db link not longer working. The error message is like "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor".

     It turned out, someone implemented  DYNAMIC_REGISTRATION_LISTENER = OFF on my source database without putting descriptions regarding what this listener should be handling. As the result, databases services and instances are no longer registered with default port listener as default. The listener ended up running without doing anything. 

     To fix it. The following description need to be added in order to tell the listener to whom it services. 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME= service.company.com)

      (ORACLE_HOME=$ORACLE_HOME)

      (SID_NAME =somesid )

    )

  )