8 Replies Latest reply on Dec 28, 2012 2:57 PM by Srini Chavali-Oracle

    Installing Oracle 11G on windows.. issues

    Nikhil Juneja
      Hi All,

      I have been trying to upgrade my personal laptop with 11G from 10G.

      Since I didn't had any important data, so i removed 10G and tried to go for a fresh install of 11G.

      Below are the entries of my files:

      # listener.ora Network Configuration File: C:\app\Nik\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
      # Generated by Oracle configuration tools.
        (SID_LIST =
          (SID_DESC =
            (ORACLE_HOME = C:\app\Nik\product\11.2.0\dbhome_1)
            (SID_NAME = ORCL)
            (PROGRAM = extproc)
            (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Nik\product\11.2.0\dbhome_1\bin\oraclr11.dll")
          (SID_DESC =
            (GLOBAL_DBNAME = Oracle8)
            (ORACLE_HOME = C:\app\Nik\product\11.2.0\dbhome_1)
            (SID_NAME = ORCL)
      LISTENER =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = Nik-Laptop)(PORT = 1521))
      ADR_BASE_LISTENER = C:\app\Nik
      ORCL =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = Nik-Laptop)(PORT = 1521))
          (CONNECT_DATA =
       trace_level_client = 16
      trace_file_client = cli
      trace_directory_client = c:\trace
      trace_unique_client = on
      trace_timestamp_client = on
      trace_filelen_client = 100
      trace_fileno_client = 2
      log_file_client = cli
      log_directory_client = c:\trace\log
      tnsping.trace_directory = c:\trace\trace
      tnsping.trace_level = admin 
      processes = 150
      audit_trail ='db'
      dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
      # You may want to ensure that control files are created on separate physical
      # devices
      control_files = (ora_control1.ctl, ora_control2.ctl)
      compatible ='11.2.0'
      If i start the database in nomount it doesn't give any error.

      Once I try to mount it, it gives the following error:

      SQL> alter database mount
      2 ;
      alter database mount
      ERROR at line 1:
      ORA-00205: error in identifying control file, check alert log for more info

      SQL> show parameter control;
      NAME                                 TYPE        VALUE
      ------------------------------------ ----------- ------------------------------
      control_file_record_keep_time        integer     7
      control_files                        string      C:\APP\NIK\PRODUCT\11.2.0\DBHO
                                                       , C:\APP\NIK\PRODUCT\11.2.0\DB
      control_management_pack_access       string      DIAGNOSTIC+TUNING
      Could you please help me if i am missing anything here..
        • 1. Re: Installing Oracle 11G on windows.. issues
          Nadeem M
          I am assuming that the installation of 11g binaries was successful and you are having issues currently to start the database.

          From the error it can be understood that Oracle is not able to find your control file. In your INITORCL.ORA parameter file the control_files parameter values are relative path rather then the complete path. change this parameter such that it includes complete path for your control files.
          • 2. Re: Installing Oracle 11G on windows.. issues
            Nikhil Juneja
            Hi Nadeem,

            But there are no ctl files created in the folders under C:\app\Nik\product\11.2.0\dbhome_1\database

            I am unable to find any ctl files altogether..

            Could you please suggest if i should recreate a new database?
            If yes, could you please provide me with relevant steps to remove the existing ones and create a new one

            Thanks and Regards,
            • 3. Re: Installing Oracle 11G on windows.. issues
              Nadeem M
              When you said you are trying to upgrade the 10g database to 11g I assumed all your 10g database files (data, redo, control and parameter files) are available. If you are not sure about this and losing the database doesn't matter to you then you can create the database.

              Regarding removal of 10g database/binaries you should have done this via OUI. But it seems you have already deleted few files which means OUI might not work. You have to delete remaining 10g files manually.
              1 person found this helpful
              • 4. Re: Installing Oracle 11G on windows.. issues
                Srini Chavali-Oracle
                Pl post exact OS and 11g versions. Looks like you only installed the 11g software - what options did you choose during the install ?


                If you chose to only install the software, then the next step is to create a database using DBCA - see the next section in the link above

                • 5. Re: Installing Oracle 11G on windows.. issues
                  Nikhil Juneja
                  Hi Srini,

                  I am trying to install Oracle 11G r2 on Windows vista

                  I have removed the database created previously.

                  Now trying to create a new one.

                  Getting the below error:

                  COnfiguring database with Database COntrol requires a listener
                  to be configured in the current Oracle home.
                  You need to run Netca to configure a listener before you can proceed
                  Otherwise you may choose to continue without database configuration.
                  • 6. Re: Installing Oracle 11G on windows.. issues
                    Srini Chavali-Oracle
                    "11gR2" and "Vista" are marketing labels :-) Pl post exact versions. What option did you choose during the software install ? Are you using DBCA to create the database ? Where are you seeing this error message ?

                    • 7. Re: Installing Oracle 11G on windows.. issues
                      Nikhil Juneja
                      Thanks Srini for all your inputs..

                      I removed the Database and created a new one using Database configuration Assistant.

                      Now its working fine as expected.
                      Oracle Database 11g Enterprise Edition Release - Production
                      PL/SQL Release - Production
                      CORE      Production
                      TNS for 32-bit Windows: Version - Production
                      NLSRTL Version - Production
                      A small query though, while connecting from cmd prompt i am able to do it successfully as sysdba and any other user like hr

                      But while connecting using sys or system and providing the Oracle SID it gives me the following error:
                      C:\Users\Nik>sqlplus system@orcl
                      SQL*Plus: Release Production on Fri Dec 28 20:15:32 2012
                      Copyright (c) 1982, 2010, Oracle.  All rights reserved.
                      Enter password:
                      ORA-12154: TNS:could not resolve the connect identifier specified
                      Could you please tell why this is coming?

                      • 8. Re: Installing Oracle 11G on windows.. issues
                        Srini Chavali-Oracle
                        There could be a variety of reasons - check out Ed's blog on this error - http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/ - is "orcl" the correct SID ?