Ora-01034:oracle Not available Solution

Problem phenomenon:

Alter user Scott account unlock;

ERROR at line 1:
Ora-01034:oracle Not available
Process id:0
Session id:0 Serial number:0

[[Email protected] ~]$ Echo $ORACLE _sidxxxx[[email protected]~]$ Sqlplus/ asSysdbasql*plus:release11.2.0.4.0Production on Tue Sep A  -: -: $  .Copyright (c)1982, -, Oracle. All rights reserved. Connected to an idle instance. SQL>SelectUserenv'language') fromUdal;SelectUserenv'language') fromUdal*ERROR at line 1:ora-01034:oracle not availableprocess id:0session id:0 Serial number:0

Problem solving:

Confirm that the current instance is not

Export ORACLE_SID=XXXX--Setup

echo $ORACLE _sid=xxxx--View

Viewing the Listening status

Lsnrctl status

sqlplus sys/[email protected] as SYSDBA #明确登录的用户及实例, it's OK.

[Email protected] ~]$ Sqlplus sys/123123@sznfpt asSysdbasql*plus:release11.2.0.4.0Production on Tue Sep A  the: Geneva: -  .Copyright (c)1982, -, Oracle. All rights reserved. Connected to:oracle Database 11g Enterprise Edition Release11.2.0.4.0-64bit Productionwith The partitioning, OLAP, Data Mining and Real application testing Optionssql>SQL>SQL>alter user Scott account unlock; User altered. SQL>SQL>SQL> Alter user Scott identified by123123; User altered. SQL>

Ora-01034:oracle Not available Solution