oracle12启动instance失败

安装完毕后oracle,重启系统。然后输入:
sqlplus
username:sys/manager as sysdba
输入查询语句:
create user admin identified by admin1234;
提示ORA-01034: ORACLE not available,

检查instance status
在命令模式下输入
lsnrctl status
输出结果

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 19-MAR-2018 17:09:20

Copyright (c) 1991, 2016, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENDBCRM
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                19-MAR-2018 14:58:28
Uptime                    0 days 2 hr. 10 min. 56 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/oracle/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/fedora27/listendbcrm/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fedora27.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=fedora27.localdomain)(PORT=5500))(Security=(my_wallet_directory=/home/oracle/app/oracle/admin/crm2018/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "67bface403cc56e7e0530901a8c04538" has 1 instance(s).
  Instance "crm2018", status READY, has 2 handler(s) for this service...
Service "67bfae14956d56f8e0530901a8c02065" has 1 instance(s).
  Instance "crm2018", status READY, has 2 handler(s) for this service...
Service "67c115e9583e64c6e0530901a8c08706" has 1 instance(s).
  Instance "crm2018", status READY, has 2 handler(s) for this service...
Service "crm" has 1 instance(s).
  Instance "crm2018", status READY, has 2 handler(s) for this service...
Service "crm2018" has 2 instance(s).
  Instance "cdb1", status BLOCKED, has 1 handler(s) for this service...
  Instance "crm2018", status READY, has 2 handler(s) for this service...
Service "dbcrm1" has 1 instance(s).
  Instance "crm2018", status READY, has 2 handler(s) for this service...
Service "dbcrm2" has 1 instance(s).
  Instance "crm2018", status READY, has 2 handler(s) for this service...
The command completed successfully

好像也没有什么问题

然后在sqlplus中启动实例,
startup

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/app/oracle/product/12.2.0.1/db_1/dbs/initcdb1.ora'

如何解决????

阅读 2.5k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题