Google IT Solutions: May 2014

Thursday 29 May 2014

How to solve ora-06413

Unable to open oracle connection (ora-06413)

Cause:
The problem scenario: some time oracle 10g could not open connection with applications like Microsoft Access, Visual Studio, and ODBC connections etc. Those applications are installed in C:\Program Files (x86). And cause is that oracle do not make connection with such these applications due to parentheses.

Solution:
Here's the real trick to making this all work; Set up a symlink to the c:\Program Files (x86) folder without the parentheses.
Open Command Prompt and "Run as administrator" At the command prompt, enter the following command;

mklink /D "C:\Program Files x86" "C:\Program Files (x86)”



Now to onwards run applications from C:\Program Files x86.

ORACLE user create

How to create user in oracle;

CREATE USER TEST IDENTIFIED BY TEST;
DEFAULT TABLESPACE USERS;
TEMPORARY TABLESPACE TEMP;
PROFILE DEFAULT;
ACCOUNT UNLOCK;

How to grant access to user;
-----Role for USER----
GRANT DBA TO TEST;
ALTER USER TEST DEFAULT ROLE ALL;
-------System Privilege for USER------
GRANT UNLIMITED TABLESPACE TO TEST;

Wednesday 28 May 2014

How to install IIS 8.5 Server 2012 R2

Install IIS 8.5 in the Server 2012 R2 
When the Web Server (UI) role is chosen for the first time in the Add Roles and Features Wizard in Server Manager, the basic components and services needed for IIS are automatically selected. The following procedure will install Internet Information Services on a running physical server when IIS has not already been installed. Open Server Manager by clicking the Server Manager icon on the desktop.
  1. In the Server Manager window, with the Dashboard and Quick Start selected, click Add roles and features, or click the Manage menu, and then click Add Roles and Features. The Add Roles and Features Wizard will start with a Before You Begin page.
  2. On the Before You Begin page, click Next.
  3. On the Installation Type page, select Role-based or feature-based installation to configure a single server. Click Next.


  1. On the Server Selection page, select Select a server from the server pool, and then select a server; or select Select a virtual hard disk server, select a server to mount the VHD on, and then select a VHD file. Click Next.


  1. On the Server Roles page, select Web Server (IIS).


  1. In the Add Roles and Features wizard, click Add Features if you want to install the IIS Management Console.

  1. On the Server Roles page, click Next.
  2. On the Features page, select any features that you would like to install, and then click Next. Note that you do not need to select any features on this page to install IIS. IIS setup will select the features that are required.

  1. On the Web Server Role (IIS) page, click Next.
  2. On the Role Services page, select any additional role services that you want to install.

  1. If you selected a role service that requires other role services or features to be installed, a page will be opened indicating the role services or features to be installed. Leave Include management tools (if applicable) selected to select the install management tools associated with the server role. You may not need the management tools on the destination server if you plan to manage the role remotely. Click Add Features to add the required role services or features.
  2. After you have added the role services that you need on the Role Services page, click Next.
  3. On the Confirmation page, verify the role services and features that are selected. Select Restart the destination server automatically if required to restart the destination server if the settings need to take immediate effect. To save the configuration information to an XML-based file that you can use for unattended installations with Windows PowerShell, select Export configuration settings, move to the appropriate path in the Save As dialog box, enter a file name, and then click Save.
When you are ready to start the installation process on the Confirmation page, click Install.


  1. The Installation Progress page is displayed. You can close the wizard without interrupting running tasks. You can view task progress or open the page again by clicking Notifications in the notification area, and then clicking Task Details.
  1. On the Results page, verify that the installation succeeds, and then click Close.

IIS installation completed.


How to Migrate Virtual machine from VMWare to Hyper-V

Please follow below steps;

Step 1: Shut down the VM

This is important – most developers that I know simply suspend their VMs when they shut down or reboot the host machine. You need to Shut down the virtual machine in VMWare Workstation before you begin the conversion.

Step 2: Convert virtual hard disk from VMDK to VHD

The main part of the process is to convert the virtual hard disk format from VMDK to VHD. There’s a variety of conversion tools available for this task – I picked the WinImage utility since, ironically, I’ve used it in the past to convert VHD images to VMDK and found it to be very reliable.
If your VMDK virtual hard disk consists of multiple files, I recommend that you execute the following command to generate a single VMDK image:
Then use below method to convert in single disk.

Step 3:  Consolidating Multiple VMware VMDK Disk Files into One

In command prompt, navigate to where you have VMWare installed.  For me it was
C:\Program Files (x86)\VMware\VMware Workstation
In that folder you can use the vmware-vdiskmanager.exe program to perform this operation
vmware-vdiskmanager -r MyVirtualMachineDisk.vmdk -t 0 SingleDiskFile.vmdk
Replace MyVirtualMachineDisk.vmdk with the full path and file name of the first file of your split VMware disk set.



The “-t 0” means to turn it into a “single growable virtual disk“.  If you would rather pre-allocate all the storage for the disk, use “-t 2” instead, which means “preallocated virtual disk.
You can view more command line options by running the vmware-vdiskmanager.exe with no parameters.

DownLoad WinImage Utility

http://www.winimage.com/download.htm
  1. Download, install and start WinImage
  2. In the Disk menu, select Convert Virtual Hard Disk Image…
  3. In the Open file dialog, select VMWare VMDK (*.vmdk) as the file type and browse to your current VM location, select the file and press Open
  4. In the Convert Virtual Hard Disk Image dialog, pick Create Fixed Size Virtual Hard Disk Size to make your new VHD fixed-size or pick Create Dynamically Expanding Virtual Hard Disk to make it dynamic. I prefer the dynamically expanding option.
  5. In the Save As file dialog, browse to the location you’d like to save the VHD image and type in the File name and make sure the Save as type is set to Virtual Hard Disks (*.vhd), then press Save.
Step 4: Configure Hyper-V networking

If this is the first virtual machine on this Hyper-V host and you haven’t configured networking yet, follow the steps below to create a new virtual network:
  1. Start the Hyper-V Manager
  2. In the Action menu, select Virtual Switch Manager…
  3. Select External and press Create Virtual Switch
  4. Type in the Name, make sure that External network option is selected and pick the network card that provides Internet access in the dropdown, then press OK
  5. Press Yes on the Apply Networking Changes dialog
Step 5: Create a new virtual machine in the Hyper-V Manager

You are now ready to create a new Hyper-V virtual machine using the VHD image created earlier in Step 1.
  1. Open the Hyper-V Manager
  2. In the Action menu, select New > Virtual Machine… to launch the New Virtual Machine Wizard
  3. On the Before You Begin screen press Next
  4. On the Specify Name and Location screen type in the virtual machine Name and select the Location, then press Next
  5. On the Assign Memory screen enter the amount of Startup memory, then press Next
  6. On the Configure Networking screen select the External virtual network created earlier in Step 3, then press Next
  7. On the Connect Virtual Hard Disk screen select the Use an existing virtual hard disk option and browse to the location of the VHD created in Step 1
  8. On the Summary screen press Finish
  9. Select the newly created virtual machine in the Virtual Machines section, then bring up the Action > Settings… dialog for the VM
  10. Select the Processor node and increase the Number of virtual processors to the desired value, then press OK
  11. Make sure the VM is still selected in the Virtual Machines section, then use the Action > Start menu option to start the virtual machine
  12. In the Action menu, select Connect… to bring up the Virtual Machine Connection window
  13. Login to the VM
  14. Make sure that remote connections are allowed by going to Control Panel > Remote settings and making sure that one of the Allow connections options is selected
Enjoy :) 

Saeed