報錯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
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/238615.html
標籤：其他
上一篇：小符MYSQL的筆記
下一篇：本周總結and下周規劃