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
Check the version: cd $ORACLE_HOME/db/OPatch ./opatch version OPatch Version: 22.214.171.124.13 OPatch succeeded.
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
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
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 126.96.36.199.0 Production on … Continue reading Reset Oracle SYS password