Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus ORA-03113 User

Re: sqlplus ORA-03113 User

From: Rick Wessman <Rick.Wessman_at_oracle.com>
Date: 20 Mar 2002 15:33:26 -0500
Message-ID: <socbsdjdlnt.fsf@rwessman-pc.us.oracle.com>


The simplest thing to do would be to make sure that $ORACLE_HOME/bin/oracle is owned by the oracle user and has the mode 4755.

                                     Rick

TurkBear <jgreco1_at_mn.rr.com> writes:

> Set all the files under ORACLE_HOME to allow others to read..
> set all in ORACLE_HOME/bin to allow execute as well
>
>
> However, if SqlPlus loads, the permissions ( at least for execute ) are OK..
> Check your environment variables and check the content of ORACLE_HOME/network/admin/tnsnames.ora
>
> Be sure that all users have ORACLE_HOME set in their environment ...
>
>
> Volker Schleif <v.schleif_at_ixmid.com> wrote:
>
> >hi
> >
> >thanks for your fast answer.
> >
> >sqlplus can be loaded.
> >but the user can't make a connect to the database.
> >so i think that other file-permissions are uncorrect.
> >
> >did you know the files that sqlplus uses ?
> >
> >by volker
> >
> >TurkBear wrote:
> >> As a first guess, look at the permissions on the oracle binaries -
> >>
> >>
> >> Volker Schleif <v.schleif_at_ixmid.com> 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 ??
> >>>
> >>
> >>
> >>
> >> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> >> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> >> Check out our new Unlimited Server. No Download or Time Limits!
> >> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
> >>
> >
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----

-- 
                                Rick Wessman
                                Security Assurance Group
                                Oracle Corporation
                                Rick.Wessman_at_oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.
Received on Wed Mar 20 2002 - 14:33:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US