The installation of Oracle Rac,grid and Oracle on AIX 7100-02-03-1334 is complete. But DBCA built the database crash, the following is the building of the Alert.log, the database reported ora-07445 error, DBCA log can be found in the CREATE database error. No matching documents were found on MOS, try using other methods. /ORAAPP/ORACLE/DIAG/RDBMS/RMBTODB/RMBTODB1/TRACE/ALERT_RMBTODB1.LOGMMNL started with pid=26, OS id=7733452 Exception [Type:sigill, illegal opcode] [addr:0x103e2afa0] [pc:0x103e2afa0, {empty}] [flags:0x0, count:1]errors in file /ORAAPP/ORACLE/DIAG/RDBMS/RMBTODB/RMBTODB1/TRACE/RMBTODB1_ASMB_6357148.TRC (incident=105793): ORA-07445: Exception Encountered:core dump [pc:0x103e2afa0] [Sigill] [addr:0x103e2afa0] [pc:0x103e2afa0] [illegal opcode] [] Incident details in:/oraapp/oracle/diag/rdbms/rmbtodb/rmbtodb1/incident/incdir_105793/rmbtodb1_asmb_6357148_ I105793.trcuse Adrci or support Workbench to the incident. See Note 411.1 at My Oracle support for error and packaging Details.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 Chann Els Reestablished master broadcasted resource hash value bitmaps non-local Process blocks cleaned out lms 1:0 GCs Shadows cancelled, 0 closed, 0 Xw survived 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 resourcesreconfiguration Completethu Dec One 11:19:18 2014lck0 started with PID =27, OS id=10420304 starting background process Rsmnthu Dec 11:19:18 2014RSMN started with pid=28, OS ID=9306256&N Bsp;oracle_base from environment =/oraapp/oracleexception [TYPE:SIGSEGV, Address not mapped to object] [ADDR:0X496568BB8 ] [pc:0x10029b4d0, {empty}] [flags:0x8, count:3]errors in File/oraapp/oracle/diag/rdbms/rmbtodb/rmbtodb1/trace/rmbtodb1_asmb_6357148.trc ( incident=105794): ora-07445:exception encountered:core dump [pc:0x10029b4d0] [SIGSEGV] [ADDR:0X496568BB8] [PC:0 X10029B4D0] [Address not mapped to object] []ora-07445:exception encountered:core dump [pc:0x103e2afa0] [Sigill] [addr:0 X103E2AFA0] [pc:0x103e2afa0] [illegal opcode] []incident details in:/oraapp/oracle/diag/rdbms/rmbtodb/rmbtodb1/ Incident/incdir_105794/rmbtodb1_asmb_6357148_i105794.trcuse Adrci or support Workbench to the incident. See Note 411.1 at My Oracle support for error and packaging details. Thu Dec 11:19:21 2014Sweep [inc][105794]: Completeduse adrci or support Workbench to package the incident. See Note 411.1 at My Oracle support for error and packaging details. Sweep [inc][105793]: Completedsweep [inc2][93794]: Completedsweep [inc2][105794]: Completedpmon (ospid:16318602): Terminating the instance due to error 486System State dump requested By (Instance=1, osid=16318602 (Pmon)), summary=[abnormal instance termination]. System state dumped to trace file/oraapp/oracle/diag/rdbms/rmbtodb/rmbtodb1/trace/rmbtodb1_diag_14352568.trcdumping Diagnostic data in directory=[cdmp_20141211111922], requested by (Instance=1, osid=16318602 (Pmon)), Summary=[abnormal instance termination]. Instance terminated by Pmon, PID = 16318602[email protected]:/oraapp/oracle/diag/rdbms/rmbtodb/rmbtodb1/trace >1/INCIDENT/INCDIR_105794/RMBTODB1_ASMB_6357148_I105794.TRC < "/oraapp/oracle/diag/rdbms/rmbtodb/rmbtodb1/incident/incdir_ 105794/rmbtodb1_asmb_6357148_i105794.trc "2832 lines, 161159 characters dump file/oraapp/oracle/diag/rdbms/ Rmbtodb/rmbtodb1/incident/incdir_105794/rmbtodb1_asmb_6357148_i105794.trc
The first suspect is that Oracle does not have write access to the ASM disk, and attempts to create the SPFile on ASM with Oracle successfully. Check crs_home and Oracle_home for execute file Oracle, no permissions issues found.1, first try to build a library on node 1th manually, write a copy of Pfile, try to nomount the database, found that the database Nomount immediately after crash. 2, try to build a library on node 2nd, where the error message is as follows: DBCA/ORAAPP/ORACLE/CFGTOOLLOGS/DBCA/RMBTODB/TRACE.LOG[THREAD-178] [2014-12-11 12:47:49.813 CST] [ POSTDBCREATIONSTEP.EXECUTEIMPL:889] Starting Database HA resource[thread-178] [2014-12-11 12:48:16.318 CST] [CRSNative . internalstartresource:389] Failed to start resource:Name:ora.rmbtodb.db, Node:null, Filter:null, msg crs-5017:the R Esource action "ora.rmbtodb.db start" encountered the following error:ora-03113:end-of-file on communication channelproc ESS id:14287060session id:126 Serial number:1. For details refer to "(: CLSN00107:)" in"/oraapp/grid/gridhome/log/urmbtodb1/agent/crsd/oraagent_oracle/oraagent_oracle.log".
Crs-2674:start of ' ora.rmbtodb.db ' on ' urmbtodb1 ' failedCrs-2632:there is no more servers to try to place resource ' ora.rmbtodb.db ' on the would satisfy its placement poli Cy[Thread-178] [2014-12-11 12:48:16.319 CST] [postdbcreationstep.executeimpl:897] Exception while starting with HA Database Resource prcr-1079:failed to start Resource ora.rmbtodb.dbcrs-5017:the resour Ce action "ora.rmbtodb.db start" encountered the following error:ora-03113:end-of-file on communication channelprocess ID : 14287060Session id:126 Serial number:1. For details refer to "(: CLSN00107:)" in "/oraapp/grid/gridhome/log/urmbtodb1/a Gent/crsd/oraagent_oracle/oraagent_oracle.log ".
Crs-2674:start of ' ora.rmbtodb.db ' on ' urmbtodb1 ' Failedcrs-2632:there is no more servers to try to place resource ' Ora . rmbtodb.db ' on this would satisfy its placement policy
Ora.rmbtodb.db failed to start on RMBTODB1, but the database can be successfully created on node # 2nd.
Specific view Oraagent_oracle.log log:/oraapp/grid/gridhome/log/urmbtodb1/agent/crsd/oraagent_oracle/oraagent_oracle.log
2014-12-10 22:48:11.505: [usrthrd][1800] {2:52141:473} Value of Local_listener is2014-12-10 22:48:11.549: [USRTHRD][180 0] {2:52141:473} ora-01405:fetched column value is NULL
2014-12-10 22:48:11.549: [usrthrd][1800] {2:52141:473} Value of Listener_networks is2014-12-10 22:48:11.549: [USRTHRD][ 1800] {2:52141:473} sqlstmt = alter SYSTEM SET local_listener= ' (description= (address_list= (address= (protocol= TCP) (host=200.31.155.225) (port=1521))) ' Scope=memory sid= ' rmbtodb1 '/* DB agent *//* {2:52141:473} */2014-12-10 22:48:13.011: [usrthrd][1800] {2:52141:473} ora-03113:end-of-file on communication channelProcess id:142870 60Session id:126 Serial number:1 found the database crash when setting up the Local_listener. At this point the problem is already very obvious, certainly is the network aspect question. The AIX administrator indicates that the mode of changing NIC bindings was previously made on node 1th. [Email protected]:/home/grid>oifcfg getif-globalen10 192.168.4.0 Global cluster_interconnecten9 200.31.155.0 glob Al public there is no exception to view public IP and priv IP. Try to reset the public IP: Delete en9 message: [Email protected]:/home/grid>oifcfg-delif-global en9[email protected]:/home/grid> Oifcfg getif-globalen10 192.168.4.0 Global cluster_interconnect reset public ip:[email protected]:/home/grid>oifcfg-se Tif-global en9/200.31.155.0:public[email protected]:/home/grid>oifcfg getif-globalen10 192.168.4.0 Global Cluster _INTERCONNECTEN9 200.31.155.0 Global Public
The CRS is then restarted. And again in the number 1th node DBCA build Library, no previous similar problems.
Oracle Rac DBCA built under AIX ora-7445 [pc:0x103e2afa0]
