Home » RDBMS Server » Enterprise Manager » OEM is not working (11gR1,Rhel5)
OEM is not working [message #476727] Fri, 24 September 2010 16:14 Go to next message
PanamDimas
Messages: 63
Registered: April 2010
Location: Maryland . U.S.A
Member
Hello all,

I tried to start my oem managing but got the folling error.
Kindly assist if you can help guide on how to resolve it

[oracle@Eagle2 ~]$ emctl start dbconsole
OC4J Configuration issue. /home/oracle/app/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_Eagle_boomiedb not found.

Thank you.

Panam
Re: OEM is not working [message #476729 is a reply to message #476727] Fri, 24 September 2010 16:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
what clues exist within EM's log file?
icon6.gif  Re: OEM is not working [message #476768 is a reply to message #476727] Sat, 25 September 2010 16:28 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
PanamDimas wrote on Fri, 24 September 2010 17:14
...Etc...
OC4J Configuration issue. /home/oracle/app/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_Eagle_boomiedb not found.
...Etc...

Maybe you forgot to execute emca to create the EM (dbconsole) repository...
Razz
Re: OEM is not working [message #486622 is a reply to message #476727] Fri, 17 December 2010 08:08 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
PanamDimas wrote on Fri, 24 September 2010 16:14
Hello all,

I tried to start my oem managing but got the folling error.
Kindly assist if you can help guide on how to resolve it

[oracle@Eagle2 ~]$ emctl start dbconsole
OC4J Configuration issue. /home/oracle/app/product/11.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_Eagle_boomiedb not found.

Thank you.

Panam


Hi Panam,
Have you finally solved your pb (start oem)?
I have a similar problem: when I installed oracle 11gR1, a message about the configuration of oem: "fail of oem because of the following error: error of the starting of db control \oracle\cfgtoollogs\dbca\instance\emConfig.log. You can try later to configure the db with entreprise manager executing manually the script C:\Oracle\Product\11.1\db_1\bin\emca."

Someone has an idea?
Thx in advance.
Sak.
Re: OEM is not working [message #486626 is a reply to message #486622] Fri, 17 December 2010 08:14 Go to previous messageGo to next message
new2ora11g
Messages: 7
Registered: December 2010
Junior Member
i have got same problem if i try to create it manually with emca -config dbcontrol -db config it asks for ORACLE_SID and then password as soon as I enter password. It throws an error. Database instance unavailable.
Re: OEM is not working [message #486631 is a reply to message #486626] Fri, 17 December 2010 08:57 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
Hi new2ora11g,

The first error I've got with oem was during the installation of oracle 11g.
Then, I tried to configure it manually with -db config (asking for oracle_sid, user, pwd,...) but it failed.
I also tried to start the service OracleDbConsole..., it failed too and the following message displayed:
"Impossible to start the service: OracleDBConsole... on local . Error 1053: The service doesn't respond quickly to the request ..."

Any idea?
Sak.
Re: OEM is not working [message #486632 is a reply to message #486631] Fri, 17 December 2010 09:04 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Use netca and configure the database to the listener.

[Updated on: Fri, 17 December 2010 10:26] by Moderator

Report message to a moderator

Re: OEM is not working [message #486633 is a reply to message #486632] Fri, 17 December 2010 09:12 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
LKBrwn_DBA wrote on Fri, 17 December 2010 09:04

Use netca and configure the database to the listener.

This step was done before...
Other ideas?
Thx in advance.
Sak

[Updated on: Fri, 17 December 2010 10:27] by Moderator

Report message to a moderator

Re: OEM is not working [message #486634 is a reply to message #486633] Fri, 17 December 2010 09:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from following commands

lsnrctl status
lsnrctl service
sqlplus scott/tiger@<TNS_ALIAS>
Re: OEM is not working [message #486635 is a reply to message #486634] Fri, 17 December 2010 09:30 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
Here are the results:

1) C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 17-D╔C. -2010 16:
20:04

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connexion α (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUT du PROCESSUS D'ECOUTE
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Produ
ction
Date de dΘpart 17-D╔C. -2010 16:19:50
DurΘe d'activitΘ 0 jours 0 heures 0 min. 13 sec
Niveau de trace off
SΘcuritΘ ON: Local OS Authentication
SNMP OFF
Fichier de paramΦtres du processus d'Θcoute C:\Oracle\Product\11.1.0\db_1\ne
twork\admin\listener.ora
Fichier journal du processus d'Θcoute c:\oracle\diag\tnslsnr\SUPPORT
_6\listener\alert\log.xml
RΘcapitulatif d'Θcoute des points d'extrΘmitΘ...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SUPPORT_6.arve-info.loc)(PORT=1521))
)
Le processus d'Θcoute ne prend en charge aucun service
La commande a rΘussi

================================
Translation from FR to EN :
Listner doens't take into account any service
The command has succeded.
================================


2) C:\>lsnrctl service

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 17-D╔C. -2010 16:
20:30

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connexion α (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
RΘcapitulatif services...
Le service "SESAMEXDB" comporte 1 instance(s).
L'instance "sesame", statut READY, comporte 1 gestionnaire(s) pour ce service.
..
Gestionnaire(s) :
"D000" Θtabli : 0 refusΘ : 0 en cours : 0 max. : 1022 statut : ready
DISPATCHER <machine: SUPPORT_6, pid: 7796>
(ADDRESS=(PROTOCOL=tcp)(HOST=SUPPORT_6.arve-info.loc)(PORT=3879))
Le service "SESAME_XPT" comporte 1 instance(s).
L'instance "sesame", statut READY, comporte 1 gestionnaire(s) pour ce service.
..
Gestionnaire(s) :
"DEDICATED" Θtabli : 0 refusΘ : 0 statut : ready
LOCAL SERVER
Le service "sesame" comporte 1 instance(s).
L'instance "sesame", statut READY, comporte 1 gestionnaire(s) pour ce service.
..
Gestionnaire(s) :
"DEDICATED" Θtabli : 0 refusΘ : 0 statut : ready
LOCAL SERVER
La commande a rΘussi

================================
Translation from FR to EN :
The command has succeded.
================================


3) C:\>sqlplus aii/fhj@sesame

SQL*Plus: Release 11.1.0.6.0 - Production on Ven. DΘc. 17 16:27:12 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS : le processus d'Θcoute ne connaεt pas actuellement le service
demandΘ dans le descripteur de connexion


Entrez le nom utilisateur :

================================
I got the erreor ora-12514
================================

Thx in advance for your comments.
Sak.
Re: OEM is not working [message #486636 is a reply to message #486635] Fri, 17 December 2010 09:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
bcm@bcm-laptop:~$ oerr ora 12514
12514, 00000, "TNS:listener does not currently know of service requested in connect descriptor"
// *Cause:  The listener received a request to establish a connection to a
// database or other service. The connect descriptor received by the listener
// specified a service name for a service (usually a database service)
// that either has not yet dynamically registered with the listener or has
// not been statically configured for the listener.  This may be a temporary
// condition such as after the listener has started, but before the database
// instance has registered with the listener.
// *Action: 
//  - Wait a moment and try to connect a second time.
//  - Check which services are currently known by the listener by executing:
//    lsnrctl services <listener name>
//  - Check that the SERVICE_NAME parameter in the connect descriptor of the
//    net service name used specifies a service known by the listener.
//  - If an easy connect naming connect identifier was used, check that
//    the service name specified is a service known by the listener.
//  - Check for an event in the listener.log file.
bcm@bcm-laptop:~$ 

EM requires SQL*Net to be functioning; which it is not at the present.
When was last time SQL*Net worked on this system?
What changed since then?
Some sort of OS/networking mis-configuration is most likely culprit
Re: OEM is not working [message #486638 is a reply to message #486635] Fri, 17 December 2010 10:29 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
SAKOURA wrote on Fri, 17 December 2010 10:30
Here are the results:

1) C:\>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 17-D╔C. -2010 16:
20:04

... Etc ...

Le processus d'Θcoute ne prend en charge aucun service

If the above means what I think it means "Listener does not support any services" -- then the configuration may be wrong.

Use netca to fix it.
.
PS: Instances should automatically register themselves with listener. if/when they do not then the OS/networking is mis-configured.

[Updated on: Sun, 19 December 2010 11:19] by Moderator

Report message to a moderator

Re: OEM is not working [message #486946 is a reply to message #486636] Tue, 21 December 2010 06:53 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
Hi Blackswan,

I tried what you suggested and the results are (can see if something is going wrong):

=================================================
Microsoft Windows XP [version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

Z:\>c:

C:\>lsnrctl services listener

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 21-D╔C. -2010 11:
26:31

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Connexion α (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
RΘcapitulatif services...
Le service "SESAMEXDB" comporte 1 instance(s).
L'instance "sesame", statut READY, comporte 1 gestionnaire(s) pour ce service.
..
Gestionnaire(s) :
"D000" Θtabli : 0 refusΘ : 0 en cours : 0 max. : 1022 statut : ready
DISPATCHER <machine: SUPPORT_6, pid: 4612>
(ADDRESS=(PROTOCOL=tcp)(HOST=SUPPORT_6.arve-info.loc)(PORT=4486))
Le service "SESAME_XPT" comporte 1 instance(s).
L'instance "sesame", statut READY, comporte 1 gestionnaire(s) pour ce service.
..
Gestionnaire(s) :
"DEDICATED" Θtabli : 25 refusΘ : 0 statut : ready
LOCAL SERVER
Le service "sesame" comporte 1 instance(s).
L'instance "sesame", statut READY, comporte 1 gestionnaire(s) pour ce service.
..
Gestionnaire(s) :
"DEDICATED" Θtabli : 25 refusΘ : 0 statut : ready
LOCAL SERVER
La commande a rΘussi
===========================================================

I also tried to replace my pc's name and domain name by the ip (which is dynamic) in the files: Tnsnames.ora and listner.ora but same results.

As attached file, the listener.log, can u have a look on it, please?

I'm creating a new db on the same machine so I'll see if the entry: database Control... will be added on the menu: Start / All programs / Database control - Sesame !

I'll let u know !

Thx in advance for your help.
Sak.
  • Attachment: listener.log
    (Size: 378.05KB, Downloaded 1594 times)
Re: OEM is not working [message #486955 is a reply to message #486946] Tue, 21 December 2010 09:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post content of C:\Oracle\Product\11.1.0\db_1\network\admin\listener.ora

post content of sqlnet.ora file, if it exists
Re: OEM is not working [message #486956 is a reply to message #486955] Tue, 21 December 2010 09:18 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
Content of Listener.ora:
------------------------

# listener.ora Network Configuration File: C:\Oracle\Product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = SUPPORT_6.arve-info.loc)(PORT = 1521))
)
)

==================================================================

Content of sqlnet.ora:
-----------------------
# sqlnet.ora Network Configuration File: C:\Oracle\Product\11.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
Re: OEM is not working [message #486957 is a reply to message #486956] Tue, 21 December 2010 09:19 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
In the Sqlnet.ora, I replaced "NTS" by "NONE"
Re: OEM is not working [message #486958 is a reply to message #486957] Tue, 21 December 2010 09:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post content of C:\Oracle\Product\11.1.0\db_1\network\admin\tnsnames.ora
Re: OEM is not working [message #486959 is a reply to message #486958] Tue, 21 December 2010 09:30 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
content of tnsnames.ora:
------------------------
# tnsnames.ora Network Configuration File: C:\Oracle\Product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

SESAME =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SUPPORT_6.arve-info.loc)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SESAME)
)
)

// Above the alias for my new db.
// On the same file, I added, the connections to other dbs (on other servers)
// I tried to create a new db on the same pc but it failed...
Re: OEM is not working [message #486960 is a reply to message #486959] Tue, 21 December 2010 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>13-DÉC. -2010 14:59:04 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=SESAME)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.11)(PORT=3330)) * establish * SESAME * 12514

above is/was only ORA-12514 error in listener.log posted; which is from more than a week in the past???
why no more recent attempts & failures?

What is IP number for SUPPORT_6.arve-info.loc ?
Re: OEM is not working [message #487045 is a reply to message #486960] Wed, 22 December 2010 02:46 Go to previous message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
Hi Blackswan,
Right, the IP is same as SUPPORT_6.arve-info.loc.
I tried to replace the pc's name & domain by the ip but same results...
Sak.
Previous Topic: unable to connect to enterprise manager console
Next Topic: Problems with different Databases monitored by Grid Control 10.2.0.5
Goto Forum:
  


Current Time: Thu Mar 28 18:09:30 CDT 2024