- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Working users then invalid username/password 6 days after database created.
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?