Environment description
Oracle 10.2.0.4
Windows 2008
2. Description of the problem
According to the field engineer description, the customer restarted the PC server, up after the start of monitoring very slow very card, database status open cannot login
3. Handling
It is useless to try to reconstruct the monitor on site. Modify the Listening file Listener.ora
Add the following parameters
Local_osauthentication<listenername> = OFF
Restart monitoring Lsnrctl Stop lsnrctl start
After modifying the parameters, the listening start and stop is normal. Still can not log in the database, view the database service, found that logged in using administrator users, modified to log on locally, the database can be connected normally.
4. Summary
Say more, it is best not to win on the production database run. Hang Keng Pit ~ ~ ~
Reference official documentation
Lsnrctl commands hang but listener process itself is running (document ID 979123.1)
Oracle 10g monitoring Hang processing