Shulou(Shulou.com)06/01 Report--

There is no problem with local connection access, but an error occurred while connecting data remotely:

Ora-12514:tns: the listener currently does not recognize the service requested in the connection descriptor

The solution is as follows:

Just add the following content to listener.ora to configure static monitoring.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBANAME = ora11g) / / Global database name

(ORACLE_HOME = / opt/oracle/ora11g/product/11.2.0/db_1)

(SID_NAME = orcl) / / ORACLE_SID

)

)

Lsnrctl reload restarts the listening service

Lsnrctl status checks the monitoring status

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.