Sponsored Content
Top Forums Shell Programming and Scripting error connecting sql through a shell script Post 302190660 by nehak on Wednesday 30th of April 2008 07:00:03 AM
Old 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

Connecting DB in the Shell Script to do SQL Query

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

connecting sql from shell

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

Calling SQL LDR and SQL plus scripts in a shell script

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

shell script for connecting to a different user

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

How to grep sql error in shell script and exit the script?

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

connecting servers using shell script

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

SQL block in a Shell Script connecting to a local and remote DB

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

How to get rid off Password expiry error message when connecting to sql in script?

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

Red Hat: Error connecting using secure shell

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

Shell script with sql script error

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
KPASSWDD(8)						    BSD System Manager's Manual 					       KPASSWDD(8)

NAME
kpasswdd -- Kerberos 5 password changing server SYNOPSIS
kpasswdd [--addresses=address] [--check-library=library] [--check-function=function] [-k kspec | --keytab=kspec] [-r realm | --realm=realm] [-p string | --port=string] [--version] [--help] DESCRIPTION
kpasswdd serves request for password changes. It listens on UDP port 464 (service kpasswd) and processes requests when they arrive. It changes the database directly and should thus only run on the master KDC. Supported options: --addresses=address For each till the argument is given, add the address to what kpasswdd should listen too. --check-library=library If your system has support for dynamic loading of shared libraries, you can use an external function to check password quality. This option specifies which library to load. --check-function=function This is the function to call in the loaded library. The function should look like this: const char * passwd_check(krb5_context context, krb5_principal principal, krb5_data *password) context is an initialized context; principal is the one who tries to change passwords, and password is the new password. Note that the password (in password->data) is not zero terminated. -k kspec, --keytab=kspec Keytab to get authentication key from. -r realm, --realm=realm Default realm. -p string, --port=string Port to listen on (default service kpasswd - 464). DIAGNOSTICS
If an error occurs, the error message is returned to the user and/or logged to syslog. BUGS
The default password quality checks are too basic. SEE ALSO
kpasswd(1), kdc(8) HEIMDAL
April 19, 1999 HEIMDAL
All times are GMT -4. The time now is 09:59 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy