Sync Windows Time with External NTP Server

​​Time synchronization is an important aspect for all computers on the network. By default, the clients computers get their time from a Domain Controller and the Domain Controller gets his time from the domain's PDC Operation Master. Therefore the PDC must synchronize his time from an external source. I usually use the servers listed at the NTP Pool Project website. Before you begin, don't forget to open the default UDP 123 port (in- and outbound) on your (corporate) firewall.

1. Log in to your PDC Server and open the command prompt.
2. Stop the W32Time service: C:>net stop w32time
3. Configure the external time sources, type: C:> w32tm /config /syncfromflags:manual /manualpeerlist:3.in.pool.ntp.org
4. Make your PDC a reliable time source for the clients. Type: C:>w32tm /config /reliable:yes
5. Start the w32time service: C:>net start w32time
6. The windows time service should begin synchronizing the time. You can check the external NTP servers in the time configuration by typing: C:>w32tm /query /configuration
7. Check the status of the Clock Synchronization by typing : C:>w32tm /query /status

From Above image you can verify your Time Service is synced with External NTP Server and Last successful Sync Time.

​

Ubuntu 12.04 Grub to boot into single user mode

​Steps to boot in single user mode in Ubuntu 12.04:

Step 1: When you start your system, press "shift" key continuously to get the grub loader screen.

Step 2: In Grub 2 menu, select the menu with Linux 3.2.0.23-generic-pae highlighted.

Step3: Press 'e' to edit the grub2 menu.

Step 4:  Move the cursor to the line that starts with "linux /boot/vmlinuz-3.2.0-23-generice-pae".

Step 5: Change the content "ro quiet spalsh $vt_handoff" To "rw init=/bin/bash".

Step 6: Press "Ctrl+x" to continue boot to in single user mode.

Step 7: Now you will get prompt of the root user.

Step 8: Change root user password,
# passwd root

Step 9: Now sync and reboot the system i.e.
# sync
# reboot -f​

Eclipse birt environmental setup

Eclipse required 32 bit java environment.

In eclipse.ini file,add java version is requied for that specific Eclipse version.

For windows:

-startup
plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar
–launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.1.100.v20110502
-showsplash
org.eclipse.platform
–launcher.XXMaxPermSize
256m
–launcher.defaultAction
openFile
-vm
C:\Program Files (x86)\Java\jdk1.6.0_25\bin\javaw.exe
-vmargs
-Xms40m
-Xmx384m

For Linux:

-startup
plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar
–launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.1.100.v20110502
-showsplash
org.eclipse.platform
–launcher.XXMaxPermSize
256m
–launcher.defaultAction
openFile
-vm
/opt//opt/jdk1.6.0_43/jre/bin/java
-vmargs
-Xms40m
-Xmx384m

Allow non-admin user to shutdown/reboot Window Server

​You can assign this in either a GPO or Local Security Policy.

The setting that you're looking for is in Computer Configuration > Windows Settings > Security Settings > Local Policies > User Rights Assignment > Shutdown the system

​

Granting Users to see the Definition of Stored Procedure created by Super User

Problem:

The Users in MySQL could not able to view definition of the store Procedures that are created by super users…

Cause:

You have to grant your "application user" select permissions on mysql.proc otherwise the connector can't see the sproc you're trying to call through it.

Solution:

Login as super user and grant the following select privilege to user who want to see the definition of stored procedure..

grant select on mysql.proc to user@localhost;

SQL Developer can’t start because MSVCR71.dll is missing (On Windows)

​

SQL Developer on Windows received above system error: due to mismatch of Java version.

Fix the issue by following steps:

1. Run regedit (remember to run it as the administrator)
2. Expand HKEY_LOCAL_MACHINE
3. Expand SOFTWARE
4. Expand Microsoft
5. Expand Windows
6. Expand CurrentVersion
7. Expand App Paths
8. At App Paths, add a new KEY called sqldeveloper.exe
9. Expand sqldeveloper.exe
10. Modify the (DEFAULT) value to the full pathway to the sqldeveloper executable (See example below step 11)
11. Create a new STRING VALUE called Path and set it value to the sqldeveloper pathway + \jdk\jre\bin                                                                                 
12. After the step 11 is completed, you van able to access sqldeveloper.exe

Grant select on all views and tables to user in Oracle

​To grant select on all views to  user, execute the query as follows

Query:

"select 'grant select on '||view_name||' to <user_name>;' from user_views"

 

To grant select on all tables to user, execute the query as follows

Query:

"select 'grant select on '||table_name||' to <user_name>;' from user_tables"

​