Password or invalid user when logging into oracle database (ORA-01017)

Asked

Viewed 1,355 times

3

Good morning, everyone,

I need to set up an environment for a course.

For this I installed the Oracle database and SQL Developer. In the oracle database I have the SYS user working perfectly.

The problem occurs when I create a new bank user and when trying to log in with this new user I get invalid password error, even being sure of the user and password. (ORA ERROR-01017)

I’ve deleted this and tried to create others, I’ve changed the password but nothing works.

One remark is that the bank is forcing me to create user with the name starting with C## I don’t know if you have any co-relation.

Thanks in advance.

database oracle sqldeveloper

  • Which operating system you are using?

  • Hi Samuel, I’m using windows 10, 64bits.

1 answer

1

Try the following steps

  • 1- Open the CMD
  • 2-type: sqlplus "/as sysdba"
  • 3- type: ALTER USER [SEU_USUARIO] IDENTIFIED BY [SUA_SENHA];
    • EXAMPLE: ALTER USER SYSTEM IDENTIFIED BY 1234;
  • 4-type: COMMIT;
  • 5- type: EXIT

After performing these steps try to login with the password you typed above.

Browser other questions tagged database oracle sqldeveloper

You are not signed in. Login or sign up in order to post.