Easily solve Oracle Database Service Startup Problems

Oracle DatabaseIt is a database system that is widely used. It is also very important in the database industry. It is necessary for future development to master the operation and use of Oracle databases, this article describes in detail the solutions to Oracle Database Service Startup problems.

Software environment:

Operating System: Windows 2000 Advanced Server.

Database: Oracle 9.0.1.1.1 Enterprise Edition.

Recently, when Browsing BBS, we often see "in a hurry! How to start OMS ?" To address these problems, I want to share some of my experiences with you.

To enable OEM or OMS properly, there are two key points:

First. Whether Oracle system services are enabled;

Second. The username and password used for Logon are correct.

First, let's talk about Oracle's system services.

In the case of full installation, there are 11 Oracle system services:

1. Oracle OLAP 9.0.1.0.1

2. Oracle OLAP Agent

3. OracleOraHome90Agent

4. OracleOraHome90ClientCache

5. OracleOraHome90HTTPServer

6. OracleOraHome90ManagementServer0.5M)

7. OracleOraHome90PagingServe

8. OracleOraHome90SNMPPeerEncapsulator

9. OracleOraHome90SNMPPeerMasterAgent

10. OracleOraHome90TNSListener5.2M)

11. OracleServiceORACLE70M)

Note: OraHome90 is the name of the main directory of Oracle that can be changed during installation, which is the default value during installation)

The three most important services are OracleOraHome90ManagementServer, OracleOraHome90TNSListener, and OracleServiceORACLE.

Next, let's take a look at the startup errors related to them:

1. Oracle System prompt: Ora-12541: TNS: No listener;

2. The operating system prompts that the OMS service cannot be started on the local computer.

Error: 1053: the service did not respond in time to control the request;

The above two error messages are mostly caused by the OracleOraHome90TNSListener listening service.

Solution: Choose Control Panel> Administrative Tools> services> right-click OracleOraHome90TNSListener and click Start ".

3. Oracle System prompt: Ora-12500: TNS: The Listener cannot start the dedicated server process;

This error is caused by the OracleServiceORACLE dedicated server process.

Solution: Choose Control Panel> Administrative Tools> services> right-click OracleServiceORACLE and click Start ".

4. Oracle System prompt: VTK-1000: Unable to connect to Management Server.

Verify that you have entered the correct host name and status of the Oracle Management Server. There are two causes for this error: OracleOraHome90ManagementServer has not been started; and host name has not been entered. Solution: Choose Control Panel> Administrative Tools> services> right-click OracleOraHome90ManagementServer, click Start, or enter the full name of your computer. Next, let's talk about the username and password used for logon. After the installation is complete, the SYSTEM provides two default database SYSTEM administrators, whose usernames and passwords are SYS/change_on_install and SYSTEM/manager, the system also provides the username and password for logging on to OMS: sysman/oem_temp. The error is that the SYSTEM uses SYS or SYSTEM as the username to log on to OMS. Therefore, the Oracle SYSTEM prompts "Incorrect logon Identity Authentication.

Summary:

The startup or shutdown of these three services are sequential. Generally, you must first start OracleOraHome90ManagementServer or OracleServiceORACLE when starting OracleOraHome90ManagementServer, and then OracleOraHome90TNSListener and then OracleServiceORACLE. However, you must first disable OracleOraHome90ManagementServer and then OracleOraHome90TNSListener or OracleServiceORACLE. If you are prompted to enter the username and password, enter the sysman username and password to ensure successful execution. If you have other tips, such as resource occupation, I/O duplication, and port usage, contact the system administrator and try again. The detailed content described above will be helpful to your work.