cancel
Showing results for 
Search instead for 
Did you mean: 

DB13 jobs getting failed after upgrade

0 Kudos

Hi

The jobs scheduled via DB13 is getting failed to schedule and below is the checkdb job log.

LOG:

BR0801I BRCONNECT 7.20 (32)
BR0805I Start of BRCONNECT processing: celtbtfp.chk 2013-07-29 06.15.49
BR0278E Command output of 'sqlplus /nolog < /dev/null':
sh: sqlplus: not found
BR0280I BRCONNECT time stamp: 2013-07-29 06.15.50
BR0279E Return code from 'sqlplus /nolog < /dev/null': 1
BR0302E SQLPLUS call for database instance XXX failed
BR0303E Determination of Oracle version failed
BR0280I BRCONNECT time stamp: 2013-07-29 06.15.50
BR0301E SQL error -12545 at location db_connect-2, SQL statement:
'CONNECT /'
ORA-12545: Connect failed because target host or object does not exist
BR0310E Connect to database instance XXX failed

BR0806I End of BRCONNECT processing: celtbtfp.chk2013-07-29 06.15.50
BR0280I BRCONNECT time stamp: 2013-07-29 06.15.50
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job finished

For ORA-12545 error,I checked the node name in tnsnames.ora and its correctly defined.

any suggestion to resolve this issue.

Regards

VC

Accepted Solutions (0)

Answers (6)

Answers (6)

0 Kudos

HI All

Thanks for the replies.

The problem was resolved after restaring the server

Regards

VC

Former Member
0 Kudos

Don't forget to mark your post as the "correct/helpful/assumed answered" answer, so future viewers know what resolved the issue.

0 Kudos

I am not able to find these options for this post

Former Member
0 Kudos

Hi Karthik,

Strange, you did have another post which has "Correct Answer" before, and now you doin't have this option? Did you logged in?

Otherwise you might ask the moderator to check this?

Regards,

Andre

Former Member
0 Kudos

Hi Karthik,

Just a query:

1. Can you run SQLplus as the oracle user i.e. ora{sid} ?

2. What do you get if you do the following:

server10:sidadm 82> env |grep LD_LIBRARY_PATH

LD_LIBRARY_PATH=/usr/sap/SID/SYS/exe/run:/oracle/client/11x_64/instantclient:/usr/sap/SID/DVEBMGS10/secude/bin

If you do not see /oracle/client/11x_64/instantclient or LD_LIBRARY_PATH there are problems.

3. If you have just logged on or switched to {sid}adm user and you do the following what do you get:

grep 10x .* and grep 11x .*

If you get any results for 10x and your current client is 11x  you will have to change these with reference to your files: .dbenv* and .sapenv* files these are your environmental files for SAP.

Check sap note  Note 602843 - Environment settings for R/3/Oracle on UNIX

Also if you make changes to these files you will have to close all linux sessions before logging on again for the changes to take effect.

Kind Regards,

Johan

Former Member
0 Kudos

Hello,

Have you check standard job failed? you must background job after upgardation.

WR,

PHB

Former Member
0 Kudos

Hi Karthik,

Can you please check R3trans -d and R3trans -x and upload logs. They overwrite the same log file so check it after each run.

Regards,

Johan

0 Kudos

HI Johan

I could run both R3trans -d and R3tans -x without any error

Regards

VC

former_member206552
Active Contributor
0 Kudos

Hi VC

can you please execute SQLPLUS as ADM and ORA user ?

because the log above shows this

BR0278E Command output of 'sqlplus /nolog < /dev/null':

sh: sqlplus: not found

if you can't sqlplus as the ADM user please execute as a test from os

setenv PATH /oracle/SID/112_64/bin:$PATH (csh)

export PATH=/oracle/SID/112_64/bin:$PATH (ksh)

if sqlplus works after this then you need to make this permanent enviroment variable and restart the system to test

Best Regards

Marius

Reagan
Advisor
Advisor
0 Kudos

Hello

If you have done an Oracle upgrade then make sure you update the Oracle Instant Client as well.

Regards

RB

Former Member
0 Kudos

Hi,

Can you please check

Check whether the "oracle" file exists on $ORACLE_HOME/bin, has a size other than 0 and has the "-rwsr-s--x" authorizations. The owner must be ora<sid>. The group is dba.

If the file is empty, you can create it again by relinking the software in accordance with Note 97953.

You can assign authorizations and the owner/group as follows:

chmod 6751 oracle

chown ora<sid> oracle

chgrp dba oracle

Also check the authorization of the $ORACLE_HOME/bin directory. This should be set to "drwxr-xr-x".

Continue to ensure that the file system that contains $ORACLE_HOME/bin supports the s-bit. Do not set the system to NOSUID.

After you carry out the adjustments, restart Oracle.If an error such as ORA-27121 continues to occur after you set the s-bit, it may be caused by hanging shared memories or semaphores that are assigned to the user that was mistakenly used to start the Oracle database until now. To correct this situation, you can use tools such as ipcs/ipcrm or carry out a reboot.

Please also check that the files in the kernel directory have correct permission.

Note 437648 - DB13: External program terminated with exit code 1/2

and the note

Note 723641 - Composite SAP Note: ORA-12545

Thanks

Rishi Abrol

0 Kudos

HI Reagan Benjamin

OIC is updated as well

Regards

VC

Former Member
0 Kudos

Hi Karthik,

What do you mean by "upgrade"? Kernel or the whole EhP?

From the command-line, try to execute "brconnect -u / -c -f check", what is the result?

I suspect there are some "missing link" to the correct path/directory ("sh: sqlplus: not found"), for example, what is ORA_HOME? Is this environment correctly defined?

Please check.

I hope this will help you.

Regards,

Andre

0 Kudos

HI

Thanks for the response.

By upgrade I meant oracle upgrade from 10g to 11g.

I could execut brconnect -u / -c -f check and all the environment variables are defined correctly.

Regards

VC