Oracle12版本报错：ORA-01034: ORACLE not available，

àì夳堔傛蜴生んèń 2022-12-29 09:22 149阅读 0赞

## 报错1 ##

描述：

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
    ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available
    Process ID: 0
    Session ID: 0 Serial number: 0

解决办法：

[oracle@SGM-Oracle-Test-Slave ~]$ lsnrctl status
    
    LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 21-DEC-2020 15:49:47
    
    Copyright (c) 1991, 2013, Oracle.  All rights reserved.
    
    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    TNS-12541: TNS:no listener
     TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
       Linux Error: 111: Connection refused
    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)

然后启动监听

[oracle@SGM-Oracle-Test-Slave ~]$ lsnrctl start;
    
    LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 21-DEC-2020 15:50:24
    
    Copyright (c) 1991, 2013, Oracle.  All rights reserved.
    
    Starting /opt/oracle/product/12.1/db_1//bin/tnslsnr: please wait...
    
    TNSLSNR for Linux: Version 12.1.0.1.0 - Production
    System parameter file is /opt/oracle/product/12.1/db_1/network/admin/listener.ora
    Log messages written to /opt/oracle/product/12.1/db_1/log/diag/tnslsnr/SGM-Oracle-Test-Slave/listener/alert/log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGM-Oracle-Test-Slave)(PORT=1521)))
    
    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 12.1.0.1.0 - Production
    Start Date                21-DEC-2020 15:50:27
    Uptime                    0 days 0 hr. 0 min. 3 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /opt/oracle/product/12.1/db_1/network/admin/listener.ora
    Listener Log File         /opt/oracle/product/12.1/db_1/log/diag/tnslsnr/SGM-Oracle-Test-Slave/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SGM-Oracle-Test-Slave)(PORT=1521)))
    The listener supports no services
    The command completed successfully

## 报错2 ##

描述

SQL> startup
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file '/opt/oracle/product/12.1/db_1/dbs/initawasoppdb.ora'

解决

cp $oraclehome /admin/awasop/pfileinit.ora.618201916351 /opt/oracle/product/12.1/db_1/dbs/initawasoppdb.ora
    chown Oracle属主属组 /opt/oracle/product/12.1/db_1/dbs/initawasoppdb.ora
    chmod +x /opt/oracle/product/12.1/db_1/dbs/initawasoppdb.ora

启动成功

[oracle@SGM-Oracle-Test-Slave pfile]$ export ORACLE_SID=awasoppdb
    [oracle@SGM-Oracle-Test-Slave pfile]$ sqlplus  sys/system as sysdba
    
    SQL*Plus: Release 12.1.0.1.0 Production on Mon Dec 21 17:01:54 2020
    
    Copyright (c) 1982, 2013, Oracle.  All rights reserved.
    
    Connected to an idle instance.
    
    SQL> startup
    ORACLE instance started.
    
    Total System Global Area 1553305600 bytes
    Fixed Size                  2288728 bytes
    Variable Size            1006633896 bytes
    Database Buffers          536870912 bytes
    Redo Buffers                7512064 bytes