Error during CHECKDB

[Former Member]

Hi Team,

I am getting an error message when i peform CHECKDB by scheduling a job in DB13. When i run the command line from AIX server it seems to go fine.

The error message is

Job started

Step 001 started (program RSDBAJOB, variant &0000000000236, user ID RAVISSHA)

Execute logical command BRCONNECT On host ssaptdb

Parameters: -u /-c -f check

BR0801I BRCONNECT 6.40 (15)

BR0805I Start of BRCONNECT processing: cdxgcmiq.chk 2008-02-12 08.18.40

BR0280I BRCONNECT time stamp: 2008-02-12 08.18.42

BR0301E SQL error -1017 at location db_connect-2

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance BWI failed

BR0280I BRCONNECT time stamp: 2008-02-12 08.18.42

BR0301E SQL error -1017 at location db_connect-2

ORA-01017: invalid username/password; logon denied

BR0310E Connect to database instance BWI failed

BR0806I End of BRCONNECT processing: cdxgcmiq.chk2008-02-12 08.18.42

BR0280I BRCONNECT time stamp: 2008-02-12 08.18.42

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Could somebody please help???

[Former Member]

Check the Note 400241 - Problems with ops$ or sapr3 connect to Oracle.

You have found files? They should help.

Edited by: Sergo Beradze on Feb 12, 2008 10:42 AM

[Former Member]

Hi,

Use SQLPLUS to create an OPS$ user in the database for the UNIX user ora<dbsid>:

SQL> connect / as sysdba

SQL> create user ops$ora<dbsid> identified externally;

SQL> grant connect, sapdba to ops$ora<dbsid>;

regards,

kaushal

[Former Member]

Hi,

I am getting the below error message when trying to create the User.

I also wanted to mention that this system was working for long and i have other jobs like Update jobs and backup's working fine

ssaptdb:orabwi:/home/orabwi > sqlplus /nolog

SQLPlus: Release 9.2.0.8.0 - Production on Tue Feb 12 09:27:46 2008*

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn /as sysdba

Connected.

SQL> create user ops$orabwi identified externally;

create user ops$orabwi identified externally

***

ERROR at line 1:

ORA-01920: user name 'OPS$ORABWI' conflicts with another user or role name

Kindly help.

[Former Member]

Hi,

it means user is already exists

so execute following

SQL> connect / as sysdba

SQL> grant connect, sapdba to ops$ora<dbsid>;

regards,

kaushal

[Former Member]

Hi Kaushal,

I tried the SQL Commands as mentioned but still it did not work.

I found the mistake that i was doing...

Command Used : brconnect -u /-c -f check

Command suppose to be used : brconnect -u / -c -f check.

Thank you for ur time and help.

[Former Member]

You need to run

sapdba_role.sql and sapconn_role.sql.

Usually they are in "sapmnt/SID/exe" , first open them using notepad (or more).

Thanks and Regards.