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 CENTOS
pwauth
PWAUTH(8) System Manager's Manual PWAUTH(8)NAME
pwauth - authenticator for mod_authnz_external and the Apache HTTP Daemon
SYNOPSIS
pwauth
DESCRIPTION
Pwauth is an authenticator designed to be used with mod_auth_external or mod_authnz_external and the Apache HTTP Daemon to support reason-
ably secure web authentication out of the system password database on most versions of Unix. Particulary - secure authentication against
PAM.
The simplest test pwauth is to start a root shell and just run pwauth. It will attempt to read the login and password from standard input,
so type a login name, hit return, then type a password, and hit return (the password will echo on your screen). The check the status code
that was returned (in csh: "echo $status" in sh: "echo $?").
If the login/password were correct you should get a zero status code. If not, you will get some other value. See below the list of status
codes to find the meaning of the various values returned. Any values 50 or greater indicate a configuration error.
STATUS CODES
0 STATUS_OK
Login OK.
1 STATUS_UNKNOWN
Nonexistant login or (for some configurations) incorrect password.
2 STATUS_INVALID
Incorrect password (for some configurations).
3 STATUS_BLOCKED
Uid number is below MIN_UNIX_UID value configured in config.h.
4 STATUS_EXPIRED
Login ID has expired.
5 STATUS_PW_EXPIRED
Login's password has expired.
6 SSTATUS_NOLOGIN
Logins to system have been turned off (usually by /etc/nologin file).
7 STATUS_MANYFAILES
Limit on number of bad logins exceeded.
50 STATUS_INT_USER
pwauth was invoked by a uid not on the SERVER_UIDS list. If you get this error code, you probably have SERVER_UIDS set incorrectly
in pwauth's config.h file.
51 STATUS_INT_ARGS
pwauth was not given a login & password to check. The means the passing of data from mod_auth_external to pwauth is messed up. Most
likely one is trying to pass data via environment variables, while the other is trying to pass data via a pipe.
52 STATUS_INT_ERR
one of several rare and unlikely internal errors occurred. You'll have to read the source code to figure these out.
53 STATUS_INT_NOROOT
pwauth was not able to read the password database. Usually this means it is not running as root. (PAM and login.conf configurations
will return 1 in this case.)
AUTHOR
pwauth was written by Jan Wolter <jan@unixpapa.com>.
This manual page was written by Hai Zaar <haizaar@haizaar.com>, for the Debian project (but may be used by others).
2009-05-02 PWAUTH(8)