DB jobs getting failed

[Former Member]

Hi,

Please advice me on this issue. This started after system copy.My environment is Sun solaris 5.10, oracle 10.2

Job started

Step 001 started (program RSDBAJOB, variant &0000000000133, user ID BASIS

Execute logical command BRCONNECT On host qas

Parameters: -u / -jid CHECK20110302120113 -c -f check

BR0801I BRCONNECT 7.10 (30)

BR0805I Start of BRCONNECT processing: cefishwj.chk 2011-03-02 12.01.13

BR0484I BRCONNECT log file: /oracle/QAS/sapcheck/cefishwj.chk

BR0613E Database instance QAS is shut down

BR0806I End of BRCONNECT processing: cefishwj.chk2011-03-02 12.01.14

BR0280I BRCONNECT time stamp: 2011-03-02 12.01.14

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

regards

Praveen

[Former Member]

Hi,

Try taking out the TNS_ADMIN variable.

But also make sure the listener starts OK using the tnsnames.or in $ORACLE_HOME/network/admin

Mark

[Former Member]

Hi,

it seems you wish to run DB check ?

if yes, is the database and SAP up and running ?

also check permission on SAP Note 113747

and maybe this thread give you an idea :

hope it help you,

rgds,

Alfonsus Guritno

[Former Member]

Dear Alfonsus

it seems you wish to run DB check ?

Yes, the log i have provided is when i try to run checkdb, but i am not able to run any from db13

if yes, is the database and SAP up and running ?

The DB instance is fine and application is up and running fine. The issue is i am not able to execute any jobs from db13.

The note didnt help me

Regards

Praveen

[former_member189546]

Hello,

Update the brtoold to latest patch level and try again.

Note #12741 - "Aktuelle Versionen von SAPDBA und BR*Tools"

regards,

John Feely

[Former Member]

Dear John ,

Thank you for the reply, i have all ready done the same as u suggested. but it didn't help me.

Regards

Praveen

[Former Member]

Hi, To the above i can execute the same from os level from user orasid. Please advice.

regards

Praveen ar

[Former Member]

 i can execute the same from os level from user orasid 

Fine.

Next try:

From os level from user sidadm

[Former Member]

Dear Joe,

i get the same error which i have provided.

Regards

Praveen.ar

[Former Member]

Make sure environment variables for user sidadm are correct.

[Former Member]

Dear Joe,

this is what i have set

DB_SID=QAS

DIR_LIBRARY=/usr/sap/QAS/SYS/exe/run

HOME=/home/qasadm

HZ=100

JAVA_HOME=/j2sdk1.4.2_17

LD_LIBRARY_PATH=/usr/sap/QAS/SYS/exe/run:/oracle/client/10x_64/instantclient

LOGNAME=qasadm

MAIL=/var/mail/qasadm

NLS_LANG=AMERICAN_AMERICA.UTF8

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/QAS/102_64

ORACLE_SID=QAS

PATH=/oracle/QAS/102_64/bin:/j2sdk1.4.2_17/bin:/home/qasadm:/usr/sap/QAS/SYS/exe /run:/usr/bin:/usr/ucb:/etc:.:/usr/ccs/bin

PS1=

qasadm>

SAPDATA_HOME=/oracle/QAS

SAPSYSTEMNAME=QAS

SHELL=/bin/sh

TERM=xterm

THREAD=NOPS

TNS_ADMIN=/usr/sap/QAS/SYS/profile/oracle

TZ=Asia/Calcutta

dbms_type=ORA

dbs_ora_schema=SAPSR3

dbs_ora_tnsname=QAS

Regards

Praveen

[Former Member]

You needn't try from DB13, unless you are able to run it as user sidadm.

Compare with environment of user orasid.

Is ORACLE_SID the same? (should be)

Is TNS_ADMIN the same? (not in every case)

Other suspicious differences?

Are you trying as sidadm and orasid from the same host?

Or are you in a distributed environment?

Is there a file /usr/sap/QAS/SYS/profile/oracle/tnsnames.ora ?

If so, check its content.

[Former Member]

Dear Joe,

1) ORACLE_SID is same.

2) TNS_ADMIN is not set for orasid. it is set for sidadm.TNS_ADMIN=/usr/sap/QAS/SYS/profile/oracle

3) Yes i am trying from same host.

4) it is not a distributed environment.

5) do we have to check the content of tnsnames.ora as it is working fine with orasid user.

Please advice.

Regards

Praveen

[Former Member]

 do we have to check the content of tnsnames.ora as it is working fine with orasid user.

I think we should find out whether orasid really is using the same tnsnames.ora file.

And I suppose Mark is thinking along the same lines.

I rather assume orasid is using a different one.

Look for a file with this name in /oracle/QAS, perhaps in /oracle/QAS/102_64/network/admin or similar.

regards