Get the App
SLTechnology News&Howtos  ›  Servers  › 

The method of checking whether oracle is started by linux

Shulou Source: shulou.com Published: 2022-06-03 07:53:26 09月21日 Update

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!

Tags: Methods data databases services monitoring users status different abbreviated content examples that is more look industry information channels face-to-face channels switching Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Redmi Microsoft NVidia Huawei Shulou Information