01,问题描述
心血来潮想看一下启动数据库的alert log.然后把数据库给关闭了,同时也在监听日志文件
下面可谓是详细的描述了整个关机过程,也看到了无数的error
[root@node1 ~]# tail -F /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/alert_oracle1.log
Wed Mar 27 02:00:00 2019
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Wed Mar 27 10:05:35 2019
OS Pid: 2355 executed alter system set events 'trace[GCS_BSCN] disk=low'
Wed Mar 27 11:26:07 2019
ALTER SYSTEM SET _gc_policy_minimum=100 SCOPE=BOTH;
Wed Mar 27 11:26:41 2019
ALTER SYSTEM SET _gc_policy_time=4 SCOPE=SPFILE;
Wed Mar 27 13:43:19 2019
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Wed Mar 27 13:43:19 2019
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
License high water mark = 10
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Wed Mar 27 13:43:24 2019
SMON: disabling tx recovery
Stopping background process RCBG
SMON: disabling cache recovery
Wed Mar 27 13:43:28 2019
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 15 *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:28
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_lgwr_4291.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
NOTE: deferred map free for map id 16 *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:28
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_lgwr_4291.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
NOTE: deferred map free for map id 17 *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:28
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_lgwr_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_lgwr_4291.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
NOTE: deferred map free for map id 18
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 69
Successful close of redo thread 1
Wed Mar 27 13:43:28 2019
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 4 *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:28
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_dbw0_4289.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
NOTE: deferred map free for map id 5 *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:28
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_dbw0_4289.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
NOTE: deferred map free for map id 6 *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:28
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_dbw0_4289.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
NOTE: deferred map free for map id 7 *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:29
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_dbw0_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_dbw0_4289.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
NOTE: deferred map free for map id 8
Wed Mar 27 13:43:29 2019
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Wed Mar 27 13:43:29 2019
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 2 *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_ckpt_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:29
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_ckpt_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_ckpt_4293.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
NOTE: deferred map free for map id 3
Completed: ALTER DATABASE DISMOUNT
Wed Mar 27 13:43:29 2019
NOTE: Deferred communication with ASM instance *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:30
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:30
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:30
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:30
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:30
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:30
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:30
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:30
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:31
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:31
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:34
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:34
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:34
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:34
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:34
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:35
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:35
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:35
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:35
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:35
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:35
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_pmon_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
NOTE: Deferred communication with ASM instance
Errors in file /oracle/app/oracle/diag/rdbms/oracle/oracle1/trace/oracle1_pmon_4242.trc:
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
NOTE: force a map free for map id 3
NOTE: force a map free for map id 2
NOTE: force a map free for map id 8
NOTE: force a map free for map id 7
NOTE: force a map free for map id 6
NOTE: force a map free for map id 5
NOTE: force a map free for map id 4
NOTE: force a map free for map id 18
NOTE: force a map free for map id 17
NOTE: force a map free for map id 16
NOTE: force a map free for map id 15
Wed Mar 27 13:43:36 2019
Stopping background process VKTM
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Wed Mar 27 13:43:36 2019
NOTE: Shutting down MARK background process *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:38
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:39
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Wed Mar 27 13:43:40 2019 *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:40
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:43:42
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user2355_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser))
WARNING: ASM communication error: op 0 state 0x0 (15055)
ERROR: direct connection failure with ASM
Wed Mar 27 13:43:43 2019
freeing rdom 0
Wed Mar 27 13:43:49 2019
Instance shutdown complete
这个节点是RAC集群,但是两台主机,就一台主机存活
启动时候错误:
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+ORADATA01/oracle/spfileoracle.ora'
ORA-17503: ksfdopn:2 Failed to open file +ORADATA01/oracle/spfileoracle.ora
ORA-12547: TNS:lost contact
文件时放在ASM磁盘里面的
02,问题探测
报错意思看看--
处理系统参数错误,识别文件错误,打开错误,TNS,失去联系?
这都是啥问题哦.
我看看文件在不在把.
[grid@node1 ~]$ asmcmd
ASMCMD> ls
OCR_VOTE/
ORADATA01/
ORADATA02/
ASMCMD> cd ORADATA01
ASMCMD> ls
ORACLE/
arch1/
arch2/
ASMCMD> ls ORACLE/
ARCHIVELOG/
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
spfileoracle.ora
似乎没什么毛病啊
查看集群状态
crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE OFFLINE node1
ora.OCR_VOTE.dg
ONLINE ONLINE node1
ora.ORADATA01.dg
ONLINE ONLINE node1
ora.ORADATA02.dg
ONLINE ONLINE node1
ora.asm
ONLINE ONLINE node1 Started
ora.gsd
OFFLINE OFFLINE node1
ora.net1.network
ONLINE ONLINE node1
ora.ons
ONLINE ONLINE node1
ora.registry.acfs
ONLINE ONLINE node1
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node1
ora.cvu
1 OFFLINE OFFLINE
ora.oc4j
1 ONLINE ONLINE node1
ora.oracle.db
1 ONLINE OFFLINE Instance Shutdown
ora.scan1.vip
1 ONLINE ONLINE node1
----
01078---问题主要就是应为$ORACLE_HOME/bin/oracle 权限导致的,默认需要的权限为6751
----
[grid@node1 ~]$ cd /oracle/11.2.0/grid/crs/bin/
[grid@node1 bin]$ ls -l oracle
-rwxr-x--x 1 grid oinstall 209914479 Mar 5 15:17 oracle
权限不对..我也没改这个权限呀,为什么会出现这个问题呢?
03, 问题解决
[grid@node1 bin]$ chmod 6751 oracle
[grid@node1 bin]$ ls -l oracle
-rwsr-s--x 1 grid oinstall 209914479 Mar 5 15:17 oracle
[grid@node1 bin]$ su - oracle
Password:
[oracle@node1 ~]$ cd $ORACLE_HOME
[oracle@node1 db_1]$ cd bin/
[oracle@node1 bin]$ ls -l oracle
-rwsr-s--x 1 oracle asmadmin 239626641 Mar 5 16:25 oracle
启动数据库
Wed Mar 27 14:00:29 2019 *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:44:19
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
NOTE: failed to open SPFILE +ORADATA01/oracle/spfileoracle.ora *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@node1)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:44:52
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
NOTE: failed to open SPFILE +ORADATA01/oracle/spfileoracle.ora *********************************************************************** Fatal NI connect error 12547, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oracle/11.2.0/grid/crs/bin/oracle)(ARGV0=oracle+ASM1_user_oracle1)(ENVS='ORACLE_HOME=/oracle/11.2.0/grid/crs,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=node1)(USER=oracle)))) VERSION INFORMATION:
TNS for Linux: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
Time: 27-MAR-2019 13:45:15
Tracing not turned on.
Tns error struct:
ns main err code: 12547 TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 517 TNS-00517: Lost contact
nt secondary err code: 32
nt OS err code: 0
NOTE: failed to open SPFILE +ORADATA01/oracle/spfileoracle.ora
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = 64 KB Total Shared Global Region in Large Pages = 0 KB (0%) Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB RECOMMENDATION:
Total System Global Area size is 2402 MB. For optimal performance,
prior to the next instance restart:
1. Increase the number of unused large pages by
at least 1201 (page size 2048 KB, total size 2402 MB) system wide to
get 100% of the System Global Area allocated with large pages
2. Large pages are automatically locked into physical memory.
Increase the per process memlock (soft) limit to at least 2410 MB to lock
100% System Global Area's large pages into physical memory
********************************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 1
Number of processor cores in the system is 1
Number of processor sockets in the system is 1
Private Interface 'eth1:1' configured from GPnP for use as a private interconnect.
[name='eth1:1', type=1, ip=169.254.73.23, mac=00-50-56-a4-35-75, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]
Public Interface 'eth0' configured from GPnP for use as a public interface.
[name='eth0', type=1, ip=192.168.0.193, mac=00-50-56-a4-00-02, net=192.168.0.0/24, mask=255.255.255.0, use=public/1]
Public Interface 'eth0:1' configured from GPnP for use as a public interface.
[name='eth0:1', type=1, ip=192.168.0.176, mac=00-50-56-a4-00-02, net=192.168.0.0/24, mask=255.255.255.0, use=public/1]
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
NUMA status: non-NUMA system
cellaffinity.ora status: N/A
CELL communication will use 1 IP group(s):
Grp 0:
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /oracle/app/oracle/product/11.2.0/db_1/dbs/arch
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options.
ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: node1
Release: 2.6.32-754.11.1.el6.x86_64
Version: #1 SMP Tue Feb 26 15:38:56 UTC 2019
Machine: x86_64
VM name: VMWare Version: 6
Using parameter settings in server-side pfile /oracle/app/oracle/product/11.2.0/db_1/dbs/initoracle1.ora
System parameters with non-default values:
processes = 300
sessions = 472
spfile = "+ORADATA01/oracle/spfileoracle.ora"
sga_target = 2400M
control_files = "+ORADATA01/oracle/controlfile/current.267.1002895765"
control_files = "+ORADATA02/oracle/controlfile/current.256.1002895765"
db_block_size = 8192
compatible = "11.2.0.4.0"
cluster_database = TRUE
db_create_file_dest = "+ORADATA01"
db_create_online_log_dest_1= "+ORADATA01"
db_create_online_log_dest_2= "+ORADATA02"
_gc_policy_time = 4
_gc_policy_minimum = 100
thread = 1
undo_tablespace = "UNDOTBS1"
instance_number = 1
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=oracleXDB)"
remote_listener = "dbscan:1521"
audit_file_dest = "/oracle/app/oracle/admin/oracle/adump"
audit_trail = "DB"
db_name = "oracle"
open_cursors = 300
pga_aggregate_target = 800M
diagnostic_dest = "/oracle/app/oracle"
Cluster communication is configured to use the following interface(s) for this instance
169.254.73.23
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Wed Mar 27 14:00:36 2019
PMON started with pid=2, OS id=444
Wed Mar 27 14:00:36 2019
PSP0 started with pid=3, OS id=446
Wed Mar 27 14:00:37 2019
VKTM started with pid=4, OS id=448 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Wed Mar 27 14:00:37 2019
GEN0 started with pid=5, OS id=452
Wed Mar 27 14:00:37 2019
DIAG started with pid=6, OS id=454
Wed Mar 27 14:00:37 2019
DBRM started with pid=7, OS id=456
Wed Mar 27 14:00:37 2019
PING started with pid=8, OS id=458
Wed Mar 27 14:00:37 2019
ACMS started with pid=9, OS id=460
Wed Mar 27 14:00:37 2019
DIA0 started with pid=10, OS id=462
Wed Mar 27 14:00:37 2019
LMON started with pid=11, OS id=464
Wed Mar 27 14:00:37 2019
LMD0 started with pid=12, OS id=466
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [960 - 1280]
Wed Mar 27 14:00:37 2019
LMS0 started with pid=13, OS id=468 at elevated priority
Wed Mar 27 14:00:38 2019
RMS0 started with pid=14, OS id=472
Wed Mar 27 14:00:38 2019
LMHB started with pid=15, OS id=474
Wed Mar 27 14:00:38 2019
MMAN started with pid=16, OS id=476
Wed Mar 27 14:00:38 2019
DBW0 started with pid=17, OS id=478
Wed Mar 27 14:00:38 2019
LGWR started with pid=18, OS id=480
Wed Mar 27 14:00:38 2019
CKPT started with pid=19, OS id=482
Wed Mar 27 14:00:38 2019
SMON started with pid=20, OS id=484
Wed Mar 27 14:00:38 2019
RECO started with pid=21, OS id=486
Wed Mar 27 14:00:38 2019
RBAL started with pid=22, OS id=488
Wed Mar 27 14:00:38 2019
ASMB started with pid=23, OS id=490
Wed Mar 27 14:00:38 2019
MMON started with pid=24, OS id=492
NOTE: initiating MARK startup
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Starting background process MARK
Wed Mar 27 14:00:38 2019
MMNL started with pid=25, OS id=496
Wed Mar 27 14:00:38 2019
MARK started with pid=26, OS id=498
NOTE: MARK has subscribed
starting up 1 shared server(s) ...
lmon registered with NM - instance number 1 (internal mem no 0)
Reconfiguration started (old inc 0, new inc 2)
List of instances:
1 (myinst: 1)
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Wed Mar 27 14:00:39 2019
LCK0 started with pid=30, OS id=508
Starting background process RSMN
Wed Mar 27 14:00:39 2019
RSMN started with pid=31, OS id=510
Wed Mar 27 14:00:39 2019
ORACLE_BASE from environment = /oracle/app/oracle
NOTE: Loaded library: System
SUCCESS: diskgroup ORADATA01 was mounted
NOTE: dependency between database oracle and diskgroup resource ora.ORADATA01.dg is established
Wed Mar 27 14:00:41 2019
ALTER DATABASE MOUNT
This instance was first to mount
SUCCESS: diskgroup ORADATA02 was mounted
NOTE: dependency between database oracle and diskgroup resource ora.ORADATA02.dg is established
Successful mount of redo thread 1, with mount id 1877148105
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Wed Mar 27 14:00:46 2019
ALTER DATABASE OPEN
This instance was first to open
Picked broadcast on commit scheme to generate SCNs
Thread 1 opened at log sequence 69
Current log# 1 seq# 69 mem# 0: +ORADATA01/oracle/onlinelog/group_1.256.1002895765
Current log# 1 seq# 69 mem# 1: +ORADATA02/oracle/onlinelog/group_1.266.1002895767
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Instance recovery: looking for dead threads
Instance recovery: lock domain invalid but no dead threads
minact-scn: Inst 1 is now the master inc#:2 mmon proc-id:492 status:0x7
minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.00000000 gcalc-scn:0x0000.00000000
[608] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:1090369464 end:1090370324 diff:860 (8 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
Starting background process GTX0
Wed Mar 27 14:00:49 2019
GTX0 started with pid=36, OS id=646
Starting background process RCBG
Wed Mar 27 14:00:50 2019
RCBG started with pid=37, OS id=648
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Wed Mar 27 14:00:52 2019
QMNC started with pid=38, OS id=650
Completed: ALTER DATABASE OPEN
Wed Mar 27 14:00:56 2019
Starting background process CJQ0
Wed Mar 27 14:00:56 2019
CJQ0 started with pid=44, OS id=760
Wed Mar 27 14:01:39 2019
Decreasing number of real time LMS from 1 to 0
Wed Mar 27 14:05:52 2019
Starting background process SMCO
Wed Mar 27 14:05:52 2019
SMCO started with pid=28, OS id=1972
如愿以偿的看到了启动过程
问题探测
[Wèntí tàncè]
Problem detection