1

When loging in to sqlplus as SYSTEM, why does the login fail with an invalid username/password error if I do not include "AS SYSDBA"

C:\Windows\System32>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 16 01:00:13 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> conn system/password
ERROR: ORA-01017: invalid username/password; logon denied


SQL> conn system/password as sysdba
Connected.
SQL>

I have a script that I need to run locally. This script runs fine on other machines, but fails with the error above for me.

6

Because you are not logged in as the user system. When you execute conn system/password as sysdba, Oracle won't even check the user and password (--> from the local systeem where the db is running on). If you enter the system/password as sysdba and then execute 'show user', you'll notice you are logged in as user 'SYS'. So you are actually entering the wrong password when you execute the conn system/password, Oracle doest not lie.

Check http://docs.oracle.com/cd/B28359_01/server.111/b28310/dba006.htm#ADMIN11046 for more information. Because what I told you is not the whole story.

| improve this answer | |
  • Thanks! This was very helpful and the link provided much insight into the problem. – BamaPookie Dec 16 '13 at 16:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.