Re: emca (database control ) re-create repository always fail
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Oracle-l Digest Users <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 16 Nov 2014 12:18:57 +0000
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
Other related posts:
