Sponsored Content
Operating Systems HP-UX 'SP2-0734: unknown command beginning "elect' Error Post 302414330 by aimy on Monday 19th of April 2010 11:55:39 PM
Old 04-20-2010
Data 'SP2-0734: unknown command beginning "elect' Error

My environment is HP-UX...

Code:
NIS CEL | uname -a
HP-UX s53kj113 B.11.11 U 9000/800 1510201964 unlimited-user license

I ran this command directly from the server's sqllplus. Logically, it should have work.

But in my case, it always escaped the 1st character of the next command after the ';' and it will be repeatedly like that.

In other words, if I have 10 lines of error-free SQL command, only those odd line numbers command will work.

Example:
Code:
SQL> select 'test 1' from dual;
select 'test 2' from dual;
select 'test 3' from dual;
select 'test 4' from dual;
select 'test 5' from dual;
select 'test 6' from dual;
select 'test 7' from dual;
select 'test 8' from dual;
select 'test 9' from dual;
select 'test 10' from dual;
'TEST1
------
test 1

SQL> SP2-0734: unknown command beginning "elect 'tes..." - rest of line ignored.
SQL>
'TEST3
------
test 3

SQL> SP2-0734: unknown command beginning "elect 'tes..." - rest of line ignored.
SQL>
'TEST5
------
test 5

SQL> SP2-0734: unknown command beginning "elect 'tes..." - rest of line ignored.
SQL>
'TEST7
------
test 7

SQL> SP2-0734: unknown command beginning "elect 'tes..." - rest of line ignored.
SQL>

'TEST9
------
test 9

SQL> SP2-0734: unknown command beginning "elect 'tes..." - rest of line ignored.

My .profile content..
Code:
ORACLE_HOME=/oracle/ora9.2
export ORACLE_HOME
PATH=/usr/bin:/etc:/oracle/ora9.2/bin:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/contrib/bin:.
export PATH
ORACLE_SID=celdwh
export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
PS1='oracle9i >>'
export PS1
SHELL=/sbin/sh
export SHELL

stty erase "^H" kill "^U" intr "^C" eof "^D"

if [ -s "$MAIL" ]           # This is at Shell startup.  In normal
then echo "$MAILMSG"        # operation, the Shell checks
fi                          # periodically.

alias list='ls -lF|pg'
alias move='mv -i'
alias copy='cp -i'
alias rem='rm -i'
alias remA='rm -r -i'
alias remdir='rmdir -i'
alias ora_pro='ps -ef|grep ora_'
alias usage='cd /data/celusr/usage/'
alias cel01='cd /data/celusr/cel01/'
alias dba='cd /oracle/ora9.2/dba_/'
alias ctl='cd /oracle/ora9.2/dba_/ctl_file/'
alias tmmdata='cd /data/tmnusr/'
alias celdata='cd /data/celusr/'
alias reject='cd /data/celusr/reject'
alias oradata='cd /data/oradata/celdwh/'
alias celsub='cd /data/celusr/POSTPAID/SUBSCRIBER'
alias celnon='cd /data/celusr/POSTPAID/Non_CDR'
alias celusg='cd /data/celusr/POSTPAID/USAGE'
#alias alert='cd /oracle/oracle10g/product/10.2.0/admin/SIPIKAT/bdump'
EDITOR=vi;export EDITOR

 

8 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

unknown error message "sh: No: not found"

I am getting this error message (sh: No: not found) and I have no idea what line in my unix script its coming from or what it means. Can anyone help? thanks, Cindy (2 Replies)
Discussion started by: cindytucci
2 Replies

2. HP-UX

HP Tape Driver "Unknown Density"

Dear Experts and Advanced User, I encounter a rare problem as mentioned above. I am not able to read the tape cartridge using the following command: #dd if=/dev/rmt/0mnb ibs=16k | tar tvf - It will prompt me with the message saying DD I/O error, broken pipe; everytime the above command is... (2 Replies)
Discussion started by: stufftiger
2 Replies

3. Shell Programming and Scripting

mv command to include files beginning with "." (like .htaccess)

Hi, how can I get the mv command to include files beginning with . (such as .htaccess)? Right now when I mv a directory the .htaccess file is missing and I need to do this on a lot of directories, so there's a lot of wordpress permalinks that don't work anymore because the .htaccess file wasn't... (5 Replies)
Discussion started by: vanessafan99
5 Replies

4. UNIX for Dummies Questions & Answers

Unix "look" Command "File too large" Error Message

I am trying to find lines in a text file larger than 3 Gb that start with a given string. My command looks like this: $ look "string" "/home/patrick/filename.txt" However, this gives me the following message: "look: /home/patrick/filename.txt: File too large" So, I have two... (14 Replies)
Discussion started by: shishong
14 Replies

5. Solaris

Unknown Disks "offline or reservation conflict"

Hi All, I am a RH Linux admin that recently started working at a company with a number of SUN Servers so it's been an interesting transition. Considering the last person left with very little documentation left behind so I have been picking up most issues half complete, or troubleshot. ... (7 Replies)
Discussion started by: MobileGSP
7 Replies

6. Shell Programming and Scripting

Sometimes getting SP2-0734 error message

Hi All, Once I try to execute the below script,it will execute the script and it will generate the output file. Sometimes,it got executed successfully and generate the output file.. sometimes,it got executed and generate the output with error message as ********************************* Top of... (3 Replies)
Discussion started by: praveenk768
3 Replies

7. Shell Programming and Scripting

Add the word "prefix" to beginning of line using sed

SUSE linux bash shell this works test -d /tmpp && echo "directory exists" || echo "directory doesn't exists" |sed -e "s/^/prefix /" prefix directory doesn't exists but why doesn't this work? test -d /tmp && echo "directory exists" || echo "directory doesn't exists" |sed -e... (3 Replies)
Discussion started by: snoman1
3 Replies

8. Shell Programming and Scripting

find files in sub dir with tag & add "." at the beginning [tag -f "Note" . | xargs -0 {} mv {} .{}]

I am trying find files in sub dir with certain tags using tag command, and add the period to the beginning. I can't use chflags hidden {} cause it doesn't add period to the beginning of the string for web purpose. So far with my knowledge, I only know mdfind or tag can be used to search files with... (6 Replies)
Discussion started by: Nexeu
6 Replies
praliases(1)						      General Commands Manual						      praliases(1)

NAME
praliases - print system-wide sendmail aliases SYNOPSIS
file] file] [key ...] DESCRIPTION
prints out the contents of the alias data base used by to resolve system-wide mail aliases. The alias data base is built with the command or See sendmail(1M). The options are: Read the configuration file specified with this option instead of the default configuration file. Accesses the alias database built from file with the command If this option is not used, accesses the database built from the default alias file Note that accesses the database, not the alias file itself. If the alias file has changed since the alias database was last built, natu- rally the output of cannot match the contents of the alias file. Each key argument, if any, is looked up in the alias database. prints out the aliases to which each key expands in the form: where mailing list can be a comma-separated list of addresses to which the key resolves. Note can be used by privileged users only. RETURN VALUE
The utility exits with 0 on success, and >0 if an error occurs. DIAGNOSTICS
key was not found in the alias database. EXAMPLES
The output reveals that is aliased to is aliased to and that there is no alias for the key WARNINGS
Because supports NIS aliases, some NIS key-words may appear in the output. These key-words, which include and may be safely ignored; they merely indicate that is properly updating the alias database. AUTHOR
was developed by the University of California, Berkeley. FILES
default alias file default alias database SEE ALSO
sendmail(1M). praliases(1)
All times are GMT -4. The time now is 04:36 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy