Re: Reserve some connections for SYS

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Sat, 19 Jul 2014 12:14:08 +0530
Message-ID: <CAFW4NVxP96x0CHWbSy3wu6Pw3YeqyWGz9LBegj3YdMAecmQhJQ_at_mail.gmail.com>

_at_Justin , you mean to create a script to connect as "sysplus / as sysdba" and keep it up as a service with chkconfig . Right ?

On Thu, Jul 17, 2014 at 12:36 PM, Justin Mungal <justin_at_n0de.ws> wrote:

> (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.
>>>
>>
>>
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

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

Received on Sat Jul 19 2014 - 08:44:08 CEST