top of page
Search
maybelricolchete

Enterprise Manager Oracle 11g: How to Use the Database Control Console



Installing the oracle-validated RPM installs RPMs required for an Oracle installation as well as creates the operating system user oracle. The lesson uses operating system user oracle to install all the software.


Oracle Base: /u01/app/oracle/database Software location: /u01/app/oracle/database/11.2.0/dbhome_1 Storage Type: File System Database file location: /u01/app/oracle/database/oradata Database Edition: Enterprise Edition OSDBA Group: dba Global database name: emrep.example.com Administrative password:




enterprise manager oracle 11g



sqlplus /nolog connect / as sysdba alter system set session_cached_cursors=200 scope=spfile; alter system set log_buffer=10485760 scope=spfile; alter system set processes=500 scope=spfile; alter database datafile '/u01/app/oracle/database/oradata/emrep/undotbs01.dbf' resize 250M; shutdown immediate startup exit


Thank you Osama Mustafa Share this:Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Like this:Like Loading...RelatedTagged 11g, Alter, blog, change, db control, dbconsole, dbcontrol, emctl, enterprise manager, oracle, Osama mustafa, password, sql, sysman, unix, windowsPublished by Osama MustafaOsama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers.In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases.Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.View all posts by Osama Mustafa


Within the MBean Browser, if you navigate to Application Defined MBeans > oracle.biee.admin, you'll see the list of MBeans that are used by Enterprise Manager, and utilities like the Config.bat configuration tool that runs after the Universal Installer and creates, or extends, an Oracle BI Domain.


When you press this button, Enterprise Manager calls the lock method provided by the oracle.biee.admin:type=BIDomain,group=Service MBean, to lock the configuration of the Oracle BI Domain. This exclusive lock prevents any other administrator from trying to make other configuration changes, and is held until either you press the Release Configuration button (equivalent to the rollback method from the same MBean, or you press the Activate button.


So what's gone on in the background to make this happen? When you press the Apply button, another MBean method gets called; this time, the uploadRepository method from the oracle.biee.admin:type=BIDomain.BIInstance.ServerConfiguration,biInstance=coreapplication, group=Service MBean.


When you call then method, it reads the value of the DataZipFileVersion attribute within the oracle.biee.local:Location=bi_server1,type=DomainConfigProxy,group=Config MBean, and increments it by one, to get the sequence number it appends to the RPD file name.


Pressing this button calls the commit method within the oracle.biee.admin:type=BIDomain,group=Service MBean (the same one that provided the lock method). This method takes a parameter that requires a literal (such as ERROR) to specify the error threshold for the operation.


At this point, if you return to Enterprise Manager, you'll see that the Activate Changes button has changed back to Lock and Edit Configuration, but there's now a Restart to apply recent changes message instead. This is because the RestartNeeded attribute value in the oracle.biee.admin:type=BIDomain,group=Service MBean has now been set to True.


In Enterprise Manager, you'd clear this message (and restart the BI Server, to pick up the configuration changes in the NQSConfig.INI file) by either navigating to the Overview page and selecting Restart, or navigating to the Capacity Management > Availability tab, selecting the BI Servers row, and pressing Restart Selected. Only a full restart of all system components will clear this message though, and this is carried out using another MBean, this time oracle.as.management.mbeans.opmn:Location=AdminServer,name=instance1,type=opmn which has methods for stopping, starting, restarting or showing the status of all, part or single system components.


In the newer versions of Oracle database, specially which are based on multi-tenant architecture, the oracle engine differentiates between login from a CDB and a PDB through the port number which we use in the URL of the oracle enterprise manager.


Micro FocusThe Operations Connector for Zenoss integrates event, topology and metrics data from the Zenoss domain manager to Operations Bridge Manager. 186 FREE Micro Focus OperationsConnector for ZabbixMicro FocusThe Operations Connector for Zabbix integrates event, topology & metrics data from Zabbix domain manager to Operations Bridge Manager. 1,037 Micro Focus Operations Bridge Integration for DatadogMicro FocusThe Operations Bridge Integration for Datadog integrates event, topology & metrics data from Datadog domain manager to Operations Bridge Manager. 113 Micro Focus Operations Bridge Integration for AppDynamicsMicro FocusThe Operations Bridge Integration for AppDynamics integrates event, topology & metrics data from AppDynamics domain manager to Operations Bridge Manager. 392 Micro Focus Operations Bridge Integration for Splunk EnterpriseMicro FocusThe Operations Bridge Integration for Splunk Enterprise integrates event data from Splunk Enterprise domain manager to Operations Bridge Manager. 99 Micro Focus Operations Bridge Integration for NewRelicMicro FocusThe Operations Bridge Integration for NewRelic APM integrates event, topology & metrics data from NewRelic domain manager to Operations Bridge Manager. 92 FREE Micro Focus OperationsConnector for CA SpectrumMicro FocusThe Operations Connector for CA Spectrum integrates event and topology data from the CA Spectrum domain manager to the Operations Bridge Manager (OBM). 378 Micro Focus Operations Bridge Integration for Splunk SignalFxMicro FocusThe Operations Bridge Integration for Splunk SignalFx integrates event data from Splunk SignalFx domain manager to Operations Bridge Manager. 25 FREE Micro Focus OperationsConnector for IBM TivoliMicro FocusThe Operations Connector for IBM Tivoli integrates event, topology & metrics data from IBM Tivoli to Operations Bridge.Manager 675 Releases Release Size Date Operations Connector for Oracle Enterprise Manager 2020.08 293.7 MB Aug 28, 2020 More info Less info Download Product compatibility Operations Bridge Manager (OBM ex OMi) Version 2019.11 Version 2020.05 2020.10 Release notes Note: Corrected the Version of Content pack to 2020.08.


iSQL*Plus HTTP port number =5560 Enterprise Manager Console HTTP Port (oracle) = 1158 Enterprise Manager Agent Port (oracle) = 3938 If this is the case, your URL should be: :1158/em/ Note (8/2/2011): Oracle changed the above access to HTTPS on Oracle 11g. Thus, if you installed Oracle 11g, your access URL will be: :1158/em/ I kept above details just in case students use different versions of the database.


The templates for Oracle Enterprise Manager and JRF components are provided in the "MW_HOME/oracle_common" directory. This directory and its contents, however, are not put in place by the install of Oracle Weblogic Server. The "oracle_common" directory can only be created by installing one of the other Oracle Middleware 11g media types such as:


If you do not wish or have no requirement to install the binaries for these install types, then you can create the "oracle_common" directory and its contents by using the installer for Oracle Middleware 11g "Application Developer" - also known as Oracle Application Development Framework ( ADF ). The ORACLE_HOME created by an install of ADF is "MW_HOME/oracle_common"


Next, we are going to create 2 scripts under /home/oracle/scripts: ora_start.sh and ora_stop.sh. These scripts will call dbstart and dbshut and will also allow us to add some more actions, for example the start of the Enterprise Manager database control or any other services you might have.


First we set the shell to read the settings stored in the .bashrc system profile of the oracle user including variables such as ORACLE_HOSTNAME, ORACLE_BASE, PATH etc. that are needed for Oracle components to run properly. After the bash settings of the oracle user are applied to the current shell session, the next command is executed to start Oracle database. 2ff7e9595c


0 views0 comments

Recent Posts

See All

Commentaires


bottom of page