RESOLVED: Non-privileged users log into server, receive no response

  • From: Gus Spier <gus.spier@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 16 Nov 2009 11:34:41 -0500

Authoritative Details:

Unidentified individual edited a Scheduler Window or created a new Scheduler
Window to run routine maintenance scripts during the evening hours.
However, it appears that the INTERNAL_QUIESCE was selected as the default
management plan.  See the oracle bugs 5410619 and 5647809.

That allowed connection as sys or system, but no others.

It's all documented in Note ID 396970.1

Regards,

Gus



On Thu, Nov 12, 2009 at 11:59 AM, Igor Neyman <igor.neyman@xxxxxxxxx> wrote:

> 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: