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?
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.
it is highly possible that this comes from kernel parameters not being weel adjusted. try these values :
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?