OEM installation on oracle 11g database
1)emctl start dbconsole
[oracle@sakthi admin]$ emctl start dbconsoleThe following exception occurred:
java.net.UnknownHostException: ol6-112.localdomain: ol6-112.localdomain
at java.net.InetAddress.getAllByName0(InetAddress.java:1174)
at java.net.InetAddress.getAllByName(InetAddress.java:1101)
at java.net.InetAddress.getAllByName(InetAddress.java:1037)
at java.net.InetAddress.getByName(InetAddress.java:987)
at oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller.getLocalHost(AgentTargetInstaller.java:4289)
at oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller.printLocalHost(AgentTargetInstaller.java:4252)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at oracle.sysman.emd.targetIntg.Util$DefaultIntegrationMethod.execute(Util.java:598)
at oracle.sysman.emd.targetIntg.TargetInstaller.execute_(TargetInstaller.java:167)
at oracle.sysman.emd.targetIntg.TargetInstaller.execute(TargetInstaller.java:155)
at oracle.sysman.emSDK.conf.TargetInstaller.printLocalHost(TargetInstaller.java:2364)
at oracle.sysman.emSDK.conf.TargetInstaller.main(TargetInstaller.java:3290)
Although there was an exception it might be possible for the program to continue.
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_ol6-112.localdomain_DB11G not found.
When I run the command emctl start dbconsole I got the above error and to fix this I set the environmental file for the database and the I run the env file and I gave the following command
- emca -config dbcontrol db -repos recreate
STARTED EMCA at Jan 3, 2019 2:59:48 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: Prod
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/db_1 ]: /u01/app/oracle/product/11.2.0/db_1/network/admin
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
—————————————————————–
You have specified the following settings
Database ORACLE_HOME ……………. /u01/app/oracle/product/11.2.0/db_1
Local hostname ……………. sakthi.doyensys
Listener ORACLE_HOME ……………. /u01/app/oracle/product/11.2.0/db_1/network/admin
Listener port number ……………. 1521
Database SID ……………. Prod
Email address for notifications ……………
Outgoing Mail (SMTP) server for notifications ……………
—————————————————————–
———————————————————————-
WARNING : While repository is dropped the database will be put in quiesce mode.
———————————————————————-
Do you wish to continue? [yes(Y)/no(N)]: y
Jan 3, 2019 3:00:29 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/Prod/emca_2019_01_03_02_59_47.log.
Jan 3, 2019 3:00:30 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) …
Jan 3, 2019 3:06:50 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jan 3, 2019 3:06:51 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) …
Jan 3, 2019 3:18:44 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jan 3, 2019 3:18:58 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) …
Jan 3, 2019 3:20:19 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jan 3, 2019 3:20:21 AM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for sakthi.doyensys
Jan 3, 2019 3:20:26 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) …
Jan 3, 2019 3:20:53 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jan 3, 2019 3:20:53 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) …
Jan 3, 2019 3:25:40 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jan 3, 2019 3:25:41 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://sakthi.doyensys:1158/em <<<<<<<<<<<
Jan 3, 2019 3:26:44 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************
Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/db_1/sakthi.doyensys_Prod/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.
***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jan 3, 2019 3:26:44 AM
I recreated the repository to fix the ocjconfiguration error and I gave the command emctl start dbconsole
[oracle@sakthi ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
https://sakthi.doyensys:1158/em/console/aboutApplication
– An instance of Oracle Enterprise Manager 11g Database Control is already running.
I received the url to monitor my database in oem
We can login as a sys user or we provide sysdba previlage to the normal user and we can login
There are performance, availability severs and schemas where we can create user, create tables, creating tablespaces
We can view our tables in gui mode by providing the schema and table name in the schema
Posted by:Sakthi Sethu Perumal S
