on 07-29-2013 2:35 PM
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
HI All
Thanks for the replies.
The problem was resolved after restaring the server
Regards
VC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Have you check standard job failed? you must background job after upgardation.
WR,
PHB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hello
If you have done an Oracle upgrade then make sure you update the Oracle Instant Client as well.
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.