Error Backup : Shutdown of database instance SID failed

[Former Member]

Dear master,

I have the problem with backup SAP on aix.

error below:

BR0280I BRBACKUP time stamp: 2014-10-04 07.43.18

BR0307I Shutting down database instance BMQ ...

BR0278E Command output of '/oracle/BMQ/102_64/bin/sqlplus /nolog < /oracle/BMQ/sapbackup/.beowsqnn.spi':

6553968 : map : Permission Denied

6553968 : map : Permission Denied

6553968 : map : Permission Denied

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Oct 4 07:43:18 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> Connected.

SQL> csh: The file access permissions do not allow the specified action.

SQL> ORA-01013: user requested cancel of current operation

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

BR0280I BRBACKUP time stamp: 2014-10-04 08.43.17

BR0279E Return code from '/oracle/BMQ/102_64/bin/sqlplus /nolog < /oracle/BMQ/sapbackup/.beowsqnn.spi': 0

BR0302E SQLPLUS call for database instance BMQ failed

BR0309E Shutdown of database instance BMQ failed

BR0056I End of database backup: beowsqnn.aft 2014-10-04 08.43.17

BR0280I BRBACKUP time stamp: 2014-10-04 08.43.17

BR0054I BRBACKUP terminated with errors

Existing permission folder sapbackup 755

and I change into 777

but same the error.

please your advice master..

[Former Member · Accepted solution]

Hi,

It seems that your oracle_home is not properly mounted. In AIX if you are using directories as mount points then it gives such error if permissions differ for root and ora<sid> on same file system.

Try following:

login with root and execute following command at os level on database server.

1- Shutdown your database

2- uumount /oracle/BMQ/102_64

3- chmod 755 /oracle/BMQ/102_64

4- mount /oracle/BMQ/102_64

After this login with orabmq user and try to execute offline backup of the dataabse.

Regards

Krishan

[former_member188883]

Hi ,

Please ensure you have 755 permission for /oracle/BMQ/sapbackup.

Also owner of this file is orasid:dba

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Deepak

existing directory sapbackup owner is orasid:dba and permission 755 but that is first error.

[former_member188883]

Hi,

Please refer below SAP note

1261142 - Warning in BRBACKUP: "<number> : map : Permission Denied"

Probably an update in brtools is required.

regards,

Deepak Kori

[Former Member]

Deepak

thank for your advice,

but, I not sure because the symptom is after install oracle.

I backup online not error and successfully.

the case is If backup offline error below:

BR0278E Command output of '/oracle/BMQ/102_64/bin/sqlplus /nolog < /oracle/BMQ/sapbackup/.beowsqnn.spi':

6553968 : map : Permission Denied

6553968 : map : Permission Denied

6553968 : map : Permission Denied

Symptom

After you install the Oracle 10.2.0.4 client software, BRBACKUP on IBM AIX platform reports the following warnings, for example:
BR0278I Command output of '/usr/sap/SID/SYS/exe/run/brconnect':
BR0801I BRCONNECT 7.10 (14)
PID=1298546
1298546 : map : Permission Denied
1298546 : map : Permission Denied
BR0280I BRCONNECT time stamp: 2008-10-09 11.24.16
#SIGNAL CAUGHT: 15
BR0074W BRCONNECT call failed

[Former Member]

Hello,

Make sure that BRTools and other oracle (/oracle/*) related folders have right permissions.

113747 - Owners and authorizations for BR*Tools

regards,

pavan

[former_member182657]

Hi B000,

Could you check for permissions of sqlplus executable under $ORACLE_HOME/bin .

Try to give or use chmod a+r sqlplus  and re perform the process again.

Regards,

Gaurav

[Former Member]

Gaurav,

where is location $ORACLE_HOME/bin?

use the user ORASID, SIDADM or root?..

please advice.

[former_member182657]

Hi B000,

$ORACLE_HOME/bin

use path /oracle/<SID>/112_64/bin and here check the owner for files and permissions and provide ora<sid>:dba to the files in it.

Regards,

Gaurav Rana