cancel
Showing results for 
Search instead for 
Did you mean: 

DB instance Installation with ORACLE ASM - ORA-17502 and ORA-15040 errors

0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

stefan_koehler
Active Contributor
0 Kudos

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

0 Kudos

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.

stefan_koehler
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

0 Kudos

Hi Dario, please tell me what values you updated from the SWPM, we are facing the same problem

Best Regards

itsrahulmehta
Explorer
0 Kudos

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

0 Kudos

Hi Rahul, sorry for the delay! The problem was that the diskgroups that SWPM offers by default were not present in the system, so it was needed to update the parameters in SWPM with the correct values, just simple as that.

I hope it helps.

Best Regards!