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

This article introduces the knowledge about "how to solve the problem of website Linux restart oracle database". In the actual case operation process, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

The service of the website was interrupted, and the restart found that the oralce service did not exist, and did not want to restart the machine, restart the oralce, and then restart the service.

Oracle9i:

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

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

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

(4) Start the database, command: startup

(5) If it is to shut down the database, the command: shutdown immediate

(6) Exit sqlplus console, command: exit

(7) Enter the stiffener console, command: lsnrctl

(8) Start the stabilizer (if it has already started, there is no need to care) Command: start

(9) Exit the stiffener console, command: exit

(10) Restart Database End

Other reference methods are as follows:

Method 1:

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

code is as follows

cd $ORACLE_HOME #Go to Oracle's installation directory

dbstart #Restart the server

lsnrctl start #Restart the listener

cd $ORACLE_HOME #Go to Oracle's installation directory

dbstart #Restart the server

lsnrctl start #Restart the listener

Method 2:

SQL code

code is as follows

cd $ORACLE_HOME/bin #Enter the Oracle installation directory

。/ dbstart #Restart the server

。/ lsnrctl start #Restart the listener

supplementary

There are two main steps to starting Oracle in Linux:

One is to start the listener, the other is to start the instance (generally forgot this step), the specific command is as follows, for your reference:

1: Connect to server

telnet ip

2: Enter administrator user and password

user-name:oracle

password:oracle

3: Enter oracle root directory

cd $ORACLE_HOME/bin

4: Enter monitoring

。/ lsnrctl

5: Start the listener

start

6: Exit Monitoring

exit

7: Enter sqlplus

sqlplus /nolog

8: Use Administrator Connection

connect as sysdba

9: Enter user and password

user-name:oracle

password:oracle

10: Start ORACLE instance

startup

"How to solve the problem of Linux website restart oracle database" content is introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

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.