Can connect as sysdba using sqlplus but not sql developer (ORA-01017)

Posted on 2012-09-10
Last Modified: 2012-09-17
I just ran through a new oracle installation, everything installed perfect.

when i connected as sysdba for the first time, i was able to connect but connected to an idle instance, i create initorcl.ora from a spfile, reconnected and exectuted startup

from the linux cli, i can connect to sysdba with no problem, but when connecting with sql developer i get

ORA-01017: invalid username/password; logon denied

from the sysdba account through sqlplus i created a standard user, and i am able to connect to that user from sql developer..

Question by:futureDBA
    1 Comment
    LVL 20

    Accepted Solution

    You don't "connect to sysdba" - sysdba is a role. You connect "as sysdba" which means you have sysdba rights upon logging in. If you did "connect / as sysdba", all it means is that you passed your OS credentials for authorization in Oracle.

    Since you already created an additional user, just give that user the sysdba role:

    grant sysdba to <your_user>;

    You can mark the connection in SQL Developer as 'sysdba', I think it's just a checkbox in the connection properties window.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now