Relationship between Oracle services and databases after Windows Installation

After oracle is installed in windows, some services will be created in windows, such as oracleoradb10g_home1tnslistener, which is used to listen to the Service port and oracleserviceorcl related to the instance to start the instance. oracledbconsoleorcl is used to start em.

Oracleoradb10g_home1tnslistener can be started using the LSNRCTL start command. Only after it is started can it listen to the port specified during installation, such as 1521, which serves multiple instances on the machine.

Oracleserviceorcl serves orcl instances. If a machine creates multiple databases and has multiple instances, each instance corresponds to such a service. You can run oradim-startup-Sid orcl.

Oracledbconsoleorcl corresponds to the em of the orcl instance. After the instance is started, you can access the EM through the URL.

The startup of oracleserviceorcl usually means that the corresponding database is also opened (start open). However, you can change the value from true to false by modifying ora_orcl_autostart of the Registry, after the service is started, the database does not start at this time.

At this time through sqlplus sys/sys as sysdba connection, you can see connected to an idle instance. At this time, the execution of SQL, will get the error: ORA-01034: Oracle not available.

At this time, the instance can be started through startup.

The executable file path is D: \ oracle \ product \ 10.2.0 \ db_1 \ bin \ oracle. EXE orcl, so we can use Oracle in CMD instead of starting this service. EXE orcl can also start the "part" function of this Service. The reason is that it is "part", because the instance cannot be connected through the network at this time:

1. Stop oracleserviceorcl. 2. Use oracle in cmd. EXT orcl starts the "service", 3 connects to the instance through sqlplus sys/sys as sysdba, and cannot connect to the instance through sqlplus sys/sys @ orcl as sysdba.