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

Posted on 2012-09-10
Medium Priority
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

gatorvip earned 2000 total points
ID: 38384649
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.

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses
Course of the Month17 days, 13 hours left to enroll

830 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