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

Today, the editor shares with you the method of linux to check whether oracle is started, and many people don't know much about it. Today, in order to let you know more about the method of linux checking whether oracle is started, I summarized the following for you. Let's look down together. I'm sure you'll get something.

Method to see if the oracle database has been started:

Check whether the database is started. You can check it with ipcs under linux, or you can check the service under windows, or enter the database to see the current status of the database. If status = open, the oracle service is normal.

Check the listening, execute lsnrctl status, and you can see the corresponding instance of the listening.

Whether there are scott users, you can view the user status of the dba_users table.

Linux restart the oracle service:

1.su-oracle-switch to oracle user

2.lsnrctl stop-stop listening

3.sqlplus / as sysdba

4. SQL > shutdown immediate-stop oracle

5.SQL > startup;-start the service

6SQL > exit

7.lsnrctl start-enable listening

8.emctl start dbconsole

9.isqlplusctl start

The above is a brief introduction to linux's method of checking whether oracle is started. Of course, the differences in the detailed use of the above have to be understood by everyone. If you want to know more, welcome to follow the industry information channel!

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.