Linux restart oracle database three major techniques

Linux system under the website problems, you can restart the oracle database for processing, and restart the oracle database methods are many, you can log in to the database for operation, but also in the terminal operation Let's take a look at the specifics with Xiaobian.

website service disruption, and is found next restart oralce service does not exist, do not want to restart the machine, you reboot oralce, and then restart the service.

The operation is oracle9i:

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

(2) Enter Sqlplus console, command: sqlplus /Nolog

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

(4) Start the database, command: startup

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

(6) Exit sqlplus console, command: exit

(7) Enter the firmware console, command: lsnrctl

(8) Start Firmware, (if you have already started it, you don't need it) Command: start

(9) Exit the console, command: exit

(10) Restart the database

Other reference methods are as follows:

Method 1:

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

Code Copy code as follows

cd $ORACLE_HOME #Enter the oracle installation directory

dbstart #restart the server

lsnrctl start #restart listener

cd $ORACLE_HOME #Enter the oracle installation directory

dbstart #restart server

lsnrctl start #restart listener

Method 2:

Sql Code

Code Copy Code as follows

cd $ORACLE_HOME/bin #Enter the oracle installation directory

. /dbstart #restart server

. /lsnrctl start #restart listener

Supplement

Starting oracle in linux is mainly divided into two steps:

One is to start the listener, one is to start the instance (usually forgot This step), the specific command is as follows, 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 listener < Br>

. /lsnrctl

5: Start Listener

start

6: Exit Listening

exit

7: Enter sqlplus

sqlplus /nolog

8: Using an administrator connection

connect as sysdba

9: Entering a user and password

user-name:oracle

password:oracle

10: Start ORACLE instance

startup

The above is the Linux restart oracle database method introduced, in addition to the introduction of the oracle database The restart method also introduces the method of starting the oracle database, I hope to help friends who do not understand the oracle database.