Re: Oracle 10g2 on RHEL 5 - sqlplus problem

On May 28, 6:12 am, "Matthias Hoys" <a..._at_spam.com> wrote:
> <nuffno..._at_gmail.com> wrote in message
>
> news:4b4306d5-e266-4c41-a7e3-74a4a5e6f275_at_f24g2000prh.googlegroups.com...
>
>
>
> > 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
>
> Do you run the *correct* sqlplus executable ? Try doing "which sqlplus" to
> see the location of the executable. Maybe there is a shell script with the
> same name which is found first in your path.
>
> Matthias

The sqlplus path is the same on myRHEL5 box as it is on my production RHEL3 boxes, but I have just noticed it is an empty file dated:

-rwxr-xr-x 1 oracle dba 0 Jun 30 2005 sqlplus (RHEL5)

instead of:

-rwxr-xr-x 1 oracle dba 8831 May 17 06:18 sqlplus (RHEL3) This is the same install media for both systems, why would the files be different? Received on Tue May 27 2008 - 19:40:55 CDT