[ILUG] Oracle on FC3

[K. Dube]

=C9ibhear wrote:

> To suggest on the first problem:
>
> Kudakwashe Dube said:
> [SNIP]
>  =

>
>> I am having two problems. The first problem is that I'm getting the
>> error "Cannot open shared file" each time I  try to connect to the
>> oracle through any other account that's not "oracle" user.
>>   =

>
>
> In order to connect to the Oracle Server, the user you're running as =

> needs
> access to the Oracle client utilities. If you're running on the same
> system as where the oracle server is installed, then *my* advice (which
> may differ from others') is:
>
> - Add the user to the same group as the oracle user. This isn't 'dba',
>   which is for a specific role, but if you created the oracle user
>   as part of the oracle group, then add the your client user to that
>   group.
>  =

>

I've "oracle" user under "oracle group".  So I added the user to this =

group.

> - Make sure the following environment variables are set correctly:
>   ORACLE_HOME, PATH (which should include $ORACLE_HOME/bin) and
>   ORACLE_SID
> - Set the environment variable LD_LIBRARY_PATH to include
>   $ORACLE_HOME/lib/. This is probably the reason for your error,
>   but the other two points will help too.
>  =

>

I realise that I had these environment vars correctly set for the oracle =

user and not for other users. I've now added these to /etc/bashrc since =

I want almost all my users to have them set.

After these settings, the problem disappeared and all my users can now =

login without any errors.

Slow response remains a problem. I am now working on applying the advice =

I'm being given by Conor.

Thank you =C9ibhear for your this useful advice.

-------
Kuda



-- =

This message has been scanned for content and =

viruses by the DIT Information Services MailScanner =

Service, and is believed to be clean.
http://www.dit.ie