Oracle solves the ConnecttoIdleInstance Problem

Oracle solves the ConnecttoIdleInstance Problem

Oracle solves the problem of Connect to Idle Instance

Connect to Idle Instance

Step 1

View Oracle_SID.

[Oracle @ linuxserver ~] $ Echo $ ORACLE_SID

Cjdl

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] $ ls

Hc_cjdl.dat hc_DBUA0.dat init. ora lkCJDL orapwcjdl spfilecjdl. ora

In most cases, this is because of a problem.

Step 2

[Oracle @ linuxserver dbs] $ export ORACLE_SID = cjdl

In general, the export can be connected normally.

Step 3

[Oracle @ linuxserver dbs] $ sqlplus/as sysdba

OK! Normal connection.