This discussion is archived
1 2 3 Previous Next 42 Replies Latest reply: Apr 26, 2009 2:24 AM by Hussein Sawwan-Oracle RSS

By Which tool . . . . . DBA can admin E-Business Suite database ?

681554 Newbie
Currently Being Moderated
Dears . . .
After greeting . . .

My question is

By which tool as a DBA can admin the Database in Oracle e-Business Suite Application ?
Because i have conflict understanding between Oracle Enterprise Manager and Oracle Application Manager.
Is Oracle Enterprise Manager for DBA and Oracle Application Manager for Applications DBA . . . . . Or what exactly ???


Thanks & Best regards . . .
  • 1. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Oracle Enterprise Manager (OEM) is a system management tool that provides an integrated solution for centrally managing your heterogeneous environment. Combining a graphical console, Oracle Management Servers, Oracle Intelligent Agents, common services, and administrative tools, Enterprise Manager provides a comprehensive systems management platform for managing Oracle products.

    Oracle Enterprise Manager Console, you can perform the following tasks:

    - Administer the complete Oracle environment, including databases, iAS servers, applications, and services
    - Diagnose, modify, and tune multiple databases
    - Schedule tasks on multiple systems at varying time intervals
    - Monitor database conditions throughout the network
    - Administer multiple network nodes and services from many locations
    - Share tasks with other administrators
    -Group related targets together to facilitate administration tasks
    - Launch integrated Oracle and third-party tools
    - Customize the display of an Enterprise Manager administrator

    Oracle Enterprise Manager
    http://www.oracle.com/technology/documentation/oem.html

    Oracle Applications Manager (OAM) is used to monitor components of your Oracle Applications instance (Web Server, Forms Server, Concurrent Manager, ..etc). With OAM, you can maintain/do the following:

    - Application Services
    - Configuration - Overview
    - Forms Sessions
    - Database Status
    - Applied Patches
    - Patch Wizard
    - Workflow Manager
    - Cloning

    Oracle® Applications System Administrator’s Guide - Maintenance
    http://download-uk.oracle.com/docs/cd/B25516_14/current/acrobat/115samg.pdf

    Core Oracle DBAs do not need to have OAM installed since they do not monitor Oracle Applications. Oracle Apps DBA require to have both tools to maintain the Application (through OAM), and maintain the Database (through OEM).

    Using Enterprise Manager with Applications Manager
    http://blogs.oracle.com/stevenChan/2006/06/using_enterprise_manager_with.html
  • 2. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    The other thing to note is that OAM is specific to an Apps instance/database. There are Apps packs available for OEM that will allow you to manage some parts of all Apps instances in your site. See http://www.oracle.com/technology/products/oem/prod_focus/app_mgmt.html
    Oracle has stated that OEM is the future and that the capabilities in OAM will be migrated to OEM as time goes along.

    HTH
    Srini
  • 3. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    681554 Newbie
    Currently Being Moderated
    Really , Many many thanks  . . .
    You make me understand exactly the difference between OEM & OAM.

    But i have another question now .
    If i have Oracle E-Business Suite Application now . . .
    How can i configure or install OEM to admin the database?
    Is OEM a software will be installed?
    Is there specific OEM for each Oracle E-Business Suite version?

    Many many thanks again
  • 4. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Really , Many many thanks  . . .
    You make me understand exactly the difference between OEM & OAM.
    You're welcome!
    How can i configure or install OEM to admin the database?
    Please refer to the following notes:

    Note: 278100.1 - How To Drop, Create And Recreate DB Control In A 10g Database
    https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=278100.1

    Note: 458533.1 - How to Enable Enterprise Manager on the Oracle E-Business Suite Release 12
    https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=458533.1
    Is OEM a software will be installed?
    Not by default, you have to configure it (review the notes referenced above for more details).
    Is there specific OEM for each Oracle E-Business Suite version?
    OEM comes as part of Oracle database 10g software (please review the notes referenced above for more details).
    Many many thanks again
    You're welcome, again!
  • 5. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    681554 Newbie
    Currently Being Moderated
    Dear . . .

    Kindly , By which user can i configure or install Oracle Enterprise Manager?
    By Application user or database User?

    Thanks & Best regards . . .

    Edited by: user4520487 on Jan 25, 2009 10:04 PM
  • 6. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    OEM is a database tool, so it should be configured using the database software owner (i.e. oracle user or ora<sid> users).
  • 7. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    681554 Newbie
    Currently Being Moderated
    Thanks . .

    I will start to configure OEM but may face some problems.
    So , may be feedback to you again.
    Sorry for inconvenience.

    Best regards . . .
  • 8. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    681554 Newbie
    Currently Being Moderated
    Dear . . .

    I write this command

    emca -repos create

    STARTED EMCA at Mon Jan 26 09:06:47 AST 2009
    Enter the following information about the database to be configured
    Listener port number: *1521*
    Database SID: crp2
    Service name: crp2
    Email address for notification:
    Email gateway for notification:
    Password for dbsnmp:*dbsnmp*
    Password for sysman:*sysman*
    Password for sys:*sys*

    -----------------------------------------------------------------

    You have specified the following settings

    Database ORACLE_HOME ................ /oracle/CRP2/apps/tech_st/10.1.2
    Enterprise Manager ORACLE_HOME ................ /oracle/CRP2/apps/tech_st/10.1.2

    Database host name ................ ebs-othaim.othaim.corp.net
    Listener port number ................ 1521
    Database SID ................ crp2
    Service name ................ crp2
    Email address for notification ...............
    Email gateway for notification ...............

    -----------------------------------------------------------------
    Do you wish to continue? [yes/no]: yes
    But , i received this error.

    Exception in thread "main" java.lang.NoClassDefFoundError: oracle/sysman/emSDK/conf/InventoryLoader
    at oracle.sysman.emcp.EMConfig.getFreePorts(EMConfig.java:4260)
    at oracle.sysman.emcp.EMConfig.checkParameters(EMConfig.java:1002)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:271)
    at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:693)
    at oracle.sysman.emcp.EMConfigAssistant.performSetup(EMConfigAssistant.java:642)
    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:341)
    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:181)

    Why this?


    Thanks & Best regards . .
  • 9. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Any other error messages in the log file?
  • 10. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    150505 Explorer
    Currently Being Moderated
    Looks like your OEM Installation is not perfect. i would suggest that you install OEM on seperate node and install only agent on EBS DB node.

    regards
    Pravin
  • 11. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    681554 Newbie
    Currently Being Moderated
    There is no log file created...
    Only that error that i sent it to you.
  • 12. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    There is no log file created...
    Only that error that i sent it to you.
    Check the log file under $ORACLE_HOME/cfgtoollogs/emca/<SID> directory.
  • 13. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    681554 Newbie
    Currently Being Moderated
    Only files that under *$ORACLE_HOME/cfgtoollogs* directory are the following . . .

    cfgfw
    configToolAllCommands
    configToolAllCommands.bak
    configToolAllCommands.bak.1
    configToolAllCommands.bak.2
    configToolAllCommands.bak.3
    configToolAllCommands.bak.4
    configToolAllCommands.bak.5
    dbca
    opatch
    oui


    What this means ?

    Edited by: user4520487 on Jan 26, 2009 12:20 AM
  • 14. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Do you get the same error when you issue "emca -config dbcontrol db -repos create"?
1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points