/home/abhishek

This blog post is an HowTo "Setup SQL*Plus to work on BASH" The commands illustrated in this howto are tested on Ubuntu 9.10 with Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production Installed.

What is SQL * Plus ?

SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers to interact with the Oracle database.

Prerequisite

Oracle Database 10g Express Edition Release 10.2.0.1.0 Installed

Once you have Oracle 10g Installed successfully you can go to

Applications > Oracle Database 10g Express Edition > Run SQL Command Line

and successfully run all your SQL PL/SQL easily but using SQL*Plus directly on BASH is the real fun, Below are the steps which will enable you to use SQL*Plus on BASH

1) set ORACLE_HOME

The IT environment today in any organization is a sort of a mixture where many different Operating Systems are used, and Windows Active Domain Controller exists in majority of such organization.

Below is a 4 step How to on "Connecting Linux (Ubuntu) Systems to Active Directory Setup"

1) Update the Software Repositories

sudo apt-get update

2) Install Required Packages (likewise-open)

sudo apt-get install likewise-open


3) Join The Domain using Domain Administrator Account, replace Administrator with Domain Administrator Username and fqdn..domain with the Fully Qualified Domain Name

sudo domainjoin-cli join fqdn.domain Administrator


4) Update the Startup Scripts

sudo update-rc.d likewise-open defaults

This user is a Novice Editor and is entitled to display this Service Badge.

Wikipedia today has become an unparalleled source of content on virtually any topic and has grown with a great pace, The content available on wiki is all contributed by users like you and me and is available under a Creative Commons Attribution-ShareAlike Licence which allows reuse of this content in various forms by attributing in a manner specified by the author.

GNUnify is one of the biggest FOSS Event organized by the students of Symbiosis Institute Of Computer Studies & Research (SICSR) Pune & Pune GNU/Linux Users Group. GNUnify is entering in its 8th year with GNUnify 2010.

When: 19th & 20th Feb 2010

Where:  Symbiosis Institute of Computer Studies and Research, Atur Centre, Gokhale Cross Road, Model Colony, Pune-411016, Maharashtra, INDIA. Tel : +91-20-25675601

Event Website : http://gnunify.in

GNUnify Gallery: http://gnunify.in/gallery

LFU Update : Story in Linux for You March 2009 (pg 36)

Hope to see a great Event ahead