关于sqlplus中出现"Connected to an idle instance"问题的处理

关于sqlplus中出现"Connected to an idle instance"问题的处理：

该问题在如下文章中有解释：
How to Check the Environment Variables for an Oracle Process (文档 ID 373303.1)

如下是从该文章中摘录：

The most used application of this document is when dealing with the "Connected to an idle instance" scenario for a bequeath sysdba connection.
This error indicates that ORACLE_SID and ORACLE_HOME in the current session do not match the same environment variables that were used when the database is started (ORACLE_SID and ORACLE_HOME are the strings used to uniquely identify the shared memory segment of the instance when a connection is done).
Check the ORACLE_SID and ORACLE_HOME of the background process and compare them with the ones in the current session to find the mismatch.

 

 

该问题，Oracle ACS 惜总也有记录：http://www.xifenfei.com/5197.html