Hi All,
Pls help me fix error while create database by dbca in oracle database 12c .
I have install oracle rac with grid by grid user and oracle by oracle user. grid and oracle db install success. But error while create database.
I see error in alert and trace file below . Pls get the attache file .
Many thank you .
Trace file /u01/app/oracle/diag/rdbms/oradb/oradb1/trace/oradb1_ora_11863.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/12.1/db_1
System name: Linux
Node name: racnode1.fe.me
Release: 2.6.32-504.el6.x86_64
Version: #1 SMP Tue Sep 16 01:56:35 EDT 2014
Machine: x86_64
Instance name: oradb1
Redo thread mounted by this instance: 0 <none>
Oracle process number: 30
Unix process pid: 11863, image: oracle@racnode1.fe.me (TNS V1-V3)
*** 2015-11-17 23:34:21.479
*** SESSION ID:(1.38026) 2015-11-17 23:34:21.479
*** CLIENT ID:() 2015-11-17 23:34:21.479
*** SERVICE NAME:() 2015-11-17 23:34:21.479
*** MODULE NAME:(sqlplus@racnode1.fe.me (TNS V1-V3)) 2015-11-17 23:34:21.479
*** CLIENT DRIVER:() 2015-11-17 23:34:21.479
*** ACTION NAME:() 2015-11-17 23:34:21.479
*** CONTAINER ID:(1) 2015-11-17 23:34:21.479
2015-11-17 23:34:21.479: [ GPNP]clsgpnpkwf_initwfloc: [at clsgpnpkwf.c:469] (:GPNP01002:)SlfFopen2
Internal Error Information:
Category: SLF_SYSTEM(-8)
Operation: lstat failed
Location: slsfopen3
Other:
Dep: 13
Dep Message: Permission denied
2015-11-17 23:34:21.479: [ GPNP]clsgpnpkwf_initwfloc: [at clsgpnpkwf.c:471] Result: (7) CLSGPNP_IO. (:GPNP01002:)Failed to open wallet file. dir 'peer' in '/u01/app/12.1/grid/gpnp/racnode1/wallets/', cannot check wallet home.
2015-11-17 23:34:21.510: [ GPNP]clsgpnp_dbmsGetItem_profile: [at clsgpnp_dbms.c:345] Result: (0) CLSGPNP_OK. (:GPNP00401:)got ASM-Profile.Mode='legacy'
*** 2015-11-17 23:34:28.496
*** CLIENT DRIVER:(SQL*PLUS) 2015-11-17 23:34:28.496
*** ACTION NAME:(0000001 FINISHED51) 2015-11-17 23:34:28.496
*** CONTAINER ID:(1) 2015-11-17 23:34:28.496
Control file created with size 1156 blocks
*** KCC: Early registration for CF file(s) with CSS failed
*** 2015-11-17 23:34:28.884
Stopping background process MMNL
*** 2015-11-17 23:34:29.889
Stopping background process MMON
*** 2015-11-17 23:34:30.913
kwsbgshms: Shutdown all masters complete
Shutting down AQ Process Coordinator
Prior to RESETLOGS processing...
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE start
Database is not in archivelog mode
ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE complete
DDE rules only execution for: ORA 313
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 1 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 1 csec) -----
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00313: open failed for members of log group 1 of thread 1
*** 2015-11-17 23:34:31.052234 4929 krsh.c
Clearing online redo logfile 1 +DATA
DDE: Problem Key 'ORA 313' was flood controlled (0x1) (no incident)
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00313: open failed for members of log group 1 of thread 1
[grid@racnode1 ~]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora....ILES.dg ora....up.type 0/5 0/ ONLINE ONLINE racnode1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE racnode1
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE racnode1
ora....N2.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE racnode1
ora....N3.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE racnode1
ora.MGMTLSNR ora....nr.type 0/0 0/0 ONLINE ONLINE racnode1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE racnode1
ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE racnode1
ora.mgmtdb ora....db.type 0/2 0/1 ONLINE ONLINE racnode1
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE racnode1
ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE racnode1
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE racnode1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE racnode1
ora....E1.lsnr application 0/5 0/0 ONLINE ONLINE racnode1
ora....de1.ons application 0/3 0/0 ONLINE ONLINE racnode1
ora....de1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE racnode1
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE racnode1
ora.scan2.vip ora....ip.type 0/0 0/0 ONLINE ONLINE racnode1
ora.scan3.vip ora....ip.type 0/0 0/0 ONLINE ONLINE racnode1