關於sqlplus中出現"Connected to an idle instance"問題的處理，sqlplusinstance

關於sqlplus中出現"Connected to an idle instance"問題的處理，sqlplusinstance

關於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