This discussion is archived
1 2 3 Previous Next 40 Replies Latest reply: May 10, 2012 7:02 AM by 904423 Go to original post RSS
  • 30. Re: Oracle EM does not loading properly shows DATABASE Instance down
    904423 Newbie
    Currently Being Moderated
    Hi,

    Previously I have 4 services running in my services

    OracledbconsoleVESS -- it seems to be missing now

    OracleJobSchedulerVESS

    OracleOraDb11g_home1TNSListener

    OracleServiceVESS
  • 31. Re: Oracle EM does not loading properly shows DATABASE Instance down
    904423 Newbie
    Currently Being Moderated
    Hi,

    Can anyone help about the password encryption of DBSNMP why because as I run

    select username from dba_users where username='SYSMAN';

    USERNAME
    ---------------
    SYSMAN

    then,

    emca -deconfig dbcontrol db -repos drop
    STARTED EMCA at May 4, 2012 6:56:13 PM
    EM Configuration Assistant, Version 11.1.0.7.0 Production
    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:
    Database SID: VESS
    Listener port number: 1521
    Password for SYS user:
    Password for SYSMAN user:
    Password for SYSMAN user:
    Do you wish to continue? [yes(Y)/no(N)]: yes
    May 4, 2012 6:56:37 PM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_04_18_56_13.log.
    May 4, 2012 6:56:38 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
    INFO: Stopping Database Control (this may take a while) ...
    May 4, 2012 6:56:39 PM oracle.sysman.emcp.EMReposConfig stopDBMSJobs
    WARNING: Error initializing SQL connection. SQL operations cannot be performed
    May 4, 2012 6:56:39 PM oracle.sysman.emcp.EMReposConfig invoke
    WARNING: Unable to remove DBMS jobs.
    May 4, 2012 6:56:39 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
    WARNING: Error initializing SQL connection. SQL operations cannot be performed
    May 4, 2012 6:56:39 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Dropping the EM repository (this may take a while) ...
    May 4, 2012 6:56:40 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    Enterprise Manager configuration completed successfully
    FINISHED EMCA at May 4, 2012 6:56:46 PM

    After that I have tried
    emca -config dbcontrol db -repos create

    STARTED EMCA at May 4, 2012 6:58:45 PM
    EM Configuration Assistant, Version 11.1.0.7.0 Production
    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:
    Database SID: VESS
    Listener port number: 1521
    Password for SYS user:
    Password for DBSNMP user:
    Password for DBSNMP user: Invalid username/password.
    Password for DBSNMP user:
    Password for DBSNMP user: Invalid username/password.
    Password for DBSNMP user:
    Password for DBSNMP user: Invalid username/password.
    Password for DBSNMP user:

    It says repeatedly invalid since i have given DBSNMP or dbsnmp or <return> but now what to do?? please help me...
  • 32. Re: Oracle EM does not loading properly shows DATABASE Instance down
    sb92075 Guru
    Currently Being Moderated
    ALTER USER SYSMAN IDENTIFIED BY NEWPASSWORD1;
  • 33. Re: Oracle EM does not loading properly shows DATABASE Instance down
    904423 Newbie
    Currently Being Moderated
    Hi,

    As per my status of previous post my OEM doesn't started still.. Please help me.. as I have dropped and tried to create it says

    C:\Documents and Settings\SKS>emca -config dbcontrol db -repos create

    STARTED EMCA at May 7, 2012 11:15:09 AM
    EM Configuration Assistant, Version 11.1.0.7.0 Production
    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:
    Database SID: VESS
    Listener port number: 1521
    Password for SYS user:
    Password for DBSNMP user:
    Password for DBSNMP user: Invalid username/password.
    Password for DBSNMP user:
    Password for DBSNMP user: Invalid username/password.
    oracle
    Password for SYSMAN user:
    Password for SYSMAN user: Email address for notifications (optional): sagoks.3@gmail.com
    Outgoing Mail (SMTP) server for notifications (optional):
    -----------------------------------------------------------------

    You have specified the following settings

    Database ORACLE_HOME ................ C:\app\SKS\product\11.1.0\db_1

    Local hostname ................ computer
    Listener port number ................ 1521
    Database SID ................ VESS
    Email address for notifications ............... sagoks.3@gmail.com
    Outgoing Mail (SMTP) server for notifications ...............

    -----------------------------------------------------------------
    Do you wish to continue? [yes(Y)/no(N)]: yes
    May 7, 2012 11:16:18 AM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_07_11_15_09.log.
    May 7, 2012 11:16:20 AM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    May 7, 2012 11:16:20 AM oracle.sysman.emcp.EMReposConfig invoke
    SEVERE: Error creating the repository
    May 7, 2012 11:16:20 AM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_repos_create_<date>.log for more details.
    May 7, 2012 11:16:20 AM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error creating the repository
    Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_07_11_15_09.log for more details.
    Could not complete the configuration. Refer to the log file at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_07_
    11_15_09.log for more details.

    and log file says

    http://oraclekarthik.blogspot.in/2012/05/emca20120507111509.html

    Please help me struggling a lot for a week..

    Thanks in advance...
  • 34. Re: Oracle EM does not loading properly shows DATABASE Instance down
    904423 Newbie
    Currently Being Moderated
    Hi,

    Since i have followed the steps and i have dropped the repos and tried to create but no use.... and now I have lost my link which is present in

    start-> Programs-> Oracle - OracleDB11g_home1-> Database control - vess (http://computer:1158/em) -- I have lost this also now...

    I have to regain with EM please legends help me..

    Karthik..
  • 35. Re: Oracle EM does not loading properly shows DATABASE Instance down
    Fran Guru
    Currently Being Moderated
    use: emctl status dbconsole and you will see the link
  • 36. Re: Oracle EM does not loading properly shows DATABASE Instance down
    904423 Newbie
    Currently Being Moderated
    Hi Fran,

    Sorry its showing
    OC4J Configuration issue. C:\app\SKS\product\11.1.0\db_1/oc4j/j2ee/OC4J_DBConsole_computer_VESS not found.

    Please help me to recreate or what to do...Struggling a lot as a beginner DBA
    Karthik..
  • 37. Re: Oracle EM does not loading properly shows DATABASE Instance down
    Fran Guru
    Currently Being Moderated
    check if oracle_sid, oracle_home and oracle_unqname are set.

    another trick is rename "C:\app\SKS\product\11.1.0\db_1/oc4j/j2ee/OC4J_DBConsole_XXXXXXX" into "C:\app\SKS\product\11.1.0\db_1/oc4j/j2ee/OC4J_DBConsole_computer_VESS"
    then go to your services from control panel and RESTART your service dbconsole again.
  • 38. Re: Oracle EM does not loading properly shows DATABASE Instance down
    880461 Newbie
    Currently Being Moderated
    Hi ,

    You can use DBCA to configure your OEM by selecting "Configure database options".
    To answer to your original question, you should have checked the host file in C:\Windows\System32\drivers\etc\ folder for proper machine name and ip address.
    on which database and oem is configured

    Regards,
    Imran
  • 39. Re: Oracle EM does not loading properly shows DATABASE Instance down
    904423 Newbie
    Currently Being Moderated
    Hi,

    I have tried through DBCA but it shows an error

    Failed to unlock all EM-related accounts
  • 40. Re: Oracle EM does not loading properly shows DATABASE Instance down
    904423 Newbie
    Currently Being Moderated
    Hi please help me

    C:\Documents and Settings\SKS>emca -config dbcontrol db -repos create

    STARTED EMCA at May 10, 2012 1:47:51 PM
    EM Configuration Assistant, Version 11.1.0.7.0 Production
    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:
    Database SID: vess
    Listener port number: 1521
    Password for SYS user:
    Password for DBSNMP user:
    Password for SYSMAN 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 ................ C:\app\SKS\product\11.1.0\db_1

    Local hostname ................ computer
    Listener port number ................ 1521
    Database SID ................ vess
    Email address for notifications ...............
    Outgoing Mail (SMTP) server for notifications ...............

    -----------------------------------------------------------------
    Do you wish to continue? [yes(Y)/no(N)]: y
    May 10, 2012 1:48:08 PM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at C:\app\SKS\cfgtoollogs\emca\vess\emca_2012_05_10_13_47_51.log
    May 10, 2012 1:48:10 PM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    May 10, 2012 1:58:05 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully created

    and it shows created but for a long time the cursor blinks for nearly 7hours... I dont know what to do now...

    Please help legends..
1 2 3 Previous Next

Legend

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