Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: 'SP2-0734: unknown command beginning "elect' Error
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

LEARN ABOUT CENTOS

aliasadm

aliasadm(1M)						  System Administration Commands					      aliasadm(1M)

NAME

       aliasadm - manipulate the NIS+ aliases map

SYNOPSIS

       aliasadm -a alias expansion [options comments] optional flags

       aliasadm -c alias expansion [ options comments] [ optional flags]

       aliasadm -d alias [ optional flags]

       aliasadm -e alias [ optional flags]

       aliasadm -l alias [ optional flags]

       aliasadm -m alias [ optional flags]

       aliasadm [-I] [-D domainname] [-f filename] [-M mapname]

DESCRIPTION

       aliasadm makes changes to the alias map.

       The alias map is an NIS+ table object with four columns:

       alias	       The name of the alias as a null terminated string.

       expansion       The value of the alias as it would appear in a sendmail /etc/aliases file.

       options	       A  list	of options applicable to this alias.  The only option currently supported is  CANON. With this option, if the user
		       has requested an inverse alias lookup, and there is more than one alias with this expansion, this alias	is  given  prefer-
		       ence.

       comments        An  arbitrary  string  containing comments about this alias. The sendmail(1M) command reads this map in addition to the NIS
		       aliases map and the local  /etc/aliases database.

OPTIONS

       -a	       Add an alias.

       -c	       Change an alias.

       -d	       Delete an alias.

       -e	       Edit the alias map.

       -I	       Initialize the NIS+ aliases database.

       -l	       List the alias map.

       -m	       Print or match an alias.

       -D domainname   Edit the map in domain  domainname instead of the current domain.

       -f filename     When editing or listing the database, use filename instead of invoking the editor.

       -M mapname      Edit mapname instead of mail_aliases.

FILES

       /etc/aliases    mail aliases for the local host in ASCII format

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWnisu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       sendmail(1M), attributes(5)

NOTES

       NIS+ might not be supported in future releases of the SolarisTM Operating Environment. Tools to aid the migration from  NIS+  to  LDAP  are
       available in the Solaris 9 operating environment. For more information, visit http://www.sun.com/directory/nisplus/transition.html.

SunOS 5.10							    12 Dec 2001 						      aliasadm(1M)
All times are GMT -4. The time now is 09:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy