oracle 12 无法启动,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'

如何解决????

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值