remote connection to oracle db using bash script Options

[c0d3]

Dear Guys,
I would like to ask for a sample bash script on how can I connect to a remote oracle database. Thanks in advance.

[dave]

how about write it yourself then we can check it over for you

[Tom]

Hi folks,

... bash connecting to an oracle database?
I´d say: SQL*Plus is connecting to an oracle database, never seen a shell doing this directly

So you will have to install an Oracle-client onto your system, configure tnsnames.ora and then have fun.

> sqlplus username@remote_database

tom

[edwardstoever]

It is true that a bash script cannot connect to the database, but it can run SQLPLUS. I am no Unix master, but I will give it a go on linux and see what we get.

t.sh:

CODE

sqlplus system@test/password @dd.sql

then you have to change the t.sh file so it can be executed:

$ chmod 777 t.sh

Then create the dd.sql file:

CODE

spool results.txt
select 'SUCCESS' from dual;
spool off
exit

Now run it:

$ ./t.sh

now check the spooled results:

$ more results.txt

'SUCCES
-------
SUCCESS

Hey it works!

Edward

[JGarmany]

I use bash as my shell but script using Korn. By placing

#!/bin/ksh

at the beginning of the script I tell Linux/Uninx to execute the script using the ksh shell. Here is part of a ksh script that I use to start my test database.

#!/usr/bin/ksh
#
# source the environment
. /home/oracle/db.env
# start the database
$ORACLE_HOME/bin/lsnrctl start
#
$ORACLE_HOME/bin/sqlplus -s /nolog << EOF
connect / as sysdba
startup
select * from v$version;
exit
EOF


Basically this starts sqlplus in silent mode without loging on so that the username and password are not viewable using the ps command.
Then the script sends each command to sqlplus unitl it encounters the EOF marker.

Hope that helps
John

[c0d3]

guys,i already figured out the lacking portion of my script. I just added to initialize my oracle environment cause my crontab runs on oracle user. thanks for all your feedback.

[metacharacter]

I use bash as my shell but script using Korn. By placing

#!/bin/ksh

at the beginning of the script I tell Linux/Uninx to execute the script using the ksh shell. Here is part of a ksh script that I use to start my test database.

#!/usr/bin/ksh
#
# source the environment
. /home/oracle/db.env
# start the database
$ORACLE_HOME/bin/lsnrctl start
#
$ORACLE_HOME/bin/sqlplus -s /nolog << EOF
connect / as sysdba
startup
select * from v$version;
exit
EOF


Basically this starts sqlplus in silent mode without loging on so that the username and password are not viewable using the ps command.
Then the script sends each command to sqlplus unitl it encounters the EOF marker.

Hope that helps
John

Why ?
What adv do you get by using korn instead of bash?