Pubudu: Data and Decisions

Problem: In SQL Worksheet you cant edit or use back space. This may happen on newly installed Oracle SQL Developer. Solution: Go to    Tools | Preferences | Accelerators and press    Load Preset . Then it'll   l oad the default preset. Then try again to edit.

Error: Failed to open a session for the virtual machine VT-x features locked or unavailable in MSR. (VERR_VMX_MSR_LOCKED_OR_DISABLED) The details are: Result Code: E_FAIL (0×80004005) Component: Console Interface: IConsole {1968b7d3-e3bf-4ceb-99e0-cb7c913317bb} Solution: You have to change the processor Number to get rid of this error. So go to vitual-Box Machine–>setting–>system–>Processor–> change the CPU No. to 1. Then restart the VM and it'll work.

The Oracle SQL developer is NOT supported on 64 bits JDK. Your PC environment may be : Database : Oracle 11g / OS Platform : Windows 7 Ultimate 64 bits / JDK : 1.6 .0_24, 64 bits So it will give you an error when trying to open SQL Developer. When you click on the Oracle SQL developer, it prompts you to give the JDK folder location. However, after you specified the correct JDK folder, it prompts you following error dialog box : Unable to find Java Virtual Machine. To point to a location of a Java Virtual Machine.... Solution To solve it, install a 32 bits / x86 JDK and update your SQL developer config file, so that it points to the 32 bits JDK. Edit the “sqldeveloper.conf“, which can be found under {ORACLE_HOME}\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf , make sure “SetJavaHome” is pointing to your 32 bits JDK.

To list only usernames type the following awk command. awk -F':' '{ print $1}' /etc/passwd Eg: [root@jbsvr u01]#   awk -F':' '{ print $1}' /etc/passwd root bin daemon adm lp sync shutdown halt mail news uucp operator games gopher ftp nobody rpm dbus nscd vcsa pcap rpc mailnull smmsp sshd rpcuser nfsnobody haldaemon avahi apache ntp xfs gdm sabayon jboss jbtest apacheds avahi-autoipd oprofile exim oracle orafin amandabackup

Step1:  Mount the OS disk and copy the contents to a local path which will be the main repository path: mkdir -p /linuxdvd/   cp -RH /mnt/dvd/* /linuxdvd/ Step2:  Create new yum repository (e.g. rhel-local.repo) Create the repo file vi /etc/yum.repos.d/rhel-local.repo   Insert the below content to the file.Change the details according to your environment. [rhel6.3-local] name=RHEL 6.3 local repository baseurl=file:///linuxdvd/ gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release enabled=1  

Issue below command in DOS prompt. convert <Drive Letter>: /fs:ntfs Eg: C:\Documents and Settings\pubudu>convert l: /fs:ntfs The type of the file system is FAT32. Volume PUBUDU-SUPP created 8/3/2012 4:29 PM Volume Serial Number is B0FB-D07D Windows is verifying files and folders... File and folder verification is complete. Windows has checked the file system and found no problems.    15,609,312 KB total disk space.            32 KB in 4 hidden files.         3,344 KB in 413 folders.     3,453,464 KB in 2,611 files.    12,152,464 KB are available.         8,192 bytes in each allocation unit.     1,951,164 total allocation units on disk.     1,519,058 allocation units available on disk. Determining disk space required for file system conversion... Total disk space:              15624576 KB Free space ...

Steps to  Change User Password in Linux 1.Login as the root user 2.Type the following command: passwd oracle 3.Enter New password 4.Confirm the new password 5.Then open another terminal and login as Oracle with new password. Eg: login as: root root@191.161.201.111's password: Last login: Thu Mar  7 00:32:14 2013 from 191.161.201.111 [root@my ~]# passwd oracle Changing password for user oracle. New password: