Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Restart oracle database under linux

2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Restart the oracle database and listeners 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:

Sql code

Cd $ORACLE_HOME/bin # go to the installation directory of oracle

. / dbstart # restart the server

. / lsnrctl start # restart the listener

-

Method 3:

(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 4: (write your own script)

1) start script (dbstart.sh)

Lsnrctl start

Sqlplus / nolog startup

=

Starting oracle in linux is mainly divided into two steps: one is to start the listener, and the other is to start the instance (generally forget this step). The specific commands are as follows, which are provided for your reference:

1: connect to the server

Telnet ip

2: enter the administrator user and password

User-name:oracle

Password:oracle

3: enter the oracle root directory

Cd $ORACLE_HOME/bin

4: enter the monitor

. / lsnrctl

5: start the listener

Start

6: exit monitoring

Exit

7: enter sqlplus

Sqlplus / nolog

8: use administrator connection

Connect as sysdba

9: enter the user and password

User-name:oracle

Password:oracle

10: start the ORACLE instance

Startup

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report