Skip to Content

DB13 jobs getting failed after upgrade

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Jul 29, 2013 at 03:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Jul 30, 2013 at 09:53 AM

    Hello

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

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 30, 2013 at 11:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Aug 02, 2013 at 05:19 AM

    Hello,

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

    WR,

    PHB

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 02, 2013 at 10:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 06, 2013 at 06:09 AM

    HI All

    Thanks for the replies.

    The problem was resolved after restaring the server😊

    Regards

    VC

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member karthik v

      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