Database creation problem. Please Help...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database creation problem. Please Help...

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    I am trying to create a 8.1.7 database on a Windows 2000 machine. I get a ORA-03113 error during the service startup. The sample error is given below.

    Note that these are the first 2 statements in the database creation script.

    C:\>C:\oracle\ora81\bin\oradim -new -sid JSH -intpwd oracle -startmode auto -pfi
    le "C:\oracle\admin\JSH\pfile\initJSH.ora"

    C:\>C:\oracle\ora81\bin\oradim -startup -sid JSH -starttype srvc,inst -usrpwd or
    acle -pfile "C:\oracle\admin\JSH\pfile\initJSH.ora"
    ORA-03113: end-of-file on communication channel

    Thanks
    Anurag

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Correct me if I'm wrong, but I thought the script 1 should look like:
    -
    C:\>oracle\ora81\bin\oradim -new -sid JSH -intpwd oracle -startmode auto pfile=C:\oracle\admin\JSH\pfile\initJSH.ora
    -
    The second script does not familiar to me. Are you trying to startup the db?? Typically, you create the service to the db, startup nomount, create the db, and then open the db.

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Why would you want to do a command prompt creation when you could use the tool, dbassist present under $ORACLE_HOME/bin?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Sep 2000
    Posts
    362
    The reason I am not using the tool is because it also gives me a end-of-file error and I wasnt able to figure out where this is happenning.

    Actually its is happenning when I am trying to connect to the database using server manager. Below are the first 3 steps of database creation and it gives ne an error when trying to open server manager and trying to connect as internal.

    Please suggest.

    C:\>set ORACLE_SID=JSH1

    C:\>C:\oracle\ora81\bin\oradim -new -sid JSH1 -startmode manual -pfile "C:\oracl
    e\admin\JSH1\pfile\initJSH1.ora"

    C:\>C:\oracle\ora81\bin\svrmgrl @C:\oracle\ora81\assistants\dbca\JSH1run.sql

    Oracle Server Manager Release 3.1.7.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    ORA-03113: end-of-file on communication channel
    Echo ON
    SVRMGR> connect INTERNAL/oracle
    ORA-03113: end-of-file on communication channel
    SVRMGR> startup nomount pfile="C:\oracle\admin\JSH1\pfile\initJSH1.ora"
    LCC-00161: Message 161 not found; product=RDBMS; facility=MGR

    ORA-03113: end-of-file on communication channel
    SVRMGR> CREATE DATABASE JSH1
    2> LOGFILE 'C:\oracle\oradata\JSH1\redo01.log' SIZE 1024K,
    3> 'C:\oracle\oradata\JSH1\redo02.log' SIZE 1024K,
    4> 'C:\oracle\oradata\JSH1\redo03.log' SIZE 1024K----

    Thanks
    Anurag

  5. #5
    Join Date
    Sep 2000
    Posts
    362
    Hi ,

    I was able to find a Note on the metalink site which helped me solve the problem.

    Below is the copy of the need. Thought it might be useful.

    Thanks
    Anurag


    Problem Description
    -------------------
    You're trying to log on to a local oracle database on a windows based
    (winNT/winn2000) server and you receive ORA-3113.

    Solution Description
    --------------------
    Make sure you do not have
    SQLNET.AUTHENTICATION_SERVICES=(NTS)
    in the sqlnet.ora if you're connected to the machine as a domain user but
    there is currently no network connection. This is very common on laptops that
    are normally used in a networked environment but used standalone as well.

    Explanation
    -----------
    If you log on to a winNT or win2000 machine as a domain user but there is
    currently no network connection, you will still be logged on to the machine
    if you've been logged on before. Windows will use cached credentials to check
    your username/password etc.
    If you've got SQLNET.AUTHENTICATION_SERVICES=(NTS) set in your sqlnet.ora
    you're asking oracle to authenticate you with the domain server when you log
    on to oracle.
    This combination of things can lead to oracle trying to ask the NT domain
    controler to validate you when there is no actual network connection, the
    result is an ORA-3113 error.



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