on 11-06-2014 6:35 PM
Hello,
I hope you can help me with this issue:
I'm installing CRM and ERP High Availability systems with ORACLE ASM in Red Hat Linux. In SWPM the DB Instance installation (2 nodes) fails in "Create Database" phase. The ora_sql_results.log throws the following:
Connected to:
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
CREATE DATABASE CAP CONTROLFILE REUSE MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 1000 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE '+DATA' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE '+DATA' SIZE 1210M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO001 DATAFILE '+DATA' SIZE 8192M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 32700M SYSAUX DATAFILE '+DATA' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: control file could not be created
ORA-00202: control file: '+DATA/cap/cntrlcap.dbf'
ORA-17502: ksfdcre:3 Failed to create file +DATA/cap/cntrlcap.dbf
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
ORA-15040: diskgroup is incomplete
Disconnected from 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
SAPINST: End of output of SQL executing program /oracle/CAP/112/bin/sqlplus.
SAPINST found errors.
SAPINST The current process environment may be found in sapinst_ora_environment.log.
2014-10-31, 13:58:25 SAPINST ORACLE stop logging
The strange thing is that the diskgroups are mounted:
In node 1:
In node 2:
I hope you can help me and share your experience.
Thanks a lot.
Dario.
Hi Dario,
this looks like a classical permission issue between GI user, RDBMS user and ASM disks.
Can you please post / cross-check the permission of each ASM disk (especially group permissions) with the GI user and Oracle RDBMS user?
shell> ls -la <path_to_asm_disks>
shell> id -a <grid_user>
shell> id -a <rdbms_user>
shell> ls -la $ORACLE_HOME/bin/oracle (as rdbms_user)
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Stefan, thank you for your time and your help. Below you will find what you requested.
[root@ORACLERAC101 disks]# pwd
/dev/oracleasm/disks
[root@ORACLERAC101 disks]# ls -la
total 0
drwxr-xr-x 1 root root 0 Oct 22 18:55 .
drwxr-xr-x 4 root root 0 Oct 22 18:55 ..
brw-rw---- 1 grid asmadmin 253, 20 Nov 7 10:06 DSKARCH01
brw-rw---- 1 grid asmadmin 253, 19 Oct 23 12:23 DSKARCH02
brw-rw---- 1 grid asmadmin 253, 22 Oct 23 12:23 DSKARCH03
brw-rw---- 1 grid asmadmin 253, 21 Nov 7 10:06 DSKDATA011
brw-rw---- 1 grid asmadmin 253, 17 Oct 31 15:44 DSKDATA012
brw-rw---- 1 grid asmadmin 253, 18 Oct 31 15:44 DSKDATA013
brw-rw---- 1 grid asmadmin 253, 24 Nov 7 10:06 DSKFRA01
brw-rw---- 1 grid asmadmin 253, 23 Oct 23 12:22 DSKFRA02
brw-rw---- 1 grid asmadmin 253, 25 Oct 23 12:22 DSKFRA03
brw-rw---- 1 grid asmadmin 253, 36 Nov 7 10:06 DSKREDO011
brw-rw---- 1 grid asmadmin 253, 26 Oct 31 15:44 DSKREDO012
brw-rw---- 1 grid asmadmin 253, 30 Oct 31 15:44 DSKREDO013
brw-rw---- 1 grid asmadmin 253, 27 Nov 7 10:06 DSKREDO021
brw-rw---- 1 grid asmadmin 253, 29 Oct 31 15:44 DSKREDO022
brw-rw---- 1 grid asmadmin 253, 28 Oct 31 15:44 DSKREDO023
[root@ORACLERAC101 disks]# id -a grid
uid=951(grid) gid=900(oinstall) groups=900(oinstall),902(asmadmin),903(asmdba),904(asmoper)
[root@ORACLERAC101 disks]# id -a oracle
uid=950(oracle) gid=900(oinstall) groups=900(oinstall),901(dba),902(asmadmin),903(asmdba),904(asmoper),905(sapinst),906(oper)
[root@ORACLERAC101 disks]# id -a capadm
uid=500(capadm) gid=501(sapsys) groups=501(sapsys),900(oinstall),901(dba),903(asmdba),904(asmoper),905(sapinst),906(oper)
[root@ORACLERAC101 disks]# su - oracle
[oracle@ORACLERAC101 ~]$ ls -la $ORACLE_HOME/bin/oracle
-rwsr-s--x 1 oracle asmadmin 239626641 Oct 22 21:15 /u01/app/oracle/product/11.2.0.4/db_1/bin/oracle
Thanks a lot.
Darío.
Hi Dario,
the permissions look good one node ORACLERAC101, but what about node ORACLERAC102?
I am sorry, that i have not mentioned to check both nodes - i just implied it. On which node did you run the "CREATE DATABASE" statement? Have you also tried to dismount and remount the DATA disk group in each ASM instance for verification of the current state or have you already tried to create a non-sys folder / file with asmcmd?
ASM notices disk issues in particular situations - Oracle documentation: http://docs.oracle.com/cd/E11882_01/server.112/e16102/asmdiskgrps.htm#OSTMG10044
I currently got only an Oracle RAC 12.0.1.2 wit udev in my lab, so i can not try to re-create your issue.
Regards
Stefan
Hi Dario, please tell me what values you updated from the SWPM, we are facing the same problem
Best Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dario
We are facing similar issue. Could you please let us know if you were able to resolve this issue?
The DB instance installation is stuck because of this. Any help would be much appreciated
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.