DB13 problem

[former_member759680]

Hello,

All scheduled tasks using DB13 are failing.

Our system is SRM 5.0 - Windows+Oracle.

CheckDB failed with the following error:

Step 001 started (program RSDBAJOB, variant &0000000000054, user ID ADMCAP)
Execute logical command BRCONNECT On host sgsi23srmebp
Parameters: -u / -jid CHECK20100128151342 -c -f check
BR0801I BRCONNECT 7.00 (42)
BR0805I Start of BRCONNECT processing: ceclnkha.chk 2010-01-28 15.13.42
BR0484I BRCONNECT log file: E:\oracle\EBP\sapcheck\ceclnkha.chk
BR0280I BRCONNECT time stamp: 2010-01-28 15.13.42
BR0301E SQL error -1041 at location db_connect-2,SQL statement:
'CONNECT /'
ORA-01041: internal error. hostdef extension doesn't exist
BR0310E Connect to database instance EBP failed
BR0280I BRCONNECT time stamp: 2010-01-28 15.13.42
BR0301E SQL error -1041 at location db_connect-2,SQL statement:
'CONNECT /'
ORA-01041: internal error. hostdef extension doesn't exist
BR0310E Connect to database instance EBP failed

BR0806I End of BRCONNECT processing: ceclnkha.chk2010-01-28 15.13.42
BR0280I BRCONNECT time stamp: 2010-01-28 15.13.42
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3

I checked the database and SAP and they are running fine.

The CheckDB commend - brconnect -u / -c -f check

works fine on Command prompt with user - SIDadm and SAPServiceSID

COuld you please help resolve this error?

[carsten_esser]

I had the same error "ORA-01041: internal error. hostdef extension doesn't exist". I googled around and couldn't find the solution.

In my case, setting the host's clock to the correct time did the thing.

[former_member227283]

Hi Gutam,

As we said

The CheckDB commend - brconnect -u / -c -f check
works fine on Command prompt with user - SIDadm and SAPServiceSID

and the check DB fails with DB13 , then it might be problem with SAP service which is running in windows i.e in services.msc.

follow the below steps.

1. goto services.msc

2. double click on service SAP<SID>_<NN>

3. in the service click on logon tab and check by which user service has been started.

4.it should be started with SIDADM , if is not then

click on this account tab and provide and username as <SIDADM> and neccesary password .

5. Stop SAP and oracle

6. restart the SAP<SID>_<NN> service

7. Start the SAP

now try to scedhule the job .

Thanks

Anil

[former_member759680]

4.it should be started with SIDADM , if is not then

Anil,

In all our systems the service SAPSID_nn is started with User - SAPServcieSID

and it works fine everywhere.

[former_member227600]

Hi Gautam,

BR0301E SQL error -1041 at location db_connect-2,SQL statement:
'CONNECT /'
ORA-01041: internal error. hostdef extension doesn't exist

Please run the below command from sql prompt.

grant dba,resource,connect,sapdba to OPS$<SID>ADM OPS$ORA<SID>

Thanks & Regards

Karan

[nirmal_konchada]

Recreating OPS$ user will surely solve this problem as OPS$ is the user which access's the database.

Nirmal.

[rupali_karbhari3]

Hi,

It seems user trying to access databse got locked. verify whether ora<SID> is unlocked or might be schema user

Hope this will help you

Regards,

Rupali

[JPReyes]

That error might indicate that something happing during shutdown or startup... I will restart the DB and check if the error persist.

Regards

Juan

[former_member759680]

But Juan,

All tasks(CheckDB, Update stats) from OS level are completing successfully.

Could you please help em understand how SAP DB13 accesses the database?

Which user does it use to perform DB13 tasks?

[JPReyes]

uses the system user at db level... but this has nothing to do with the message its not an authentication issue.

My advice will be to do a full system and DB restart and run the DBCHECK again

Regards

Juan