Re: Oracle 9i on Mandrake 9.2 Linux

Neil Holmes wrote:
>
> Have any Mandrake 9.2 users been successful in installing Oracle 9i on
> their systems ? I have managed to install 9.2.0.1, primarily relying
> on the instructions for Red Hat on www.puschitz.com. Oracle seems to
> work fine but only as the "oracle" user. I haven't been able to get it
> to work for any other user. I have checked my steps by going over them
> 3 times now (removed oracle and started again).
>
> The problem I get, initially, when connecting to sqlplus as a user is
> :-
>
> ORA-01034: ORACLE not available
> ORA-27123: unable to attach to shared memory segment
> Linux Error: 13: Permission denied
>
> I have been down all the shared memory routes with this as suggested
> on puschitz.com. I then started to follow threads that I read about
> permissions on the oracle binaries. I tried changing the oracle binary
> itself to have the permissions "-rwsr-s--x". This changed my
> connection error to :-
>
> oracletest: error while loading shared libraries: libodm9.so: cannot
> open shared object file: No such file or directory
> ERROR:
> ORA-12547: TNS:lost contact
>
> Maybe more permissions problems ?
>
> Anyway. I am well out of my depth now and would appreciate some
> pointers if anyone can help ?
>
> Many Thanks
>
> Neil

These other 'users' ... what are the environment variables set in bash? Simplest check is "set | grep ORA" and that should match up the same set (ORACLE_HOME, ORACLE_SID, etc.) as your oracle owner. Other env vars that contain 'ora' should match up as well. Most of the time that should be set up properly by running "oraenv" which might be in /usr/local/bin

While it's set up for W2K, you should consider following the Oracle By Example site at http://otn.oracle.com/obe/start/index.html for some step-by-step tutorials. Any serious Linux person should have no major trouble translating the stuff (other than initial install) from Windows to Linux since Oracle is pretty transparent.

You also want to spend some time re-reading the Concepts manual at http://docs.oracle.com

HTH
/Hans Received on Sat Jan 03 2004 - 17:01:54 CST