• Home
• 

• Products
• DbaBar

• Oracle administration made easy

• OraSpy

• Simple Oracle monitoring

• Oracle Locator Express

• The Oracle Home Selector Replacement

• Oracle Password Changer

• Change (expired) passwords

• Oracle Listener Remover

• Remove obsolete Listeners on Windows

• Actions
• Download

• Download Free Products and Trials

• Buy Licenses

• Buy an official license

• Support

• Get support for our products

• Oracle Error Codes

• Oracle Error Messages Explained

• DbMotive
• About Us

• Everything you want to know about us

• News

• Jan 27th: New Oracle Locator Express Release

• Sitemap

• Browse our website

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

Connect SYS/<password> 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 [ [] [] [] ]
where  ::= -H | -V | [ [-L] [-M ] [-R ] [-S] ]
        ::= [/][@] | / | /NOLOG
        ::= @|[.] [ ...]
        "-H" displays the SQL*Plus version banner and usage syntax
        "-V" displays the SQL*Plus version banner
        "-L" attempts log on just once
        "-M " uses HTML markup options 
        "-R " uses restricted mode 
        "-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.