安装完毕后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'
如何解决????
运行
lsnrctl start
dbstart
参考
http://blog.itpub.net/2838988...
http://blog.itpub.net/2449295...
http://blog.csdn.net/yabingsh...