ora-03113 when trying to use database configuration assistant (win2k)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ora-03113 when trying to use database configuration assistant (win2k)

  1. #1
    Join Date
    Jul 2002
    Posts
    13

    Question

    Hi,

    I have installed oracle 8.1.7 on a brand new machine (win2k) and I was trying to create a database by using the database configuration assistant. After I go through the wizard, it begins to create the database but very quickly I get a ora-03113 end of file on communication channel error. I think it happened when the wizard was just beginning to create datafiles. Can anyone help me please?

    Thanks in advance.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    I had a similar problem and here was the workaround suggested by Oracle:

    "The init.ora for your new DB may have the parameter remote_login_passwordfile=exclusive requiring a password file that has not yet been created

    Using the database assistant choose the option to save your db creation. This will save the options you choose to script. Before running the scripts to create the database, either remove remote_login_passwordfile=exclusive from the init.ora, or edit the batch file so that the oradim line has the -intpwd parameter ex: D:\Oracle\Ora81\bin\oradim -new -sid SD03 -intpwd ORACLE -startmode manual -pfile D:\Oracle\admin\sd03\pfile\init.ora"

    Otherwise there is a good generic page for resolving ORA-3113 errors

    http://support.oracle.co.uk/metalink...p_id=1003596.6

    Hope that helps

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

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


Click Here to Expand Forum to Full Width