Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to restart oracle database and listener under linux". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to restart oracle database and listener under linux.

Method 1

Log in to linux with root as ssh, open the terminal and enter the following command:

Cd $ORACLE_HOME # go to the installation directory of oracle

Dbstart # restart the server

Lsnrctl start # restart the listener

Cd $ORACLE_HOME # go to the installation directory of oracle

Dbstart # restart the server

Lsnrctl start # restart the listener

-

Method 2:

(1) Log in to the database as oracle, and command: su-oracle

(2) enter the Sqlplus console and command: sqlplus / nolog

(3) Log in as system administrator, command: connect / as sysdba

(4) start the database, command: startup

(5) if the database is closed, the command: shutdown immediate

(6) exit the sqlplus console, command: exit

(7) enter the listener console, and command: lsnrctl

(8) start the listener, command: start

(9) exit the listener console, command: exit

(10) end of restarting the database

-

Method 3: (write your own script)

3.1) Startup script (dbstart.sh)

Lsnrctl start

Sqlplus / nolog startup

At this point, I believe you have a deeper understanding of "how to restart oracle database and listeners under linux". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.