Database creation problem. Please Help...

[anuragmin]

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

[Halo]

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.

[sambavan]

Why would you want to do a command prompt creation when you could use the tool, dbassist present under $ORACLE_HOME/bin?

Sam

[anuragmin]

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

[anuragmin]

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.