关于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