how can i call sqlplus? Post: 302189357

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sqlplus

I am looking to loop round a load of files and execute each in sqlplus, I have looked at the forum to see what was posted in the past, but most of the examples seem to use the sql being passed in through the script, which is not really what I am looking for, can someone tell me if the code below is...

2. UNIX for Advanced & Expert Users

how to differentiate system call from library call

Hi, Ho do I differentiate system call from library call? for example if I am using chmod , how do I find out if it is a system call or library call? Thanks Muru

3. Shell Programming and Scripting

Call sqlplus in the shell script

Hi, I am writing a script to test database connection. If the first try fails, it will wait for 1 minutes and then try again. The script is as following: ........ for i in $ORACLE_SID do $ORACLE_HOME/bin/sqlplus $username/$password@$i <<! >/dev/null select * from tab; exit if ; then...

4. UNIX for Dummies Questions & Answers

sqlplus call

I have a .sh file which acts as an all set for a couple of oracle scripts i want to call. Basically it has 3 variables, the user Id, the password, and the oracle instance to connect to.. the problem is I cant seem to get the connection string format properly.. the program essentially is this: ...

5. Infrastructure Monitoring

diffrence between method call and function call in perl

Hello, I have a problem with package and name space. require "/Mehran/DSGateEngineLib/general.pl"; use strict; sub System_Status_Main_Service_Status_Intrusion_Prevention { my %idpstatus; my @result; &General_ReadHash("/var/dsg/idp/settings",\%idpstatus); #print...

6. UNIX for Dummies Questions & Answers

Why do I need to call make if I call gcc ?

Why do I need to call make if I call gcc ? I thought gcc already compiles the sources. thanks

7. Shell Programming and Scripting

Sqlplus Help

When i run the following script am getiing the output correct but i want to get it in the form of a table, could any one help me please. the script is a s follows count=`sqlplus -s $ORACLE_ACCOUNT << EOF set heading off set wrap on set feedback off column ChangeNumber format a12 column...

8. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}...

9. UNIX and Linux Applications

Problem on SQLplus command ""bash: sqlplus: command not found""

Hi all, i face an error related to my server ""it's running server"" when i use sqlplus command $ sqlplus bash: sqlplus: command not found the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup. i already check the directory...

LEARN ABOUT CENTOS

amin

AMIN(1)                                                       General Commands Manual                                                      AMIN(1)

NAME

       amin - notify writers that you are busy

SYNOPSIS

       amin [-ynesp] command [args...]

DESCRIPTION

       Amin  is  used when you don't want to be written while running a command.  It runs the command given normally.  If your message permissions
       (see mesg(1)) are off, it does nothing much else.  If your messages are on, people writing you with write(1) will be warned  that  you  are
       running that command and will be given the opportunity to change their minds about writing you.

       The  -n  option  may  be used to turn your messages entirely off for the duration of the execution of command.  People writing you will get
       "Permission denied".  The -y option turns your message permissions on for the duration of the execution of the command.  The -e may be used
       after  either -n or -y to indicate that the logins listed in the .yeswrite or the .nowrite files respectively are exceptions to the message
       permissions set.  The default is -s which leaves your message permissions in their original state.  In any case, after the command is  com-
       plete, your permissions will be restored to the original state.

       The  -p  flag causes all telegrams sent to you while the command is running to be saved.  They are displayed as soon as the command is com-
       plete.  If used with the -n flag, writes are refused, but telegrams are still saved.

       If you have designated yourself as a helper, you will still be marked on the finger(1) output as a helper while you are  running  amin  but
       people doing ``write help'' will not be connected to you, even if you have the helper flag set to ``Y''.

AUTHOR

       Jan Wolter

FILES

       /etc/wrttmp    to find message permissions
       /etc/utmp to find user

SEE ALSO

       mesg(1), finger(1), write(1), huh(1).

7th Edition                                                        July 1, 1991                                                            AMIN(1)