Category Archives: Oracle

Create New Schema in Oracle 11G express

In order to create a new schema in oracle 11G express, we need to create a user account and assign all the privileges. Step 1 : Open SQL command Line Step 2 : Run Connect Step 3 : Enter Username : SYSTEM Step 4 : Enter Password for The SYSTEM account , which is specified… Read More »

Installing Oracle OCI (oci8) library to Lubuntu 10.04.4 LTS – Using OCI instantclient 12.1

First Check Version of your Ubuntu Run Command :  lsb_release -a Distributor ID: Ubuntu Description: Ubuntu 10.04.4 LTS Release: 10.04 Codename: lucid Pre Requisites: sudo apt-get install build-essential sudo apt-get install php5-dev php-pear libaio1 Instant Client installation requires some environment variables to be able to see the library folder. Edit /etc/environment and add at the… Read More »

First MVC ODP.net project using entity framework – Part 2/2

Task : Connect to oracle DB using ODP.net and generate forms using Entity Frame Work without any coding. Pre Requisites : Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio  http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html Microsoft Visual Studio 2013 Oracle Database Instance Credentials. Entity Framework 6 Tools for Visual Studio 2012 & 2013 (http://www.microsoft.com/en-us/download/details.aspx?id=40762) Oracle Database… Read More »

Create and Manage Oracle Database Using Oracle SQL Developer GUI

Pre Requisites: Oracle SQL Developer Oracle Database Instance Login Details Complete Video Tutorial Step 1: Install Oracle SQL Developer http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Please note that in order to install Developer Tool you must have JDK 7 or above in your PC. If you do not have please download JDK from following link prior to downloading to SQL… Read More »