Re: sqlplus ORA-03113 User

If the SQL*Plus is on the client machines then this likely has nothing to do with permissions. I'll go back to my original question. Did you follow the instructions on the CD or wing it? Did you set the correct values for shared memory and semaphores? Did you create the correct UNIX groups and users? Did you put ORACLE_HOME, ORACLE_BASE, and ORACLE_SID in users' .profiles?

If you did not follow the installation CD instructions remove it and start over again. ORA-03113 on a UNIX box is almost always caused by someone not following the installation instructions.

Daniel Morgan

Volker Schleif wrote:

> hi daniel
>
> thanks for your fast answer.
>
> the installation was finished without errors, and the user oracle
> haven't problem's to connect to the database.
>
> i think that oracle has set permisons for user oracle only in the
> file-system, so that the user x ,or sqlplus who is started by user x,
> can't read or write to a file who is owned by oracle.
>
> but what file's are sqlplus uses ?
>
> by volker
>
> damorgan wrote:
> > Did you follow the installation instructions on the CD or just wing it?
> >
> > I am thinking in terms of settings for shared memory and semaphores.
> >
> > Daniel Morgan
> >
> >
> >
> > Volker Schleif wrote:
> >
> >
> >>Hello
> >>
> >>I have installed Oracle 8.1.7 on a Linux 2.2.16 Kernel.
> >>as User oracle i can connect to the Database via sqlplus whitout errors.
> >>
> >>as user x i can't start sqlplus with the same oracle-user name and password.
> >>The enviroment-variables ORA_HOME, ORACLE_HOME, ORACLE_SID are the same
> >>as user oracle.
> >>
> >>when the User x under oracle-user y will log on, he become the
> >>ORA-03113-Error.
> >>
> >>The enviroment are the same as User oracle.
> >>The logs (alert and trc- files) say nothing about this failue
> >>
> >>what ca i do ??
> >>
> >
Received on Wed Mar 20 2002 - 10:52:23 CST