Find Oracle users with DBA or different privileges

Hello, How do I identify all Oracle users who have been granted DBA, Deployer or Etc. privileges. This would include SYSDBA and the DBA role granted. What are some swcript examples for finding these users? basic scripts. SQL> select * from dba_role_privs where granted_role='DBA'; SQL> select * from dba_role_privs where granted_role='Deployer'; The v$pwfile_users view contains … Continue reading Find Oracle users with DBA or different privileges

Advertisements

Check the Oracle Opatch Version

Check the version: cd $ORACLE_HOME/db/OPatch ./opatch version OPatch Version: 12.2.0.1.13 OPatch succeeded.

Administering ASM Diskgroups

About Mirroring and Failure Groups Mirroring protects data integrity by storing copies of data on multiple disks. When you create a disk group, you specify an Oracle ASM disk group type based on one of the following three redundancy levels: Normal for 2-way mirroring High for 3-way mirroring External to not use Oracle ASM mirroring, … Continue reading Administering ASM Diskgroups

LRM-00109: could not open parameter file

Hello Everyone, When trying to start the instance , getting this .. Enter user-name: sys as sysdba; Enter password: Connected to an idle instance. SQL> startup; ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initDemo.ora' solutuon one : Check the Oracle SID name.  Wrong settings in bash profile. Solution two : I … Continue reading LRM-00109: could not open parameter file

Reset Oracle SYS password

I have list my SYS password in Oracle and I need to recover the SYS password, or at least restore the password.  How can I recover my lost SYS password? sqlplus /nologconnect / as sysdbaALTER USER sys IDENTIFIED BY "new_password"; demo : [oracle@mezon01 ~]$ . profile_db_PDEV [oracle@mezon01 ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.4.0 Production on … Continue reading Reset Oracle SYS password