Re: Oracle user group

On May 5, 12:25 pm, JMecc <j..._at_telus.net> wrote:
> I just installed Oracle on a Red Hat server per tutorialhttp://www.oracle.com/technology/pub/articles/smiley_10gdb_install.ht...
> . From the 'oracle' unix user, I can use the database just fine, but
> I can't start sqlplus from my unix account:
>
> bash-3.00$ sqlplus
> sqlplus: error while loading shared libraries: libsqlplus.so: cannot
> open shared object file: No such file or directory
>
> I've set environment variables per other internet discussions:
> setenv ORACLE_HOME /database/Oracle10g
> setenv ORACLE_BASE /database/Oracle10g
> setenv ORACLE_SID btap
> setenv ORAENV_ASK NO
> source $ORACLE_HOME/bin/coraenv
> setenv LD_LIBRARY_PATH $ORACLE_HOME/lib
> setenv PATH $PATH\:$ORACLE_HOME/bin
>
> I've also tried using bash and csh but neither allows me sqlplus
> access.
>
> I guess I could go in and change this library's (and many others')
> permissions per chmod o+r, but it feels wrong - since Oracle must plan
> for an installation where a dba group can administer the DB and a
> dbuser group can access the DB with privileges layed out by the dba's,
> right?
>
> How do I allow this dbuser group access to sqlplus?
>
> Thanks,
> Jonathan

How about doing a unix set command and post the results here.

There's a script at the end of the oracle install which must be run as root. If run correctly this script should set the permissions correctly.

Go to your oracle home bin directory and do an "ll -ltr *" ... do the same for your lib directory ... post all the results here ...

That should let us see if that script was run correctly. Received on Sat May 05 2007 - 13:26:57 CDT