Oracle Database 12c Installation Step by Step on Oracle Linux 6.4

Newly announced Oracle Database 12c (12.1.0.1) comes with new features ; especially pluggable database , changings behaviour of CBO etc ... 

I downloaded latest Oracle Linux from http://edelivery.oracle.com and installed into Oracle Virtualbox .

Unzip files 

unzip linuxamd64_12c_database_1of2.zip
unzip linuxamd64_12c_database_2of2.zip 

  

Configure your /etc/hosts file

127.0.0.1   localhost localhost.localdomain 

xx.xxx.xx.xx cdb12c cdb12c.mytest

You can configure parameters for now or later. I skipped this step because of when installer checking prerequsite step it generates a bash script for correcting these parameters. 

Add or amend the following lines in the "/etc/sysctl.conf" file.

After installation VirtualBox 4.2.14 for Windows hosts from https://www.virtualbox.org/wiki/Downloads an error message appeared like below

Failed to create the VirtualBox COM object.
The application will now terminate.

Callee RC:

CO_E_SERVER_EXEC_FAILURE (0x80080005)

A bit digging in Virtualbox logs (Document and Settings\.Virtualbox ,


VirtualBox COM Server 4.2.14 r86644 win.x86 (Jun 21 2013 16:12:11) release log
00:00:00.000000 main     Log opened 2013-06-26T09:55:00.622000300Z
00:00:00.000000 main     OS Product: Windows 7
00:00:00.000000 main     OS Release: 6.1.7601
00:00:00.000000 main     OS Service Pack: 1
00:00:00.015000 main     DMI Product Name: HP Compaq Pro 6300 SFF
00:00:00.031000 main     DMI Product Version: 
00:00:00.031000 main     Host RAM: 3476MB total, 1787MB available
00:00:00.031000 main     Executable: C:\Program Files\Oracle\VirtualBox\VBoxSVC.exe
00:00:00.031000 main     Process ID: 5960
00:00:00.031000 main     Package type: WINDOWS_32BITS_GENERIC
00:00:00.764000          VDInit finished

00:00:05.881000 Watcher  ERROR [COM]: aRC=E_ACCESSDENIED (0x80070005) aIID={3b2f08eb-b810-4715-bee0-bb06b9880ad2} aComponent={VirtualBox} aText={The object is not ready}, preserve=false

Just run program as administrator and problem solved.

Linux Cheat Sheet

Command		Description
•	apropos whatis	Show commands pertinent to string. See also threadsafe
•	man -t ascii | ps2pdf - > ascii.pdf	make a pdf of a manual page
	which command	Show full path name of command
	time command	See how long a command takes
•	time cat	Start stopwatch. Ctrl-d to stop. See also sw
dir navigation
•	cd -	Go to previous directory
•	cd	Go to $HOME directory
	(cd dir && command)	Go to dir, execute command and return to current dir
•	pushd .	Put current dir on stack so you can popd back to it

Linux/Unix Compare File or Folder Permissions

Last night , in exadata machine , file permissions accidentally changed recursively with "chmod -R 777  /u01"  command.Therefore oracle binaries ,especially "s" bit permission, didn't work.First of all , scan listener crashed with "TNS no listener" error  in cluster, after that cluster rebooted and instances didn't start.So we decided to compare oracle binaries with other exadata machine for fastest solution.

Original permissions oracle binary
--------------------------------
-rwsr-s--x 1 oracle dba 232399123 Jun 21 09:30 oracle

nmon performance: A free tool to analyze AIX and Linux performance

This free tool gives you a huge amount of information all on one screen. Even though IBM doesn't officially support the tool and you must use it at your
own risk, you can get a wealth of performance statistics. Why use five or six tools when one free tool can give you everything you need?

The nmon tool is designed for AIX and Linux performance specialists to use for monitoring and analyzing performance data, including:

• CPU utilization
• Memory use
• Kernel statistics and run queue information
• Disks I/O rates, transfers, and read/write ratios
• Free space on file systems
• Disk adapters
• Network I/O rates, transfers, and read/write ratios
• Paging space and paging rates
• CPU and AIX specification
• Top processors
• IBM HTTP Web cache
• User-defined disk groups
• Machine details and resources
• Asynchronous I/O -- AIX only
• Workload Manager (WLM) -- AIX only
• IBM TotalStorage® Enterprise Storage Server® (ESS) disks -- AIX only
• Network File System (NFS)
• Dynamic LPAR (DLPAR) changes -- only pSeries p5 and OpenPower for either AIX or Linux

A Tip for mostly used sql codes in Toad

In Toad do these steps ;

 View -> Toad Options -> Editor -> Behavior  choose Code Templates and add new code templates.

For Lazy DBA's

       Most of DBAs monitor alert.log for production databases.It sucks many times :) . Not only monitoring alert log in shell screen is so boring but also searching ORA- errors in lines. An idea came up my mind , during tailing log file , when founding ORA- error it displays popup dialog message into your screen.It is useful this command when surfing in web :)) .

Enterprise Manager Agent Configuration Issue

After upgrade 11.1.0.7 oracle rdbms to 11.2.0.3 , enterprise manager 11g has begun to work improperly.When running "emctl status console" command in unix shell , the message was that "running" , but when clicking the enterprise manager url the error message was database is down.After upgrading database ; ORACLE_HOME path , listener configuration ... etc. was changed and EM control needs to fix.

Trying different commands in order to configure EM was come to nothing.First I did ,