Could not schedule jobs from DB13

[Former Member]

Hi Experts,

yesterday we have changed the file permission in /oracle/<SID>/102_64 mount point in our production system.

After changing i could not schedule any jobs from DB13 and i could not use <sidadm> user for taking the backup from sap.

Now i am taking the backup through OS and Archive log copying also OS level.

I have given the below command for changing the file permission.

chmod -R 777 /oracle/TPR/102_64

I think we changed the whole permission under the oracle/SID/102_64 mount point. its changing the full permission for Oracle related files.

How i can revoke the same?

Kindly advice.

Regards,

Sundar.C

[Former Member]

Hi,

Please check you are able to run the backup from Brtools at os level.

If yes then check the permission of the files in the sapmnt/SID/exe as mentioned below.

-rwxr-xr-x 1 <SID>adm sapsys 9652136 brrecover

-rwxr-xr-x 1 <SID>adm sapsys 3403504 brrestore

-rwxr-xr-x 1 <SID>adm sapsys 12771456 brspace

-rwsrwxr-x 1 ora<SID> dba 4962288 brtools

-rwsrwxr-x 1 ora<SID> dba 8910816 brarchive

-rwsrwxr-x 1 ora<SID> dba 9282832 brbackup

-rwsrwxr-x 1 ora<SID> dba 12419824 brconnect

If you are not able to fire the backup from Brtools.

then you need to get the file system restored as you change the permission of all the files by doing the chmod -R.

or

you can compare the permission with another sap server of same database and same patch level and then change the permission manually of all the directoried and files.

did you stop the dtabase and then did the permission change if no then restart the server .it may be possible thet your database shall not come up.

thanks

Rishi Abrol

[Former Member]

Hi,

1) I am able to take Offline backup by using <SIDadm>. full backup and incremental backup I am able to take for DEV & QAS servers.

2) I am not able to take Online Backup by using DB13 for DEV & QAS Server. I am not able to trace to trouble. I am falling proper procedure, but I am not able to take.

Try to send the procedure to take Online backup

Need help how to take the Online backup.

[Former Member]

Dear pandu,

What is the error message you are getting in DB13 while you are trying to take online backup. If possible please paste the log here.

Also. for firing backup from DB13 we need to give parameter file init<SID>.sap file and in that we need to modify the below parameters as per our requuirement and while scheduling the backup we need to supply the name of the parameter file. Either you can change the values in original file or copy original file to some other name and need to give that name while scheduling backup from DB13 for eg... if original file is initXXX.sap then rename it to Online_initXXX.sap and change the below parameters as per requirenment.

backup_type - online_cons

backup_dev_type - disk/tape (As per your requirement) If you want to backup to disk then need to give the path of disk where you are backing up the data in next parameter

backup_root_dir - path of the disk where you want to take the backup.

If you have already done above settings then please paste the error log you are getting.

Regards,

Sharath