Sunday, July 25, 2010

listener not registered dbca dbconsole 11g filegroup12.jar missing CompEMdbconsole.pm not found

I made a mistake, file win32_11gR2_database_2of2.zip was not extracted correctly I think.
So I missed a lot of filegroup.jar which was reported during the installation...;-)

So not noting this, I tried to create a database with dbca, all went ok except the dbconsole went wrong.
The errors I received where misleading :
1. Listener is not up or database service is not registered
2. CompEMdbconsole.pm not found.

By extracting the win32_11gR2_database_2of2.zip . Create a new database.
Configured with netca a listener2 on port 1526.
sqlplus / as sysdba
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101
)(PORT=1526))'
SQL> /

Then I run PLEASE NOTE THE USE OF paramname oracle_hostname:
D:\app\Gebruiker\product\11.2.0\dbhome_2>emca -config dbcontrol db -paramname or
acle_hostname:localhost

STARTED EMCA at 25-jul-2010 13:25:22
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: demo
Listener port number: 1526
Listener ORACLE_HOME [ D:\app\Gebruiker\product\11.2.0\dbhome_2 ]:
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:\app\Gebruiker\product\11.2.0\dbhome_2

Local hostname ................ 192.168.1.101
Listener ORACLE_HOME ................ D:\app\Gebruiker\product\11.2.0\dbhome_2
Listener port number ................ 1526
Database SID ................ demo
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
25-jul-2010 13:25:44 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\app\Gebruiker\cfgtoollogs\emca\demo\e
mca_2010_07_25_13_25_21.log.
25-jul-2010 13:25:52 oracle.sysman.emcp.EMReposConfig uploadConfigDataToReposito
ry
INFO: Uploading configuration data to EM repository (this may take a while) ...
25-jul-2010 13:30:20 oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
25-jul-2010 13:30:31 oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
25-jul-2010 13:30:31 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
25-jul-2010 13:32:01 oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
25-jul-2010 13:32:01 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
25-jul-2010 13:32:18 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
25-jul-2010 13:32:18 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
25-jul-2010 13:34:07 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
25-jul-2010 13:34:08 oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://192.168.1.101:1158/em <<<<
<<<<<<<
25-jul-2010 13:34:14 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: D:/app/
Gebruiker/product/11.2.0/dbhome_2/192.168.1.101_demo/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 25-jul-2010 13:34:15

And now I can use dbconsole and prepare for the OCP exam.

2 comments:

Gustavo said...

Gracias.
Tu explicación fue muy útil para mi. Esto resolvió mi problema.

Anonymous said...

Nice fill someone in on and this enter helped me alot in my college assignement. Thank you seeking your information.