This problem has recently been plagued by the fact that the Oracle listening service is not automatically started after the server is powered off and restarted (the listening service has been set to self-started ).
Specifically, the listening service is set to boot automatically, and the Oracle database service is set to boot delayed. In principle, this should meet the condition that "Start listening first and then start database service, however, after each power failure and restart, the database service is started normally and the listening service fails to start.
After reading these two statements, I think it makes sense:
1. Generally, You need to manually set the auto-start service, which is caused by inconsistent registry;
2. The Logon account is different from the account used to install Oracle. You do not have the permission to start it.
For the above two statements, we decided to use windows to schedule tasks (all tasks are created and executed as administrators ):
Reference: Windows Server 2008 add an automatic Task Scheduler
1. Create a windows scheduled task and set it to be executed five minutes after the startup (Oracle TNS Listener );
2. Create another scheduled windows Task and set it to be executed six minutes after the startup (Oracle Service ).
Test Problem Solving