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?
# 8  
Old 12-01-2009
I know,
perhaps the statement below should be reformulated Smilie

Quote:
[...]the output and return codes are not useful[...]
# 9  
Old 12-01-2009
Agreed and done, although parts of the output are still not useful (if lsnrctl didn't manage to stop the listener, I'd like to know that without running ps myself).
# 10  
Old 12-01-2009
Quote:
lsnrctl didn't manage to stop the listener[...]
Well, I've never seen this exact situation:

Code:
lsnrctl stop <listenername> with success
lsnrctl start <thesamelistenername> with TNS-12542

Unless in the meantime the configuration has been altered, it's not obvious to me what could have happened: I suppose that the first command was really successful and it's only the second one that's failing for whatever reason.
Last edited by radoulov; 12-01-2009 at 10:23 AM..
# 11  
Old 12-01-2009
No configuration change whatsoever. At that point the script was a pretty simple "Stop listener -> Stop DB -> Start DB -> Start listener" thing. After I received the error, I checked the running processes, and sure there was an old listener process left. When I manually issued a restart, everything stopped/started just fine.
# 12  
Old 12-01-2009
Quote:
Originally Posted by pludi
No configuration change whatsoever. At that point the script was a pretty simple "Stop listener -> Stop DB -> Start DB -> Start listener" thing. After I received the error, I checked the running processes, and sure there was an old listener process left. When I manually issued a restart, everything stopped/started just fine.
Did you save and consult the output/log of the last script execution?
I doubt that lsnrctl stop was successful.

Is the output you posted above the real one?
# 13  
Old 12-01-2009
What I've posted is what was the output sent to me via email, minus the output of our internal developed programs (I've checked their logs, exited successfully, no connections left open), and the restart of the instance itself (which is checked via sqlplus output).
# 14  
Old 12-01-2009
As far as your original question is concerned, I suppose the reported behavior should be considered an exception (might be a bug).
Assuming, of course, they sent you the complete log, all the relevant information and didn't miss/skip something between the stop and the start command Smilie
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