ERP6.0 installation error: require help

[Former Member]

hi everyone,

i am installing erp6 sr3 abap+java on linux rhel5 and oracle10.2.0.2.

i am stuck with phase 12 "create database"..... the error is below:

ERROR 2011-01-20 11:39:24.936

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-01501: CREATE DATABASE failed

ORA-00200: control file could not be created

ORA-00202: control file: '/orafiles/SE0/origlogA/cntrl/cntrlSE0.dbf'

ORA-27041: unable to open file

Linux-x86_64 Error: 13: Permission denied

Additional information: 2

what i have tried;

1) gave permissions to owner and group

2) gave 777 to /orafiles(after 3 days of unsuccessful attempts)

3) linux kernel parameters set according to note 1048303

4) hard soft limit for nofile set appropriately

5) fs.file-max parameter set accordingly

6) sqlplus show parameter control_file points to the right locations

7) IBM java paramaters set

😎 umask 022 set

9) tmp, TMP variables set

please can anyone help, im running out of ideas

Thank you.

Edited by: Shanser on Jan 20, 2011 2:36 PM

[Former Member]

During the install, does Oracle create the file? I'm just wondering if you have some weird kind of umask issue.

Not sure that helps but thought I would throw that out there.

Cheers!

Joe Haynes

[Former Member]

the error occurs when it tris to create the control file,

in sqlplus the db instance is in nomount state,

additional info: the show parameter control_file; gives the cntrl.dbf path in 3 locations,

ie origlogA origlogB and sapdata1 all in /orafiles/<sid>/....

[markus_doehr2]

> ERROR 2011-01-20 11:39:24.936

> CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-01501: CREATE DATABASE failed

> ORA-00200: control file could not be created

> ORA-00202: control file: '/orafiles/SE0/origlogA/cntrl/cntrlSE0.dbf'

> ORA-27041: unable to open file

> Linux-x86_64 Error: 13: Permission denied

> Additional information: 2

Make sure the user ora<sid> is owner of the directory and the subdirectories.

Is that an NFS mounted directory?

Markus

[Former Member]

hi...

yes ora<sid> is the owner and dba the group...

i logged on to os level and su to ora<se0> ... then created a file by giving touch... it created so no permission issues i guess

it is not nfs...

/dev/mapper/vg006-orafilesSE0

158G 189M 150G 1% /orafiles/SE0

[markus_doehr2]

> i logged on to os level and su to ora<se0> ... then created a file by giving touch... it created so no permission issues i guess

Did you do

su - ora<sid>

(including the dash)?

Can you also touch a file in the directory /orafiles/SE0/origlogA/cntrl/? Is that directory existing?

Markus

[Former Member]

yes su - orase0

/orafiles/SE0/orilogA/cntrl

then touch xyz it did create...

after this i didnt have ne option but to try 777, but still the sapinst give the same error..

FYI: i uninstalled and wiped clean the server, started the inst from the begining... still same error

is there a chance of it being a linux kernel issue? i mean the os team did hand over the server after installing linux el 5, maybe an issue with linux?

Edited by: Shanser on Jan 20, 2011 4:44 PM

[Former Member]

Does not look like issue with OS but have you checked the supported platforms under service.sap.com/pam

[markus_doehr2]

> FYI: i uninstalled and wiped clean the server, started the inst from the begining... still same error

> is there a chance of it being a linux kernel issue? i mean the os team did hand over the server after installing linux el 5, maybe an issue with linux?

Do you have the security modules (AppArmor or SELinux) deactivated for the installation? Are you running a high security installation?

Markus

[Former Member]

1. This file controls the state of SELinux on the system.

2. SELINUX= can take one of these three values:

3. enforcing - SELinux security policy is enforced.

4. permissive - SELinux prints warnings instead of enforcing.

5. disabled - SELinux is fully disabled.

SELINUX=disabled

1. SELINUXTYPE= type of policy in use. Possible values are:

2. targeted - Only targeted network daemons are protected.

3. strict - Full SELinux protection.

SELINUXTYPE=targeted

1. SETLOCALDEFS= Check local definition changes

SETLOCALDEFS=0

hi joe,

im using vnc for the install, i did set umask 022 on the vnc session too

Edited by: Shanser on Jan 21, 2011 10:00 AM

[markus_doehr2]

Another idea: Did you maybe do a "chmod 777" on the Oracle binary directory? Certain Oracle files have sticky bit set, if that is not set, permissions are no properly set during executing and hence failing.

What filesystem do those files reside on (ext3, reiserFS, ocfs)?

Markus

[Former Member]

i did give 777 to /orafiles .... but still same error... this is wat i really dont understand, why inspite of giving 777 it is not able to create....

the file system is :

/dev/vg0/rootvol / ext3 defaults 1 1

/dev/vg0/usr /usr ext3 defaults 1 2

/dev/vg0/freespace /freespace ext3 defaults 1 2

/dev/vg0/tmp /tmp ext3 defaults 1 2

/dev/vg0/export /export ext3 defaults 1 2

/dev/vg0/var /var ext3 defaults 1 2

LABEL=/boot /boot ext3 defaults 1 2

tmpfs /dev/shm tmpfs defaults 0 0

devpts /dev/pts devpts gid=5,mode=620 0 0

sysfs /sys sysfs defaults 0 0

proc /proc proc defaults 0 0

/dev/vg0/swapa swap swap defaults 0 0

/dev/vg0/swapb swap swap defaults 0 0

/dev/vg0/swap2 swap swap defaults 0 0

/dev/vg0/swap1 swap swap defaults 0 0

/dev/vg001/usrsapSE0 /usr/sap/SE0 ext3 defaults 1 2

/dev/vg002/usrsaptrans /usr/sap/trans ext3 defaults 1 2

/dev/vg003/sapmnt /sapmnt ext3 defaults 1 2

/dev/vg004/sapstage /sapstage ext3 defaults 1 2

/dev/vg005/oraunix /oraunix ext3 defaults 1 2

/dev/vg006/orafilesSE0 /orafiles/SE0 ext3 defaults 1 2

/dev/vg007/oraarchiveSE0 /oraarchive/SE0 ext3 defaults 1 2

/dev/vg008/orabackupSE0 /orabackup/SE0 ext3 defaults 1 2

/dev/vg009/swap01 swap swap defaults 0 0

[markus_doehr2]

>

> i did give 777 to /orafiles .... but still same error...

This is an ERROR, do NOT do that. You just hosed your Oracle installation.

Markus

[Former Member]

im rebooting the server, uninstalling and trying again

[markus_doehr2]

> im rebooting the server, uninstalling and trying again

You can try to fix the permissions by

- shutting down the database and all database related processes

- login as ora<SID>

- execute "relink.sh all"

then try to restart the installation.

Markus

[Former Member]

ok, ill try that