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

    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 Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated
  • 25. Re: emca -repos create causes instance unavailable error
    Allie_Jane Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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

Legend

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