Last Protocol

How To complete Uninstall Oracle Database 11g/12g from windows

2021-07-11T11:32:00.006-07:00

AS we know Oracle database is very common & useful product but some time it create problems. There are may unknown issue occurred when we try to uninstall & install it again. Before re-installation, it must be cleaned from system every where. Many time Sysadmin need to format the system to reinstall the Oracle. We get lot of queries to uninstall to the organization. Some how we clean up the oracle & reinstall. it work fine.

Most of time issue come due to incomplete uninstall of previous Oracle. If we install the new setup then we need to confirm that previous version is properly uninstall & no more file left in system. Go through the complete article for uninstall oracle. It will help to save your unnecessary work to clean and deliver the task in optimal time.

Step1

First, Go to Start -> Run -> Services.msc, locate all Ora* services. disable & stop them

Step 2

Uninstall all Oracle components using the Oracle Universal Installer (OUI)

DEinstall Products One by one

Oracle universal installer

Step3

Go to Run window and type “%APPDATA%” with out double quotes and press enter.

Delete the Oracle named folder & sub-folder.

Step 4

Delete from Registry complete

HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE on 64bit

Step 5

Delete ORACLE_BASE directory. (i.e C:\Oracle)

Delete the directory C:\Program Files\Oracle.

Step 6

Delete temp Files & Disk cleanup for C drive. Click here check step 1-4 for disk cleanup.

Step 7

Now Restart the system & delete services related to Oracle

Delete any references to Oracle services/components in the following registry

Path: HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/.

find key entries starts with “Ora” which are related to Oracle and delete all.

It is always recommended to restart a machine on completion of software install / uninstall process.

Share your queries through comments,Happy to resolve your Issue. at earliest.

How to fix there are currently no logon servers available

2021-06-30T08:00:00.275-07:00

Error:

There are currently no logon servers available to service the logon request

The error message "There are currently no logon servers available to service the logon request" usually indicates that a client computer is unable to connect to a domain controller in order to authenticate a user account. Here are some potential causes and solutions for this issue:

1.Network connectivity issues:

Make sure that the client computer has a working network connection. connected to WIFi/LAN connection properly. Restart system & check. and that it can communicate with the domain controller(s). Check the IP address settings and DNS settings to ensure that they are correct.

2.Network Reset:

Usually when this error come you will not able to login with domain ID. you need to login with last login user or buid-in Administrator account or LAPS password used in organization. Once you able to login try to reset network . you can try below two command:

netsh winsock reset

netsh int ip reset

3. DHCP server not available

Might be case that DHCP server not allocating IP to system . That case you may get APIPA- IP 169.254.x.x. You need to check with Network people for this & get it fixed. You can try below command to IP release & renew.

ipconfig /release

ipconfig /renew

4. Try to set manual/Static IP & DNS server entry to system.

Below are the step to set Static IP for system/server:
1.Click on the Start button and select Settings.
2.Click on Network & Internet.
3.Click on Ethernet or Wi-Fi, depending on your network connection.
4.Click on Change adapter options.
5.Right-click on the network adapter you want to configure and select Properties.
6.Scroll down and select Internet Protocol Version 4 (TCP/IPv4) and then click on Properties.
7.Select "Use the following IP address" and enter the IP address you want to use. This should be an IP address that is within the same subnet as the other devices on your network.
8.Enter the Subnet mask and Default gateway information as provided by your network administrator or Internet Service Provider.
9.If needed, enter the DNS server information, which is also provided by your network administrator or Internet Service Provider. 10.Click OK to save the settings.
Once you have completed these steps, your computer should be configured to use the manual IP address you specified. Keep in mind that if you are on a network with DHCP enabled, your manual IP address configuration may not work properly, so be sure to verify with your network administrator that the IP address you are setting is available and not already in use.

5. W32Time:

Make sure NTP service-W32Time time on your DCs and clients match correctly.It must not differ more than by 5 mints.

6. Netlogon service on DC

Make sure Netlogon service running on DC. restart the service on DC & dependent services.

7. Hostfile entry need to verify

Due to some wrong entry in hostfile entry. DNS server is not reachable. Check & delete entry accordingly.

On my best practice, In this article highlighted the area where you can check & troubleshoot for Error no logon server. Hope you get solution & fixed for this.

How to Prevent Users to Install Removable Devices in Windows

2021-06-29T04:45:00.003-07:00

In the organization we prevent auto installation to secure the system to run malicious file.We have in-build policy to restrict the device Installation.This policy setting allows you to specify a list of Plug and Play hardware IDs and compatible IDs for devices that Windows is prevented from installing. This policy setting takes precedence over any other policy setting that allows Windows to install a device.

If you enable this policy setting, Windows is prevented from installing a device whose hardware ID or compatible ID appears in the list you create. If you enable this policy setting on a remote desktop server, the policy setting affects redirection of the specified devices from a remote desktop client to the remote desktop server.

If you disable or do not configure this policy setting, devices can be installed and updated as allowed or prevented by other policy settings.

We prevent USB or any device auto installation with two method

Method-1 Group Policy setting

Method-2 Registry setting

Method-1 Group Policy setting

Go to Run(Win+R) type gpedit.msc (make sure login with admin account)

Computer configuration->Systems->Device Installation-> Device Installation Restriction

Method-2 Registry setting

Go to Run(Win+R) type regedit (make sure login with admin account)

HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\DeviceInstall\Restrictions

DenyRemovableDevices DWORD

(delete) = Enable
1 = Disable

How to enable blocked USB/CD/DVD ROM Drives in Windows-10

2021-06-28T08:00:00.007-07:00

Today's time every organization tried to secure the system to get unauthorized access. Many time user try to connect Pen drive or any USB & found it is blocked by organization/school/collages. If we connect mobile it will allow for charging but you can't access for file transfer. Admin must block USB/ CD Rom to prevent the data theft. There are may ways you can enable or disable the USB.

1. Group policy setting

2. Services

3. Registery setting

4. Device Manager

1. Group Policy setting

Go to Run(Win+R) type gpedit.msc (make sure login with admin account)

Computer configuration->Systems->Removable storage Access->and change settings same as below:

Enable: Disable the USB access.

Disable/ Not configure: Enable the access

2. Portable Device Enumerator Services

Enable for access USB & disable for block

3. registry setting

Computer>HKEY_LOCAL_MACHINE>SYSTEM>CurrentControlSet>Services

HKLM->system->current control set->services->CDFS
• Change the value of start to 3 for Enable & 4 for disable

HKLM->system->current control set->services->CDROM
• Change then value of start to 3 for Enable & 4 for disable

HKLM->system->current control set->services->USBSTOR
• Change then value of start to 3 for Enable & 4 for disable

4. Device manger

Go to Start and type Device Manager>> right click>>run as Administrator

You can check below setting to enable or disable the USB driver as below :

NO matter what USB blocked. You can check above all step cross verify the USB setting for Enable/ Disable the USB / CD drive. I tried all setting my system USB Unblocked. Although 1 more setting for Device installation restriction. click here to check for setting.

Only part of readprocessmemory or writeprocessmemory request was completed

2021-06-15T11:58:00.002-07:00

Only part of readprocessmemory or writeprocessmemory request was completed

The User Profile Server service failed the logon. User profile can't be loaded and logout

When we work on windows system. Many times we encounter the above screenshot error. I also got the same issue. I was trying to login my system with new user account but It suddenly gave me error-" The User Profile Server service failed the logon. User profile can't be loaded and logout".

While login with other user account which is already login profile present, did not get any error. Also I tried to run any application with different user to create my profile and got error- "Only part of readprocessmemory or writeprocessmemory request was completed".

This error also come when we are installing any application. I am pretty sure error come due to some read write process save data on os. Might be some background process running which is not allowing to read or write the request on OS label issue.

It was very tough to me find out the way to create new create new user profile. I tried my best to resolve this issue.

On troubleshoot part:-

I Tried for Reboot system which doesn't work at all. also tried to repair scan disk. Clear temp files. window restore to last good configuration. Still not work. I was totally frustrated. Finally got the solution.

Solution:-

You can try to delete INT Temp File

C:\Users\default\AppData\Local\Microsoft\Windows\Temporary Internet Files

Note:- Default is hidden folder you need to view the hidden item as below folder setting.

Once the bad temporary file is removed, you can try for login. Now you can not see the error anymore, if it still appears then Try below file replaced with working system.

C:\Users\default

I think while doing above only solution will help you a lot to save your busy schedule time. The purpose of my blog to get optimal solution for last protocol. you don't require other more solution to go other site. Keep visit for more solution for Windows/Linux/Servers and many more.

How to Disable Shut Down, Restart, Hibernate and Sleep in Windows 10

2021-05-30T06:09:00.009-07:00

Many user use the power option to Shut Down, Restart, Hibernate and Sleep. Usually we take remote to physical machine or virtual machine & shutdown the system. It very difficult to start the physical machine because it required to do physically.

Admin can restrict user to use power menu option to avoid shutdown. There are different ways to disable the power option, so that user can not do it self to Shut Down, Restart, Hibernate and Sleep in Windows 10. If we disable the power menu option available in Windows. It reduces the workload of Admins.

This will not affect the Alt+F4 Windows dialog & CMD command to Shut Down, and will not prevent users from using other methods to sleep, hibernate, shut down, or restart.

After applying the policy. Use can't see the option to Shut Down, Restart, Hibernate and Sleep as below screenshot.

Perform any below method to Enable or Disable Power option. You can apply any one of then to restrict. I as System Admin preferer method 2 to use to restrict all user to use Power option.

Method 1.

Enable or Disable Shut Down, Restart, Sleep, and Hibernate in Power Menu for All Users in Local Group Policy Editor

1.1 Edit group policy Go to Run(Win+R) type gpedit.msc

1.2 Go to Computer Configuration>> Administrative Templates>> Start Menu and Taskbar.

Remove and prevent access to shutdown, Restart, Sleep and hibernate commands- change to enable for restrict.

1.3 change not configured or disable - To show option

Enable- To disable option

Method 2

Enable or Disable Shut Down, Restart, Sleep, and Hibernate in Power Menu for All Users using a REG file

2.1 open registry Editor as admin- Go to Run(Win+R) type regedit

2.2 By default no entry will be found. you need to create Go to path

[Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\Explorer]
"HidePowerOptions"=_
1 -To Disable option
0- To Enable option

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

User can use above 2 method to restrict but user below command to Shut Down, Restart, Hibernate and Sleep in Windows 10

Method 1

ALT+F4

Method 2

Go CMD type below command as per requirement

To shut down system                  Shutdown -s
To Restart system immediately        Shutdown -r -t 1
To Abort a system shutdown           Shutdown -a

How to fix- Automatically Log off Idle Remote Desktop Sessions in Windows

2020-09-30T08:22:00.003-07:00

Many Times we take Remote(RDP) & if it is more 30 mint. login account get disconnected & your unsaved data get lost. It is not your fault but due to data loss, I feel angry on myself.

This feature is enabled In many organization. An idle/ inactive session consume CPU resources and memory. let us take an example- In case of server, 100 users are login but at a time only 3-4 user work. Since feature for limit RDP IDL session is not configured so the user who haven't logout their active session consume huge no. CPU & RAM Utilization. The best way to kick out the IDL user from login session which helps alot to save RAM & CPU to overload.

If the feature enabled in system. Regularly we get this popup. Normally don't see such since we are not using RDP.

For solution, User must click to ok or provide input otherwise session will time out & login account get sign-out/Logoff in 2 mint.

If you want to turn off the feature from you system/Server then Configure Timeout and Reconnection Settings for Remote Desktop Services Sessions

Go to Run(Win+R) type gpedit.msc (make sure login with admin account)

Computer Configuration > Administrative Templates > Windows Components > Remote Desktop Services > Remote Desktop Session Host > Session Time Limits

Now double click on click on

set time limit for active Remote Desktop Services Sessions 

  Disable or not configure or enable accordingly for limit the time

If you want to stop this feature either not configured to all set time limit as shown in screenshot.

Now My system not get auto signout :)

The system can't find the file specified. C:\Windows\system32\\mstsc.exe.MUI

2020-09-19T05:54:00.006-07:00

The system cannot find the file specified. C:\Windows\system32\LANG_NAME>\mstsc.exe.MUI

Yesterday My system got windows Update. Now I am trying access Remote- MSTSC & getting above Error after windows restart. I am using latest windows 10 build version 1909. I don't know how this thing happened. I uninstalled the latest patch installed but it doesn't work. I don't want to reinstall windows or restore to last good configuration. I tried a lot to find the solution.

There are some system file missing or got corrupted. So I tried to file as shown in error.

Tried below file replaced with working system & get issue resolved.

Go to path C:\Windows\System32\en-US & replace to file to working system

c:\windows\system32\en-us\mstsc.exe.mui
c:\windows\system32\en-us\mstscax.dll.mui

Finally issue resolved :)

How to fix- The Group Policy Client service failed the logon. Access denied

2020-06-08T12:42:00.001-07:00

The Group Policy Client service failed the logon. Access denied

Many time we Encounter the above error -The Group Policy Client service failed the logon. Access denied. this error comes when user profile get corrupted or User profile permission issue. For that we need to login the system with local system admin.

As per my Experience, Resolution for this will different for different system. I am just providing in sequence to apply one by one and check. It will 100% work.

1. Enable Inheritance & replace all child object permission with inheritable object
2. Restart Group Policy Service and Reset Winsock
3. Replace NTUSER.DAT with working system
4. Delete user account

1. Enable Inheritance & replace all child object permission with inheritable object

Many Times, There is issue access permission issue to folder and sub folder in user profile for that we need to give permission as parent folder. This best way to give access permission at single to to all by enabling inheritance to folder security

1.1 go to c:\users\%Userprofile% right click Properties-> security tab

1.2 click advance

1.3 Click Enable Inheritance. and check the box to replace child object with inheritable permission. If this button is not available, that means that Inheritance is already enabled.

1.4 click yes and continue

Many times some folder is in use. it will ask for continue. Just click and proceed for continue.

Now log off and try for login the system with profile having issue. Most of time it work. If it not work then try other method

2. Restart Group Policy Service and Reset Winsock

Many time by restating the service-Group Policy client

2.1 Go Run( Win+R ) Type services.msc

2.2 Restart the service Group Policy client and Change its Startup type to Automatic, Click on the Start button, and then Apply > OK.

2.3 Now open CMD as admin Type the command and hit enter.netsh winsock reset

3. Replace NTUSER.DAT with working system

Now copy the NTUSER.DAT file from other working system or other profile present in system

3.1 File is hidden so you need to enable to show hidden item & file extension. Just go to user profile and view on top and check the box for hidden item.

3.2 Once Hidden item enabled, you will able to see the NTUSER.DAT file at last

3.3. Now copy and past in other user profile having issue. you may copy the same file from other system as well.

4. Delete user account

Note:- Before deleting User Profile you must take backup files. It may leads to data loss after deletion of profile.
Now above all 3 method not work then Last option we have only to delete user Profile

4.1 Go to run type sysdm.cpl and Advance tab --> User Profile-->settings

4.2 In the User Profiles dialog box, select the profile of your affected user account and click on Delete.

Now Delete the profile. IT may take time depends on size of Profile.

51 Shortcuts for SysAdmin to Boost Productivity

2020-05-31T11:57:00.001-07:00

Today's Work Environment we have to support more project then we expect. Due to Limited System Admin in office increase the workload with you. To maximize the Productivity, we need to do smart work. For that we need to get shortcuts process to skip multiple clicks.

In This article you will get all shortcuts of windows to Boost Productivity and save Valuable time.
Here I am skipping basic short like cut copy past Win+L which every SysAdmin Know.

Note:- All command work in command Promt(cmd) & run Windows

Shortcut Commands	Purpose
appwiz.cpl	Uninstall or change program
inetcpl..cpl	Internet option
powercfg.cpl	power Option
firewall.cpl	firewall setting
main.cpl	mouse Pointer option
ncpa.cpl	Network connections
compmgmt.msc	computer Management
sysdm.cpl	system Properties
gpedit.msc	Local group Policy editor
secpol.msc	Local Security Policy
printmanagement.msc	Printer Management
diskmgmt.msc	Disk Management
lusrmgr.msc	local group & user setting
devmgmt.msc	device Manager
fsmgmt.msc	share Folders
tpm.msc	TPM Management
services.msc	Service Management
mstsc	Remote Desktop connections
msra	Windows Remote assistance
cmd	command Prompt
poweshell	Power shell
printui	printer User Interface
rstui	system restore
recdisk	recovery tool
dxdiag	direct X diagnostic tool
dfragui	disk Fragment User Interface
sdclt	Backup & Restore
computerdefaults	computer default settings
mspaint	Microsoft Paint
notepad	NotePad
lpksetup	Install-Uninstall display language
taskmgr	task Manager
osk	keyboard
sethc (press 5 times shift key)	Sticky key setting
narrator	Narrator
magnify	Magnifier
quickassist	Quick assist window App
write	Word Pad
calc	Calculator
msdt	Microsoft support diagnostic tool
regedit	registry editor
winver	Windows version
UserAccountControlSettings	Change user account Settings
wscui.cpl	Security & maintenance
eventvwr	Event Viewer
control system	System properties
Perfmon	performance Monitor
resmon	Resource Monitor
msinfo32	System Information
cleanmgr	clean management
wf.msc	windows Firewall

Fix: Remote Desktop Connection ‘ An Internal Error has Occurred’

2020-05-17T10:39:00.004-07:00

Remote Desktop An Internal Error has Occurred

Many time we need to take remote to system connected in Network Domain. We take RDP through windows default Remote desktop tool(MSTC). After Entering Hostname/IP of System to connect, It freezes and Error-" Internal error Has Occurred " pop comes after few second. Many times, We restart system and it fix. But after few hours, It again come with same error.

As per my Experience Exact cause for the Error-" Internal error Has Occurred "is due to group policy security implemented in organisation. I did all below setting to fix the issue. & once done all setting Never faced issue for Internal Error.

1. RDP Security change in Local Group Policy
2. Terminal server Outstanding connection change

3. Group policy- Remote desktop security
4. Domain Rejoin

** Make sure all setting done with administrative account only**

1. RDP Security change in Local Group Policy

1.1 Edit group policy Go to Run(Win+R) type gpedit.msc

Go to Computer configuration>Windows Component>Local Policies>Security Options>

System cryptography: Use FIPS complaint algorithms for encryption , hashing and signing

1.2 By Default is Disabled. If it is Enabled then Disabled Or it is Disabled then Enabled it

2. Terminal server Outstanding connection change

You may workaround for this issue is to increase the maximum outstanding connections limit. On client it is 100 by default, while for server it is 10000. The following DWORD registry key controls this value:

Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\

DWORD: MaxOutstandingConnections

VALUE: 10000

3. Group policy- Remote desktop security

Go to Run(Win+R) type gpedit.msc

Computer Configuration >> Administrative Templates >> Windows Components >> Remote Desktop Services >> Remote Desktop Session Host >> Security

Set Require secure RPC Communication & Require USE SSL for RDP Connection to Not configure or disabled

In case already have setting Not configured then Enable to Require USE SSL for RDP Connection as RDP

4. Domain Rejoin

4.1 Go to Run(Win+R) type sysdm.cpl

4.2 Under Computer name tab, domain, and workgroup settings, click Change settings.

4.3. Under member of select Work group and type any name as workgroup (ex-xyz) and click OK

4.4 Now it will ask for credential to unjoin. Now type any crendial or domain ID having Domain rejoin access.

4.5 Click OK, and then restart the computer

4.6 follow same process 3.1 and select domain (compnydomain.com) and join

After apply all above 4 steps Till time not found same issue. Share your views any issue for RDP.

7 Ways to Get out of Low Disk Space & boost speed of Windows 7/8.1/10

2019-04-21T11:44:00.004-07:00

Are you facing Issue with Low disk space? Drive showing Red? System hang??? Nothing in drive but no space in C drive? Then you come to right place to find and understand the basic concept to clean up system without using any 3rd party software.

Below process to remove all unwanted data and clean system time to time. Which make system faster

1. Delete Temp files

Temporary files are basically files created before we unsaved data. once we save data it delete but some system encrypted file saved in location C:\Windows\Temp directory with unique name. We have manually delete the file time to time.

Go to Run(win+R)-type temp. Select all files and delete. Some file may not get delete. you can skip and continue.

2.User’s temp files

User temporay files are similar to system temp files. only difference it is specific to partical to user profile folder Location -C:\Users\UserProfile\AppData\Local\Temp

Go to Run-type %temp% Select all files and delete. Some file may not get delete. you can skip and continue.

3. Clean Prefetch files

Prefetch are basically the co related to catche. It is spesific data of perticular application to run faster than normally. but some continuous user of application/ system. It become full. so time to time we need to clean the prefetch

Go to Run-type prefetch Select all files and delete. Some file may not get delete. you can skip and continue.

4.Use Disk Clean-up Utility

1. Open Windows Explorer, right-click the C drive and select “Properties.”
2. Click “Disk CleanUp,” then new window of Disk clean up open. Then click “Clean up system files” to open the advanced disk cleanup window or click OK to clean.

5.Disable Hibernation

Everyone is using the Hibernate and sleep option in Laptop system. Normally we hibernate the system. once we start system again back to same position as we left before power option used Hibernate
As much as application, browser tab and other windows open before hibernate. It take space to save the suspected point. Its batter to save data and off hibernate option. You may get 5-10 GB space by turning of Hibernate to system.

Click Start, and then type cmd in the Start Search box. ...
In the search results list, right-click Command Prompt or CMD, and then click Run as Administrator.
When you are prompted by User Account Control, click Continue.
At the command prompt, type powercfg.exe /hibernate off, and then press Enter.

6.Disk Defragmention

When our hard drive become old. Disk Space get full. For new file to write we need to delete old data. Once we delete old data to save new file, Gaps are created. Since New data not fit to gap. It save to multiple sector of hard disk Which is called fragmented data. Once we read the fragmented data. It become slow to read from multiple sector. Disk Fragment help to optimize our hard disk and store similar file to save same place to read faster which make system faster.

Go to start> search for disk fragment

7.Virtul Memory

This is the best concept to utilize your system free disk space as virtual RAM. Most of people does know about this. From this way you can make can increase system performance faster.

Go to My computer>properties>Advance system Setting