解决Linux下oracle12报错Connected

绿底为输入，白底为输出，黄底为输出中的错误提示。

十年的渭城网站建设经验，针对设计、前端、开发、售后、文案、推广等六对一服务，响应快，48小时及时工作处理。成都全网营销推广的优势是能够根据用户设备显示端的尺寸不同，自动调整渭城建站的显示方式，使网站能够适用不同显示终端，在浏览器中调整网站的宽度，无论在任何一种浏览器上浏览网站，都能展现优雅布局与设计，从而大程度地提升浏览体验。创新互联从事“渭城网站设计”,“渭城网站推广”以来，每个客户项目都认真落实执行。

问题描述：

[root@oracle ~]# su - oracle
Last login: Tue Sep 17 23:40:50 CST 2019 on pts/0

[oracle@oracle ~]$sqlplus /nolog

SQL*Plus: Release 12.2.0.1.0 Production on Mon Sep 2 01:09:18 2019

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

SQL> conn sys /as sysdba
Enter password:
Connected to an idle instance.

解决办法：

 1、进入到sqlplus启动实例

[root@oracle ~]# su - oracle                --1.确认切换到oracle用户
Last login: Tue Sep 17 23:40:50 CST 2019 on pts/0

[oracle@oracle ~]$ lsnrctl start                     --2.打开监听

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 02-SEP-2019 01:19:38

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

Starting /u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                02-SEP-2019 01:19:40
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully

[oracle@oracle ~]$ sqlplus /nolog                    --登录sqlplus

SQL*Plus: Release 12.2.0.1.0 Production on Mon Sep 2 01:23:29 2019

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

SQL> conn /as sysdba
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/12.2.0/dbhome_1/dbs/initoradb.ora'

原来打不开initoradb.ora，于是进入/u01/app/oracle/product/12.2.0/dbhome_1/dbs/目录

[root@oracle ~]# cd /u01/app/oracle/product/12.2.0/dbhome_1/dbs/

[root@oracle dbs]# ls
hc_orcl.dat  init.ora  lkORCL  orapworcl  spfileorcl.ora

原来是没有initoradb.ora文件。

解决此问题的方法就是到/u01/app/oracle/admin/orcl/pfile/目录下，将init.ora.818201912514复制到dbs目录下：

[root@oracle app]# cd /u01/app/oracle/admin/orcl/pfile/
[root@oracle pfile]# ls
init.ora.818201912514
[root@oracle pfile]# cp init.ora.818201912514 /u01/app/oracle/product/12.2.0/dbhome_1/dbs/initoradb.ora

cp的目标文件用oracle用户打开可能为空，用chmod命令授权：chmod -R 777 /目标文件

[root@oracle dbs]# chmod -R 777 /u01/app/oracle/product/12.2.0/dbhome_1/dbs/initoradb.ora

然后再次用sqlplus连接数据库，

[oracle@oracle ~]$ sqlplus /nolog
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup                    --启动oracle数据库
ORACLE instance started.

Total System Global Area 3741319168 bytes
Fixed Size      8627344 bytes
Variable Size    872418160 bytes
Database Buffers  2852126720 bytes
Redo Buffers      8146944 bytes
Database mounted.
Database opened.

数据库启动后，连接数据库
SQL> conn /as sysdba
Connected.