Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2003
    Posts
    9

    Unanswered: Problem during ORACLE INSTALLATION :(

    Hi All,

    I've installed Oracle 9i ver.2 Enterprise Edition Software. The sofware was installed without any problems. However, While creating Database tru Database Configuration Assistant it stops on 46% on "Creating & starting Oracle instance" stage with foll. 2 error windows:

    1. Oracle.exe has generated errors & will be closed by windows. You'll need to restart the program. An error log is being created.

    2. ORA-03113: End-of-file on communication channel.

    I tried to repeat creating DB several times, but in vain. Could anybody plz help me solve the above problem.

    I shall be really greatful.

    Thanks & Regards,
    Rakesh.

    P.S: My colleague suggested to reinstall Windows 2000 Professional,
    the version on which I've installed the Oracle. But will it slove the
    above problem? I can consider this option only as a last resort.

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    What errors are there in the alert log?
    Are there any trace files in user_dump_dest or background_dump_dest?

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I'm not sure it will help as I had problems while installing database 8.1.7.
    HTTP Server, running on Windows 2000 (or XP), Pentium 4 processor and Oracle 8.1.7 caused database installation to fail.

    However, you could try it ...

    Comment those lines (should be at the bottom of the file) in %oracle_home%\Apache\Apache\conf\httpd.conf:

    #include «C:\oracle\ora81\Apache\Jserv\conf\jserv.conf»
    #include «C:\oracle\ora81\Apache\Jserv\conf\oracle_apache.c onf»

  4. #4
    Join Date
    Feb 2004
    Location
    Eternity
    Posts
    31
    Try manually creating the database in stages so that u can find out where exactly the error is occuring

  5. #5
    Join Date
    Sep 2003
    Posts
    9

    NO SOLN. YET

    Dear SkyWriter, Littlefoot & spvijay,

    Thanks very much for your immediate response. I went tru' all the 3 solutions one by one:

    1) First I tried with the method mentioned by Littlefoot, as it looked the easiest method among all. NO RESULSTS
    2) I checked the alert log file in every db I created as suggested by Skywriter. But I couldn't find any errors!
    3) Finally, I tried to create a DB manually as suggested by spvijay. But without any user(sys,system not created yet) I'm unable to login.

    Any further tips is highly appreciated.

    Thanks & Regards,
    Rakesh.

  6. #6
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Hi ,
    Before creating any oracle Db u need to have an instance created that will mount the db.
    U must be having a valid Init<sid>.ora/spfile<sid>.ora configured.

    Do the following things.
    First check whether any Oracle service is there under ur services panel.
    If u find one as OracleService<sid> then stop it and delete it
    To make sure u can also use
    Oradim -delete -sid

    Thereafter search for Pwd<sid>.ora which is ur passwrd file , delete that.

    Now create an instance using Oradim utility syntax u can get from the command prompt.
    With the oradim command u can give the password of the Sys user or else u can create it later using Orapwd utility.

    After creation of the instance log into the sqlplus with sys as sysdba
    it will connect to an idle instance.
    Now create ur DB manually.

    All the best
    Kaushik

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    I can connect fine without an instance or database ...

    Code:
    *kod1-/export/oracle
    > echo $ORACLE_SID
    kod1
    *kod1-/export/oracle
    > ORACLE_SID=NOSID
    *NOSID-/export/oracle
    > echo $ORACLE_SID
    NOSID
    *NOSID-/export/oracle
    > sqlplus /nolog
    
    SQL*Plus: Release 9.2.0.4.0 - Production on Tue Feb 24 17:02:36 2004
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    17:02:36 idle> connect /as sysdba
    Connected to an idle instance.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  8. #8
    Join Date
    Feb 2004
    Location
    Eternity
    Posts
    31
    For the steps mentioned above,the user has to be a member of the group ORA_DBA in Windows.Please check for the same in (My Computer--rightclick ->Manage->Local Users and Groups->Groups)

  9. #9
    Join Date
    Sep 2003
    Posts
    9

    Bravo! Oracle DB Created!

    Bravo! Oracle DB Created!

    I take this opportunity to thank you all for your timely help. Finally, I'm able to create DB after struggling for 3 days.

    Special thanks to Kausik_m123 whose tips actually gave the way. After creating the instance I struggled with the Listener! Manual creation of Db didn't work. Only after trying again with the Database Configuration Asst. it got created!

    Discovering ORADIM utility was the highlight! I'm thankful to all the members of this wonderful forum.

    Thanks & Regards,
    Rakesh Sharma.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •