Re: Oracle 10g2 on RHEL 5 - sqlplus problem

On May 27, 9:18 am, nuffno..._at_gmail.com wrote:
> On May 28, 12:09 am, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>
>
>
>
>
> > On May 27, 9:07 am, nuffno..._at_gmail.com wrote:
>
> > > On May 27, 11:57 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>
> > > > On May 27, 8:14 am, nuffno..._at_gmail.com wrote:
>
> > > > > Hi.
>
> > > > > I have jsut installed Oracle 10g2 on RHEL 5.  I create my listener
> > > > > file.  Set my environment variables (sid, ld library path, etc) and
> > > > > then, as the oracle user, I try to run sqlplus '/ as sysdba'.   It
> > > > > does nothing.   Doesn't report an error,  just returns me back to my
> > > > > prompt.
>
> > > > > I have absolutely no idea where to start to troubleshoot this.   I've
> > > > > been running this with RHEL3 for a couple of years now with no
> > > > > problems.  I need to upgrade because the new hardware I am getting
> > > > > doesn't support RHEL3, but if I can't get sqlplus running, it is a
> > > > > showstopper.
>
> > > > > Please help!
>
> > > > > Thanks!!
>
> > > > > nuffi
>
> > > > You might try running sqlplus /nolog instead, to see if you even see a
> > > > SQL> prompt or any banner information.
>
> > > Thanks for the response, David.
>
> > > It doesn't seem to matter what switches I use,  I get no response from
> > > sqlplus.  No SQL> prompt, no error,  nothing.  If I run it as root,  I
> > > get the expected "command not found" error.- Hide quoted text -
>
> > > - Show quoted text -
>
> > You did run root.sh at the appropriate place in the installation?
>
> > David Fitzjarrell
>
> I did, yes.  Would it be bad to do it again?- Hide quoted text -
>
> - Show quoted text -

Not to my knowledge as it sets file permissions.

If truss is available you might want to use it to reveal what, exactly, sqlplus is doing (or not doing) after you invoke it.

David Fitzjarrell Received on Tue May 27 2008 - 09:40:50 CDT