My Tech Journey: October 2010

Monday, October 25, 2010

11G R2 RAC OVM Templates.

It became pretty old news that Oracle released OVM templates for RAC (Real Application Clusters) , this was announced in openworld also.
This post is mainly to discuss the issues I faced during the installation and tips to do it better ,
I downloaded 11.2.0.2 ovm templates to the playaround with RAC.
Download links :

http://www.oracle.com/technetwork/server-storage/vm/templates-101937.html ( Database & Real Application Clusters (RAC) ).
http://edelivery.oracle.com

1) During the download itself I got into issues ,as I went with a Download Manager and the Checksum failed. So its verify the check sum of the downloaded zip.

2) The Installation steps are pretty much clearly described in the Document that comes along with the download.

3) One main page I like to mention here is the screen where the OVM template is getting added to the VM server.The user name and password entering should anything apart from root , as if we enter root over here then it changes the password of the root each time we create a VM from this template.

So Make sure that root user is not given here.

4) In this page please be careful with the With and down arrow at the end of the configuration.

5) The emca is not configured with the default installation, so if you like to have it installed during this then its needs to enabled in the config file .
File : /u01/racovm/params.ini
Parameter : " CONFIGURE_DBCONSOLE= YES"

Have a nice time with RAC OVM installation.

http://edelivery.oracle.com

Friday, October 15, 2010

Oracle SQL Developer 3.0 Early Adopter 1: New Feature List

Last week Oracle SQL Developer 3.0 got released and its making news in all Blogs.

Below is the feature list and the cool additions to SQL developer.

Just downloaded and started working, its cool & good J

Eye Catching :::

DBA Functionality

DB Configuration	Ability to review and tune db config and edit initation parameters
Resource Manager	Create and prioritize consumer groups and manage resource plans
Security	Define audit settings and manage profiles, roles and users
Storage	Define and manage archive logs, control files, datafiles, redo logs, rollback segments and tablespaces

Schema Browser

Easier navigation between object types and schemas for a specific connection

Support fast client-side name based filtering for narrowing the list of objects displayed

Tuning

SQL Tuning Advisor	Analyzes submitted high-volume SQL statement and offers tuning recommendations
Diff Tool for Explain Plans	Compare selected Explain Plan or Autotrace results for any SQL statements.
Management Pack Licensing Preferences	Preferences option to track which Oracle database features are claimed to be licensed on a connection-by-connection basis

Setting TNS_ADMIN for SQL developer :

We can set the tns_admin from sql developer , see the user Document :
"You can specify the tnsnames.ora location in the Database: Advanced preferences.By default, tnsnames.ora is located in the $ORACLE_HOME/network/admin directory, but it can also be in the directory specified by the TNS_ADMIN environment variable or registry value or (on Linux systems) the global configuration directory. On Windows systems, if the tnsnames.ora file exists but its connections are not being used by SQL Developer, define TNS_ADMIN as a system environment variable. For information about the tnsnames.ora file, see the "Local Naming Parameters (tnsnames.ora)" chapter in Oracle Database Net Services Reference."

Link ::

New Feature : http://www.oracle.com/technetwork/developer-tools/sql-developer/rel3-featurelist-ea1-166831.html

New Feature : http://www.oracle.com/technetwork/developer-tools/sql-developer/featurelist-094691.html

To Download : http://www.oracle.com/technetwork/developer-tools/downloads/ea1-downloads-176664.html