Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Shell script verify connection to Oracle if not successful
Top Forums Shell Programming and Scripting Shell script verify connection to Oracle if not successful Post 303032933 by Neo on Tuesday 26th of March 2019 11:59:47 PM
Old 03-27-2019
You need to create a script or wrapper that expects a return status from the server and process the return status.

More specifically, you can use:

Code:
WHENEVER SQLERROR EXIT SQL.SQLCODE
WHENEVER OSERROR EXIT

For example:

Code:
WHENEVER SQLERROR EXIT SQL.SQLCODE
begin
  SELECT COLUMN_DOES_NOT_EXIST FROM DUAL;
END;
/

And for OS errors:

Code:
WHENEVER OSERROR EXIT FAILURE
START no_such_file

Check out the reference material for more details:

SQL*Plus Command Reference
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shell script- oracle connection problem

Hi all, I am having problem with a shell script. I have a couple of csv files. The shell script will do some operation on them, create a sql file which will then be called by sqlplus. The problem is to gracefully exit sqlplus at the end of every operation as I do not want to hang on to the... (4 Replies)
Discussion started by: nattynatty
4 Replies

2. Solaris

Can before and after snapshots be used to verify successful filesystem restoration?

Hello Guys, Can before and after snapshots be used to verify successful filesystem restoration? snapshots will be created using fssnaps and restoration is thru legato restore? Any ideas on this? or any other ways I could verify that restoration is good? Regards (0 Replies)
Discussion started by: MarkyBoy
0 Replies

3. Shell Programming and Scripting

oracle connection from shell script

Hi, For connecting to oracle my script is using the command sqlplus username/password@db_instance_name.For this to work i am setting ORACLE_HOME,TNS_ADMIN and ORACLE_SID in a seperate script.My question is,could we make a connection to oracle just by the command sqlplus... (4 Replies)
Discussion started by: DILEEP410
4 Replies

4. UNIX for Advanced & Expert Users

Connection closing immediatly after successful login

When ssh'ing into certain Unix boxes I'm seeing two errors that appear immediately after entering the password I've never seen. After the error message is displayed the connection closes immediately. The first is “/bin/ksh: Not owner” after which the connection is closed. And, “Read from remote... (2 Replies)
Discussion started by: twk
2 Replies

5. Shell Programming and Scripting

Verifying oracle connection from shell script

Hi, Oracle 9.2 Solaris 10 From the shell script ........How can we verify whether oracle connection is successful or not ? Shell script will prompt the user to enter the oracle schema username, password and tns name. So, *how to verify whether oracle connection has been established or... (14 Replies)
Discussion started by: milink
14 Replies

6. Shell Programming and Scripting

How the user will provide the parameters for Oracle db connection in a shell script?

I'm new into unix. My question: is possible to write a shell script which will ask for the ORACLE_HOME, ORACLE_SID, USERNAME, PASSWORD to connect to Oracle db. In generally we have to set the ORACLE_HOME in .profile file. And after putting the 'sqlplus' command it asks for the username &... (6 Replies)
Discussion started by: priya001
6 Replies

7. Shell Programming and Scripting

How to setup Oracle connection inside shell script?

Hi, We have Oracle Connection parameters set up in file name "TESTDB" at location /abc/etc.When I try to run my shell script it does not connect to Oracle database. Please let me know how "TESTDB" file can be called inside script. ####################### Setting the directories... (2 Replies)
Discussion started by: sandy162
2 Replies

8. UNIX for Dummies Questions & Answers

How to fix connection to Oracle database through shell script?

I have a question regarding how to connect to Oracle Database through shell script. 1. If I want call a stored procedure on Linux server as this, it works. $sqlplus /nolog SQL*Plus: Release 12.1.0.2.0 Production on Fri Jun 12 14:49:49 2015 Copyright (c) 1982, 2014, Oracle. All rights... (2 Replies)
Discussion started by: duke0001
2 Replies

9. Shell Programming and Scripting

How to check the status of sftp connection is successful or not in Linux?

Hi All, We are working on linux with putty terminal for file transferring using SFTP server... here we want to know /We have Urgent Requirement If SFTP connection is successfull then we should get .txt log file in target locaton as "Success/Failure" Please provide batch script for above... (7 Replies)
Discussion started by: sravanreddy
7 Replies

10. UNIX for Beginners Questions & Answers

Shell script is hanging up every time even after it's successful

We are using a korn shell script which is meant to trigger a Oracle job to load the data from a flat file to an Oracle database . Also the same script addresses the following tasks also like triggering a SFTP job to pick the file from one path to the target location and checking the same with... (6 Replies)
Discussion started by: senmng
6 Replies

LEARN ABOUT DEBIAN

pppoe-connect

PPPOE-CONNECT(8)					      System Manager's Manual						  PPPOE-CONNECT(8)

NAME

       pppoe-connect - Shell script to manage a PPPoE link

SYNOPSIS

       pppoe-connect [config_file]

       pppoe-connect interface user [config_file]

DESCRIPTION

       pppoe-connect  is  a  shell  script  which  manages a PPPoE connection using the Roaring Penguin user-space PPPoE client.  If you omit con-
       fig_file, the default file /etc/ppp/pppoe.conf is used.	If you supply interface and user, then they override the  Ethernet  interface  and
       user-name settings in the configuration file.

       Note that normally, you should not invoke pppoe-connect directly.  Instead, use pppoe-start to bring up the PPPoE connection.

       pppoe-connect  first  reads a configuration file.  It then brings up a PPPoE connection.  If the connection ever drops, a message is logged
       to syslog, and pppoe-connect re-establishes the connection.  In addition, each time the connection is dropped  or  cannot  be  established,
       pppoe-connect executes the script /etc/ppp/pppoe-lost if it exists and is executable.

       The shell script pppoe-stop causes pppoe-connect to break out of its loop, bring the connection down, and exit.

TECHNICAL DETAILS

       pppoe-connect uses the following shell variables from the configuration file:

       ETH    The Ethernet interface connected to the DSL modem (for example, eth0).

       USER   The PPPoE user-id (for example, b1xxnxnx@sympatico.ca).

       PIDFILE
	      A file in which to write the process-ID of the pppoe-connect process (for example, /var/run/pppoe.pid).  Two additional files ($PID-
	      FILE.pppd and $PIDFILE.pppoe) hold the process-ID's of the pppd and pppoe processes, respectively.

       By using different configuration files with different PIDFILE settings, you can manage multiple PPPoE connections.  Just specify  the  con-
       figuration file as an argument to pppoe-start and pppoe-stop.

AUTHOR

       pppoe-connect was written by David F. Skoll <dfs@roaringpenguin.com>.

       The pppoe home page is http://www.roaringpenguin.com/pppoe/.

SEE ALSO

       pppoe(8),  pppoe-start(8),  pppoe-stop(8), pppd(8), pppoe.conf(5), pppoe-setup(8), pppoe-status(8), pppoe-sniff(8), pppoe-server(8), pppoe-
       relay(8)

4th Berkeley Distribution					 21 February 2000						  PPPOE-CONNECT(8)
All times are GMT -4. The time now is 11:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy