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

I learned oracle10g these days. After using pl/sql.developer for a while, I reported an error such as the title, so I searched the Internet for the answer and made the following record.

There are generally two situations in which this problem occurs.

The first is that you do not configure monitoring after you have installed it (here I temporarily forget whether it is configured after installation)

The second is that listening was previously configured but the system did not write to the listener.ora file (I don't know when to write it here), so you just need to write the configuration parameters in that file.

Solution:

1. Open the listener.ora file

Find the location of the listener.ora file and open it. My local files directory is under H:\ oracle\ product\ 10.2.0\ db_1. The file should be found according to the actual situation of your own installation directory. (note: the directory of Oracle10g and 11g does not seem to be the same). The contents of the file are as follows:

We can see from the above figure that I have configured listening, but the error is due to the fact that the address of Oracle is not written to SID_DESC, so we can write it here.

2. Modify listener.ora file

Append the following to the SID_LIST node of the file (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = H:\ oracle\ product\ 10.2.0\ db_1) (SID_NAME = orcl) Note: modify according to the installation directory of your own machine

3. Restart the monitoring service. OK, get it!

Lsnrctl stop

Lsnrctl start

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.