154.41 MB of Audit Trail files collected (.aud: 154.41, .xml: 0, .bin: 0)

Enterprise Manager giving error 'Audit Trail files collected' after EM upgrade to 12.1.0.5.0

Current 'Database Instance' template was showing:

> Operating System Audit Records

> > File Count [>=, 10, 20]

After hours of investigating found my ideal fix for our environment.


Fix: Created a new 'Database Instance' and applied to database.

Now we got the desired option

> Operating System Audit Records

> > Size of Audit Files [>=, 10, 20]

After updating above numbers to 1024, 1280 and applying the template to database, above alert has gone. Selected 1GB and 1.2GB, since we the space and for all 40+ rac's size of current audit folders were 100 - 800 MB.

Basic RMAN backup / Basic Archive backup

- Simple RMAN backup / RMAN Basic backup - Simple Archive backup / Simple Archivelog backup 1. For first time RMAN backup, do some basic checks / config changes CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXOPENFILES 4 MAXPIECESIZE 5G FORMAT '/mnt/backup01/oracle/backup_rman/rmanNIDEV/nidev_b_%T_%u_%s_%p' RATE 15 M; CONFIGURE CHANNEL 2 DEVICE TYPE DISK MAXOPENFILES 4 MAXPIECESIZE 5G FORMAT '/mnt/backup01/oracle/backup_rman/rmanNIDEV/nidev_b_%T_%u_%s_%p' RATE 15 M; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/mnt/backup01/oracle/backup_rman/rmanNIDEV/nidev_cf_%F'; CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/mnt/backup01/oracle/backup_rman/rmanNIDEV/nidev_snapcf.f'; show all; 2. Here is a backup script DATELOG_ID=`date '+%Y%m%d%H%M'` rman target / <>log_rman_${DATELOG_ID}.txt show all; crosscheck archivelog all; backup incremental level=0 database plus archivelog delete input; EOF 3. Here is a basic ARCHIVE backup script DATELOG_ID=`date '+%Y%m%d%H%M'` rman target / <>log_rman_${DATELOG_ID}.txt show all; crosscheck archivelog all; backup archivelog all delete input; EOF

How to start Apache and MySQL Automatically when Windows 7

How to start Apache and MySQL Automatically when Windows 7
How to start XAMPP Automatically when Windows 7
Xampp 3.2 autostart as service

1. Go to XAMPP folder
2. Find 'xanoo-control.exe'
3. Right Click on above and run using "Run as administrator"
4. Then you can click Servuce checkbox to install apache, Mysql as a service.

OEM 12c How to Drop Cluster Database Target

OEM 12c How to Drop Cluster Database Target and how to drop the Cluster.

Below steps can be used to do many other similar tasks, relate to oem Agents.

1. Click Setup > Manage Cloud Control > Agents
2. Select the number in column "Monitored Targets" for the 1st node
3. There you can select the Cluster and Cluster Database
4. Once selected, click Cluster (on top left)
5. Click Target Setup > Remove Target
6. Click Yes to confirm
7. (Do similar with other nodes)

New to Enterprise Manger Cloud Control 12c (oem 12c)

Some Useful links and topics of Oracle Enterprise Manager 12c (OEM 12c):

oem 12c User administration

• Login as SYSMAN user or other super admin user
• Click Setup (top left) > Select Security > Click Administration 
• Here you can add / edit or delete oem 12c users

oem 12c: Administer Monitoring Templates
http://www.youtube.com/watch?v=xk9y5299dX0

How to add RAC Databases to Enterprise Manager Cloud Control 12c http://www.gokhanatil.com/2014/01/how-to-add-rac-databases-to-enterprise-manager-cloud-control-12c.html 

1. Click "Configure Auto Discovery"
2. Click "Oracle Database, Listener and Automatic Storage Management"
3. Add Clusterwaer Home e.g. /u01/app/11.2.0.3/grid

1. Add Targets Manually
2. Add Targets Using Guided Process (Also Adds Related Targets)
3. Select "Oracle Cluster and HA Service"
4. Click "Add Using Guided Process"
5. Select 1st node click "Select"
6. Click Continue

1. Add Targets Manually
2. Select "Add Targets Declaratively by Specifying Target Monitoring Properties"
3. Target Type: Cluster Database
4. Select 1st node
5. Click Manullay

Tips to get some of the info:

• cemutlo -n (Cluster name)
• srvctl config scan
• srvctl status SCAN_LISTENER

oem 12c: Incident Management: Use Incident Rule Sets

• Part 1: http://www.youtube.com/watch?v=SWjZM1ugPDc
• Part 2: http://youtu.be/IhPtcq8nEP4

Oracle 12c clusterware ONS port

$ cat /u01/app/11.2.0.3/grid/opmn/conf/ons.config

(05 Jan 2014) I used the value remoteport value 6200, and it worked         

Standby common sqls

select thread#, max(sequence#) as "Last_Applied_Log" from v$log_history group by thread#; select process, status, sequence# from v$managed_standby; alter database recover managed standby database disconnect from session; alter database register logfile '/u02/oracle/backup_arch/o1_mf_1_57518_93s5gop2_.arc'; alter database register logfile '/u02/oracle/backup_arch/o1_mf_1_57519_93s5v0pm_.arc'; ... or you can try to use rman to register a group of them e.g. RMAN> catalog start with '/u01/oracle/arch/arc'; Shutdown Standby select process, status, sequence# from v$managed_standby; alter database recover managed standby database cancel; shutdown immediate Restore archivelog from RMAN backup. restore archivelog from logseq 69124 until logseq 69134; -- or restore archivelog from logseq 69135;

Oracle 12c installation

# cd /etc/yum.repos.d # wget http://public-yum.oracle.com/public-yum-el5.repo # wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle # gpg --quiet --with-fingerprint /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle # yum install oracle-validated