ORA-27041: unable to open file

[former_member189971]

Dear All,

I am facing the error backup errors ..

can anybody help on this. please...

Regards,

Ram.

[former_member189971 · Accepted solution]

Dear All,

Thanks your time for giving valuable suggestions/Recommendations to get me out of the  issue.

Finally Issue resolved.

Issue symptom:

1. Backup Failure.
2. Archive Stuck.
3. Redo log backup failure
4. End-to-end communication channel errors.
5. ORA-27041: unable to open file.
6. Linux_x64 Error: 13 Permission Denied.additional Information :2

Solution

1. Implemented the note:“546006 - Problems with Oracle due to operating system errors

from the note we have Identified the issue.

We have implemented the "1" option from the note.

McAfee antivirus agent and scanner caused for :

1. Linux_x64 Error: 13 Permission Denied.additional Information :2

Solution checklist:

1. ps -ef | grep MacAfee
2. Top command for running MacAfee scanner process
3. ps -ef | grep scanner

Implemented Solution:

/etc/init.d/cma stop

In addition we have identified the issue with the McAfee antivirus Informed to hosting partner and they have re installed the McAfee antivirus  and after that system is operational with out any hiccups.

Regards,

Rama

[former_member206552]

Good Morning,

does the file allready excist ?

/oracle/RT1/sapbackup/cntrlRT1.dbf , if so move the files to another location and retry

Best Regards

Marius

[former_member189971]

Hi Burger,

Very Good Morning,

I have moved to another Location but no luck,

Regards,

Rama

[former_member206552]

Hi Rama,

does it work when you go to sqlplus and run

alter database backup controlfile to '/oracle/RT1/sapbackup/cntrlRT1.dbf';

or

alter database backup controlfile to '/oracle/RT1/cntrlRT1.dbf';

Best Regards

Marius

[former_member182657]

Hi Ram,

Have you checked SAP Note  841014 - Error ORA-01580 in BRSPACE database space administration

earlier i mentioned you to follow,as per this Note

This error only occurs if the control files are on Raw hard disks.

For this kindly check with your system disks as well.

Regards,

Gaurav

[former_member182657]

Hi Ram,

As @Reagan Benjamin already suggested you so many solutions,here i would like to add one of my query regarding space level on your system,If possible kindly reconfirm for any space related issue first at your end.

Please confirm.

Regards,

Gaurav Rana

[former_member189971]

Hi Gaurav,

Thanks for the suggestions, and there is no issue problems with space and we are having the sufficient space .

Regards,

Ram

[former_member189971]

Hi RB,

cllxcdlert01:orart1 51> ls -la /usr/sap/RT1/SYS/exe/run/br*

-rwsrwxr-- 1 orart1 sapsys  9592196 Jan 11  2014 /usr/sap/RT1/SYS/exe/run/brarchive

-rwsrwxr-- 1 orart1 sapsys  9722473 Jan 11  2014 /usr/sap/RT1/SYS/exe/run/brbackup

-rwsrwxr-- 1 orart1 sapsys 11624117 Jan 11  2014 /usr/sap/RT1/SYS/exe/run/brconnect

-rwxr-xr-x 1 rt1adm sapsys 10181075 Jan 11  2014 /usr/sap/RT1/SYS/exe/run/brrecover

-rwxr-xr-x 1 rt1adm sapsys  6434884 Jan 11  2014 /usr/sap/RT1/SYS/exe/run/brrestore

-rwxr-xr-x 1 rt1adm sapsys 12063513 Jan 11  2014 /usr/sap/RT1/SYS/exe/run/brspace

-rwxr-xr-x 1 rt1adm sapsys  7013948 Jan 11  2014 /usr/sap/RT1/SYS/exe/run/brtools

cllxcdlert01:orart1 52>

Regards,

Ram

[Reagan]

Thanks.

I would first update the BR*Tools and see if that helps

You can also set the permission and ownership of the BR*Tools files as described in the last part of the SAP note 776505 - ORA-01017/ORA-01031 in BR*Tools on Linux and Solaris 11

su - root
cd /usr/sap/<SAPSID>/SYS/exe/run
chown ora<dbsid> brarchive brbackup brconnect
chgrp dba brarchive brbackup brconnect
chmod 6754 brarchive brbackup brconnect

These commands should result in the following file authorizations:
-rwsr-sr-- 1 ora<dbsid>  dba     9325374 2012-12-19 04:52 brarchive
-rwsr-sr-- 1 ora<dbsid>  dba     9443223 2012-12-19 04:52 brbackup
-rwsr-sr-- 1 ora<dbsid>  dba    11333756 2012-12-19 04:55 brconnect
-rwxr-xr-x 1 <sapsid>adm sapsys  9893702 2012-12-19 04:56 brrecover
-rwxr-xr-x 1 <sapsid>adm sapsys  6203096 2012-12-19 04:56 brrestore
-rwxr-xr-x 1 <sapsid>adm sapsys 11766827 2012-12-19 04:58 brspace
-rwxr-xr-x 1 <sapsid>adm sapsys  6797524 2012-12-19 04:58 brtools

I know it is not relevant for this issue but I would personally try and see if that helps.

If that doesn't help then I strongly believe there is an issue with the Linux and I would ask an OS specialist to validate the OS and also umask settings.

You may also raise an OSS message with all the actions you have done and see if the support could help you in some way.

Good Luck

RB

[former_member189971]

Dear All,

I have activated the trace Brtools as per the note  29321 - Creating traces for BR Tools

I am unable to Identify the trace log file .. could you please advise ...how to ge the trace file....

Regads,

Ram

[Reagan]

Have you run the saproot.sh script ?

[former_member189971]

Hi RB,

[root@cllxcdlert01 exe]# ./saproot.sh RT1

Preparing /usr/sap/RT1/SYS/exe/run/brbackup ...

Preparing /usr/sap/RT1/SYS/exe/run/brarchive ...

Preparing /usr/sap/RT1/SYS/exe/run/brconnect ...

Preparing icmbnd ...

Set user ID bit on /usr/sap/RT1/SYS/720_REL/sapuxuserchk

Set user ID bit on /usr/sap/RT1/DVEBMGS00/exe/sapuxuserchk

Set user ID bit on /usr/sap/RT1/DVEBMGS00/exe_byinst/sapuxuserchk

done

[root@cllxcdlert01 exe]# ./oraroot.sh RT1

Preparing /usr/sap/RT1/SYS/exe/run/brarchive ...

Preparing /usr/sap/RT1/SYS/exe/run/brbackup ...

Preparing /usr/sap/RT1/SYS/exe/run/brconnect ...

done

Regards,

Ram

[former_member189971]

Hi RB,

After running the script I have started the tools and I am getting the below error..

BR0259I Program execution will be continued...

###############################################################################

BR0051I BRBACKUP 7.20 (35)

BR0055I Start of database backup: beotflpw.anf 2014-09-15 21.00.40

BR0484I BRBACKUP log file: /oracle/RT1/sapbackup/beotflpw.anf

BR0477I Oracle pfile /oracle/RT1/112_64/dbs/initRT1.ora created from spfile /oracle/RT1/112_64/dbs/spfileRT1.ora

BR0280I BRBACKUP time stamp: 2014-09-15 21.00.42

BR0301E SQL error -1580 at location BrCtlBackup-1, SQL statement:

'/* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/RT1/sapbackup/cntrlRT1.dbf''

ORA-01580: error creating control backup file /oracle/RT1/sapbackup/cntrlRT1.dbf

ORA-27041: unable to open file

Linux-x86_64 Error: 13: Permission denied

Additional information: 2

BR0320E Copying of control file to /oracle/RT1/sapbackup/cntrlRT1.dbf failed

BR0314E Collection of information on database files failed

BR0056I End of database backup: beotflpw.anf 2014-09-15 21.00.42

BR0280I BRBACKUP time stamp: 2014-09-15 21.00.42

BR0054I BRBACKUP terminated with errors

###############################################################################

Thank You,

[Reagan]

and how does the permission look now ?

ls -la /usr/sap/RT1/SYS/exe/run/br*

[former_member189971]

Dear All,

We have recently patched for OS(Red hat Linux). and After starting the sap I am getting the errors as attached.

Regards,

Ram,

[divyanshu_srivastava3]

What is you OS ? AIX ?

Take a restart of your DB or may be reboot your system, and this should be will be fixed.

Otherwise,

Refer - 583861 - UNIX: Errors due to Oracle executable

and permissions as suggest above.

Regards

[former_member189971]

Hi Sri,

Thanks for the update.

our operating system is Redhat linux .

verified as well but no luck.

Regards,

Ram

[divyanshu_srivastava3]

Open Alert log and see if you can find any problems in that.

Also, supply full backup logs.

[Former Member]

Dear

check all permissions

Could you download the latest brtools and try to execute the backup, again?

Regards,

[Former Member]

Dear

This is your new installation or it is an running system which got this issue

if it is new system then follow the link

Regards

[former_member182657]

Hi Ram,

Please follow SAP Notes   651351 - BR tools on UNIX: Error due to executable permissions

and   841014 - Error ORA-01580 in BRSPACE database space administration

and check for permission issue as already been suggested by Reagan.

Thanks,

Gaurav

[former_member189971]

Hi Gaurav,

Thanks for the prompt response.

I have gone through the notes and checked 651351 and according to to the note all are correct.

Regards,

Ram

[Reagan]

Check whether the permissions of the BR*Tools are set correctly.

Follow this SAP note 113747 - Owners and authorizations for BR*Tools

Regards

RB

[former_member189971]

Hi Regan,

Thanks for the quick response ... I have gone through the 113747

all permissions are correctly set.

Regards,

Ram

[Reagan]

Could you supply the output of these commands ?

ls -lad /oracle/RT1/sap*

id orart1

id rt1adm

Regards

RB

[former_member189971]

Hi RB,,

Please find the out of the commands,

cllxcdlert01:orart1 51>

cllxcdlert01:orart1 51> ls -lad /oracle/RT1/sap*

drwxrwxr-x  2 orart1 dba 36864 Sep 15 19:00 /oracle/RT1/saparch

drwxrwxr-x  2 orart1 dba  4096 Sep 15 19:16 /oracle/RT1/sapbackup

drwxrwxr-x  2 orart1 dba  4096 Sep 15 15:29 /oracle/RT1/sapcheck

drwxrwxr-x 19 orart1 dba  4096 Aug 13  2013 /oracle/RT1/sapdata1

drwxrwxr-x 15 orart1 dba  4096 Aug 13  2013 /oracle/RT1/sapdata2

drwxrwxr-x 15 orart1 dba  4096 Sep 17  2013 /oracle/RT1/sapdata3

drwxrwxr-x 16 orart1 dba  4096 Jun 15 13:24 /oracle/RT1/sapdata4

drwxrwxr-x  3 orart1 dba  4096 Sep 14 05:33 /oracle/RT1/sapreorg

drwxrwxr-x  4 orart1 dba  4096 Aug 13  2013 /oracle/RT1/saptrace

cllxcdlert01:orart1 52> exit

logout

[cadmin@cllxcdlert01 ~]$ sudo su - rt1adm

cllxcdlert01:rt1adm 51>  ls -lad /oracle/RT1/sap*

drwxrwxr-x  2 orart1 dba 36864 Sep 15 19:00 /oracle/RT1/saparch

drwxrwxr-x  2 orart1 dba  4096 Sep 15 19:16 /oracle/RT1/sapbackup

drwxrwxr-x  2 orart1 dba  4096 Sep 15 15:29 /oracle/RT1/sapcheck

drwxrwxr-x 19 orart1 dba  4096 Aug 13  2013 /oracle/RT1/sapdata1

drwxrwxr-x 15 orart1 dba  4096 Aug 13  2013 /oracle/RT1/sapdata2

drwxrwxr-x 15 orart1 dba  4096 Sep 17  2013 /oracle/RT1/sapdata3

drwxrwxr-x 16 orart1 dba  4096 Jun 15 13:24 /oracle/RT1/sapdata4

drwxrwxr-x  3 orart1 dba  4096 Sep 14 05:33 /oracle/RT1/sapreorg

drwxrwxr-x  4 orart1 dba  4096 Aug 13  2013 /oracle/RT1/saptrace

Regards,

Ram

[Reagan]

You haven't provided me the output for all the commands.

Could you supply the output of the id commands as well ?

[former_member189971]

Hi RB,

Is There any differences,from the both Id's Rt1adm and orart1

Regards,

Ram.

[former_member189971]

Hi RB

Please find the out put of the ID's

[cadmin@cllxcdlert01 ~]$ id rt1adm

uid=22437(rt1adm) gid=1045(sapsys) groups=1045(sapsys),1044(sapinst),201(dba),202(oper),200(sapsys)

[cadmin@cllxcdlert01 ~]$ id orart1

uid=22438(orart1) gid=201(dba) groups=201(dba),1044(sapinst),202(oper),200(sapsys)

Regards,

Ram

[Reagan]

They look OK apart from the fact the group sapsys is present twice.

Could you also check the ownership and permission of the Oracle control files ?

Run saproot.sh and see if that helps.

cd /sapmnt/RT1/exe

./saproot.sh RT1

Regards

RB

[former_member189971]

Hi RB,

Thanks for the Prompt response.. I will check and get back to you.

Regards,

Ram

[former_member189971]

Hi RB,

cllxcdlert01:orart1 55> ll

total 111248

-rwxrwxrwx 1 orart1 dba 113917952 Sep 15 20:44 cntrlRT1.dbf

/oracle/RT1/origlogA/cntrl

cllxcdlert01:orart1 57> cd /oracle/RT1/origlogB/cntrl/

cllxcdlert01:orart1 58> ll

total 111248

-rwxrwxrwx 1 orart1 dba 113917952 Sep 15 20:44 cntrlRT1.dbf

cllxcdlert01:orart1 60> cd /oracle/RT1/sapdata1/cntrl/

cllxcdlert01:orart1 61> ll

total 111252

-rwxrwxr-x 1 orart1 dba 113917952 Sep 15 20:45 cntrlRT1.dbf

cllxcdlert01:orart1 62>

Regards,

Ram