6.3 Starting Oracle Net Listener and the Oracle Database Server

Oracle Net Listener and the Oracle Database server must be running in order for the database server to receive connections.

The following procedure describes how to start Oracle Net Listener:

1. Start the listener with the Listener Control utility. From the command line, enter the following:

   lsnrctl
   LSNRCTL> START [listener_name]

   In the preceding command, listener_name is the name of the listener defined in the listener.ora file. It is not necessary to identify the listener if you are using the default name LISTENER.

   A status message indicating that the listener has successfully started appears.

2. Start the database as follows:

   1. Start SQL*Plus without connecting to the database using the following command:

      SQLPLUS /nolog

   2. Connect to the database as SYSDBA using the following command:

      SQL> CONNECT username as sysdba

      You will be prompted to enter a password.

      Note:

      For simplicity, this example does not perform the password management techniques that a deployed system normally uses. In a production environment, follow the Oracle Database password management guidelines, and disable any sample accounts. See Oracle Database Security Guide for password management guidelines and other security recommendations.

   3. Start the database using the following command:

      SQL> STARTUP database_name

      In the preceding command, database_name is the name of the database.

      For additional information about starting the database, see Oracle Database Administrator’s Guide.

3. Confirm that database service registration with the listener has completed using the Listener Control utility and the following command:

   LSNRCTL> SERVICES [listener_name]

   The SERVICES command lists the services supported by the database, along with at least one available service handler. If the database service registration is not listed, then enter the following SQL command:

   SQL> ALTER SYSTEM REGISTER;