Shell script not working


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shell script not working
# 1  
Old 01-19-2015
Shell script not working

Code:
. /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:

Code:
LMS_PROFILE.sh: ORACLE_SID=SEGODI: is not an identifier


Last edited by zaxxon; 01-19-2015 at 11:43 AM.. Reason: code tags
# 2  
Old 01-19-2015
Quote:
Originally Posted by malefho
. /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: ORACLE_SID=SEGODI: is not an identifier
Can you show results of these commands:


Code:
which sqlplus

sqlplus
(log in manually)

exit;

export ORACLE_SID=SEGODI

sqlplus /nolog

connect sysadm/sysadm

# 3  
Old 01-20-2015
Code:
mainbrain:/home/bscs6/scripts>sqlplus

SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jan 20 08:04:07 2015

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Enter user-name: 


mainbrain:/home/bscs6/scripts>export ORACLE_SID=SEGODI
mainbrain:/home/bscs6/scripts>sqlplus /nolog   

SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jan 20 08:06:32 2015

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

SQL> connect sysadm/sysadm
Connected.
SQL>


Last edited by Don Cragun; 01-20-2015 at 03:39 AM.. Reason: Add CODE tags.
# 4  
Old 01-20-2015
Quote:
Originally Posted by malefho
Code:
mainbrain:/home/bscs6/scripts>sqlplus

SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jan 20 08:04:07 2015

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Enter user-name: 


mainbrain:/home/bscs6/scripts>export ORACLE_SID=SEGODI
mainbrain:/home/bscs6/scripts>sqlplus /nolog   

SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jan 20 08:06:32 2015

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

SQL> connect sysadm/sysadm
Connected.
SQL>

Ok, and what does this file look like:

. /home/bscs6/.kshrc

?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

Shell script help: not working as I like

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

2. Shell Programming and Scripting

Installer is shell script not working

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

3. Shell Programming and Scripting

Cp not working in shell script but running perfectly from shell

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

4. Ubuntu

Shell script not working accordingly

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

5. Shell Programming and Scripting

expect script inside shell script not working.

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. UNIX for Dummies Questions & Answers

shell Script working

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

7. Shell Programming and Scripting

ftp in shell script is not working

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

8. Shell Programming and Scripting

Perl script 'system' linking to local shell script not working

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

9. Shell Programming and Scripting

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... (2 Replies)
Discussion started by: govindts
2 Replies

10. Shell Programming and Scripting

Shell script is not working...

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
Login or Register to Ask a Question