Check DB Failed

[Former Member]

Hi,

SAP(640)+Oracle(10g) on hp-ux

Check DB is failing with below error code

BR0805I Start of BRCONNECT processing: ceghyeyu.chk 2011-07-13 18.42.44

BR0484I BRCONNECT log file: /oracle/RRC/sapcheck/ceghyeyu.chk

BR0280I BRCONNECT time stamp: 2011-07-13 18.42.45

BR0301E SQL error -604 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-00604: error occurred at recursive SQL level 1

ORA-20101: OASM-20101: OASM: You are not allowed to login.

ORA-06512: at line 35

BR0310E Connect to database instance RRC failed

BR0280I BRCONNECT time stamp: 2011-07-13 18.42.45

BR0301E SQL error -604 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-00604: error occurred at recursive SQL level 1

ORA-20101: OASM-20101: OASM: You are not allowed to login.

ORA-06512: at line 35

BR0310E Connect to database instance failed

BR0806I End of BRCONNECT processing: ceghyeyu.chk 2011-07-13 18.42.45

BR0280I BRCONNECT time stamp: 2011-07-13 18.42.45

BR0804I BRCONNECT terminated with errors

[Former Member]

Issue is with Roles of user..

[Former Member]

Go through the SAP notes 50088, 400241 and correct the ops$ mechanism.

Correct the file permissions at Os level as well.

Regards,

Nick Loy

[former_member213250]

Hello Manmohan

Which version of BRTOOLS your are using ?

If it is older version of BRTOOLS, I would recommend you first upgrade your BRTOOLS as per SAP Note: 12741 and see how the job runs.

Did you noticed any errors in alert log ?

Since when you are noticing these ORA errors.

Regards

Venkat

[Former Member]

Manmohan,

As ora<sid> try the following (replace the <sid> with your SID):

sqlplus /

Does that log you in to sqlplus? If you get an error then either the OPS$ORA<SID> is not created or you don't have the correct grants (SAP Note 361641)

As <sid>adm try the following:

sqlplus /

Does that log you in?

Also look at:

sqlplus "/as sysdba"

select username from dba_users order by 1;

You are looking to see if you have the OPS$ORA<SID> (if you are running the check from the unix ora<SID> user) or OPS$<SID>ADM if you are running the check from the unix <sid>adm user.

Also check the permissions on the BR*Tools via SAP Note 113747.

Good Luck,

Mike Kennedy

[Former Member]

I am able to log in with ora<SID> and check DB run successfully in that case.

Issue is with <SID>adm only.

When i schdeule the job from DB13 ...its getting failed from same reason.