Skip to content
Advertisements

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.

Advertisements
6 Comments Post a comment
  1. Could you please share the log details?

    After DB installation why do we need to keep oracle software ??

    October 18, 2010
  2. dai liang #

    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!

    October 7, 2011
    • 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?

      October 8, 2011
      • dai liang #

        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

        October 13, 2011
  3. test #

    Thanks for the valuable post. Your information was just enough for the installation to work.

    September 24, 2012

Trackbacks & Pingbacks

  1. Wordpress SEO

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: