12c: Testing audit features for Data Pump (Export & Import) and RMAN jobs

Comments

Post a Comment

Popular posts from this blog

Oracle DataGuard – How to resize Redo Log and Standby Redo Log

Oracle DataGuard – How to resize Redo Log and Standby Redo Log set linesize 200 col dest_name for a30 select DEST_NAME,STATUS,PROTECTION_MODE,ARCHIVED_SEQ#,APPLIED_SEQ# from v$archive_dest_status; On Standby server - make file management parameter to manual if not: show parameter standby; alter system set standby_file_management=manual; ================== +     On Primary             + ==================  SQL> select group#,thread#,status from v$log; col member for a60 set linesize 200 select member,group#,status from v$logfile; SQL> select group#,thread#,status from v$log;     GROUP#    THREAD# STATUS ---------- ---------- ----------------          1          1 ACTIVE          2       ...
Read more

Modifying the network configuration on Exadata x5-2

Modifying the network configuration on Exadata x5-2 Run the /opt/oracle.cellos/ipconf utility which is an interactive tool that will allow you to modify any and all of the network settings, including NTP or DNS.   Check Script: [root@exasc02-adm ~]# vi check_cellconf.sh IPCONF_RAW_OUTPUT=$(/opt/oracle.cellos/ipconf -verify -semantic -at-runtime -check-consistency -verbose 2>/dev/nu ll); IPCONF_RESULT=$(echo "$IPCONF_RAW_OUTPUT" | egrep "Consistency check PASSED" | wc -l); IPCONF_SUMMARY=$(echo "$IPCONF_RAW_OUTPUT" | tail -1); if [ $IPCONF_RESULT = "1" ]   then     echo -e "SUCCESS: $IPCONF_SUMMARY"   else     echo -e "FAILURE: $IPCONF_SUMMARY\n"     echo -e "`echo -e "$IPCONF_RAW_OUTPUT" | grep FAILED`" fi; Run Script:  sh -x check_cellconf.sh ---- ILOM second NTP server time.cmcom.net must have valid syntax in /opt/oracle.cellos/cell.conf   : PASSED I...
Read more

Add additional node to 12cR2 RAC Cluster Testing

Image
$ ./gridSetup.sh Launching Oracle Grid Infrastructure Setup Wizard...  Click Next  Pass the additional Node details . Next two screen it does all checks. Click OK. Run the listed two scripts - root@racdb02::/root $ /u01/app/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /u01/app/oraInventory to oinstall. The execution of the script is complete. root@racdb02::/root $ /u01/app/grid/software/root.sh Performing root user operation. The following environment variables are set as:     ORACLE_OWNER= grid     ORACLE_HOME=   /u01/app/grid/software Enter the full pathname of the local bin directory: [/usr/local/bin]:    Copying dbhome to /usr/local/bin ...    Copying oraenv to /usr/local/bin ...  ...
Read more