Tip of the Day - Remote Sessions for Windows SQL server

How to enable multiple remote connection for windows server 2012/2014
Answer:

1. Open command propmt

2. Write gpedit.msc and open it

3. Go to

computer configuration -> Administrative Tempalates -> Wondows Components
->Remote Desktop services -> Remote Desktop Session Host -> Connections.

4. Here Disble the below mentioned.

Restrict Remote Desktop Services user to a single remote.....

NOw goto command propmt and update the group ploicy using below mentioned command.

Goto command propmt and type -> gpupdate and enter it. it should be successfully applied

Comments

Oracle Part

Process Increase due to error sometimes : SQL> connect / as sysdba ERROR: ORA-00020: maximum number of processes (300) exceeded or java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found Steps to increase the number for processes/sessions at database level in Oracle is as follows 1. Log on to the database as system administrator In SQL Plus enter: " connect / as sysdba " 2. Set the number of processes to be desired value In SQL Plus " alter system set processes= scope=spfile " 3. Unset the number of sessions to remove the default session limit In SQLPlus " alter system reset sessions scope=spfile sid='*' " 4. Shutdown the database In SQL Plus " shutdown immediate " 5. Startup the database In SQL Plus " startup " 6. Check the changes have taken effect. In SQL Plus...

Explain Plan Vs Execution Plan

Explain Plan DELETE PLAN_TABLE EXPLAIN PLAN FOR SELECT COUNT(*) FROM ARADMIN80.T3293 WHERE ((((T3293.C230000009 = 'MAINCHANGE') AND ((T3293.C301813800 = '20001-Test') OR (T3293.C1000000337 = '20001-Test')) AND (T3293.C1000003561 >= 1) AND (T3293.C1000003561 <= 9)) OR ((T3293.C230000009 = 'MAINHELPDESK') AND (T3293.C301813800 = '20001-Test') AND (T3293.C1000003561 >= 0) AND (T3293.C1000003561 <= 3)) OR ((T3293.C230000009 = 'MAINWORKORDER') AND (T3293.C301813800 = '20001-Test') AND ((T3293.C1000003561 = 0) OR (T3293.C1000003561 = 1) OR (T3293.C1000003561 = 2) OR (T3293.C1000003561 = 3) OR (T3293.C1000003561 = 4))) OR ((T3293.C230000009 = 'MAINKNOWLEDGEDATABASE') AND (T3293.C301813800 = '20001-Test') AND (T3293.C1000003561 >= 4) AND (T3293.C1000003561 <= 4)) OR ((T3293.C230000009 = 'MAINKNOWNERROR') AND (T3293.C301813800 = '20001-Test') AND (T3293.C1000003561 >=...

Ansible - Agentless Architecture DevOps

Ansible Ansible is an open source IT configuration management, deployment, and orchestration tool. It is unique from other management tools in many respects, aiming to provide large productivity gains to a wide variety of automation challenges. Example From YouTube - Short Videos - Quick to learn about Ansible :)

Gorakshnath

Search This Blog