1 2 Previous Next 23 Replies Latest reply on May 23, 2012 2:56 PM by Srini Chavali-Oracle

    OUI DBCA error in 11g installation

    karthiksingh_india
      Dear Legends,

      As i am trying to install oracle 11g db in windows xp it shows


      Checking for Oracle Home incompatibilities ....
      Check complete. The overall result of this check is: Failed <<<<
      Problem: Oracle Database 11g Release 1 can only be installed in a new Oracle Home
      Recommendation: Choose a new Oracle Home for installing this product.
      ========================================================

      Checking Network Configuration requirements ...
      Check complete. The overall result of this check is: Failed <<<<
      Problem: The install has detected that the primary IP address of the system is DHCP-assigned.
      Recommendation: Oracle supports installations on systems with DHCP-assigned IP addresses; However, before you can do this, you must configure the Microsoft LoopBack Adapter to be the primary network adapter on the system. See the Installation Guide for more details on installing the software on systems configured with DHCP.
      ========================================================

      If i proceed with this installation then OEM does not configures properly.. because i have tried this several times... please help me what to do with this issue..
      Beginner in DBA want to learn a lot... Please help..

      Thanks in advance...
      Karthik
        • 1. Re: OUI Network configuration assistant Error - Warning
          kuljeet singh -
          Check complete. The overall result of this check is: Failed <<<<
          Problem: Oracle Database 11g Release 1 can only be installed in a new Oracle Home
          First try to install the software in new oracle_home, give new location in oracle_home while installing.
          • 2. Re: OUI Network configuration assistant Error - Warning
            Srini Chavali-Oracle
            Pl confirm you are using XP Professional. Home version is not supported - http://docs.oracle.com/cd/B28359_01/install.111/b32006/reqs.htm#CHDHGGFE

            Install into a new ORACLE_HOME as already suggested.

            Also enable loopback adapter - this is necessary - http://docs.oracle.com/cd/B28359_01/install.111/b32006/reqs.htm#BABGCEAI

            HTH
            Srini
            • 3. Re: OUI Network configuration assistant Error - Warning
              karthiksingh_india
              I am trying to install Oracle 11g in windows xp i got an error for several times even i have changed the HOME directory as it spots home directory errors....

              http://oraclekarthik.blogspot.in/2012/05/oracle-11g-oem-error.html

              but after installing i have checked the listener it shows
              C:\Documents and Settings\SKS>lsnrctl status

              LSNRCTL for 32-bit Windows: Version 11.1.0.7.0 - Production on 17-MAY-2012 11:45:25

              Copyright (c) 1991, 2008, Oracle. All rights reserved.

              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
              STATUS of the LISTENER
              Alias LISTENER
              Version TNSLSNR for 32-bit Windows: Version 11.1.0.7.0 - Production
              Start Date 17-MAY-2012 11:02:43
              Uptime 0 days 0 hr. 42 min. 46 sec
              Trace Level off
              Security ON: Local OS Authentication
              SNMP OFF
              Listener Parameter File D:\app\SKS\product\11.1.0\db_1\network\admin\listener.ora
              Listener Log File d:\app\sks\diag\tnslsnr\computer\listener\alert\log.xml
              Listening Endpoints Summary...
              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=computer)(PORT=1521)))
              Services Summary...
              Service "orcl" has 1 instance(s).
              Instance "orcl", status READY, has 1 handler(s) for this service...
              Service "orclXDB" has 1 instance(s).
              Instance "orcl", status READY, has 1 handler(s) for this service...
              Service "orcl_XPT" has 1 instance(s).
              Instance "orcl", status READY, has 1 handler(s) for this service...
              The command completed successfully

              and i here is my set command status
              C:\Documents and Settings\SKS>set
              ALLUSERSPROFILE=C:\Documents and Settings\All Users
              APPDATA=C:\Documents and Settings\SKS\Application Data
              CLASSPATH=.;.;C:\PROGRA~1\JMF21~1.1E\lib\sound.jar;C:\PROGRA~1\JMF21~1.1E\lib\jmf.jar;C:\PROGRA~1\JMF21~1.1E\lib
              ;
              CLIENTNAME=Console
              CommonProgramFiles=C:\Program Files\Common Files
              COMPUTERNAME=COMPUTER
              ComSpec=C:\WINDOWS\system32\cmd.exe
              FP_NO_HOST_CHECK=NO
              HOMEDRIVE=C:
              HOMEPATH=\Documents and Settings\SKS
              LOGONSERVER=
              COMPUTER
              NUMBER_OF_PROCESSORS=2
              ORACLE_SID=orcl
              OS=Windows_NT
              Path=D:\app\SKS\product\11.1.0\db_1\bin;';C:\WINDOWS\system32'
              PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
              PROCESSOR_ARCHITECTURE=x86
              PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 13, GenuineIntel
              PROCESSOR_LEVEL=6
              PROCESSOR_REVISION=0f0d
              ProgramFiles=C:\Program Files
              PROMPT=$P$G
              SESSIONNAME=Console
              SystemDrive=C:
              SystemRoot=C:\WINDOWS
              TEMP=C:\DOCUME~1\SKS\LOCALS~1\Temp
              TMP=C:\DOCUME~1\SKS\LOCALS~1\Temp
              USERDOMAIN=COMPUTER
              USERNAME=SKS
              USERPROFILE=C:\Documents and Settings\SKS
              VBOX_INSTALL_PATH=C:\Program Files\Oracle\VirtualBox\
              windir=C:\WINDOWS

              Please help me what to do now..?

              Thanks in advance.,
              Karthik
              • 4. Re: OUI Network configuration assistant Error - Warning
                Srini Chavali-Oracle
                Pl post the contents of the log file mentioned in your last screenshot

                HTH
                Srini
                • 5. Re: OUI Network configuration assistant Error - Warning
                  karthiksingh_india
                  Hi,

                  hereby i have posted my full log contents of previous error of the snapshot

                  http://oraclekarthik.blogspot.in/2012/05/emconfiglog-error-details.html

                  Karthik
                  • 6. Re: OUI Network configuration assistant Error - Warning
                    karthiksingh_india
                    Hi,

                    I have tried several times but it shows

                    C:\Documents and Settings\SKS>emca -config dbcontrol db -repos create

                    STARTED EMCA at May 18, 2012 11:08:02 AM
                    EM Configuration Assistant, Version 11.1.0.7.0 Production
                    Copyright (c) 2003, 2005, Oracle. All rights reserved.

                    Enter the following information:
                    Database SID: orcl
                    Listener port number: 1521
                    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\SKS\product\11.1.0\db_1

                    Local hostname ................ computer
                    Listener port number ................ 1521
                    Database SID ................ orcl
                    Email address for notifications ...............
                    Outgoing Mail (SMTP) server for notifications ...............

                    -----------------------------------------------------------------
                    Do you wish to continue? [yes(Y)/no(N)]: y
                    May 18, 2012 11:08:21 AM oracle.sysman.emcp.EMConfig perform
                    INFO: This operation is being logged at D:\app\SKS\cfgtoollogs\emca\orcl\emca_2012_05_18_11_08_02.log.
                    May 18, 2012 11:08:23 AM oracle.sysman.emcp.EMReposConfig createRepository
                    INFO: Creating the EM repository (this may take a while) ...
                    May 18, 2012 11:16:29 AM oracle.sysman.emcp.EMReposConfig invoke
                    INFO: Repository successfully created


                    ........ the cursor blinks for one hour i dont know what to do...
                    Please help me
                    • 7. Re: OUI Network configuration assistant Error - Warning
                      karthiksingh_india
                      Hi,

                      I have a doubt that OracleDBConsoleorcl service is not available in services.. but the remaining 3 services are running namely listener,jobscheduler,oracleservice...

                      Please help to create my EM.. thanks a lot for helping
                      • 8. Re: OUI Network configuration assistant Error - Warning
                        Srini Chavali-Oracle
                        The error in your log posted above is ORA-12547 - does this error show up all the time ? Pl confirm you are not using XP Home version

                        Srini
                        • 9. Re: OUI Network configuration assistant Error - Warning
                          karthiksingh_india
                          Hi,

                          http://oraclekarthik.blogspot.in/2012/05/windowsxp.html

                          I have issued the following in a sql_script

                          exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'SYSMAN.MGMT_NOTIFY_QTABLE',force=>TRUE);
                          SHUTDOWN IMMEDIATE;
                          STARTUP RESTRICT;
                          EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
                          EXEC sysman.setEMUserContext('',5);
                          REVOKE dba FROM sysman;
                          DECLARE
                          CURSOR c1 IS
                          SELECT owner, synonym_name name
                          FROM dba_synonyms
                          WHERE table_owner = 'SYSMAN';
                          BEGIN
                          FOR r1 IN c1 LOOP
                          IF r1.owner = 'PUBLIC' THEN
                          EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
                          ELSE
                          EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
                          END IF;
                          END LOOP;
                          END;
                          /
                          DROP USER mgmt_view CASCADE;
                          DROP ROLE mgmt_user;
                          DROP USER sysman CASCADE;
                          ALTER SYSTEM DISABLE RESTRICTED SESSION;

                          after this i have restarted my machine and in my prompt i issued

                          emca -config dbcontrol db -repos create
                          and then it says repository created successfully but the cursor blinks long time

                          and in my Oracledb_1home option from start panel there is no link or option for em(https://hostname:1158/em)

                          either now i want to re-install my windows xp or do something else related to os or db work...
                          pls help am suffering this issue for more than 3 weeks
                          • 10. Re: OUI Network configuration assistant Error - Warning
                            Srini Chavali-Oracle
                            >
                            emca -config dbcontrol db -repos create
                            and then it says repository created successfully but the cursor blinks long time
                            >

                            Pl post the complete log file for this emca action

                            HTH
                            Srini
                            • 11. Re: OUI Network configuration assistant Error - Warning
                              karthiksingh_india
                              hi,

                              http://oraclekarthik.blogspot.in/2012/05/emca20120518110802log.html --- my log file contents are here and I have posted some of my missing directories contents in following link

                              LISTENER IS UP OR NOT?

                              Please help me I want to know where and what is the issue and I want to solve it and learn more

                              thanks in advance
                              Karthik
                              • 12. Re: OUI Network configuration assistant Error - Warning
                                Srini Chavali-Oracle
                                Is this the lastest log ? Seems to be dated May 18th - pl confirm

                                Srini
                                • 13. Re: OUI Network configuration assistant Error - Warning
                                  karthiksingh_india
                                  Hi,

                                  This is the log that created while using OUI

                                  http://oraclekarthik.blogspot.in/2012/05/emca20120518170337log.html

                                  and the previous log is created while i tried using command prompt..
                                  • 14. Re: OUI Network configuration assistant Error - Warning
                                    Srini Chavali-Oracle
                                    There are no errors in the log posted. Are there any errors in the database alert log ?

                                    Pl follow the procedures in this MOS Doc to completely delete the repository and install it all over again

                                    How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g [ID 278100.1]     

                                    HTH
                                    Srini
                                    1 2 Previous Next