So I missed a lot of filegroup
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.