Login or Register to Ask a Question and Join Our Community


UNIX and Linux Applications

Oracle return codes?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums UNIX and Linux Applications Oracle return codes?
# 1  
Old 11-30-2009
Oracle return codes?
Having searched high and low through Oracles documentation, I came to think that they're very scripting-averse, as there's (apparently) no list of possible return/exit codes for their various command line utilities.

Is anyone here in possession of such a list, or knows where to find one? It would help me a great deal, as it's simpler to use that, than parsing through the load of output that lsnrctl and the like produce.
# 2  
Old 11-30-2009
This one?

Code:
$ORACLE_HOME/rdbms/mesg/oraus.msg

It's used by the oerr utility.

EDIT: Actually, you're asking for the return codes, not for the error messages so ignore my post.

Now that I think ... could you explain what exactly you're trying to achieve? Status != 0 is not sufficient?
# 3  
Old 11-30-2009
Generally: yes, status != 0 is sufficient, if I can be sure that status 0 isn't the only code returned, and without any documentation I assume the worst (I've seen too many tools always returning 0, no matter what).

But, knowing the operators that will have to use that script, sooner or later I'll have to give more information than just Success/Failure, and I'd rather get that information via a return code, that by parsing the command output, which could change without warning.

Besides, I'm sure I'm sooner or later someone will have a similar task, where the scripts execution path will depend on the failure reason.
# 4  
Old 11-30-2009
I understand and I believe that the only reliable way of doing this is to parse the utilities output.
# 5  
Old 12-01-2009
Well, it's pretty much confirmed that parts of the output and return codes are not useful when used in scripting. Following is the relevant parts of the script when it failed (additional comments in color):
Code:
lsnrctl stop LISTENER_xxx_V10
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 27-NOV-2009 05:25:11

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1545))
The command completed successfully

lsnrctl start LISTENER_xxx_V10
LSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 27-NOV-2009 05:25:58

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /orabase/product/10.2.0/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.2.0.4.0 - Production
System parameter file is /etc/listener.ora
Log messages written to /tmp/listener_xxx_v10.log
Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1545))
TNS-12542: TNS:address already in use
 TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   HPUX Error: 226: Address already in use

Listener failed to start. See the error message(s) above...

Return code of both calls to lsnrctl: zero. No information that it didn't completely close the listener. No return code indicating that starting the listener didn't run normally.
Last edited by pludi; 12-01-2009 at 11:04 AM..
# 6  
Old 12-01-2009
Quote:
Originally Posted by pludi
Well, it's pretty much confirmed that the output and return codes are not useful when used in scripting. [...]
As already stated, while I agree that you cannot rely on the meaning of the return codes, I believe that the output gives you a good idea of what happened,
as you surely already know, in the case of Oracle NET utilities you can always use the string TNS- (often in addition to the famous ORA-).
# 7  
Old 12-01-2009
Yes, the output gives a pretty good idea of what's going on. But I was hoping that I could avoid parsing the output, and any possible problems that can stem from it (wrong match because of a typo, incompatibilities across platforms, ...) by applying a simple 'case $? in...'.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Return Codes...

Not sure if this is of any use but...... I was messing around with getting return codes greater than 255 for special usage... Of course the code could be made simple but in this code the new stored return code is generated as exit is progressing... #!/bin/sh # Real and imaginary return... (9 Replies)
Discussion started by: wisecracker
9 Replies

2. Shell Programming and Scripting

Different Return Codes

Hi, I wanted to know the significance of different return codes when we do echo $? I know when $? returns 0 the command has worked successfully. but what does $? = 1, 2, 3 etc. signify. Thanks in advance for the help !!! (3 Replies)
Discussion started by: aarti.popi
3 Replies

3. Shell Programming and Scripting

sftp return codes

sftp -v b $putlist $SFTP_ID@TARGET_SERVER How can I get a return code if fails to put the file? sftp -v b $getlist $SFTP_ID@TARGET_SERVER How can I get a return code if fails to put the file? (1 Reply)
Discussion started by: TimHortons
1 Replies

4. UNIX for Dummies Questions & Answers

Displaying Return Codes

This is a high-level explanation, if more details are needed, please do not hesitate to ask. I have a set of .ctl files which I want to execute: AV1.ctl AV2.ctl AV3.ctl I have a script which has a for loop in it: for filename in AV1 AV2 AV3 do . execute_another_script.sh done ... (2 Replies)
Discussion started by: hern14
2 Replies

5. Shell Programming and Scripting

help with return codes

Hi In an unix script I am using an Perl one liner perl -i -ne '-----' If the perl one liner fails i am not able to catch the return code. It always give 0 as return code. Can you tell me how can i catch the return code perl -i -ne '---' RETCODE=$? echo $RETCODE Thanks and Regards Ammu (2 Replies)
Discussion started by: ammu
2 Replies

6. HP-UX

Return codes of RDIST

Can any body please tell me the return codes of RDIST tool? I am using RDIST (through an UNIX script) to synchronize files between two servers say ukblx151(source) & ukapx050(target). RDIST raises an alert mail (through notify option) in case of success & also failure but there is a problem if... (0 Replies)
Discussion started by: vishal_ranjan
0 Replies

7. UNIX for Advanced & Expert Users

Return Codes

I have a simple script which renames a file.How do i capture the return code of the script if the script fails (3 Replies)
Discussion started by: kris01752
3 Replies

8. UNIX for Dummies Questions & Answers

Return codes

Hi, Can anyone tell me if there are return codes for SFTP? If so how would you capture them? I've tried 'man sftp' but its not particularly helpful. Many thanks Helen :confused: (4 Replies)
Discussion started by: Bab00shka
4 Replies

9. UNIX for Dummies Questions & Answers

unix return codes

Suppose I have a script which is monitoring a directory whenever a file drops in that directory,it sends alert say I want to write a return code for the above script which on successful execution of script gives a return value Based on return code , I want to do initiate some jobs in other... (1 Reply)
Discussion started by: abhib45
1 Replies

10. UNIX for Dummies Questions & Answers

Help with Return codes

I have the below script I am running on a Solaris system to check the status of a Tivoli Workload Scheduler job and return the status. We need this script to return a '0' if any of the jobs in the stream are in a "EXEC" state and an "1" if in a "HOLD" state. I am not a programmer so I am not sure... (1 Reply)
Discussion started by: leezer1204
1 Replies
Login or Register to Ask a Question