07-29-2008
shell script is not working..
Dear all,
I am writing simple shell script.
#/bin/bash
ORACLE_HOME=/home/app/oracle/product/9.2.0
export ORACLE_HOME
export ORACLE_SID=DATX
$ORACLE_HOME/bin/sqlplus -s datadmin/password <<EOF
execute testproc;
exit;
EOF
~
~
In the above shell script, the oracle instance name is DATX. This instance is available in another server.
db1:/home/app/oracle/admin/DBA/crontab/jobs>sh testproc.sh
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_string>] | /
ERROR:
ORA-01005: null password given; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
DB1:/home/app/oracle/admin/DBA/crontab/jobs>
Can anyone help me what is wrong here...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
All,
I have oracle 9i and 10g on unix. now i have 920.env and 1020.en file to set p respective enviornment.
when I excecute this commnad
. $HOME/920.env from the shell prompt it is working fine. and also same for 1020.env .
Now same command . $HOME/920.env i am putting in shell... (2 Replies)
Discussion started by: vishalpatel03
2 Replies
2. Shell Programming and Scripting
Trying to figure out why this works:
printpwd.pl
#!/usr/bin/perl
use CGI::Carp qw( fatalsToBrowser );
print "Content-type: text/html\n\n";
$A = system("pwd");
$A = `pwd`;
print "$A\n";
^^actually that works/breaks if that makes any sense.. i get the working directory twice but when... (5 Replies)
Discussion started by: phpfreak
5 Replies
3. Shell Programming and Scripting
Hi All,
I have writtern a shell script which has a sql query. I want to send the results of sql query to a shared area over a network.I also want to log the errors in a log file if the text file is not sent to shared area.
The results of sql query are spooled in TEMPFILE.
LOGFILE... (1 Reply)
Discussion started by: nsachin
1 Replies
4. UNIX for Dummies Questions & Answers
i wrote a shell program in Home Directory.
and i changed to other directory.
i want to try to execute shell script in Other Dir.
it is not executed.
how can i make this script to execute in other directory also??
Thanks,
Arun (11 Replies)
Discussion started by: arun508.gatike
11 Replies
5. Shell Programming and Scripting
Shell Scipt: temp.sh
su - <$username>
expect pass.exp
Expect script: pass.exp
#!/usr/bin/expect -f
# Login
#######################
expect "Password: " send "<$password>\r"
it comes up with Password: but doesnt take password passed throguh file. (2 Replies)
Discussion started by: bhavesh.sapra
2 Replies
6. Ubuntu
loop=y
while
do
clear
tput cup 5 15
echo -n "People Database"
echo -n "===================================="
tput cup 8 12
echo -n "L-Print Last Names"
tput cup 9 12
echo -n "F-Print First NAmes"
tput cup 10 12
echo -n "C-Print First Name, Last Name sorted by city"
tput cup 11 12... (3 Replies)
Discussion started by: Akhilaprabhakar
3 Replies
7. Shell Programming and Scripting
. /home/bscs6/.kshrc
set -x
monthy=`date +%m`
daty=`date +%d`
yeary=`date +%Y`
cd /home/bscs6/scripts
sqlplus sysadm/sysadm@SEGODI @lms_profile.sql
mv /home/bscs6/scripts/lmsprofile.log /home/bscs6/scripts/LMS_PROFILE_DUMP_$daty$monthy$yeary.txt
gives me the error below:
LMS_PROFILE.sh:... (3 Replies)
Discussion started by: malefho
3 Replies
8. Shell Programming and Scripting
Dear All,
I have script.
Dest=""
IFS='
'
for translation in $(echo $MY_MAP)
do
t1=$(echo $translation | cut -d"=" -f1)
t2=$(echo $translation | cut -d"=" -f2| cut -d"," -f1)
if
then
Dest=$UNX/$u_product_path/$u_study_path/$UNXTR/$t2
break;
... (4 Replies)
Discussion started by: yadavricky
4 Replies
9. Shell Programming and Scripting
Hi Guys,
I have one installer shell script which normally get from the dev team to install the app and it works fine for years (in IAX) the same installer/script iam trying to run in Linux 7.2 but it stuck somewhere which I cannot debug, can you help me to point out where it stuck .
here is the... (9 Replies)
Discussion started by: Riverstone
9 Replies
10. Homework & Coursework Questions
Student just starting to learn shell script
I have file named
smallFile
John:Doe:ECE:3.54:doe@jd.home.org:111.222.3333
James:Davis:ECE:3.71:davis@jd.work.org:111.222.1111
Al:Davis:CS:2.63:davis@a.lakers.org:111.222.2222
Ahmad:Rashid:MBA:3.74:ahmad@mba.org:111.222.4444... (2 Replies)
Discussion started by: jetoutant
2 Replies
LEARN ABOUT OPENSOLARIS
shells
shells(4) File Formats shells(4)
NAME
shells - shell database
SYNOPSIS
/etc/shells
DESCRIPTION
The shells file contains a list of the shells on the system. Applications use this file to determine whether a shell is valid. See getuser-
shell(3C). For each shell a single line should be present, consisting of the shell's path, relative to root.
A hash mark (#) indicates the beginning of a comment; subsequent characters up to the end of the line are not interpreted by the routines
which search the file. Blank lines are also ignored.
The following default shells are used by utilities: /bin/bash, /bin/csh, /bin/jsh, /bin/ksh, /bin/ksh93, /bin/pfcsh, /bin/pfksh, /bin/pfsh,
/bin/sh, /bin/tcsh, /bin/zsh, /sbin/jsh, /sbin/sh, /usr/bin/bash, /usr/bin/csh, /usr/bin/jsh, /usr/bin/ksh, /usr/bin/ksh93, /usr/bin/pfcsh,
/usr/bin/pfksh, /usr/bin/pfsh, and /usr/bin/sh, /usr/bin/tcsh, /usr/bin/zsh, and /usr/sfw/bin/zsh. /etc/shells overrides the default list.
Invalid shells in /etc/shells could cause unexpected behavior, such as being unable to log in by way of ftp(1).
FILES
/etc/shells list of shells on system
SEE ALSO
vipw(1B), ftpd(1M), sendmail(1M), getusershell(3C), aliases(4)
SunOS 5.11 20 Nov 2007 shells(4)