I use below command to log in to oracle database
When i enter into sql prompt i press
If there are any errors it will show just below the output of
. The errors generally start with keyword
can we do this by using a unix shell script.? If there are any errors while logging in then script should say " ERROR in database connectivity. "
Hi
I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this.
1. Opened a cursor to a table in DB2 databse.
2. Fetching individual rows with the help of cursor.
3. Each row has 4 fields.
I want each of the field in individual shell... (1 Reply)
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... (6 Replies)
I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful. (3 Replies)
Hi,
I have basic knowledge on how to write pl/sql code inside shell script.
I am looking for more advance thing. Is there any book for that which can just talk about how to write more advance plsql code inside shell script.
Please help
Thanks!!!!!! (1 Reply)
I need to compare a R$Timestamp field sql within a Unix Shell Script.
In straight SQL the following code works fine:
Table Name: LL_UNIT_TRANSACTION UT
Field: R$Timestamp
Where TRUNC(UT.R$Timestamp) >= TRUNC(SYSDATE -7)
the following returns no data within the Unix Shell Script... (2 Replies)
Hi all
I am writing a shell script which will run a select query from a table . If the ouput is not 500 - then send a email to the team saying there is a error . But i am not sure how to redirect this output of the select query to the log file -
#!/bin/ksh
sqlplus /nolog
conect... (1 Reply)
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
I know this question is out there in many forums, but I tried all the combinations in vain.
I'm basically trying to call a sql script from a shell script.
Below is my sql script (plsql.sql)
DELCARE
v_empno NUMBER := '&empno';
BEGIN
select ename,sal from emp where empno = v_empno;... (3 Replies)
Discussion started by: FName_LName
3 Replies
LEARN ABOUT ULTRIX
su
su(1) General Commands Manual su(1)Name
su - substitute a user ID
Syntax
su [username]
su - [username]
su -f [username]
Description
The command requests the password of the specified username. If the correct password is given, changes to that username without changing
the current directory. The user environment is unchanged except for HOME and SHELL which are taken from the password file entry for user-
name. The shell that is run is also taken from the password file entry for username. The new user ID stays in force until the shell
exits.
If no username is specified, `root' is assumed. To remind the superuser of his responsibilities, the shell substitutes `#' for its usual
prompt.
Options-f Prevents from executing the .cshrc file, making start up faster.
- Simulates a full login.
Diagnostics
Sorry
An invalid password was supplied for the specified username.
Unknown login: username
The specified username was not found in the passwd database.
No directory
The home directory for the username is not accessible at this time (only with ``-'' argument).
No shell
The shell specified in the passwd database entry for username could not be executed.
Kerberos initialization failure
Consult your system administrator.
If enhanced security features are enabled the following error messages are also possible:
Requires secure terminal
Attempt to su to UID 0 on a line that is not marked secure in
User's password has expired
Access is denied because the password for username is expired.
This account is disabled
Access is denied because the auth entry corresponding to username is marked disabled.
Files
Log file of anyone who became
root, with a date mark.
See Alsocsh(1), sh(1), passwd(5yp), environ(7), edauth(8)
Security Guide for Administrators
Security Guide for Users
su(1)