数据库启动发现如下报错:
[oracle@test01 ~]$ !sql
sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 22 08:52:24 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initwls.ora'
SQL> !
#文件不存在
执行以下操作:
[oracle@test01 pfile]$ cp /u01/app/admin/wls/pfile/init.ora.722201883016 $ORACLE_HOME/initwls.ora
然后执行启动数据库的操作:
sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 22 09:11:05 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_WLS'
SQL> !
依旧报错
执行以下操作:
将initwls.ora 文件中local_listener做出如下修改:
local_listener= "(ADDRESS =(PROTOCOL = TCP)(HOST = test01)(PORT = 1521))"
再次执行起库操作:
SQL> tartup
ORACLE instance started.
Total System Global Area 4194304000 bytes
Fixed Size 2932336 bytes
Variable Size 2348810640 bytes
Database Buffers 1828716544 bytes
Redo Buffers 13844480 bytes
????????
????????
SQL>
启动成功!
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/31438871/viewspace-2212601/ ,如需转载,请注明出处,否则将追究法律责任。