Re: Reserve some connections for SYS

From: Justin Mungal <justin_at_n0de.ws>
Date: Thu, 17 Jul 2014 02:05:22 -0500
Message-ID: <CAO9=aUyxqZ=MOMRiDaY_m5ZF9U75yFyuhmxsttTh8WujLigZ4w_at_mail.gmail.com>

I run into this same problem from time to time. Your comment inspired me. We have an RPM that sets up the pre-reqs for Oracle... it shouldn't be too hard to write a script that creates a "sqlplus / as sysdba" connection in a screen session, and then set that script up as a service with chkconfig. Hmm.

On Wed, Jul 16, 2014 at 3:37 AM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com> wrote:

> No, you cannot reserve process table entries for SYS.
>
>
>
> You’d have to have a pre-connected session as SYS in a terminal. You
> could protect that terminal by having it running in VNC behind a password.
>
>
>
> Hemant K Chitale
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *sumit Tyagi
> *Sent:* Wednesday, July 16, 2014 4:23 PM
> *To:* Oracle L
> *Subject:* Fwd: Reserve some connections for SYS
>
>
>
> Can we reserve some connections / processes only for SYS.
>
> ---------- Forwarded message ----------
> From: "sumit Tyagi" <dba.tyagisumit_at_gmail.com>
> Date: Jul 16, 2014 1:51 PM
> Subject: Reserve some connections for SYS
> To: "Oracle L" <oracle-l_at_freelists.org>
>
> Hi all,
>
> Can we some connections only for sys. Like below example:
> Max limit processes = 500
> For all other users use processes upto limit say 498 and give rest 2 for
> sysdba .
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
> .
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 17 2014 - 09:05:22 CEST