Share |

ORA-28009: Connection as SYS should be as SYSDBA or SYSOPER

Connect SYS/ is not longer valid since Oracle 9i.

When you want to connect to the SYS or INTERNAL account, you'll have to connect using SYSDBA or SYSOPER. 
C:\>sqlplus

SQL*Plus: Release 10.1.0.2.0 - Production 
Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Enter user-name: / as sysdba
Prior to Oracle 10g, when you wanted to connect using / AS SYSDBA on the command prompt, you had to put the connection string between double quotes:
C:\>sqlplus / as sysdba
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-L] [-M ] [-R ] [-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

C:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.7.0

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

Connected.

 Was this information helpful?  Yes No
If it was not helpful, please take some time to explain why. This is not to ask questions, you can do so in the forum.

Welcome to our forum for Oracle error: ORA-28009 Add your own message



At the moment there are no forum messages. You can add your own question.

Add your message

 Please provide your personal info 



 Please ask your message as briefly and clear as possible 

 Spam Protection 
Validation Code: 4t7gg36pujaq46hcb


Ask Your Question

If you need more information about this particular error message, you can leave a forum message.

We are replying to this message whenever we have some spare time, so please do not consider this as a private 'solve my critical issue asap' service.

Should you need professional Oracle Assistance to make your project a success, please have a look at our consultancy services.


Spam Protection

In order to prevent automatic generation of messages, we are asking for a validation code. This code is unique and is generated every time a new message is asked.

If you do not enter the validation correctly, your message will not be recorded.


Forum Rules

Please be polite, do not USE ALL UPPERCASE, no insults, violance or any other threats.