OraFAQ Forum: Client Tools » login as sys using sqlplus

Home » Other » Client Tools » login as sys using sqlplus (oracle 11g , client oracle 1og, windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tue, 08 May 2012 09:12

miroconnect@yahoo.com
Messages: 202
Registered: April 2006

Senior Member

I am trying to connect to my database using sys from console.

E:\>sqlplus sys/password@aws

SQL*Plus: Release 9.2.0.1.0 - Production on Tue May 8 10:11:10 2012

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER


Enter user-name: ^C
E:\>sqlplus sys/password@aws  as sysdba
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
      <logon>  ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
      <start>  ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
        "-H" displays the SQL*Plus version banner and usage syntax
        "-V" displays the SQL*Plus version banner
        "-L" attempts log on just once
        "-M <o>" uses HTML markup options <o>
        "-R <n>" uses restricted mode <n>
        "-S" uses silent mode

E:\>

please help how to login as sys using sqlplus

Report message to a moderator

Re: login as sys using sqlplus [message #553789 is a reply to message #553787]

Tue, 08 May 2012 09:16

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

sqlplus /as sysdba

Report message to a moderator

Re: login as sys using sqlplus [message #553790 is a reply to message #553787]

Tue, 08 May 2012 09:18

Michel Cadot
Messages: 68506
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Try sqlplus 'sys/password@aws as sysdba' or similar things with quotes.

Regards
Michel

Report message to a moderator

Re: login as sys using sqlplus [message #553791 is a reply to message #553789]

Tue, 08 May 2012 09:19

miroconnect@yahoo.com
Messages: 202
Registered: April 2006

Senior Member

thanks for quick reply I tried as you said

E:\>sqlplus /as sysdba
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
      <logon>  ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
      <start>  ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
        "-H" displays the SQL*Plus version banner and usage syntax
        "-V" displays the SQL*Plus version banner
        "-L" attempts log on just once
        "-M <o>" uses HTML markup options <o>
        "-R <n>" uses restricted mode <n>
        "-S" uses silent mode

Report message to a moderator

Re: login as sys using sqlplus [message #553792 is a reply to message #553790]

Tue, 08 May 2012 09:20

miroconnect@yahoo.com
Messages: 202
Registered: April 2006

Senior Member

also tried this


E:\>sqlplus 'sys/password@aws as sysdba'
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
      <logon>  ::= <username>[/<password>][@<connect_string>] | / | /NOLOG
      <start>  ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
        "-H" displays the SQL*Plus version banner and usage syntax
        "-V" displays the SQL*Plus version banner
        "-L" attempts log on just once
        "-M <o>" uses HTML markup options <o>
        "-R <n>" uses restricted mode <n>
        "-S" uses silent mode

Report message to a moderator

Re: login as sys using sqlplus [message #553793 is a reply to message #553792]

Tue, 08 May 2012 09:31

miroconnect@yahoo.com
Messages: 202
Registered: April 2006

Senior Member

when I try to connect using toad I get ORA-01017:invalid username/password; logon denied

I can only login using enterprise manager. Please advice ,

Report message to a moderator

Re: login as sys using sqlplus [message #553794 is a reply to message #553792]

Tue, 08 May 2012 09:35

miroconnect@yahoo.com
Messages: 202
Registered: April 2006

Senior Member

Now I am able to connect I used double quotes it worked. but not able to login from toad

Report message to a moderator

Re: login as sys using sqlplus [message #553797 is a reply to message #553794]

Tue, 08 May 2012 09:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>login as sys using sqlplus (oracle 11g ,
above from TITLE & below from original post
>SQL*Plus: Release 9.2.0.1.0 - Production on Tue May 8 10:11:10 2012

In which reality does problem exist?
With V11 passwords are CaseSensitive & TOAD does not always do the correct thing!

Report message to a moderator

Re: login as sys using sqlplus [message #553816 is a reply to message #553797]

Tue, 08 May 2012 10:57

Michel Cadot
Messages: 68506
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

TOAD does not always do the correct thing!

Fix: TOAD sometimes does the correct thing, but you can't know when.

Regards
Michel

Report message to a moderator

Previous Topic:	worksheet shortcut
Next Topic:	limit of max pool size.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 27 13:08:53 CDT 2023