04-30-2008
error connecting sql through a shell script
Hi I am getting this error while connecting to sql through a shell script, whereas i am able to connect to sql directly.
It was working properly earlier, no clue why i am getting this.
Please find the log below:
FTP to <IP> completed Wed Apr 30 11:42:01 BST 2008
Program ended. Wed Apr 30 11:42:01 BST 2008
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
Enter password:
Enter password:
ERROR:
ORA-01005: null password given; logon denied
Beginnning Load Process at Wed Apr 30 11:42:02 BST 2008
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
where <logon> ::= <username>[/<password>][@<connect_string>] | /
Enter password:
Enter password:
ERROR:
ORA-01005: null password given; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
Ending Load Process at Wed Apr 30 11:42:03 BST 2008
Any help is appreciated.
Thanks.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Any link or example to write shell script for the Connecting Oracle for Quering through SQL
thanks in advance ...
Cheers !!
Mehul Doshi (3 Replies)
Discussion started by: mehuldoshi
3 Replies
2. Shell Programming and Scripting
Hi all,
I am running an sql file from unix .In the log file along with the output
i am getting details of connecting and disconnecting sqlplus like
It saves the output with "Connected to Oracle8i Enterprise Edition Release
8.1.7.4.0 Connected as apps" and "disconnected... (1 Reply)
Discussion started by: rrs
1 Replies
3. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
4. UNIX for Dummies Questions & Answers
Hi Gurus,
I want to connect to a different user in unix from my terminal. I know the password
of that user and username.when i am using "su username" it asks me for the password and entering the corresponding password ,it takes me to that.but i want to write a shell script in which i will be... (4 Replies)
Discussion started by: sanjay.login
4 Replies
5. Shell Programming and Scripting
I need help in the following script. I want to grep the sql errors insert into the error table and exit the shell script if there is any error, otherwise keep running the scripts.
Here is my script
#!/bin/csh -f
source .orapass
set user = $USER
set pass = $PASS
cd /opt/data/scripts
echo... (2 Replies)
Discussion started by: allinshell99
2 Replies
6. Shell Programming and Scripting
Hi ,
I have three linux servers. I want to login from one server and check some status in the other server.
How to connect other server from one server using shell script.
Can anyone advice on this?
Thanks,
Chelladurai. (4 Replies)
Discussion started by: ckchelladurai
4 Replies
7. UNIX for Dummies Questions & Answers
Hi All,
In a Shell scriipt with a SQL block I want to issue a query against a local DB and a remote DB on a remote server. The shell script is running locally.
This is how I connect to the local server. But I want the query to reference remote table in the join. Question can I specify a... (1 Reply)
Discussion started by: daveu7
1 Replies
8. Shell Programming and Scripting
I am connecting to sql databases through shell script. Databases that i am connecting will need password change every 60 days. This is according to our security policy and cannot be changed. But this is creating problem when connecting to Databases through shell script . To connect to oracle DB we... (2 Replies)
Discussion started by: pallvi_mahajan
2 Replies
9. UNIX for Beginners Questions & Answers
Hi All,
I am getting below error when I try to connect with ssh. Not sure why the error is on.I am able to connect from a different login from the same server
(local: rhe/home/s3>) ssh acces1@91.1.12.102
Connection closed by 91.1.12.102
(local: rhe/home/s3>) ssh redhlinx102
Connection... (7 Replies)
Discussion started by: arunkumar_mca
7 Replies
10. Shell Programming and Scripting
Hi All
when I execute from psql prompt, I get the result, when I try to automate
using a shell script, the query is not working
# `/usr/bin/psql -U postgres -d coba1 -c "select name from users where
"Date" > current_date - 30;"`
ERROR: column "Date" does not exist
LINE 1: select... (2 Replies)
Discussion started by: srilinux09
2 Replies
LEARN ABOUT REDHAT
afppasswd
AFPPASSWD(1) General Commands Manual AFPPASSWD(1)
NAME
afppasswd - netatalk password maintenance utility
SYNOPSIS
afppasswd [ -acfn ] [ -p passwd file ] [ -u minimum uid ]
DESCRIPTION
afppasswd allows the maintenance of afppasswd files created by netatalk for use by some User Authentication Modules (UAMs)
afppasswd can either be called by root with parameters, or can be called by local system users with no parameters to change their pass-
words.
EXAMPLE
Local user changing their own password:
example% afppasswd
Enter NEW AFP password: (hidden)
Enter NEW AFP password again: (hidden)
afppasswd: updated password.
OPTIONS
-a Add a new user to the afppasswd file.
-c Create and/or initialize afppasswd file or specific user.
-f Force the current action.
-p path
Path to afppasswd file.
-n If cracklib support is built into netatalk this option will cause cracklib checking to be disabled, if the superuser does not want
to have the password run against the cracklib dictionary.
-u minimum uid
This is the minimum user id (uid) that afppasswd will use when creating users.
SEE ALSO
afpd(8), atalkd(8).
netatalk 1.5 03 Aug 2000 AFPPASSWD(1)