-
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?
Thanks.
-
no lk<SID> file
Hi,
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.
Thanks.
-
Some recommednation:
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!
-
it is highly possible that this comes from kernel parameters not being weel adjusted. try these values :
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmseg=50
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=700
set semsys:seminfo_semmns=1200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
-
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.
-
Check your umask -a it should be set to 022
Sam
Thanx
Sam
Life is a journey, not a destination!
-
ora-03113
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
svrmgr>connected
Since the database is not started, it should show 'connect to idle database' instead of 'connect'. Anyone have ideas?
Thanks
-
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
any suggestions
Thanks in advance
[Edited by thood on 05-09-2001 at 03:15 PM]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|