The error message seems quite clear. It looks like you either don't have a listener running, or it isn't running on port 1158. I suspect you've supplied the port you want em to be available on rather than the port for the listener. On Sun, Nov 16, 2014 at 11:27 AM, Mostafa Eletriby < dmarc-noreply@xxxxxxxxxxxxx> wrote: > Hello > Kindly find log file for emca , please check. > I like to ask if this drop & delay at recreate will affect database by any > means. > > Thanks > > > On Sunday, November 16, 2014 1:22 PM, Mostafa Eletriby < > dmarc-noreply@xxxxxxxxxxxxx> wrote: > > > Hello , > I had a problem at em database control & I dropped repository to re-cretae > again. > > EM recreate repository always fail, > I successfully drop the repository but couldn't create it. > I used this statement:- > > *emca -deconfig dbcontrol db -repos drop* > > > *emca -config dbcontrol db -repos recreate* > > Please advice. > Regards, > > > log file attached. > ----------------------------------------------------- > Microsoft Windows [Version 6.1.7600] > Copyright (c) 2009 Microsoft Corporation. All rights reserved. > > C:\Users\orasupport>SET ORACLE_HOSTNAME = localhost > > C:\Users\orasupport>echo %ORACLE_HOSTNAME% > %ORACLE_HOSTNAME% > > C:\Users\orasupport>SET ORACLE_UNQNAME=pidb > > C:\Users\orasupport>emca -config dbcontrol db -repos recreate > > STARTED EMCA at Nov 16, 2014 1:11:05 PM > EM Configuration Assistant, Version 11.2.0.0.2 Production > Copyright (c) 2003, 2005, Oracle. All rights reserved. > > Enter the following information: > Database SID: pidb > Listener port number: 1158 > Listener ORACLE_HOME [ D:\oradb\product\11.2.0\dbhome_1 ]: > D:\oradb\product\11.2 > .0\dbhome_1 > 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 ................ D:\oradb\product\11.2.0\dbhome_1 > > Local hostname ................ ENR-HP-PIDB-01.ENR.gov.eg > Listener ORACLE_HOME ................ D:\oradb\product\11.2.0\dbhome_1 > Listener port number ................ 1158 > Database SID ................ pidb > Email address for notifications ............... > Outgoing Mail (SMTP) server for notifications ............... > > ----------------------------------------------------------------- > ---------------------------------------------------------------------- > WARNING : While repository is dropped the database will be put in quiesce > mode. > ---------------------------------------------------------------------- > Do you wish to continue? [yes(Y)/no(N)]: yes > Nov 16, 2014 1:11:44 PM oracle.sysman.emcp.EMConfig perform > INFO: This operation is being logged at > D:\oradb\cfgtoollogs\emca\PIDB\emca_2014 > _11_16_13_11_05.log. > Nov 16, 2014 1:11:45 PM oracle.sysman.emcp.util.FileUtil backupFile > WARNING: Could not backup file > D:\oradb\product\11.2.0\dbhome_1\sysman\config\em > d.properties > Nov 16, 2014 1:11:45 PM oracle.sysman.emcp.util.FileUtil backupFile > WARNING: Could not backup file > D:\oradb\product\11.2.0\dbhome_1\sysman\config\em > oms.properties > Nov 16, 2014 1:11:45 PM oracle.sysman.emcp.util.FileUtil backupFile > WARNING: Could not backup file > D:\oradb\product\11.2.0\dbhome_1\sysman\emd\targe > ts.xml > Nov 16, 2014 1:11:46 PM oracle.sysman.emcp.ParamsManager > checkListenerStatusForD > BControl > WARNING: ORA-12541: TNS:no listener > > Nov 16, 2014 1:11:46 PM oracle.sysman.emcp.EMConfig perform > SEVERE: > > Database connection through listener failed. Fix the error and run EM > Configurat > ion Assistant again. > > Some of the possible reasons may be: > > 1) Listener port 1158 provided is incorrect. Provide the correct port. > 2) Listener is not up. Start the Listener. > 3) Database service PIDB is not registered with listener. Register the > database > service. > 4) Listener is up on physical host and ORACLE_HOSTNAME environment > variable is s > et to virtual host. Unset ORACLE_HOSTNAME environment variable. > 5) Listener is up on virtual host. Set environment variable > ORACLE_HOSTNAME=<vir > tual host>. > 6) /etc/hosts does not have correct entry for hostname. > > Refer to the log file at > D:\oradb\cfgtoollogs\emca\PIDB\emca_2014_11_16_13_11_05 > .log for more details. > Could not complete the configuration. Refer to the log file at > D:\oradb\cfgtooll > ogs\emca\PIDB\emca_2014_11_16_13_11_05.log for more details. > > C:\Users\orasupport> > > > > -- Niall Litchfield Oracle DBA http://www.orawin.info