Re: Reserve some connections for SYS
- From: sumit Tyagi <dba.tyagisumit@xxxxxxxxx>
- To: Justin Mungal <justin@xxxxxxx>
- Date: Sat, 19 Jul 2014 12:14:08 +0530
@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@xxxxxxx> wrote:
> (and add the aforementioned script / chkconfig setup to the RPM)
>
>
> On Thu, Jul 17, 2014 at 2:05 AM, Justin Mungal <justin@xxxxxxx> 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@xxxxxx> 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@xxxxxxxxxxxxx [mailto:
>>> oracle-l-bounce@xxxxxxxxxxxxx] *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@xxxxxxxxx>
>>> Date: Jul 16, 2014 1:51 PM
>>> Subject: Reserve some connections for SYS
>>> To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
>>>
>>> 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*
Other related posts:
