1 2 3 Previous Next 31 Replies Latest reply: Oct 9, 2013 5:34 AM by Allie_Jane Go to original post RSS
      • 15. Re: emca -repos create causes instance unavailable error
        sb92075

        7fbb02c8-9d05-40ac-ac85-e1cf2b4dcc14 wrote:

         

        I've tried to run the dbca app from command line but nothing happens - at first it said

         

        oracle@chalf002:/opt/oracle/diag/rdbms/alf/alf> dbca

        DISPLAY not set.

        so I ran

        oracle@chalf002:/opt/oracle/diag/rdbms/alf/alf> export DISPLAY=:0

        Though not sure if that is the correct entry (I'm not a Linux person really)

         

        Then when I ran dbca it didn't error but nothing happened.

         

        Any ideas?

        X-windows does not work  after su

        You need to log onto the OS directly as OS user oracle

        • 16. Re: emca -repos create causes instance unavailable error
          Allie_Jane

          Can I ask why you thing dbca would run when emca doesn't? I would have thought that the enterprise manager part of dbca would just run emca in the background anyway?

          I'll try it as soon as I get access to the oracle password.

          • 18. Re: emca -repos create causes instance unavailable error
            EdStevens

            7fbb02c8-9d05-40ac-ac85-e1cf2b4dcc14 wrote:

             

            sb92072 - I totally agree with you about root - but as I'm in a customer site I have not control over the access they grant me.

             

             

            Interesting.  They hire you to do oracle dba work for them, but won't give you the credentials to log on with the appropriate user account ... but they do give you credentials to log on as root!

             

            Wow!  I hope this isn't the financial institution that manages my retirement funds!

             

            Personally, I wouldn't even want root access.  Not having it would eliminate the possibility of being accused of doing certain things.

            • 19. Re: emca -repos create causes instance unavailable error
              Allie_Jane

              There isn't any clues in the em logfiles - this is the last few lines of the emca_date_log

               

              CONFIG: Done deleting /opt/oracle/product/11g/nes_alf/EMStagePatches_alf/15

              08-Oct-2013 10:56:53 oracle.sysman.emcp.util.FileUtil _deleteDirectory

              CONFIG: Done deleting /opt/oracle/product/11g/nes_alf/EMStagePatches_alf/41

              08-Oct-2013 10:56:53 oracle.sysman.emcp.util.FileUtil _deleteDirectory

              CONFIG: Done deleting /opt/oracle/product/11g/nes_alf/EMStagePatches_alf/63

              08-Oct-2013 10:56:53 oracle.sysman.emcp.util.FileUtil _deleteDirectory

              CONFIG: Done deleting /opt/oracle/product/11g/nes_alf/EMStagePatches_alf

              08-Oct-2013 10:56:53 oracle.sysman.emcp.EMConfig restoreOuiLoc

              CONFIG: Restoring oracle.installer.oui_loc to /opt/oracle/product/11g/nes_alf/oui

              This was me dropping the repository this morning - nothing in there about my many attempts to create it during the rest of the day. It's like it's not even getting that far.

              • 20. Re: emca -repos create causes instance unavailable error
                DK2010

                Hi,

                ORACLE_SID=alf  ORACLE_BASE=/opt/oracle 

                ORACLE_HOME=/opt/oracle/product/11g/nes_alf  _=/usr/bin/env

                is that really your Oracle Home value?

                set the proper Oracle home and restart your Db with using that home , then Try to configure Db console.

                 

                HTH

                • 21. Re: emca -repos create causes instance unavailable error
                  Allie_Jane

                  No must have been a copy / paste error

                   

                  oracle@chalf002:/opt/oracle/cfgtoollogs/emca/alf> env | grep ORACLE

                  ORACLE_UNQNAME=alf

                  ORACLE_SID=alf

                  ORACLE_BASE=/opt/oracle

                  ORACLE_HOME=/opt/oracle/product/11g/nes_alf

                  These are the correct values.

                  • 22. Re: emca -repos create causes instance unavailable error
                    DK2010

                    Hi,

                     

                    how did you drop  your Repository.

                    try this

                    $emca -repos drop

                    $ emca -deconfig dbcontrol db

                    also check for the file and remove them manually if any

                    rm -rf $ORACLE_HOME/<hostname_sid>

                    rm -rf $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>

                    Then Try to recreate  db console.

                     

                    HTH

                    • 23. Re: emca -repos create causes instance unavailable error
                      jgarry

                      I think that is a good hypothesis.  Mysteriously named original poster, try doing a find command to see if you have root-owned files left over, that the proper owner cannot overwrite:

                       

                      find /opt/oracle -user root

                      • 24. Re: emca -repos create causes instance unavailable error
                        16cb11f1-0cd6-41f2-9ccb-fd58fe7d6ed7
                        • 25. Re: emca -repos create causes instance unavailable error
                          Allie_Jane

                          Hi there,

                           

                          I ran the find command to see what files might be left over - can I get a stear on what I should do with them please.

                           

                          oracle@chalf002:/opt/oracle> find /opt/oracle -user root

                          /opt/oracle/product/11g/dbhome_1/rdbms/admin/externaljob.ora

                          /opt/oracle/product/11g/dbhome_1/bin/nmhs

                          /opt/oracle/product/11g/dbhome_1/bin/extjob

                          /opt/oracle/product/11g/dbhome_1/bin/nmo

                          /opt/oracle/product/11g/dbhome_1/bin/jssu

                          /opt/oracle/product/11g/dbhome_1/bin/oradism

                          /opt/oracle/product/11g/dbhome_1/bin/nmb

                          /opt/oracle/product/11g/nes_alf/rdbms/admin/externaljob.ora

                          /opt/oracle/product/11g/nes_alf/bin/nmhs

                          /opt/oracle/product/11g/nes_alf/bin/extjob

                          /opt/oracle/product/11g/nes_alf/bin/nmo

                          /opt/oracle/product/11g/nes_alf/bin/jssu

                          /opt/oracle/product/11g/nes_alf/bin/oradism

                          /opt/oracle/product/11g/nes_alf/bin/nmb

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_10_50_53.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_12_58_13.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_13_36_38.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_13_35_58.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_13_34_46.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_11_41_20.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_13_04_44.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_10_51_56.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_13_04_13.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_11_29_10.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_10_51_47.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_13_03_45.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_11_11_20.log

                          /opt/oracle/cfgtoollogs/emca/alf/emca_2013_10_09_09_19_29.log

                          /opt/oracle/cfgtoollogs/emca/alf/emca_2013_10_08_10_52_49.log

                          /opt/oracle/cfgtoollogs/emca/alf/emca_repos_drop_2013_10_09_09_20_04.log

                          /opt/oracle/cfgtoollogs/emca/alf/emca_repos_drop_2013_10_08_10_54_43.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_14_23_40.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_11_07_11.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_13_05_09.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_11_12_16.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_09_59_30.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_13_04_21.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_11_05_55.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_13_34_32.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_11_16_25.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_11_27_26.log

                          /opt/oracle/cfgtoollogs/emca/emca_2013_10_08_12_55_51.log

                          • 26. Re: emca -repos create causes instance unavailable error
                            Allie_Jane

                            DK2010

                             

                            That is exactly how I dropped my repo and I've checked and the directorys you suggested removing are already removed.

                             

                            Recreate still doesn't work.

                            • 27. Re: emca -repos create causes instance unavailable error
                              DK2010

                              Hi

                               

                               

                              assumning Your Database/listener is running fine

                              then

                              $unset ORACLE_UNQNAME

                               

                               

                              echo $ORACLE_HOME

                              echo $ORACLE_SID

                              -- Verify above variable

                               

                               

                              then you can try to create the repositry first and then configure db control with following command

                              $ emca -repos create  

                              $ emca -config dbcontrol db

                               

                              check the log file and update

                              • 28. Re: emca -repos create causes instance unavailable error
                                Allie_Jane

                                OK - wow that seemed to work - I've done that in the past however I did on a single command rather than breaking it up over 2.. Oh well live and learn thanks so much everyone...

                                 

                                However I now have the issue that I can't access EM via the web https://chalf002.nes.xxxx.uk:1158/em

                                 

                                I can ping the server but get 'Internet Explorer could not display the web page'

                                 

                                Any ideas..

                                 

                                C:\Users\AlisonI>ping chalf002.nes.xxxxx.uk

                                Pinging chalf002.nes.scot.nhs.uk [10.240.75.11] with 32 bytes of data:
                                Reply from 10.240.xx.11: bytes=32 time=4ms TTL=59
                                Reply from 10.240.xx.11: bytes=32 time=3ms TTL=59
                                Reply from 10.240.xx.11: bytes=32 time=3ms TTL=59
                                Reply from 10.240.xx.11: bytes=32 time=5ms TTL=59

                                Ping statistics for 10.240.xx.11:
                                    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
                                Approximate round trip times in milli-seconds:
                                    Minimum = 3ms, Maximum = 5ms, Average = 3ms

                                Database SID: alf
                                Listener port number: 1521
                                Password for SYS user:
                                Password for SYSMAN user:

                                Do you wish to continue? [yes(Y)/no(N)]: y
                                09-Oct-2013 10:16:17 oracle.sysman.emcp.EMConfig perform
                                INFO: This operation is being logged at /opt/oracle/cfgtoollogs/emca/alf/emca_20                                                                                                                                                             13_10_09_10_15_52.log.
                                09-Oct-2013 10:16:17 oracle.sysman.emcp.EMReposConfig createRepository
                                INFO: Creating the EM repository (this may take a while) ...
                                09-Oct-2013 10:21:24 oracle.sysman.emcp.EMReposConfig invoke
                                INFO: Repository successfully created
                                Enterprise Manager configuration completed successfully
                                FINISHED EMCA at 09-Oct-2013 10:21:24
                                oracle@chalf002:~> emca -config dbcontrol db

                                STARTED EMCA at 09-Oct-2013 10:24:53
                                EM Configuration Assistant, Version 11.2.0.0.2 Production
                                Copyright (c) 2003, 2005, Oracle.  All rights reserved.

                                Enter the following information:
                                Database SID: alf
                                Listener port number: 1521
                                Listener ORACLE_HOME [ /opt/oracle/product/11g/nes_alf ]:
                                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 ................ /opt/oracle/product/11g/nes_alf

                                Local hostname ................ chalf002.nes.xxxxxx.uk
                                Listener ORACLE_HOME ................ /opt/oracle/product/11g/nes_alf
                                Listener port number ................ 1521
                                Database SID ................ alf
                                Email address for notifications ...............
                                Outgoing Mail (SMTP) server for notifications ...............

                                -----------------------------------------------------------------
                                Do you wish to continue? [yes(Y)/no(N)]: y
                                09-Oct-2013 10:25:36 oracle.sysman.emcp.EMConfig perform
                                INFO: This operation is being logged at /opt/oracle/cfgtoollogs/emca/alf/emca_20                                                                                                                                                             13_10_09_10_24_53.log.
                                09-Oct-2013 10:25:39 oracle.sysman.emcp.EMReposConfig uploadConfigDataToReposito                                                                                                                                                             ry
                                INFO: Uploading configuration data to EM repository (this may take a while) ...
                                09-Oct-2013 10:26:26 oracle.sysman.emcp.EMReposConfig invoke
                                INFO: Uploaded configuration data successfully
                                09-Oct-2013 10:26:28 oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
                                INFO: Software library configured successfully.
                                09-Oct-2013 10:26:28 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
                                INFO: Deploying Provisioning archives ...
                                09-Oct-2013 10:26:53 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
                                INFO: Provisioning archives deployed successfully.
                                09-Oct-2013 10:26:53 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
                                INFO: Securing Database Control (this may take a while) ...
                                09-Oct-2013 10:27:35 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
                                INFO: Database Control secured successfully.
                                09-Oct-2013 10:27:35 oracle.sysman.emcp.util.DBControlUtil startOMS
                                INFO: Starting Database Control (this may take a while) ...
                                09-Oct-2013 10:28:31 oracle.sysman.emcp.EMDBPostConfig performConfiguration
                                INFO: Database Control started successfully
                                09-Oct-2013 10:28:31 oracle.sysman.emcp.EMDBPostConfig performConfiguration
                                INFO: >>>>>>>>>>> The Database Control URL is https://chalf002.nes.xxxx.uk:1158/em <<<<<<<<<<<
                                09-Oct-2013 10:28:33 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: /opt/or                                                                                                                                                             acle/product/11g/nes_alf/chalf002.nes.xxxxxxx.uk_alf/sysman/config/emkey.ora.                                                                                                                                                                Please 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 09-Oct-2013 10:28:33

                                • 29. Re: emca -repos create causes instance unavailable error
                                  Allie_Jane

                                  Both the agent and dbconsole are up and running

                                   

                                  oracle@chalf002:~> emctl status agent

                                  Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

                                  Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.

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

                                  Agent Version     : 10.2.0.4.2

                                  OMS Version       : 10.2.0.4.2

                                  Protocol Version  : 10.2.0.4.2

                                  Agent Home        : /opt/oracle/product/11g/nes_alf/chalf002.nes.xxxx

                                   

                                  .uk_alf

                                  Agent binaries    : /opt/oracle/product/11g/nes_alf

                                  Agent Process ID  : 2731

                                  Parent Process ID : 2708

                                  Agent URL         : https://chalf002.nes.xxxxhttps://chalf002.nes.xxxx.uk:3938/emd/main.uk:3938/emd/main

                                  Repository URL    : https://chalf002.nes.xxxx.uk:1158/em/upload/

                                  Started at        : 2013-10-09 11:11:29

                                  Started by user   : oracle

                                  Last Reload       : 2013-10-09 11:11:29

                                  Last successful upload                       : 2013-10-09 11:12:29

                                  Total Megabytes of XML files uploaded so far :     1.56

                                  Number of XML files pending upload           :        0

                                  Size of XML files pending upload(MB)         :     0.00

                                  Available disk space on upload filesystem    :    36.57%

                                  Data channel upload directory                : /opt/oracle/product/11g/nes_alf/chalf002.nes.xxxx.uk_alf/sysman/recv

                                  Last successful heartbeat to OMS             : 2013-10-09 11:15:02

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

                                  Agent is Running and Ready

                                  oracle@chalf002:~> emctl status dbconsole

                                  Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

                                  Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.

                                  https://chalf002.nes.xxxx.uk:1158/em/console/aboutApplication

                                  Oracle Enterprise Manager 11g is running.

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

                                  Logs are generated in directory /opt/oracle/product/11g/nes_alf/chalf002.nes.xxxx.uk_alf/sysman/log