Oracle 10g snooping hang processing

Environment description

Oracle 10.2.0.4

Windows 2008

two。 Problem description

According to the description of the field engineer, the customer restarted the PC server, and after getting up, the monitoring was slow and slow, and the database status OPEN could not log in.

3. Deal with

It is useless to try to reconstruct the surveillance at the scene. Modify the listening file listener.ora

Add the following parameters

LOCAL_OSAUTHENTICATION = OFF

Restart listening lsnrctl stop lsnrctl start

After modifying the parameters, the monitoring start and stop is normal. Still can not log in to the database, check the database service, found that login using administrator users, modified to local login, the database can be connected normally.

4. Summary

One more thing, it's best not to run the production database on win. Pit pit ~ ~

Refer to the official documentation

LSNRCTL commands hang but listener process itself is running (document ID 979123.1)