Friday, 1 October 2021
How to reset password with knowing user password in Oracle Database
SQL> select username,account_status from dba_users where username='SAMIK';
SQL> select 'alter user "'||d.username||'" identified by values '''||u.password||''';' c from dba_users d, sys.user$ u where d.username = upper('&&username') and u.user# = d.user_id;
User altered.
Subscribe to:
Post Comments (Atom)
How to recovery PDB when PDB database is dropped in Oracle
How to recovery PDB when PDB database is dropped :) [oracle@rac01 ~]$ sqlplus '/as sysdba' SQL*Plus: Release 21.0.0.0.0 - Product...
-
What Is OEM? Oracle Enterprise Manager (OEM) has built-in management capabilities that enable DBAs and Apps DBAs to monitor and ma...
-
In each version of the Oracle database, a large number of background processes will be added. Below I have compiled a list of Oracle backg...
-
Oracle ASMCMD is ASM command-line utility that you can use to manage Oracle ASM instances, disk groups, file access control for disk groups,...
No comments:
Post a Comment