How to login as user without changing the password in Oracle database(alter user identified by values)

In many cases, DBA needs to log in with another user whose credentials/oracle password are not known, also exporting schema and importing the schema, and preserve the same password. Let’s check out how it works out with alter user identified by values Oracle Database 10G Oracle stores the hash of the username and password is

How to login as user without changing the password in Oracle database(alter user identified by values) Read More »

How to see the OS timezone used when the database was started

Sometimes we might have different OS timezone settings while starting the database. Also, it could be possible that srvctl is using different timezone settings while starting the Database and this will impact the Database timezone used. You can use the below method to find currently used OS timezone for background processes For 11.2 and up:this

How to see the OS timezone used when the database was started Read More »

Scroll to Top