Oracle solves the problem of Connect to Idle Instance

Oracle solves Connect to Idle Instance problem solve Connect to Idle Instance problem www.2cto.com first step view ORACLE_SID. [oracle @ linuxserver ~] $ Echo $ ORACLE_SIDcjdl the SID here must be the same as that in the initialization file spfilecjdl. ora. [Oracle @ linuxserver ~] $ Cd $ ORACLE_HOME [oracle @ linuxserver 11.2.0] $ cd dbs [oracle @ linuxserver dbs] $ lshc_cjdl.dat hc_DBUA0.dat init. ora lkCJDL orapwcjdl spfilecjdl. in most cases, ora is caused by a problem. Step 2 [oracle @ linuxserver dbs] $ export ORACLE_SID = cjdl generally, you can connect to the database by using export. Step 3 [oracle @ linuxserver dbs] $ sqlplus/as sysdba OK! Normal connection.