Hi all. I tried to create a database using the scripts generated by dbassist. When I run the create script, I got ORA-03113:end-of-file on communication channel. I checked the listener file, all the setting is correct. I then manually run create database command on svrmgrl, got the same message. anyone have any ideas?
04-26-2001, 02:53 PM
no lk<SID> file
I found out there is no lk file under $ORACLE_HOME/dbs. Is it the reason cause the ora-03113 error? Does it mean I need to re-install the software. BTW, it's a solaris box and the oracle version is 8.1.7.
04-26-2001, 03:00 PM
1. Check to see if you have privilege to write in the directory where you want to create your datafiles.
2. If 1 is OK, I would like to suggest re-install Oracle and use dbassist to create a database. See if that helps!
04-27-2001, 03:23 AM
it is highly possible that this comes from kernel parameters not being weel adjusted. try these values :
04-27-2001, 11:55 AM
Check on Metalink for this issue.
1. there are known reasons for this error.
2. this error crops up during db creation in 8.1.6 (that I know of), dunno if this was fixed.
04-27-2001, 12:01 PM
Check your umask -a it should be set to 022
04-30-2001, 10:39 AM
Thanks for your reply.
I checked everything you mentioned, still get the error. Do you think I shoud reboot the server? There is another weird thing, when I shutdown the database abort and
svrmgr> connect internal
Since the database is not started, it should show 'connect to idle database' instead of 'connect'. Anyone have ideas?
05-09-2001, 02:58 PM
I am also getting this same error ( Ora-03113) but I am using Winnt Workstation 4.0 with SP6a. I only run Oracle on this workstation for stand-alone testing..
I am installing Oracle 8.1.6. and have installed 3 times with the same error. The error happens DURING install.
I can tnsping the database...but when I try to access via SQL*NET it fails.
I have tried to recreate the tnsnames.ora file (several times) using Net8 with no luck.
changed my ip from DHCP to static