Test Failed: ORA-01017: invalid username/password; logon denied

3274947 Jul 13, 2016 12:32 AM

Hello All,

I am new to Oracle products and need them for my college course.

I installed Oracle Datebase 11g Express Edition 32bit

I installed SQL Developer 4.13 32bit

I installed Java 1.8.0_91

I am using Windows 10

My problem after spending many hours trying to get SQL Developer to install, I finally was able to get it open to the main home page. I tried to create a new connection with the Oracle Database using my login credentials from Oracle website that I set up my account. I used the same password when installing both software packages. Now I get the following error message when trying to connect. Any thoughts?

1. Re: Test Failed: ORA-01017: invalid username/password; logon denied

Gary Graham-Oracle Jul 13, 2016 7:45 AM (in response to 3274947)

When you installed XE 11g you had to specify a default password for certain database userids like SYS and SYSTEM.
Try creating a connection definition with the SYSTEM user and that default password, not your web/email userid.

For more details, see https://docs.oracle.com/cd/E17781_01/admin.112/e18585/toc.htm#XEGSG111
in the section 2 about creating a database user, and especially a bit further on past 2.5 in the tip titled
SQL Developer as an Alternative for Creating Database Users

Section 4.1 gives a SQL Developer connection definition example for user CHRIS, which assumes you (or someone) created user CHRIS from another user with sufficient privileges, like SYSTEM.
Like Show 0 Likes(0)

Actions
2. Re: Test Failed: ORA-01017: invalid username/password; logon denied

Elamaran Police Jul 14, 2016 11:56 AM (in response to 3274947)

You have to use either SYS or the SCHEMA that you created in the DB. i.e USERNAME should be either SYS or SYSTEM, and the password should be the same which you gave during installation
Also check the DB Name. SID should contain the right DB Name.
Like Show 0 Likes(0)

Actions

Go to original post