Oracle Introduces Oracle SQL Developer Data Modeler

Oracle's New SQL Developer Data Modeller Enables Data Modeling, Design and Development for Oracle Database, Delivering Comprehensive Capabilities to Ease Data Model Development. Data models are powerful communication aids that are used when initiating projects and consolidating or updating existing projects.

Oracle SQL Developer Data Modeler delivers a spectrum of data and database modeling capabilities spanning:
Visual entity relationship modeling – Supports both Barker and Bachman notations so developers can switch between models to suit the audience’s needs or create and save different visual displays;
Forward engineering ERDs to relational models – Transforms all rules and decisions made at the conceptual level to the relational model, where details are further refined and updated;
Separate relational and physical models – Enables developers to develop a single relational model for different database versions or different databases such as Oracle Database, IBM DB2 V7 and V8 for Linux, UNIX and Windows and OS/390 mainframe, and Microsoft SQL Server 2000 and 2005; and,
Full spectrum of physical database definitions – Supports physical definitions such as partitions, roles, and tablespaces for specific database versions for multi-database, multi-vendor support leading to improved developer consistency and productivity.
The new tool integrates seamlessly with Oracle SQL Developer – Oracle’s popular graphical tool for database development – to let developers open and view previously developed designs as well as query, run and write reports against the reporting repository.
Oracle SQL Developer Data Modeler is available for all editions of Oracle Database 11g and runs on Windows, Linux and Mac OS X. The tool is also available for Oracle Database 10g.

ORA-12541 TNS no listener

ORA-12541 TNS no listener error is generated by oracle network layer. This error occurs when the listener for the oracle server you are trying to reach is down or unreachable. ORA-12541

ITIL V3

A number of you dba's out there use ITIL in day to day life and are looking to upgrade from V2 to V3 in your organizations. Here is a quick reference that provides ITIL V3 introduction and the various areas that it addresses.

ITIL V3

ORA-03113

An ORA-03113 end-of-file on communication channel error is a very generic error that indicates that the connection has been lost. ORA-03113 is reported by the oracle client processes due to many reasons. ORA-03113 by itself does not indicate the cause of the issue and is accompanied by other messages that are either displayed on the client side or in the oracle database alertlog.

ORA-03113

ORA-12154 TNS Could not resolve service name

This is a collection of documents that refer to a solution related to this error. Looks like most of my end users are constantly searching google for this and I thought I should put this up as a link

ORA-12154

ORA-12155

ORA-12560

Oracle 11G - OLTP Table Compression

Oracle 11G introduces a new option to support compression of various structured, unstructured and other backup data. This option named Oracle Advanced Compression option provides multiple features including OLTP table compression ( this feature extends the basic table compression that was available since 9i ) , Secure File Deduplication, RMAN Compression and Data Pump Compression.

Technorati : Compression, New Features, OLTP, Oracle 11g

Oracle 11G New Features - SQL Performance Analyzer

Database Administrators spend countless hours troubleshooting SQL statements that have taken upon a new life after a simple system or environment change. Oracle 11G SQL Performance Analyzer provides a solution to this never ending regressive statement issues. This new feature of Oracle 11G allows the database administrator to get a granular view of the impact to sql execution plans and statistics due to environment changes and the best part is that it completely automates the impact analysis process of extremely large SQL workloads

Oracle 11G - Database Replay

Database Replay a new feature of Oracle 11G provides DBAs and system administrators with the ability to accurately rerun actual production workloads, including online user and batch workloads, in test environments. By capturing the full database workload from production systems, including all concurrency, dependencies and timing, Database Replay enables you to realistically test system changes by essentially recreating production workloads on the test system -something that a set of scripts can never duplicate.

Technorati : New Feature, Oracle 11g, Real Application Testing