if[ $action = 'export' ];
sql="select username from dba_users where username = '$FromUser';"
check_FromUser=`ExecSql "$sql"`
I want to connect to Oracle database & check the users in the database, store the value in check_FromUser.
First how to connect to Oracle database from the shell script ?
CHKLOGIN()
{
if sqlplus -s /nolog <<! >/dev/null 2>&1
WHENEVER SQLERROR EXIT 1;
CONNECT $1 ;
exit;
!
then
echo OK
else
echo NOK
fi
}
LOGIN_ID="$1" (This will take login/pwd u have to give it as 'scott/tiger' from cmd promt)
while [ "$LOGIN_ID" = "" -o `CHKLOGIN "$LOGIN_ID" "DUAL"` = "NOK" ]
do
if [ "$LOGIN_ID" = "" ];then
echo "Enter Login Userid/Passwd : \c"
read LOGIN_ID
else
echo "Enter Login Userid/Passwd : \c"
LOGIN_ID=""
fi
done
if sqlplus -s $LOGIN_ID @$TOP_path/sql/xxx.sql(or any package) > $LOGFILE
then
echo "Any thing u can do or can display sucessfull" >> $LOGFILE
else
echo "Installation of sql script is not successful" >> $LOGFILE
echo "Aborting......" >> $LOGFILE
exit 1
fi
Good evening
I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus.
I tried to find out the user/passwd and service name by env variable and all Ive got is this:
ORACLE_SID_REPCOL=SCL_REPCOL
ORACLE_SID=xmeta
ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Hi guys, long time no typing :D
I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box.
Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I... (2 Replies)
Hai
i want to connect to oracle database from user input and create a view.
${ECHO} "Debut Creating View"
${ECHO} "Please Enter the User Name:"
read user_name
${ECHO} "Please Enter the Connection String:"
read con_string
${ECHO} "Please Enter the Password:"
read pwd... (3 Replies)
Hi,
I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not?
Can anyone help me in this regard?
Appreciate your help and concern.
Thanks,
Dave (1 Reply)
Hi all,
I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data... (8 Replies)
Hello, I am very new to Scripting. I am having a Kornshell Script below for connecting to Oracle database. But getting an error while executing it.
#!/bin/ksh
ssh -X root@192.168.2.127 <perimuka>
sleep 5
su - oracle
sqlplus <mraghunandanan>/<peri123> <<eof
Can anyone tell what is wrong... (3 Replies)