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

Usually, either there is a problem with the environment variable, or there is a problem with the oracle execution file permissions, or the root user is used, or the oracle_sid export is set incorrectly, or the database itself is not started, and so on.

The scenario described in this article is about an environment variable:

Su-oracle

Export ORACLE_SID

Sqlplus / as sysdba

The above steps are all set correctly, and it is normal to check the environment variable oracle_home. However, the .bash _ profile you checked at this time may have been corrected later, and the environment variable running pmon may not be at this time.

The parameters set in .bash _ profile.

Solution:

Ps-ef | grep pmon-find the process ID

Cat / proc/pmon_id/environ

Look at the environment variables that pmon is running and match to check what went wrong. Make changes based on the error parameters (restart the instance takes effect)

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.