Re: Reserve some connections for SYS

From: Justin Mungal <justin_at_n0de.ws>
Date: Thu, 17 Jul 2014 02:06:06 -0500
Message-ID: <CAO9=aUzgXkUfyGx78txib_sLtu9XUHgoNh4zvz1Vzyz7g+9Qjw_at_mail.gmail.com>

(and add the aforementioned script / chkconfig setup to the RPM)

On Thu, Jul 17, 2014 at 2:05 AM, Justin Mungal <justin_at_n0de.ws> wrote:

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