Re: Non-privileged users log into server, receive no response
- From: Igor Neyman <igor.neyman@xxxxxxxxx>
- To: gus.spier@xxxxxxxxx
- Date: Thu, 12 Nov 2009 11:59:08 -0500
Gus,
You mean PADDR in V$SESSION for your user is empty?
What about STATUS (in V$SESSION)?
Igor N.
On Thu, Nov 12, 2009 at 10:28 AM, Gus Spier <gus.spier@xxxxxxxxx> 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 ...
>
> <START SCREEN SIMULATION>
>
> $sqlplus dba_jim
> PASSWORD:
>
> <END SCREEN SIMULATION>
>
> 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
>
Other related posts:
