ORA-01078 ORA-01565 ORA-17503 oracle 11.2.0.1重启虚拟机报错

寡人将臣

大家好，前段时间在安装11.2.0.1的时候无意发现这个问题，现总结如下，希望对你们有所帮助。（建议：早日升级新的版本）版本：centos 6.5
oracle：11.2.0.1 单机版


-----------------------------------------

[root@oracle-3 ~]# su - grid
[grid@oracle-3 ~]$ asmcmd
Connected to an idle instance.
ASMCMD> ls
ASMCMD-08102: no connection to ASM; command requires ASM to run
ASMCMD> exit
[grid@oracle-3 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-MAR-2018 07:26:46

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

Starting /u01/app/grid/product/11.2.0/grid/bin/tnslsnr: please wait...

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                03-MAR-2018 07:26:46
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/oracle-3/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle-3)(PORT=1521)))
The listener supports no services
The command completed successfully
[grid@oracle-3 ~]$ exit
logout
[root@oracle-3 ~]# su -oracle
su: invalid option -- 'o'
Try `su --help' for more information.
[root@oracle-3 ~]# su - oracle
[oracle@oracle-3 ~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 3 07:27:05 2018

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

Enter user-name: ^C
[oracle@oracle-3 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 3 07:27:14 2018

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

SQL> startup
ORA-01031: insufficient privileges
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/pug1/spfilepug1.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/pug1/spfilepug1.ora
ORA-29701: unable to connect to Cluster Synchronization Service
SQL> exit
Disconnected
[oracle@oracle-3 ~]$ exit
logout
[root@oracle-3 ~]# su - grid
[grid@oracle-3 ~]$ ps -ef|grep cssd
grid       2199   2169  0 07:28 pts/0    00:00:00 grep cssd
[grid@oracle-3 ~]$ crsctl check css
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
[grid@oracle-3 ~]$ crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@oracle-3 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.cssd       ora.cssd.type  OFFLINE   OFFLINE               
ora.diskmon    ora....on.type OFFLINE   OFFLINE               
[grid@oracle-3 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        OFFLINE OFFLINE                                                   
ora.diskmon
      1        OFFLINE OFFLINE                                                   
[grid@oracle-3 ~]$ crs_stat -p ora.cssd
NAME=ora.cssd
TYPE=ora.cssd.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=30
DESCRIPTION="Resource type for CSSD"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=600
STOP_TIMEOUT=900
UPTIME_THRESHOLD=1m

[grid@oracle-3 ~]$ crs_stat -p ora.diskmon
NAME=ora.diskmon
TYPE=ora.diskmon.type
ACTION_SCRIPT=
ACTIVE_PLACEMENT=0
AUTO_START=never
CHECK_INTERVAL=20
DESCRIPTION="Resource type for Diskmon"
FAILOVER_DELAY=0
FAILURE_INTERVAL=3
FAILURE_THRESHOLD=5
HOSTING_MEMBERS=
PLACEMENT=balanced
RESTART_ATTEMPTS=10
SCRIPT_TIMEOUT=60
START_TIMEOUT=60
STOP_TIMEOUT=60
UPTIME_THRESHOLD=5s

[grid@oracle-3 ~]$ crsctl start resource ora.cssd
CRS-2672: Attempting to start 'ora.cssd' on 'oracle-3'
CRS-2679: Attempting to clean 'ora.diskmon' on 'oracle-3'
CRS-2681: Clean of 'ora.diskmon' on 'oracle-3' succeeded
CRS-2672: Attempting to start 'ora.diskmon' on 'oracle-3'
CRS-2676: Start of 'ora.diskmon' on 'oracle-3' succeeded
CRS-2676: Start of 'ora.cssd' on 'oracle-3' succeeded



    到这里基本就找到了原因了,可以看到这两个资源的AUTO_START属性默认都设置为never,也就是说他们不会随着HAS服务的启动而自动启动的,
尽管默认情况下HAS服务是开机自动启动的.好了，那我们就手动启动一下吧:

注:ora.cssd和ora.diskmon这两个服务是有依赖关系的，启动哪个都会把两个都起来.

[grid@oracle-3 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.cssd       ora.cssd.type  ONLINE    ONLINE    oracle-3   
ora.diskmon    ora....on.type ONLINE    ONLINE    oracle-3   
[grid@oracle-3 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 3 07:30:38 2018

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

SQL> conn  /as sysdba
Connected to an idle instance.
SQL> startup
ORA-00099: warning: no parameter file specified for ASM instance
ORA-01031: insufficient privileges
SQL> exit
Disconnected
[grid@oracle-3 ~]$ asmcmd
Connected to an idle instance.
ASMCMD> ls
ASMCMD-08102: no connection to ASM; command requires ASM to run
ASMCMD> exit
[grid@oracle-3 ~]$ asmca
[grid@oracle-3 ~]$ export DISPLAY=192.168.133.1:0.0
[grid@oracle-3 ~]$ asmca
[grid@oracle-3 ~]$ exit
logout
[root@oracle-3 ~]# su - oracle
[oracle@oracle-3 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 3 07:34:53 2018

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

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  626327552 bytes
Fixed Size                  2215944 bytes
Variable Size             222302200 bytes
Database Buffers          398458880 bytes
Redo Buffers                3350528 bytes
Database mounted.
Database opened.
SQL>


注意：这里省略了去ASM管理器里面去把asm磁盘 mount哦。。

file:///D:\QQ Files\185692373\Image\Group\Image22\XC~~SH]B@AN2J~L2K`_2NU0.jpg