Database Experts

Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c This document is prepared for monitoring windows server where sql server installed.Mostly used OEM for monitoring databases. In this document we will cover agent installation with target addition into OEM 12c. We will also cover prerequisite like enabling port for communication from agent to oms server Agent Installation on windows server  As a part of installation, we require to fulfil prerequisite like connectivity between OEM server and Window server. For Port opening and communication between two servers Ports required to open : 4903 , 7799 , 3872 Following steps require doing for manually installation of Agent in Windows server. Verifying if the agent exists on OMS. To begin, open your Cloud Control and go to "Setup -> Extensibility -> Self Update". Open the "Agent Software" folder and check if the Agent Software of Windows x64 is with statu...

Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL  APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and later Information in this document applies to any platform. GOAL  How to purge the  UNIFIED_AUDIT_TRAIL table ? SOLUTION The unified audit trail can be purged using the DBMS_AUDIT_MGMT package:  qlplus / as sysdba SQL>  select  count(*) from unified_audit_trail;   COUNT(*) ----------       2619 SQL>  BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL( audit_trail_type         =>  DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp  =>  FALSE); END; / PL/SQL procedure successfully completed. SQL>  select  count(*) from unified_audit_trail;   COUNT(*) ----------          1 You can also use the last_arch_timestamp, if you don't want to purge all ...

Oracle 11g:OEM grid control 11gR1 installation and configuration on Windows Server (64 Bit) This post is mainly written for Installation of Oracle 11gR1(11.1.0.1.0) OEM grid control on windows server. We will install it on separate grid server which OS is windows server 2012. 64 bit. Perquisites.. Oracle Database for repository of OEM grid control. All servers hosts names added to hosts files on server. Installation of Weblogic server. We will go steps by steps to complete grid control configuration. 1.Installation of JDK. Read on this link.. http://oracle-mssql-dba.blogspot.in/2015/04/oracle-11g-grid-controlweblogic-1032.html 2.Installation of Weblogic Server for middleware. Read on this link.. http://oracle-mssql-dba.blogspot.in/2015/04/oracle-11g-grid-controlweblogic-1032.html 3.Make necessary changes to repository database. sqlplus / AS SYSDBA ALTER SYSTEM SET log_buffer=10485760 SCOPE=SPFILE; ALTER SYSTEM SET processes=500 SCOPE=SPFILE; ALTER S...

Oracle 11g grid control:Weblogic 10.3.2 Installation on windows server 64 Bit Today We will learn to installaton of Weblogic installation for middleware in grid control configuration. This installation requires  JDK with suitable version to support as it will give error while configuration so be careful while choosing JDK to install. For us, We will use  Java TM  Platform, Standard Edition 6 Development Kit. You can also download it from  http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase6-419409.html#jdk-6u18-oth-JPR Check installed version. Download the Weblogic server 10.3.2 from oracle.com Do not download any other versions of Weblogic because other versions doesnt work with grid control configuration. This version is archived from oracle site .So getting this need to create "Contact US SR" to oracle to provide edelivery link to download the weblogic server. Once download finish, We wi...

Oracle 10g/11g:Install & deploy interim patch ::19148376 for bug fixes Dear User, In this post, We will apply small sized interim patch for bug fixes that affect the business. This interim patch specially developed for specific operating system level. This interim patch doesn't affect any major release or update the software  binaries. Its developed to fix the particular ORA errors comes in production to affect the problems. This patch can be deployed easy steps to follow. Pr-requisites. 1.   PSU Patch 11.2.0.4.0 AIX64(any other OS) Bit database software 2.   Free space of around 20 GB for taking oracle binary Backup and installing Patch sets during patching 3.   Take TAR Backup of the ORACLE_HOME post DATABASE stop 4.   Root, Grid, Oracle OS user password 5.   OPatch utility version 11.2.0.4.0 or later 6.   Hot/Cold backup of database.    1.Check the running database. [oracl...