Operating system to win2003 r2 32-bit version of the enterprise, for oracle9i database, database instance for the YTH, into the system after network connection is slow, the bottom right hand corner network connections that come out icon along while, oracleYTH service has been displayed during the start-up, network connection, such as display blank oracleYTH services, has stopped trying to start, only manual start oracleYTH service to succeed every time, also includes the listener service is the same, excuse me what reason, have a solution?

CodePudding user response:

Connected or not does not affect the service, network, look at the alert log, the content of the before and after the system startup,

CodePudding user response:

Want to, maybe need Windows event log, and see whether have news related to the db and the listener,

CodePudding user response:

Don't know whether you and I use the same business systems, our experience is that when start above applies to the login screen, do not be eager to log in, wait for about 1 minute before login system can reduce a lot of problems,
Is also encountered under the business services straight start up, check the oracle instance of the service and monitoring service works, the problem is that the instance of the service, even after the normal boot, but oarcle database in nomount state, the need to load the database to mount, specific operation command check list,

CodePudding user response:

reference weixin_40290083 reply: 3/f

don't know whether you and I use the same business systems, our experience is that when start above applies to the login screen, do not be eager to log in, wait for about 1 minute before login system can reduce a lot of problems,
Is also encountered under the business services straight start up, check the oracle instance of the service and monitoring service is normal, the problem is that the instance of the service, even after the normal boot, but oarcle database in nomount state, the need to load the database to mount, specific operation command audits,

So let you check the alert log, why can't a instance in nomount state automatically mount? Is the special problems, you have to find the reason to do further processing,
Or you may have a look whether you Windows service set problems
In addition, if you can't find the alert, so to come to the log file:
Up sqlplus "/as sysdba"
Show parameter background_dump_dest
This parameter points to the directory, there is an alert ${is}. The log file, you find this file, at system startup time points before and after the content, can start and see if I can find the instance to the nomount state of reason,

CodePudding user response:

In addition, the listener log directory:
LSNRCTL status command output, a Listener Log File, but the point is an XML File, readability is poor, you can exit the XML Log alert to the location of the directory, to its at the same level of trace directory, find a Listener, the Log File, also can look for system startup time point before and after listening Log, see exactly why failed to start monitoring,

CodePudding user response:

Also thought of a possible, whether to use oradim created service, and there is no specified startmode for auto?