Tuesday, June 21, 2016

How to DISABLE CASE SENTIVITIY of SCHEMA Logins in ORACLE

* Check the current status of the CASE Sensitive parameter.

1) Log in to database as SYS or SYSTEM

C:\sqlplus system/password@PIONEERS


SQL> show parameter case;

Output will be like below.

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
sec_case_sensitive_logon             boolean     TRUE


* Alter the value and disable the CASE sensitivity.

SQL> alter system set sec_case_sensitive_logon=FALSE;

"System altered." message will be appear.

*  Check the new status of the CASE Sensitive parameter as mentioned in the first step.

SQL> show parameter case;

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------
sec_case_sensitive_logon             boolean     FALSE

Wednesday, June 8, 2016

How to enable multiple remote connection for windows server 2012


How to enable multiple remote connection for windows server 2012
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 go to command prompt and update the group policy using below mentioned command.

Go to command prompt and type -> gpupdate and enter it. it should be successfully applied.