Home » SQL & PL/SQL » Client Tools » login as sys using sqlplus (oracle 11g , client oracle 1og, windows xp)
login as sys using sqlplus [message #553787] Tue, 08 May 2012 09:12 Go to next message
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
Re: login as sys using sqlplus [message #553789 is a reply to message #553787] Tue, 08 May 2012 09:16 Go to previous messageGo to next message
cookiemonster
Messages: 13017
Registered: September 2008
Location: Rainy Manchester
Senior Member
sqlplus /as sysdba
Re: login as sys using sqlplus [message #553790 is a reply to message #553787] Tue, 08 May 2012 09:18 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
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
Re: login as sys using sqlplus [message #553791 is a reply to message #553789] Tue, 08 May 2012 09:19 Go to previous messageGo to next message
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


Re: login as sys using sqlplus [message #553792 is a reply to message #553790] Tue, 08 May 2012 09:20 Go to previous messageGo to next message
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

Re: login as sys using sqlplus [message #553793 is a reply to message #553792] Tue, 08 May 2012 09:31 Go to previous messageGo to next message
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 ,
Re: login as sys using sqlplus [message #553794 is a reply to message #553792] Tue, 08 May 2012 09:35 Go to previous messageGo to next message
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
Re: login as sys using sqlplus [message #553797 is a reply to message #553794] Tue, 08 May 2012 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 25858
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!
Re: login as sys using sqlplus [message #553816 is a reply to message #553797] Tue, 08 May 2012 10:57 Go to previous message
Michel Cadot
Messages: 65389
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
Previous Topic: worksheet shortcut
Next Topic: limit of max pool size.
Goto Forum:
  


Current Time: Sat Feb 24 17:56:42 CST 2018

Total time taken to generate the page: 0.01468 seconds