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.

Saturday, July 24, 2010

DIA-49424 and perl not found

adrci> show home
ADR Homes:
diag\rdbms\dik\dik
adrci> ips add file diag\rdbms\dik\dik\trace\dik_dbrm_1260.trc package 4
DIA-49424: Directory outside ADR not allowed
adrci> ips add file \trace\dik_dbrm_1260.trc package 4
DIA-49424: Directory outside ADR not allowed
adrci> ips add file /trace/dik_dbrm_1260.trc package 4
Added file /trace/dik_dbrm_1260.trc to package 4

adrci> ips generate package 4 ;
perl wordt niet herkend als een interne
of externe opdracht, programma of batchbestand.
perl wordt niet herkend als een interne
of externe opdracht, programma of batchbestand.
Generated package 4 in file C:\Users\Gebruiker\ORA4031_20100724214430_COM_1.zip,
mode complete
adrci> exit

D:\>set path=%PATH%;D:\app\Gebruiker\product\11.2.0\dbhome_1\perl\bin

D:\>perl -v

This is perl, v5.10.0 built for MSWin32-x86-multi-thread

Copyright 1987-2007, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl". If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.


D:\>adrci

ADRCI: Release 11.2.0.1.0 - Production on Za Jul 24 22:11:15 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

ADR base = "d:\app\gebruiker"
adrci> show homes
ADR Homes:
diag\clients\user_gebruiker\host_1490817586_76
diag\clients\user_system\host_1490817586_76
diag\rdbms\dik\dik
diag\tnslsnr\gebruik-3i5s8n0\listener
adrci> set home diag\rdbms\dik\dik
adrci> ips generate package 4;
Generated package 4 in file D:\ORA4031_20100724214430_COM_2.zip, mode complete

Sunday, July 11, 2010

ORA-04067

last week in forms10g we got ORA-04067.
In development and test we did not had this problem, checking the config files, searching metalink we could not solve this problem.
Finally we relinked the forms executable that solved the problem.
Statement used :
$ make -f ins_forms.mk install