New Features In Oracle Enterprise Manager Cloud Control 1. This section describes new features and enhancements for database management. Database System Discovery Enhancements. Unlike previous releases, Enterprise Manager Cloud Control can detect databases in a data center even before the Management Agent is deployed on the host. Enterprise Manager Cloud Control can detect the presence of the database by using an agentless nmap technology. This is then integrated with the database target promotion process to perform deep and automated agent based discovery. Willi, A most excellent piece of documentation. I wish I had seen this prior to just completing my landscapes 7. Oracle patch tracking patch management. Oracle Database Tips by Donald BurlesonJanuary 16, 2015. Solve your Oracle errors quickly and easily with this list of advice from Oracle experts on common error messages. Hi All,We upgrading our oracle database fromHi All,We are planning to upgrade oracle version 10. Oracle patch set 10. As part of post upgrade steps I. The target promotion also includes the deployment of target specific monitoring templates, such as the ones for test and production databases. The result of the discovery process is a database system that includes associated targets and applications. Configuration Management Enhancements. Enterprise Manager Cloud Control provides a set of features to manage database configurations and underlying infrastructure. This includes the ability to perform configuration searches, detect configuration drifts, and track configuration history. Configuration Search uses the underlying data and dependency mappings to find databases among thousands of databases. For example, it can find databases that are part of Exadata but missing a particular patch. Configuration comparison functionality has been enhanced with new capabilities such as template support, system level comparison, comparison scheduling, and change notification. You can also ignore certain configuration differences. You can easily save output of a comparison and exported in plain text or CSV formats. Configuration Compliance. IhMPcK4opA/TYrz-p2EwnI/AAAAAAAAAQ0/nQT5YrkQh4c/s1600/upgrade9.png' alt='Oracle 10G Patch Upgrade Steps' title='Oracle 10G Patch Upgrade Steps' />Enterprise Manager Cloud Control can detect whether a database is compliant with Oracles or the data centers own best practices. It includes a compliance framework which enables administrators to define rules and roll them up into compliance standards for better visibility. Rules can be created to detect changes from certain values or to detect real time changes. Database System and Associations. N5Pme37Ez98/UrgDlc58DHI/AAAAAAAAAhg/WNIVhC95Tzk/s1600/8.jpg' alt='Oracle 10G Patch Upgrade Steps' title='Oracle 10G Patch Upgrade Steps' />A Database System is automatically created on discovery of an Oracle Database. The system is built on the new target and association model that can be used to monitor the databases storage, connectivity, and high availability. This also enables you to monitor and manage applications that are dependent on the database. Database System topology can be used to view relationship between various entities within the database system as well as external dependencies. Database Patching and Upgrade. Enterprise Manager Cloud Control enables administrators to patch and upgrade multiple databases in mass scale. The patch management capability includes proactive patch advisories and patch plans for deploying many interim patches to multiple databases under one single downtime period. Enterprise Manager Cloud Control also supports out of place patching which enables administrators to create a copy of the patched version and move database instances when a downtime can be afforded. Implementing Data Guard Standby General Concepts Components, Roles, Interfaces Architecture Data Guard Protection Modes Physical Standby Implementation with. Overview. Oracle Clusterware 10g, formerly known as Cluster Ready Services CRS is software that when installed on servers running the same operating system. Start the database and r un the PostUpgrade Status Tool ORACLEHOMErdbmsadminutlu112s. Similarly, Enterprise Manager Cloud Control automates the application of major upgrades to the database environments. Integration with My Oracle Support enables administrators to ensure that current patch levels are being maintained in the new release, before the databases are upgraded. Both patching and upgrade features leverage the already collected information to perform extensive pre requisite checks such as conflicts so that the process is seamless and error free. Simplified EM CLI verbs for Deployment Procedures. This release simplifies existing EM CLI verbs and includes new verbs that enable system administrators to execute and track Deployment Procedures in a scripted manner. Oracle 10G Patch Upgrade Steps' title='Oracle 10G Patch Upgrade Steps' />Performance Diagnostics Enhancements. Oracle Enterprise Manager Cloud Control 1. Active Session History ASH Analytics, a new tool to explore ASH data that enables the administrator to roll up, drill down, and slice or dice performance data across various performance dimensions. Using ASH Analytics the database administrator can explore the different performance attributes of a database session at any point in time. With the ability to create filters on various dimensions, the database administrator DBA can not only identify performance issues but also get a good understanding of various performance patterns and resource usage of the system. Oracle 10G Patch Upgrade Steps' title='Oracle 10G Patch Upgrade Steps' />Real Time Automatic Database Diagnostics Monitor ADDM provides an innovative way to analyze problems in extremely slow or hung databases, which would have traditionally required a database restart. Real Time ADDM can help resolve issues such as deadlocks, hangs, shared pool contentions, and many other exception situations without resorting to a restart of the database. Real Time ADDM uses two different types of connection modes to connect to the target instance. The normal JDBC connection is intended to perform extensive performance analysis when some connectivity is available. The diagnostic mode which makes a latch less connection is useful for extreme hang situations when normal connection is not possible. Zero Data Loss Recovery Appliance Plug in 1. Features. Zero Data Loss Recovery Appliance is a ground breaking data protection solution that is completely integrated with Oracle Database and easily protects all databases in the data center with a massively cloud scaled architecture. Enterprise Manager for Zero Data Loss Recovery Appliance provides comprehensive management and monitoring of Recovery Appliance operations, enabling complete control of the data protection lifecycle. Database Plug in 1. Features. 2. 7. 9. Oracle Real Applications Clusters Management Enhancements. Enterprise Manager Cloud Control can be used to monitor and manage Oracle Real Applications Clusters RAC One Node databases. RAC One Node has the same rich monitoring capabilities as a regular RAC databases. You can perform Online Database Relocation of RAC One Node using Enterprise Manager. Additionally, fail over or relocation of RAC One Node database instances is now automatically handled by Enterprise Manager. Enterprise Manager Cloud Control can be used to manage Quality of Service Qo. S Management functionality provided in Oracle Clusterware release 1. You can create and edit policy sets, review or implement recommendations, and monitor Qo. S metrics. 2. 7. 9. Manage Automatic Storage Management Clusters as a Target. You can now monitor and manage clustered Automatic Storage Management ASM instances as a single clustered target. This includes discovery, monitoring, configuration, and administration operations at the cluster level. Also, shared storage resource monitoring will be performed from one master agent with a failover mechanism, resulting in higher performance and availability. Backup and Restore Enhancements. The new Group backup feature in Enterprise Manager Cloud Control provides the ability to backup multiple databases, Oracle homes, and file systems in one operation. Centrally maintained backup configurations can be created, containing uniform database and file backup settings that are applied to all of the objects in a Group backup. A Group backup can include all or a subset of the databases that are members of the group. In addition, in environments where Oracle Secure Backup is used to backup file systems to tape, the respective Oracle homes of each included database can also be included in a Group backup, as well as any other files or directories on hosts that are members of the group. Enable Oracle database to send emails via SMTP server. Hard Truck No Cd Patch. July 2. 1, 2. 01. Kirill Loifman Often in a complex enterprise Infrastructure Oracle DBAs face issues by enabling SMTP mail traffic on the databases through corporate email gateway servers. Imagine you have to provide your database applications an ability to send emails via Simple Mail Transfer Protocol SMTP protocol from Oracle database. Below I give a detail action plan to accomplish the same. My test example includes an Oracle database 1. R2 running on Linux Red. Hat 6 and a Microsoft Exchange corporate server. Oracle packages SYS. UTLSMTP and SYS. UTLTCPCheck if Oracle packages SYS. UTLSMTP and SYS. UTLTCP are available on Oracle database and you have EXECUTE grants on them. Check SMTP access of database Linux server on mail server Check whether you are able to contact the email gateway server via SMTP from the database Linux box telnet smtpserver 2. If you see blank screen or an error telnet Unable to connect to remote host Connection refused,your DB server is not recognized by the SMTP server. In this case you have to apply for mail SMTP access. Otherwise type the following commands to test sending email from Linux to your corporate email account. Sender OK. rcpt to myemailmycompany. Recipient OK. data Start mail input. SMTP and orcl DB. Apply for mail SMTP access. Contact your mail exchange admins and apply for SMTP access on your corporate smtp mail gateway server. Below is an example Please allow SMTP traffic at smtpgate. Hostname. com IP 9. Function Oracle production DB Outgoing email myappmycompany. Amount emails per month around 5. After that your mail admins will add a sender IP address to a corporate SMTP mail server to allow the sender Linux server access the SMTP server. This will enable the SMTP server sending emails on behalf of the sender your Oracle database Linux box. Note that the mail server can check if the sender email exists. If not, you can send an email from a dummy email account. Sending email from Oracle database via SMTP. Place twice in the below procedure your actual smtpserver name. Connection utlsmtp. Data varchar. 23. Connection UTLsmtp. UTLsmtp. heloobj. Connection, lt smtpserver. UTLsmtp. mailobj. Connection, fromm. UTLsmtp. rcptobj. Connection, too. UTLsmtp. Connection. Sending the header information. UTLsmtp. writedataobj. Connection, From fromm UTLtcp. CRLF. UTLsmtp. writedataobj. Connection, To too UTLtcp. CRLF. UTLsmtp. writedataobj. Connection, Subject sub UTLtcp. CRLF. UTLsmtp. writedataobj. Connection, MIME Version 1. UTLtcp. CRLF. UTLsmtp. Connection, Content Type texthtml. UTLsmtp. writedataobj. Connection, Content Transfer Encoding 8. Bit. UTLsmtp. Connection,UTLtcp. CRLF. UTLsmtp. writedataobj. Connection,UTLtcp. CRLF UTLsmtp. Connection,UTLtcp. CRLF. UTLsmtp. Connection,UTLtcp. CRLFlt span stylecolor red font family Courier New bodylt span. UTLsmtp. writedataobj. Connection,UTLtcp. CRLF UTLsmtp. Connection,UTLtcp. CRLF. UTLsmtp. Connection. UTLsmtp. Connection. WHEN UTLsmtp. OR UTLsmtp. THEN. UTLsmtp. quitobj. Connection. dbmsoutput. WHEN OTHERS THEN. UTLsmtp. quitobj. Connection. dbmsoutput. Subject,Test Body Text,2. In case of following ORA error go to step 2 and 3 ORA 2. SMTP transient error 4. Service not available. ORA 0. 65. 12 at SYS. UTLSMTP, line 2. ORA 0. SYS. UTLSMTP, line 9. ORA 0. 65. 12 at SYS. UTLSMTP, line 1. The ORA 2. SMTP transient error 4. Service not available error indicates that the problemis not with the UTLSMTP package but the fact that your database servers network configuration doesnot allow it to contact an external SMTP server. In case a following Oracle error, go to next step and enable ACL in Oracle 1. ERROR at line 1 ORA 2. SMTP transient error 4. Service not available. ORA 0. 65. 12 at SYS. UTLSMTP, line 5. ORA 0. SYS. UTLSMTP, line 1. ORA 0. 65. 12 at SYS. UTLSMTP, line 6. ORA 0. TESTMAIL, line 3. ORA 2. 42. 47 network access denied by access control list ACLORA 0. Enable access control list ACL for your network hosts on 1. The network utility family of PLSQL packages, such as UTLTCP, UTLINADDR, UTLHTTP, UTLSMTP, and UTLMAIL, allow Oracle users to make network callouts from the database using raw TCP or using higher level protocols built on raw TCP. As of Oracle 1. 1g a new package DBMSNETWORKACLADMIN allows fine grained control over network hosts access using access control lists ACL implemented by XML DB. Below I show major steps that are required to enable ACL for user SCOTT. You have to run them as SYS or SYSDBA user. Read Oracle documentation for more details. Create an ACL with one database user in Oracle database. BEGIN. DBMSNETWORKACLADMIN. CREATEACL. acl smtp gate permissions. Permissions for smtp gate. SCOTT. isgrant TRUE. Assign an ACL to one or more network hosts. BEGIN. DBMSNETWORKACLADMIN. ASSIGNACL. acl smtp gate permissions. Confirm the created ACL is correct. SELECT host, lowerport, upperport, acl. FROM   dbanetworkacls. TOCHARstartdate, DD MON YYYY HH2. MI AS startdate. TOCHARenddate, DD MON YYYY AS enddate. FROM   dbanetworkaclprivileges. So that was my action plan for providing your applications an ability to send email via SMTP protocol from an Oracle database Linux server using a real example with UTLSMTP package including ORA error handling and ACL creation on Oracle 1. Enjoyed this article Please share it with others using the social site of your choice Filed under. How to, Oracle Tags. ACL, database, email, error, Linux, ORA, Oracle, SMTP.