Author: Rizwan Ansari
Access SD Card on Linux from Windows using VirtualBox
In order to use SD Card from Host OS (Windows) on Guest OS (Linux) through Oracle VirtualBox, follow below steps. Step 1 – Get the Device ID of your SD card reader. On Command Line enter below command wmic diskdrive list brief It will show something like this C:\Users\rizwan>wmic diskdrive list brief Caption DeviceID Model […]
Show Running Processes in Linux terminal
The Linux terminal has a number of useful commands that can display running processes, kill them, and change their priority level. top The top command is classic way to view system’s resource usage and view processes that are taking up most system resources. Top displays a list of processes, with the ones using the most […]
Ubuntu – Boot into Text Mode / Console / Command Line
First backup GRUB file sudo cp -n /etc/default/grub /etc/default/grub.backup Edit GRUB file sudo nano /etc/default/grub Make following changes Comment the line GRUB_CMDLINE_LINUX_DEFAULT=”quiet splash”, by adding # at the beginning, which will disable the Ubuntu purple screen. Change GRUB_CMDLINE_LINUX=”” to GRUB_CMDLINE_LINUX=”text”, this makes Ubuntu boot directly into Text Mode. Uncomment this line #GRUB_TERMINAL=console, by removing the […]
Oracle EM Configuration
Start Stop DBConsole Service for Oracle EM emctl status dbconsole emctl start dbconsole emctl stop dbconsole OC4J Configuration issue If you get following error in starting dbconsole OC4J_DBConsole__ not found then drop and re-create OC4J configuration first drop existing configuration and then create new. To drop existing configuration emca -deconfig dbcontrol db -repos drop To […]
Oracle connect remotely
If Oracle is not connecting from remote machine then in listener.ora file add one more listener apart from localhost (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<HOST NAME or NIC IP>)(PORT=1521))) If it is not connected after this then check firewall.
SQLPlus Snippets
SET LINESIZE <linesize> the length of the line. In most cases the maximum value for linesize is 32767 SET TRIMSPOOL ON otherwise every line in the spoolfile is filled up with blanks until the linesize is reached. SET TRIMOUT ON otherwise every line in the output is filled up with blanks until the linesize is […]
Import Oracle dump in different tablespace
Follow below steps to Import Oracle dump into different Tablespace With your .DMP file, create a SQL file containing the structure (Tables): imp <username>/<password>@<sid> file=<filename.dmp> indexfile=index.sql full=y Open the indexfile (index.sql) in a text editor and issue the following find and replace statements IN ORDER (ignore the single quotes): Find: ‘REM<space>’ Replace: <nothing> Find: ‘”<source_tablespace>”‘ […]
Customize the “Send To” Menu in Windows
If you want to add your own application or folder to the Send to menu then open the Run dialog box by pressing Win+R, then paste this command into the text box: shell:sendto This will open the folder where all shortcuts for send to menu are available. Alternatively, you can navigate to %UserProfile%\AppData\Roaming\Microsoft\Windows\SendTo Create a […]
Using comma separated value CSV parameter strings in SQL IN clauses
Below function when called with a CSV list returns a temporary table which can be used in “IN” of WHERE clause /****** Object: User Defined Function [dbo].[CSVTable] ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[CSVTable] (@InStr VARCHAR(MAX)) RETURNS @TempTab TABLE (id varchar(10) not null) AS BEGIN SET @InStr = REPLACE(@InStr + […]
Get query string values in JavaScript
Option 1 No need jQuery for that purpose. Just pure JavaScript: function getParameterByName(name) { name = name.replace(/[\[]/, "\\[").replace(/[\]]/, "\\]"); var regex = new RegExp("[\\?&]" + name + "=([^&#]*)"), results = regex.exec(location.search); return results === null ? "" : decodeURIComponent(results[1].replace(/\+/g, " ")); } Usage: var prodId = getParameterByName('prodId'); Option 2 var urlParams; (window.onpopstate = function () […]