Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01017: invalid username/password; logon denied

SANPATNov 12 2021 — edited Nov 13 2021

Dear Friends
Till now i was using Oracle 12c and it was working fine. many a times uninstalled and installed but never got the issue, today when i installed the Oracle 19.0.0.0.0 Version 19.3.0.0.0 I am able to connect to sys as sysdba with password . Created the user as erp and password as erp. but unable to connect to erp. at the same time i am able to connect to sys.
I tried all the options , sqlnet.ora, tnsnames.ora, listner . even couple of times changed the password for this user . even ALTER SYSTEM SET DEFERRED_SEGMENT_CREATION=FALSE;
still getting the following error msg.
ORA-01017: invalid username/password; logon denied.
You someone please help if there is any changes in Oracle 19c
Sanjay

Comments
Post Details
Added on Nov 12 2021
16 comments
60,658 views