While running dbassist to create a database I was getting an error:
ORA-03114:cant connect to ORACLE?????
So I started lsnrctl and started a listener,
and I tried running dbassist again,
and this time I got the error:
ORA-03113:end-of-file on communication channel.
Any ideas whats going on? and how can I resolve this?
How else can I create a database?
What kind of platform are you using? UNIX or WIN NT?
you have to set correctly the parameter for sheared segments and semaphories in your etc/system.
They probably are too small or they were not setted.
It should solve your problem.
etc/system for Sun Solaris
stand/system for HP-UX in etc is not present
What should I set them to?
I made the changes to shmparam.h and the sem.h as instructed in the pre-installation guide.
And then recompiled the kernel as told.
Is that different than what youre saying?
I think you have some kind of environment problem. Make certain your $ORACLE_HOME
variable is set correctly, that nothing else is resetting it (duplicate line in .profile,
a .kshrc file, etc). Make certain that $PATH contains $ORACLE_HOME/bin.
Do you have $ORACLE_SID set to what the instance name you are creating.
Can you open another xterm or telnet session and see if the Oracle background
processes are running?
I opened up a new Xterm session and did a
and it gives me a blank line.
but on the term where I run dbassist, it gives me the correct path.
If I go to the .bash_login file, and the path settings there are correct.
Ive set ORACLE_SID=DNC
thats what I plan to call the database ONCE its created.
Is that the problem?
Even once Ive set it?
If you had this problem trying to create the database after Oracle installation probably the problem is the settings I told you are not correctly.
In the instllation guide there is a section related to the pre-installation tasks where you can find what I tried to explain above.
However if you set those parameters into tthe file system and then rebbot your machine there is no matter to modify you did and to recompile the kernel.
Remember you must be root to edit the file etc/system
Click Here to Expand Forum to Full Width