Archive for

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.

Deinstall Oracle 11gR2 windows

Somebody thinking This is simple one How do we deinstall Oracle Software. Then Why this post need? Yes. the previous release oracle software version like 10g  or less than, you can click on Oracle Universal Installer Page and then choose deinstall product and clicked what you want remove, you can easily. But now you cannot deinstall using Oracle universal Installer, It something different , See below when i try remove Oracle 11g product using OUI.

Okay.Now I’m going to deinstall the oracle product at using the picture mentioned path,

 C:\app\mazar\product\11.2.0\dbhome_1\deinstall\deinstall        Enter

But it showing some permissions issues and also It’s recommand, you should go to download Oracle Deinstall software from OTN.

Now I have plan to download this product from OTN, from here

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

After downloaded it, I just unzip this file ,After extracted I go to deinstall folder and then again I run it deinstall, but it shows following message,

C:\Users\mazar>cd C:\software\oracle11gr2\win32_11gR2_deinstall\deinstall

C:\software\oracle11gr2\win32_11gR2_deinstall\deinstall>deinstall

C:\softwarbat -home <Complete path of Oracle home>
               [ -silent ]
               [ -checkonly ]
               [ -local ]
               [ -paramfile <complete path of input parameter properties file> ]
               [ -params <name1=value[ name2=value name3=value …]> ]
               [ -o <complete path of directory for saving files> ]
               [ -help | -h: Type -h or -help to get more information on each of the above options. ]

Tool is being run outside the Oracle Home, -home needs to be set.

C:\software\oracle11gr2\win32_11gR2_deinstall\deinstall>

So We need to set Oracle 11g home path here ,and then you can deinstall easily

C:\software\oracle11gr2\win32_11gR2_deinstall\deinstall>deinstall -home C:\app\mazar\product\11.2.0\dbhome_1
Location of logs C:\Program Files\Oracle\Inventory\logs\

############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################## CHECK OPERATION START ########################
Install check configuration START
Checking for existence of the Oracle home location C:\app\mazar\product\11.2.0\dbhome_1
Oracle Home type selected for de-install is: SIDB
Oracle Base selected for de-install is: C:\app\mazar
Checking for existence of central inventory location C:\Program Files\Oracle\Inventory

Install check configuration END

Checking Windows and .NET products configuration START
The following Windows and .NET products will be deconfigured from the Oracle home : asp.net,ode.net,odp.net,ntoledb,oramts,oo4o

Checking Windows and .NET products configuration END
Network Configuration check config START

Network de-configuration trace file location: C:\Program Files\Oracle\Inventory\logs\netdc_check62985.log

Specify all Single Instance listeners that are to be de-configured [LISTENER]:
“”””””””””””””””””””””””””””””””””””””””””””””””””””””””

Here it will ask something , you need to give like dbname.

“”””””””””””””””””””””””””””””””””””””””””””””””””””””””””””””
“”””””””””””””””””””””””””””””””””””””””””””””””””””””””””””

Oracle Universal Installer cleanup completed with errors.

Oracle install successfully cleaned up the temporary directories.
#######################################################################
############# ORACLE DEINSTALL & DECONFIG TOOL END #############

Now deinstallations Completed,  sometimes the services doesnot removed, so you need to remove using REGEDIT.