Update Oracle from 11.2.0.1 to 11.2.0.3

First you need to download the software. Do this via Oracle support (formerly metalink).
https://support.oracle.com/CSP/ui/flash.html
search for patch ID 10404530

or go directly to
https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=10404530

You need a valid support license to download it.

 A rather long installation guide is located at
http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=

If you don't want to read it all, start the installer (remember to do almost all the things you did before installing 11.2.0.1 - do the appropriate preinstalliation steps) Guide: 

http://g-tech-blog.blogspot.dk/2012/03/centos-62-and-oracle-11r2.html

Once you have an Xming window running with the installation, choose to UPGRADE the database.

Install the new version to a NEW home.

When you are done, remember to run the root script as usual after installing oracle, and let the installer guide you though the process of upgrading your DB.

It will also update Enterprise Manager for you.

Post installation steps:
rename $ORACLE_HOME to the NEW destination.
The important files are:
/etc/init.d/oracle
/home/oracle/.bash_profile
/etc/profile
If you for some reason after a reboot can't start the EM or DB, look for an entry with the wrong $ORACLE_HOME destination.
If you want the DB to start "automagically" when booting (using the dbstart command) remember to change
/etc/oratab
change the :N to :Y

When you have successfully installed oracle end EM, its time for the critical patch, updated jan 2012.
Download OPach utility first.

goto https://support.oracle.com
search for 6880880 or try to go directly to: 6880880 .
download and follow readme (put it in the $ORACLE_HOME dir).

Download the patch:
again, on oracle support, search for 13466801.
The file is called something like: p13466801_112030_<OS>-<Architecture>.zip
run the opatch util from the unzipped dir of the patch.
Follow the instractions.
Done! :-)

Posted By: Haxjer Hunt Wednesday, 14 August 2013

0

Read More

SQL DML And DDL

Sql Dml And DDL Statement

Sql Can Be Divided Into Two Parts :-

1. The Data Manipulation Language (DML) .
2. The Data Definition Language (DDL) .

The Data Manipulation Language (DML) : Is Used to Manipulate The Data In The Database  Objects. Some of The DML Commands Are :-

• Insert : Used To Insert A New Data Record In A Table.
• Update : Used To Modify An Existing Record In A Table.
• Delete : Used To Delete An Existing Records In A Table.

The Data Definition Language (DDL) : Is Used to Define The Databases Data Types, Structures And Constraints on the data. Some Of The DDL commands Are :-

• Create : Used To Create A new Database objects, Such as a table.
• Alter : Used To Modify the database objects.
• Drop : Used To Delete The Objects.

Posted By: Haxjer Hunt Saturday, 10 August 2013

0

Read More

What Is Tables (SQL)

What Is Tables

• A Table Is A Collection of Related Data Entries And It Consists Of Coolumns And Rows. 
• A table has a specified number of columns, but can have any number of rows. 
• Each row is identified by the values appearing in a particular column subset which has been identified as a unique key index.

For example, an Employees table would contain the same basic details on each employee: name, title, department and so on. Each detail, each chunk of information you need to store lives in a field. When you view a single employee record, QuickBase displays it in a form. Whenever you want to view more that one record at a time, you do so in a table report, where fields appear as columns and each record is a row.

Posted By: Haxjer Hunt

0

Read More