Re: sqlplus ORA-03113 User

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! ==----- Received on Wed Mar 20 2002 - 12:27:44 CST