#!/bin/ksh
# usage $1 = username $2=pwd, assumes ORACLE_SID and TWO_TASK (if needed) are set
test_conn()
{
usr="$1"
pwd="$2"
sqlplus -s ${usr}/${pwd} << EOF | tr -d '[:space:]'
set feed off
set head off
set pages 0
set verify off
select 'ok' from dual;
exit
EOF
}
oops=1
while [ $oops -eq 1]
do
print 'Enter username: '; read uname
print 'Password: ';
stty -echo
read pass
stty echo
result=$(test_conn $uname $pass)
if [ "$result" = "ok"] then
oops=0
fi
start with that.
Last edited by jim mcnamara; 10-13-2010 at 11:54 AM..
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)
Hi,
I am working on a shell script that would verify if the mount command has executed or not. So , i have been doing this.
mount /dev/cdrom /mnt/cdrom
echo "$?"
if ; then
echo " Mount succesful"
else
echo " Mount unsuccessful"
fi (3 Replies)
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)
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)
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)
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)
Hi All,
As we are using SQLPLUS command to connect Oracle Database in unix:
Like below syntax:
sqlplus username/password@dbname << EOI
SET HEADING OFF
SPOOL MAX_DATE_VAL.txt
select max(LAST_UPDT_DATE) from source_defect;
SPOOL OFF
here the result is stored in... (0 Replies)
Hi,
I am quite new to shell scripting and was wondering if it was possible to automatically enter the username and password fields to a wifi-access-router and then ping it.
I have most trouble with entering the username and password fields. Is that even possible?
Also, what do I do if the... (1 Reply)
i have a script that connects to the oracle database and executes the query statements. it works fine and i would like to add some message to check if the connection to oracle is not successful.
basically this is the code snippet:
#!/bin/sh
...
...
...
sqlplus -s username/password@dbName... (2 Replies)
Discussion started by: wtolentino
2 Replies
LEARN ABOUT OPENSOLARIS
pwd.h
pwd.h(3HEAD) Headers pwd.h(3HEAD)NAME
pwd.h, pwd - password structure
SYNOPSIS
#include <pwd.h>
DESCRIPTION
The <pwd.h> header provides a definition for struct passwd, which includes the following members:
char *pw_name user's login name
uid_t pw_uid numerical user ID
gid_t pw_gid numerical group ID
char *pw_dir initial working di rectory
char *pw_shell program to use as shell
The gid_t and uid_t types are defined as described in <sys/types.h>. See types.h(3HEAD).
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Interface Stability |Standard |
+-----------------------------+-----------------------------+
SEE ALSO getpwnam(3C), types.h(3HEAD), attributes(5), standards(5)SunOS 5.11 10 Sep 2004 pwd.h(3HEAD)