Re: Can't start SQL*PLUS as users other than oracle -- SOLVED
Date: 11 Mar 1995 22:28:45 -0800
Message-ID: <3ju4at$cgf_at_ics.uci.edu>
In article <9559.794977444_at_ics.uci.edu>,
Wang-chan Wong <wong_at_ics.uci.edu> wrote:
>Hello there,
>
>I just installed oracle v6.0.36 to my machine (vax, ultrix). I tried
>to run the sqlplus/sqlforms/sqlmenu packages as a user other than oracle.
>I got the same problem, saying that message not found. However, I had
>no problem running sqldba.
>
>All packages works fine if I log in as oracle. Any hints? Thanks in
>advance. Please email me if possible.
>
>-- Wang
I found out what caused the problem. It was *not* because I forgot to set the environ variable ORACLE_HOME. Somehow after the installation, the privileges for the oracle's directories such as rdbms, sqlplus, sqlforms, etc were all set to 700. I reset them to 755 and it works fine. I wonder what went wrong in the installation process. The install.log did give a clue...
- Wang
-- Wang-chan WongReceived on Sun Mar 12 1995 - 07:28:45 CET