Skip to Main Content

Database Software

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!

Working users then invalid username/password 6 days after database created.

Mathew BosherAug 17 2020 — edited Aug 20 2020

I have a new Oracle 19c installation on Windows 10.

I created a new non-container database and created various users and imported database exports.

User logins work fine for a number of days.

Then after what appears to be a random number of days, I get "ORA-01017: invalid username/password; logon denied" errors.

I can only connect to the database using sysdba.

I can't find anything obviously wrong in the user info or DEFAULT profile.

I am having to recreate the database, user, schemas etc. to get things running again.

This has happened three times now since I did the original install.

I have even reinstated Oracle 19c.

The most recent occurrence happened 6 days after everything was reinstated.

My machine is being rebooted on a daily basis.

It has been many years since I last asked a question online re Oracle problems so not sure where best to ask for help now.

Could someone please point me in the right direction?

Thanks.

Comments

Post Details

Added on Aug 17 2020
7 comments
2,050 views