Life with Oracle

 In the world of oracle database, most of the DBA'S concentrate on Migration, Upgradation, replication and other database activities. Today, we will learn a new concept called Access Control List (ACL) which configures rules/regulation for database users to connect to external networks. Access Control List(ACL) is a fine-grained security mechanism. It is a list of access control entries to restrict the hosts that are allowed to connect to the Oracle database . From 11G, all external network access is blocked by default and can be enabled through Access Control List(ACL). High Level Steps in Configuring ACL --Create ACL --Assign Network access to ACL --Add Users to the ACL --Validate the ACL's which are created High Level steps for ACL Deconfiguration --Unassign network from ACL's Following are the steps for Create ACLs for public or HR schema: Create the ACL BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl => 'hr_utl_http.xml', description => 'Allow mail'...

 When deciding to configure Oracle Enterprise Manager with custom or third-party SSL certificates,  you usually need to complete configuration tasks with following EM components   *  EM Cloud Control Console   *  Oracle Management Service (OMS) and EM Agent   *  WebLogic Server (WLS) Oracle Enterperise Manager Cloud control console overview: Is a web based Enterprise manger cloud console is a rich interface that provides you customizable feature for monitoring and managing wide variety of targets witnin your Enterprise. Oracle Management Agent (Management Agent) is one of the core components of Enterprise Manager Cloud Control that enables you to convert an unmanaged host to a managed host in the Enterprise Manager system. The Management Agent works in conjunction with the plug-ins to monitor the targets running on that managed host. Therefore, at any point in time, if you want to monitor a target running on a host, ensure that you first convert t...

Data Replication techniques has gained importance in the market with the need of maintaing production data in other databases like Postgre, Mysql etc.. to avoid heavy license fee charged by top rdbms providers like Oracle, Sql Server .Goldengate is one of the most famous and popular software which can be used for data replication between homogenous and hetrogenous databases.  GoldenGate supports two types of architectures : Classic Architecture Microservice Architecture CLASSIC ARCHITECTURE It is first architecture supported by the Goldengate when it was introduced 20 years ago. Goldengate Classic architecture drawn many advantages in the market when customers are facing problems when replicating data between heterogenous databases. Classic Architecture has below components: Manager - Is the master process running in the Goldengate which takes care of all other slave                 process like Extract, Datapump, Replicat and Collector....