SQLPLUS in script Post: 101222

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

connect to sqlplus in a script

Hi, I want to write a script, in which I will connect to sqlplus and do a quary and then exit sqlplus user/pwd@database select count(*) from table exit. and write the result in a log file. How to write it ? Many thanks before.

2. UNIX for Dummies Questions & Answers

Shell Script And SQLPLUS

i'm having real problems retrieving the returncode of my sqlplus-call. I found a lot of informations on the net, but havn't been able to get it running so far, so now i ask for some help ;) I do start the sqlplus out of my shell script with the parameters stored in the proc_clips.sql, which is...

3. Shell Programming and Scripting

help me in sending parameters from sqlplus script to unix shell script

Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files.. Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this? Please tell me...

4. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given...

5. Shell Programming and Scripting

SQLPLUS within shell script

Hi I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional. Can anybody help me with this. Thanks Gaurav

6. UNIX for Dummies Questions & Answers

sqlplus script out param

For starters, I have read the forums from top to bottom and cannot find a solution to this particular scenario. Just finished up two hours or scouring the archives. Here is my question which has been asked numerous times before but never fully explained for this particular solution: How do I pass a...

7. Shell Programming and Scripting

sqlplus in shell script

Hi When I use sqlplus in shell script, I get sqlplus: command not found. ORACLE_HOME is not set. How to set ORACLE_HOME in unix? Thanks

8. Shell Programming and Scripting

Sqlplus in shell script

Hi All, Please let me know what i am missing in the following code (part of my script) Schemas=(AWQM WFCONTROLLER PROVCO PRISM) for s in "${Schemas}" do sch="${s}_$tol" if || ;then echo "This is AD or TD region" sqlplus -s $sch/$tpwd@$ttns <<EOF...

9. 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}...

10. UNIX for Beginners Questions & Answers

SQLPLUS calling Via Script

Hello All, Could you please help me if i am doing anything wrong in below script, especially the sqlplus part performance wise or anything else i could improvise in the script. Thank you. #!/bin/ksh ## Batch Obj Id MP_BCH_OBJ_ID=$1 PASS=$2 partition=$3 ## script dir...

LEARN ABOUT V7

shutdown

asadmin-shutdown(1AS)                                              User Commands                                             asadmin-shutdown(1AS)

NAME

       asadmin-shutdown, shutdown - brings down the administration server

SYNOPSIS

       shutdown [--user admin_user][--password admin_password][--host localhost] [--port 4848][--passwordfile filename][--secure|-s]

       shutdown  gracefully brings down the administration server and all the running instances. You must manually start the administration server
       to bring it up again.

OPTIONS

       --user                  administrative user associated for the instance.

       --password              administrative password corresponding to the administrative user.

       --host                  host name of the machine hosting the administrative instance.

       --port                  administrative port number associated with the administrative host.

       --passwordfile          file containing passwords appropriate for the command (e.g., administrative instance).

       --secure                if true, uses SSL/TLS to communicate with the administrative instance.

       Example 1: Using the shutdown command

       asadmin> shutdown --user admin --password adminadmin --host bluestar --port 4848
       Waiting for admin server to shutdown...
       Admin server has been shutdown

EXIT STATUS

       0                       command executed successfully

       1                       error in executing the command

INTERFACE EQUIVALENT

       Administration Server page

       asadmin-start-instance(1AS), asadmin-stop-instance(1AS), asadmin-restart-instance(1AS)asadmin-start-domain(1AS),  asadmin-stop-domain(1AS),
       asadmin-start-appserv(1AS), asadmin-stop-appserv(1AS)

J2EE 1.4 SDK                                                        March 2004                                               asadmin-shutdown(1AS)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

connect to sqlplus in a script

Discussion started by: big123456

2. UNIX for Dummies Questions & Answers

Shell Script And SQLPLUS

Discussion started by: maco_home

3. Shell Programming and Scripting

help me in sending parameters from sqlplus script to unix shell script

Discussion started by: Hara

4. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Discussion started by: praka