Can’t locate CompEMdbconsole.pm during EM dbconsole creation Oracle 11gR2
Most of the Oracle 11gR2 user asked OTN forums , Why we cann’t create Oracle EMdbconsole during database creation.They are all say same error like below
Can’t locate CompEMdbconsole.pm in @INC
where they were mistaken ?
Yes, They were mistaken at Extract or unzip the Oracle Software Files (1 & 2). They were unzipped separate folder not in one folder like linux enviornment , you can see after unzipped only one folder showing “database”. Windows , they were unzipped the two disk files using some Utility like Winzip or anyone. What happen here, It will unzipped separate folder, so When you’re going to install, some opf the components are missed out in this folder (First disk unzipped folder).
What should we do? How do we unzip this Files?
c:\software\oracle11gr2>dir
Volume in drive C has no label.
Volume Serial Number is 725B-4DA0
Directory of c:\software\oracle11gr2
10/17/2010 02:23 PM <DIR> .
10/17/2010 02:23 PM <DIR> ..
10/17/2010 01:06 PM 1,625,721,289 win32_11gR2_database_1of2.zip
10/17/2010 01:51 PM 631,934,821 win32_11gR2_database_2of2.zip
2 File(s) 2,257,656,110 bytes
2 Dir(s) 106,398,171,136 bytes free
c:\software\oracle11gr2>mkdir c:\azar\software
c:\software\oracle11gr2>copy *.zip c:\azar\software
win32_11gR2_database_1of2.zip
win32_11gR2_database_2of2.zip
2 file(s) copied.
c:\azar\software>dir
Volume in drive C has no label.
Volume Serial Number is 725B-4DA0
Directory of c:\azar\software
10/17/2010 02:25 PM <DIR> .
10/17/2010 02:25 PM <DIR> ..
10/17/2010 01:06 PM 1,625,721,289 win32_11gR2_database_1of2.zip
10/17/2010 01:51 PM 631,934,821 win32_11gR2_database_2of2.zip
2 File(s) 2,257,656,110 bytes
2 Dir(s) 104,139,374,592 bytes free
c:\azar\software>unzip win32_11gR2_database_1of2.zip
” ” ” “” “” ‘ ‘ ‘ ‘ ” ‘
After unzipped first disk files , I should go to unzip second disk files on same directory In this case , Some of the componets overwritten at “database” folder.
c:\azar\software>dir
Volume in drive C has no label.
Volume Serial Number is 725B-4DA0
Directory of c:\azar\software
10/17/2010 02:26 PM <DIR> .
10/17/2010 02:26 PM <DIR> ..
04/03/2010 05:29 AM <DIR> database
10/17/2010 01:06 PM 1,625,721,289 win32_11gR2_database_1of2.zip
10/17/2010 01:51 PM 631,934,821 win32_11gR2_database_2of2.zip
2 File(s) 2,257,656,110 bytes
3 Dir(s) 102,475,350,016 bytes free
c:\azar\software>unzip win32_11gR2_database_2of2.zip
“” “”” “””‘””””””
After unzipped , I can see only one folder like Linux , see below
c:\azar\software>dir
Volume in drive C has no label.
Volume Serial Number is 725B-4DA0
Directory of c:\azar\software
10/17/2010 02:26 PM <DIR> .
10/17/2010 02:26 PM <DIR> ..
04/03/2010 05:29 AM <DIR> database
10/17/2010 01:06 PM 1,625,721,289 win32_11gR2_database_1of2.zip
10/17/2010 01:51 PM 631,934,821 win32_11gR2_database_2of2.zip
2 File(s) 2,257,656,110 bytes
3 Dir(s) 101,823,766,528 bytes free
Now I’m got Install , After Installation, the DBconsole also created succesfully.
c:\azar\software>cd database
c:\azar\software\database>dir
Volume in drive C has no label.
Volume Serial Number is 725B-4DA0
Directory of c:\azar\software\database
04/03/2010 05:29 AM <DIR> .
04/03/2010 05:29 AM <DIR> ..
03/26/2010 11:42 PM <DIR> doc
04/02/2010 09:15 PM <DIR> install
04/02/2010 10:46 PM <DIR> response
03/12/2010 11:49 AM 542,088 setup.exe
04/02/2010 10:46 PM <DIR> stage
03/03/2010 02:52 AM 5,038 welcome.html
2 File(s) 547,126 bytes
6 Dir(s) 119,008,116,736 bytes free
c:\azar\software\database>setup.exe
After installed, DB console create successful.
DBA 
Could you please share the log details?
After DB installation why do we need to keep oracle software ??
dear Azar:
Excuse me，I am from china, My English is not very good，sorry! To ask you questions：
[oracle@11g ~]$ env | grep ORA
ORA_GRID_HOME=/u01/app/product/11.2/grid
ORACLE_SID=db11
ORACLE_BASE=/u01/app
ORACLE_HOME=/u01/app/product/11.2/db_1
[oracle@11g ~]$ export ORACLE_SID=+ASM
[oracle@11g ~]$ export ORACLE_HOME=/u01/app/product/11.2/grid
[oracle@11g ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Sat Oct 8 10:41:55 2011
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> conn / as sysasm
Connected to an idle instance.
SQL> startup;
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2227664 bytes
Variable Size 256537136 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Automatic Storage Management option
[oracle@11g ~]$ export ORACLE_SID=db11
[oracle@11g ~]$ export ORACLE_HOME=/u01/app/product/11.2/db_1
[oracle@11g ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Oct 8 10:42:39 2011
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 801701888 bytes
Fixed Size 2232640 bytes
Variable Size 264244928 bytes
Database Buffers 532676608 bytes
Redo Buffers 2547712 bytes
Database mounted.
Database opened.
SQL> select * from v$version
2 ;
BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
PL/SQL Release 11.2.0.3.0 – Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 – Production
NLSRTL Version 11.2.0.3.0 – Production
SQL>
[oracle@11g ~]$ java -version
java version “1.6.0_24”
Java(TM) SE Runtime Environment (build 1.6.0_24-b07)
Java HotSpot(TM) 64-Bit Server VM (build 19.1-b02, mixed mode)
now, start em error
[oracle@11g ~]$ emctl start dbconsole
Can’t locate CompEMdbconsole.pm in @INC (@INC contains: %s_javapOracleHome%/sysman/admin/scripts %s_javapOracleHome%/bin /u01/app/product/11.2/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/app/product/11.2/grid/perl/lib/5.10.0 /u01/app/product/11.2/grid/perl/lib /u01/app/product/11.2/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/app/product/11.2/grid/perl/lib/site_perl/5.10.0 /u01/app/product/11.2/grid/perl/lib/site_perl /u01/app/product/11.2/grid/perl/libwww-perl/lib /u01/app/product/11.2/grid/perl/ext/POSIX /u01/app/product/11.2/grid/perl/URI /u01/app/product/11.2/grid/perl/HTML_Parser /u01/app/product/11.2/grid/perl/HTML-Parser/lib /u01/app/product/11.2/grid/sysman/admin/scripts /u01/app/product/11.2/grid/bin /u01/app/product/11.2/grid/sysman/admin/scripts/Net-DNS-0.48/lib/ /u01/app/product/11.2/grid/sysman/admin/scripts/libnet-1.19/ .) at /u01/app/product/11.2/grid/bin/EmctlCommon.pm line 598.
Thank you! best wishes!
Hi,
Can you try like below
[oracle@11g ~]$export ORACLE_HOME=/u01/app/product/11.2/db_1
[oracle@11g ~]$export ORACLE_HOME=/u01/app/product/11.2/db_1/bin
[oracle@11g ~]$export ORACLE_SID=db11
[oracle@11g ~]$emctl status dbconsole
Please let me know what are you get output after execute?
Excuse me!
[oracle@11g ~]$ export ORACLE_HOME=/u01/app/product/11.2/db_1/bin
[oracle@11g ~]$ export ORACLE_SID=db11
[oracle@11g ~]$ emctl status dbconsole
Can’t locate CompEMdbconsole.pm in @INC (@INC contains: %s_javapOracleHome%/sysman/admin/scripts %s_javapOracleHome%/bin /u01/app/product/11.2/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/app/product/11.2/grid/perl/lib/5.10.0 /u01/app/product/11.2/grid/perl/lib /u01/app/product/11.2/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/app/product/11.2/grid/perl/lib/site_perl/5.10.0 /u01/app/product/11.2/grid/perl/lib/site_perl /u01/app/product/11.2/grid/perl/libwww-perl/lib /u01/app/product/11.2/grid/perl/ext/POSIX /u01/app/product/11.2/grid/perl/URI /u01/app/product/11.2/grid/perl/HTML_Parser /u01/app/product/11.2/grid/perl/HTML-Parser/lib /u01/app/product/11.2/grid/sysman/admin/scripts /u01/app/product/11.2/grid/bin /u01/app/product/11.2/grid/sysman/admin/scripts/Net-DNS-0.48/lib/ /u01/app/product/11.2/grid/sysman/admin/scripts/libnet-1.19/ .) at /u01/app/product/11.2/grid/bin/EmctlCommon.pm line 598.
[oracle@11g ~]$ export ORACLE_HOME=/u01/app/product/11.2/db_1
[oracle@11g ~]$ export ORACLE_SID=db11
[oracle@11g ~]$ emctl status dbconsole
Can’t locate CompEMdbconsole.pm in @INC (@INC contains: %s_javapOracleHome%/sysman/admin/scripts %s_javapOracleHome%/bin /u01/app/product/11.2/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /u01/app/product/11.2/grid/perl/lib/5.10.0 /u01/app/product/11.2/grid/perl/lib /u01/app/product/11.2/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /u01/app/product/11.2/grid/perl/lib/site_perl/5.10.0 /u01/app/product/11.2/grid/perl/lib/site_perl /u01/app/product/11.2/grid/perl/libwww-perl/lib /u01/app/product/11.2/grid/perl/ext/POSIX /u01/app/product/11.2/grid/perl/URI /u01/app/product/11.2/grid/perl/HTML_Parser /u01/app/product/11.2/grid/perl/HTML-Parser/lib /u01/app/product/11.2/grid/sysman/admin/scripts /u01/app/product/11.2/grid/bin /u01/app/product/11.2/grid/sysman/admin/scripts/Net-DNS-0.48/lib/ /u01/app/product/11.2/grid/sysman/admin/scripts/libnet-1.19/ .) at /u01/app/product/11.2/grid/bin/EmctlCommon.pm line 598.
[oracle@11g ~]$
error Seems as ! thank you
Thanks for the valuable post. Your information was just enough for the installation to work.