cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01031: insufficient privileges in oracle 10.2 in windows 2008r2

former_member298251
Participant
0 Kudos

Dear All,

We have install SAP ecc6 EHP4 on oracle 10.2.0.5 on windows 2008R2

whenever we schedule any activity in db13 we are getting below error .

=================================

Job started

Step 001 started (program RSDBAJOB, variant &0000000000059, user ID PARESH)

Execute logical command BRBACKUP On host IRDAECCDEV

Parameters:-u / -jid FLL__20110922104226 -c force -t online -m full -p initieq_online.sap

BR0051I BRBACKUP 7.20 (3)

BR0055I Start of database backup: begvgwgh.fnf 2011-09-22 10.42.27

BR0484I BRBACKUP log file: K:\oracle\IEQ\sapbackup\begvgwgh.fnf

BR0280I BRBACKUP time stamp: 2011-09-22 10.42.28

BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL statement:

'CONNECT / AT PROF_CONN IN SYSOPER MODE'

ORA-01031: insufficient privileges

BR0303E Determination of Oracle version failed

=================================

As per sap note 400421 i have carry out all the check and all are perfect.

Also i have check below notes and every thing are fine

Note 834917 - Oracle Database 10g: New database role SAPCONN

Note 1028220 - ORA-01031: Insufficient privileges despite SAPCONN role

Note 700548 - FAQ: Oracle authorizations

Also i have check the note which suggest to run the sapdba_role.sql script

But still i am getting the same error.

Also SAPSID services is running with user id sapserviceSID and i change it to SIDadm but no lock.

Request you please help me in this regard.

Sincerely

Paresh

Accepted Solutions (0)

Answers (3)

Answers (3)

JPReyes
Active Contributor
0 Kudos

I think this could be an issue with SAPService<SID> as OPS$ synonym

Check Note 50088 - Creating OPS$ users on Windows NT/Oracle

it may be no harm to run oradbusr.sql

Regards

Juan

Former Member
0 Kudos

Hi,

Is there an additional application server attached to the SAP system?

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi,

>

> Is there an additional application server attached to the SAP system?

>

> Best regards,

>

> Orkun Gedik

Is your system distributed or installed on a single host?

Best regards,

Orkun Gedik

former_member298251
Participant
0 Kudos

Dear Orkun,

No additonal application attached.

But in server we have dev and quality instance with seprate database host.

Sincerely

Paresh

Former Member
0 Kudos

Hi,

Is the system member of a domain or a workgroup?

Best regards,

Orkun Gedik

former_member298251
Participant
0 Kudos

Hi Orkun,

Thanks for your quick reply

System is domain group

Sincerely

Paresh

Former Member
0 Kudos

Hi,

Check time difference the SAP host and domain controller. It should be max 5 mins. It might be a solution. Let's continue step by step.

Best regards,

Orkun Gedik

former_member298251
Participant
0 Kudos

Dear Orkun,

Thanks for you quick reply

The differance is 7 min . hope this may be the issue

I will take short downtime and change the time

and update you the status soon

Sincerely

Paresh

Former Member
0 Kudos

'Also i have check the note which suggest to run the sapdba_role.sql script '

Hi Paresh,

Did you restart SAP after applying sapdba_role.sql script ? We have faced several similar problems and sometimes after executing sapdba script we had to restart sap to see the results, not sure why.

Thanks

former_member298251
Participant
0 Kudos

Dear DatabaseSAP,

I have restarted SAP several time after running the script but no luck.

Sincerely

Paresh

Former Member
0 Kudos

As expected

This is really a very small problem but very weird we suffered so many times. May be we should confirm the authorizations for SAPServiceSID and sidadm users on that windows host, sometimes we miss this part in Windows to check.

Kernel folders should be proper accessible by both of the users. Also, please keep SAP instance service via SAPServiceSID itself.

Just to reconfirm - you restarted SAP and restarted SAP/Oracle services as well, right ?

Thanks

former_member298251
Participant
0 Kudos

hi,

I have give the full access to SAPService<SID> user on kernel folder and restarted the server.

but still the issue remain same.

Sincerely

Paresh