FAQ
Solaris 10
Oracle 10.2.0.3
RAC, 2 node

So, a non-privileged user (not sys, system, et alia) does secure shell to
the database and attempts to invoke sqlplus. The user supplies the correct
password and expects to see the sql prompt, the banner information, and
whatever environment has been set up for him.

(The user can attempt this from a regular client with the same results)

Instead, the user sees no activity on his terminal ...

$sqlplus dba_jim
PASSWORD:

Troubleshooting as reported by the other DBAs on the team. They include
rebuild the catalog and other basic activities (not immediately available to
me for this email).

We log in to the server as sys or system (as sysdba) and look at the
V$SESSION view. We see the session(s) for the user. Further, we look at
the V$PROCESS view and realize that there is no process associated with that
session!

Servers are DEDICATED (vice SHARED)

An SR has been filed. The system is in late development stages and
prototypes have been circulated about the user community. Anxiety mounts
and we cannot figure out why user sessions do not begin correctly.

Has anyone seen anything like this? We could sure use the help

Fond regards,

Gus

Search Discussions

  • Bobak, Mark at Nov 12, 2009 at 3:56 pm
    Hi Gus,

    First thought, check the permissions on the 'oracle' binary:
    ls -l $ORACLE_HOME/bin/oracle

    Second thought, try connecting via SQL*Net, something like:
    Sqlplus dba_jim_at_yourconnstr

    Third thought, you might try trussing the sqlplus process, something like:
    truss -f sqlplus dba_jim

    The '-f' option is to follow forks, so you'll also see trace of the server process, in addition to the trace of the sqlplus process running in the foreground. If you're not experienced reading the output, it can be a bit painful, but it's also often enlightening as to where stuff is getting hung up.

    Hope that helps,

    -Mark

    From: oracle-l-bounce_at_freelists.org On Behalf Of Gus Spier
    Sent: Thursday, November 12, 2009 10:29 AM
    To: oracle-l
    Subject: Non-privileged users log into server, receive no response

    Solaris 10
    Oracle 10.2.0.3
    RAC, 2 node

    So, a non-privileged user (not sys, system, et alia) does secure shell to the database and attempts to invoke sqlplus. The user supplies the correct password and expects to see the sql prompt, the banner information, and whatever environment has been set up for him.

    (The user can attempt this from a regular client with the same results)

    Instead, the user sees no activity on his terminal ...

    $sqlplus dba_jim
    PASSWORD:

    Troubleshooting as reported by the other DBAs on the team. They include rebuild the catalog and other basic activities (not immediately available to me for this email).

    We log in to the server as sys or system (as sysdba) and look at the V$SESSION view. We see the session(s) for the user. Further, we look at the V$PROCESS view and realize that there is no process associated with that session!

    Servers are DEDICATED (vice SHARED)

    An SR has been filed. The system is in late development stages and prototypes have been circulated about the user community. Anxiety mounts and we cannot figure out why user sessions do not begin correctly.

    Has anyone seen anything like this? We could sure use the help

    Fond regards,

    Gus
  • Stephane Faroult at Nov 12, 2009 at 4:17 pm
    Gus,

    This is a very, very stupid idea but are you absolutely sure that
    "sqlplus" invokes the program you think it does? I'd try "whatis
    sqlplus" first ...

    I have already, in the past, created an alias for SQL*Plus to discourage
    users to pass their password on the command line ...

    SF

    Gus Spier wrote:
    Solaris 10
    Oracle 10.2.0.3
    RAC, 2 node

    So, a non-privileged user (not sys, system, et alia) does secure shell
    to the database and attempts to invoke sqlplus. The user supplies the
    correct password and expects to see the sql prompt, the banner
    information, and whatever environment has been set up for him.

    (The user can attempt this from a regular client with the same results)

    Instead, the user sees no activity on his terminal ...
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 12, '09 at 3:28p
activeNov 12, '09 at 4:17p
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase