1 2 3 Previous Next 42 Replies Latest reply on Apr 26, 2009 9:24 AM by Hussein Sawwan-Oracle Go to original post
      • 15. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
        681554
        May be emca -config dbcontrol db -repos create need specific option
        because I received this . . .

        Incorrect usage:
        oracle.sysman.emcp.EMConfigAssistant [options] [list of parameters]
        Options:
        -a :configure for an ASM database
        -b :configure for automatic backup
        -c :configure a cluster database
        -e <node> :remove a node from the cluster
        -f <file> :specify the file name that contains parameter values
        -h :help
        -m :configure EM for a central agent
        -n <node> :add a new node to the cluster
        -r :skip creation of repository schema
        -s :silent mode (no user prompts
        -x <db> :deletion of a SID or DB
        -RMI_PORT <port> :specify the RMI port for DB Control
        -JMS_PORT <port> :specify the JMS port for DB Control
        -AGENT_PORT <port> :specify the EM agent port
        -DBCONSOLE_HTTP_PORT <port> :specify the DB Control HTTP port

        The script will prompt for any required data that is not specified in a configuration file. The script always prompts for all required passwords. If you use a configuration file, the file may contain any of the following specifications, as shown, with the specified values correctly filled in:

        Parameters for single instance databases:
        HOST=<Database hostname>
        SID=<Database SID>
        PORT=<Listener port number>
        ORACLE_HOME=<Database ORACLE_HOME>
        LISTENER=<Listener name>
        HOST_USER=<Host user name for automatic backup>
        HOST_USER_PWD=<Host user password for automatic backup>
        BACKUP_HOUR=<Automatic backup hour in number>
        BACKUP_MINUTE=<Automatic backup minute in number>
        ARCHIVE_LOG=<Archive log>
        EMAIL_ADDRESS=<Email address for automatic notification>
        MAIL_SERVER_NAME=<Email gateway for automatic notification>
        ASM_OH=<ASM ORACLE_HOME>
        ASM_SID=<ASM SID>
        ASM_PORT=<ASM port>
        ASM_USER_ROLE=<ASM user role>
        ASM_USER_NAME=<ASM user name>
        ASM_USER_PWD=<ASM user password>
        EM_HOME=<Enterprise Manager ORACLE_HOME>
        DBSNMP_PWD=<Password for dbsnmp>
        SYSMAN_PWD=<Password for sysman>
        SYS_PWD=<Password for sys>

        Parameters for cluster databses:
        HOST=<Database Instance hostname>
        PORT=<Listener port number>
        LISTENER=<Listener name>
        ORACLE_HOME=<Database ORACLE_HOME>
        CLUSTER_NAME=<Cluster name>
        DB_NAME=<Database name>
        SERVICE_NAME=<Service name>
        HOST_USER=<Host user name for automatic backup>
        HOST_USER_PWD=<Host user password for automatic backup>
        BACKUP_HOUR=<Automatic backup hour in number>
        BACKUP_MINUTE=<Automatic backup minute in number>
        ARCHIVE_LOG=<Archive log>
        EMAIL_ADDRESS=<Email address for automatic notification>
        MAIL_SERVER_NAME=<Email gateway for automatic notification>
        ASM_OH=<ASM ORACLE_HOME>
        ASM_PORT=<ASM port>
        ASM_USER_ROLE=<ASM user role>
        ASM_USER_NAME=<ASM user name>
        ASM_USER_PWD=<ASM user password>
        EM_HOME=<Enterprise Manager ORACLE_HOME>
        DBSNMP_PWD=<Password for dbsnmp>
        SYSMAN_PWD=<Password for sysman>
        SYS_PWD=<Password for sys>



        I appreciate your patience . . .

        Edited by: user4520487 on Jan 26, 2009 2:05 AM
        • 16. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
          Hussein Sawwan-Oracle
          user4520487 wrote:
          May be emca -config dbcontrol db -repos create need specific option
          because I received this . . .

          Incorrect usage:
          oracle.sysman.emcp.EMConfigAssistant [options] [list of parameters]
          Same command works properly here (10gR2).

          I guess you are on 10gR1, right? If yes, run the command "$ORACLE_HOME/bin/emca" to create the DB control repository objects and configuration files.
          • 17. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
            681554
            I received the same 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).


            I think that Oracle E-Business Suite V 12.0.6 don't have by default Oracle Enterprise Manager software.
            So , May be this is the problem.
            FYI . . . Oracle Database technology stack for E-Business Suite Appliaction V 12.0.6   is   Oracle 10gR3 RDBMS 10.2.0.3

            What is your opinion?

            Edited by: user4520487 on Jan 26, 2009 3:53 AM
            • 18. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
              Hussein Sawwan-Oracle
              Database ORACLE_HOME ................ /oracle/CRP2/apps/tech_st/10.1.2
              Enterprise Manager ORACLE_HOME ................ /oracle/CRP2/apps/tech_st/10.1.2
              From the above, looks like you have sourced the application env file (NOT the database env file), and this is wrong. You need to source the env file under $RDBMS_ORACLE_HOME instead.

              This also explains why the above path points to 10.1.2, while it should point to 10.2.0 (i.e. /oracle/CRP2/db/tech_st/10.2.0).
              • 19. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                681554
                Dear , you are right . . .
                I didn't source the env file under $RDBMS_ORACLE_HOME before.


                *[root@ebsibm 10.2.0]# emca -config dbcontrol db -repos create*

                STARTED EMCA at Jan 27, 2009 9:32:57 AM
                EM Configuration Assistant, Version 10.2.0.1.0 Production
                Copyright (c) 2003, 2005, Oracle. All rights reserved.

                Enter the following information:
                Database SID: vis
                Listener port number: 1521
                Password for SYS user:
                Invalid username/password.
                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 ................ /oracle/VIS/db/tech_st/10.2.0

                Database hostname ................ ebsibm.othaim.corp.net
                Listener port number ................ 1521
                Database SID ................ vis
                Email address for notifications ...............
                Outgoing Mail (SMTP) server for notifications ...............

                -----------------------------------------------------------------
                Do you wish to continue? [yes(Y)/no(N)]: yes
                Jan 27, 2009 9:34:04 AM oracle.sysman.emcp.EMConfig perform
                INFO: This operation is being logged at /oracle/VIS/db/tech_st/10.2.0/cfgtoollogs/emca/SP2-0640: Not connected/emca_2009-01-27_09-32-57-AM.log.
                Jan 27, 2009 9:34:05 AM oracle.sysman.emcp.EMReposConfig createRepository
                INFO: Creating the EM repository (this may take a while) ...
                Jan 27, 2009 9:34:09 AM oracle.sysman.emcp.EMReposConfig invoke
                INFO: Repository successfully created
                Jan 27, 2009 9:34:10 AM oracle.sysman.emcp.EMReposConfig invoke
                SEVERE: Failed to unlock all EM-related accounts
                Jan 27, 2009 9:34:10 AM oracle.sysman.emcp.EMConfig perform
                SEVERE: Failed to unlock all EM-related accounts
                Refer to the log file at /oracle/VIS/db/tech_st/10.2.0/cfgtoollogs/emca/SP2-0640: Not connected/emca_2009-01-27_09-32-57-AM.log for more details.
                Could not complete the configuration. Refer to the log file at /oracle/VIS/db/tech_st/10.2.0/cfgtoollogs/emca/SP2-0640: Not connected/emca_2009-01-27_09-32-57-AM.log for more details.

                =================================================================
                I have 2 problems now.
                First Problem :
                I already altered sys,dbsnmp users with passwords (sys,dbsnmp)
                But when enter password for sys user like this: sys ---------------------> Give me error
                But when enter password for sys user like this: "sys" ---------------------> Success WHY ??

                Second Problem:
                The errors that appeared while running the command (log file created) emca_2009-01-27_09-32-57-AM.log
                Can i send log file to your mail?



                I appreciate your efforts . . .
                Thanks&Best regards . . .
                • 20. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                  681554
                  Dear Pravin Takpire . . Thank you for your reply

                  Do you have full installation guide for installing OEM and Agent?

                  Thanks & Best regards . . .
                  • 21. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                    Hussein Sawwan-Oracle
                    Did you create a password file? Are you able to connect as sysdba remotely?

                    Yes, you can send me the log file by email.
                    • 22. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                      Hussein Sawwan-Oracle
                      Do you have full installation guide for installing OEM and Agent?
                      Oracle Enterprise Manager 10g Release 4 (10.2) Documentation Oracle Enterprise Manager 10g Release 4 (10.2) Documentation
                      http://www.oracle.com/technology/documentation/oem.html
                      • 23. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                        681554
                        Sorry for not reply until now . . .
                        I have some work, Once i will free i will back again to you.

                        I appreciate your patience.
                        • 24. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                          681554
                          Dear,,

                          I sent log file to you .... Check your mail.

                          Thanks & Best regards . . .
                          • 25. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                            681554
                            Dear,,

                            Is log file not clear?
                            • 26. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                              Hussein Sawwan-Oracle
                              user4520487,

                              Please send it again.

                              Thanks
                              • 27. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                                681554
                                Dear,,

                                I sent log file again to you..

                                Thanks & BR,,
                                • 28. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                                  681554
                                  Dear Hussein ,,

                                  I followed the following steps and it success . . .

                                  set local=
                                  set ORACLE_HOME= oracle home
                                  set ORACLE_SID= database sid
                                  emca -config dbcontrol db -repos create

                                  Oracle Enterprise Manager is working now . . . Really , many thanks

                                  But , i can't connect by SYS user in OEM.
                                  Only , i can connect by Application user.
                                  WHY?

                                  Thanks & Best regards . . .

                                  Edited by: user4520487 on Feb 22, 2009 2:51 AM
                                  • 29. Re: By Which tool . . . . . DBA can admin E-Business Suite database ?
                                    576856
                                    Hi,

                                    Do you have password file created?

                                    if not please refer the following document

                                    http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dba.htm#ADMIN10241

                                    if you want to connect to database as sys user from remotely, you need to create password file. refere the above document.