Home » SQL & PL/SQL » Client Tools » SP2-0734 error (Oracle 10g)
SP2-0734 error [message #325171] Thu, 05 June 2008 04:21 Go to next message
sidd_411
Messages: 30
Registered: March 2008
Member
Dear all

Below is the error message I am getting in HP unix system. Need a solution for it.


SQL> conn / as sysdba
SP2-0734: unknown command beginning "co..." - rest of line ignored.
Re: SP2-0734 error [message #325181 is a reply to message #325171] Thu, 05 June 2008 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Seems you have something that is not in your post.

Regards
Michel

[Updated on: Thu, 05 June 2008 04:43]

Report message to a moderator

Re: SP2-0734 error [message #325188 is a reply to message #325181] Thu, 05 June 2008 04:51 Go to previous messageGo to next message
sidd_411
Messages: 30
Registered: March 2008
Member
I did not get you Michel. Could you please elaborate ?
Re: SP2-0734 error [message #325203 is a reply to message #325188] Thu, 05 June 2008 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"conn / as sysdba" works.
If it does not work maybe you have something that is not visible, a control character or the like.

Regards
Michel
Re: SP2-0734 error [message #325232 is a reply to message #325203] Thu, 05 June 2008 05:55 Go to previous messageGo to next message
sidd_411
Messages: 30
Registered: March 2008
Member

Michel !

First command is not working, but if I specify username/password, it is working. Could you explain me why it is like that ?

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges


SQL> conn sys/manager1 as sysdba
Connected.
SQL>
Re: SP2-0734 error [message #325234 is a reply to message #325232] Thu, 05 June 2008 06:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are many and many topics on ORA-1031 on "connect / as sysdba", please search them.

Regards
Michel
Re: SP2-0734 error [message #325238 is a reply to message #325234] Thu, 05 June 2008 06:16 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is one of them; check what Alison has said, perhaps you'll understand why it happened.

By the way,
your first message
SQL> conn / as sysdba
SP2-0734: unknown command beginning "co..." - rest of line ignored.
and
your last message
SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges
have nothing in common. Just being curious: what happened to "unknown command"?
Re: SP2-0734 error [message #325283 is a reply to message #325238] Thu, 05 June 2008 09:32 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I wanna bet there are some invisible control characters as a result of using cursor-keys or backspace..
Previous Topic: 3rd Party tool Requirement for DB Replication
Next Topic: Free 3rd Party Tools
Goto Forum:
  


Current Time: Mon Dec 05 23:53:31 CST 2016

Total time taken to generate the page: 0.22523 seconds