Oracle pl sql King

SBL-OMS-00203: Error (null) invoking method "(null)" for Business Service "(null)"

2011-06-29T21:53:00.003-04:00

We recently implemented Siebel and keep running into a few SBL errors now and then. We were being bugged by a SBL-OMS-00203 and here is a solution that worked for SBL-OMS-00203

ORA-06512

2011-06-29T21:45:00.000-04:00

ORA-06512 or ORA 6512 is a common error faced by oracle users and administrators alike during the operations of an oracle database. The ORA-06512 error in itself does not indicate the actual issue or an exception code.

ORA-00904 and ORA-01722 calls from developers

2011-05-14T07:47:00.002-04:00

I am surprised that many of the developers cannot even solve simple oracle errors like ORA-00904 and ORA-01722. These errors are caused by issues in your code, do not google and call your dba asking if the server is still up or if its running into some issue.

If you are a newbie PL/SQL developer, spend some time on ORA-06550 while you are reading through the above 2 errors

mtime find and unix

2010-07-16T15:32:00.002-04:00

A good article that explains mtime, ctime and atime and usage of the same in find command of unix

Oracle releases updated to Sun Ray

2010-07-15T15:35:00.000-04:00

Administrators and End Users Benefit from Broader Support of Heterogeneous Environments, Greater Efficiency, Access and Ease-of-Use
Sun Ray Software 5 provides a comprehensive Oracle-based virtualization solution that easily integrates with popular third-party technologies like Microsoft Windows Server, Microsoft Active Directory, Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and VMware View.
This broad support for heterogeneous environments is unique to Oracle’s desktop virtualization solutions and offers customers enhanced flexibility and investment protection.
New features in the Sun Ray Software 5 update include:
Support for Oracle Enterprise Linux – enables customers to choose among Oracle Solaris, Oracle Enterprise Linux, Red Hat Enterprise Linux or SUSE Linux Enterprise Server as their server platform to deploy Sun Ray Software;
Enhanced virtual desktop client – installs on existing PCs and allows them to be used as an alternative to a dedicated Sun Ray Client device. This enables organizations to quickly experience many of the benefits of the Sun Ray solution, using their existing desktops. New in this release is support for Mac OS X computers, in addition to existing support for Windows XP, Windows Vista, and Windows 7;
Greater mobility – with the enhanced virtual desktop client, customers can now use smart card readers on supported PCs to “hotdesk” desktop sessions between PCs and dedicated Sun Ray Clients. “Hotdesking” allows users instant access to their desktop sessions simply by inserting a smart card into a Sun Ray Client or a PC with a smart card reader;
Sun Ray connector for VMware View 4 – allows Sun Ray Clients to be used as a client with the VMware View 4 virtual desktop infrastructure product;
Enhanced multimedia with bidirectional audio capabilities – improves the user experience with Windows applications.

ORA-06550 and ORA-06502

2009-09-08T00:15:00.003-04:00

Two errors that continuously dog developers and dba's alike are ORA-06550 and ORA-06502. These are due to code issues within the PL/SQL that has been developed and a good explanation of the same is available at the locations below.

ORA-06502 :Text: PL/SQL: numeric or value error

Oracle Introduces Oracle SQL Developer Data Modeler

2009-07-08T02:07:00.002-04:00

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

2008-10-28T13:34:00.004-04:00

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

2008-09-23T02:12:00.002-04:00

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

2008-09-23T02:09:00.001-04:00

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

2008-09-19T16:37:00.004-04:00

This is a collection of documents that refer to a solution related to this error. Looks like most of my end users are constantly googling for this..

ORA-12154

Oracle 11G - OLTP Table Compression

2007-07-16T13:38:00.002-04:00

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 ( 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

2007-07-15T08:21:00.001-04:00

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

2007-07-13T16:26:00.000-04:00

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

Oracle expansion in Hyderabad

2007-05-06T23:54:00.003-04:00

Oracle and its salaries are expanding in Hyderabad Job Market at a very quick pace. During my recent trip to Hyderabad, I noticed that they have moved into their own campus and are continuing to lease a ton of office space in and around their campus. Hiring engines seem to be firing on all cylinders to meet the continued customer and consulting demand for offshore work.

ORA-03113 End of File

2007-02-12T13:47:00.001-05:00

ORA-03113 seems to be an error that keeps haunting new dba's over and over again. Metalinks has tons of documentation on this error but a great place to start is on this ORA-03113 Error

Some of the regular readers have complained about ORA-12154 and here is a link to resolving the ORA-12154 error

ORA-00918 ate our weekend

2007-01-20T03:55:00.004-05:00

A good explanation about solving the ORA-00918 issue.

Oracle is easier to manage than DB2

2007-01-04T14:05:00.000-05:00

An interesting study by Edison Group that announced that oracle saves 38% in RDBMS Management cost over IBM DB2. Looks like this study is based on a study of the administrative tasks and the time it takes to complete those tasks. It claims that Oracle will save upto $30K+ in administrative costs...

More info can be found here and here

Oracle Accelerate for Small and Medium Businesses

2006-12-25T07:13:00.000-05:00

Oracle announced Oracle Accelerate that delivers a complete set of applications and implementation tools combined with a partner system that delivers maximum value to small and medium enterprises implementing Oracle Applications.

More information can be found here

Hacking Oracle through Google

2006-11-25T09:08:00.000-05:00

Hope you all got your hands on "Google Hacking for Penetration Testers” by Johnny Long by now.. if not, you can read a summary by don burleson over here

OOW Oracle announces Unbreakable Linux Support

2006-10-29T06:52:00.000-05:00

Oracle Unbreakable Linux is a support program that provides enterprises with industry-leading global support for Linux. Recognizing the demand for true enterprise-quality Linux support and seeing an opportunity to significantly reduce IT infrastructure costs, Oracle is now offering Linux operating system support.

More information about this program can be found here

Oracle CRM on Demand Release 10

2006-04-21T10:01:00.003-04:00

Siebel Acquisition and Integrations activities are known to be moving at a very fast pace. Today oracle announced the CRM on demand release 10, based on siebel's hosted CRM application. It claims to deliver the powerful sales, marketing and service fuctionality per the new release at Oracle DBA Spot

And the heat is on for Sales Force.Com ......

"One of the key features that led us to Oracle CRM On Demand, instead of Salesforce.com, is the mass list updating that helps us keep our data as clean as possible and reassign mass records for our new sales staff," said Dave Hannum, National Sales Manager from Technogym USA Corporation. "We have seen huge productivity gains just with these advanced list management capabilities. In particular, the context-sensitive help quickly and easily guides sales people through defining list criteria for their own outbound marketing efforts giving them more time to spend selling instead of on administrative overhead.

Oracle 10g Express Edition Wins LinuxWorld Award

2006-04-18T15:45:00.000-04:00

Oracle Database XE is the free starter edition database that is known to work on a wide range of 32-bit Linux operating systems, including Mandriva, Power Pack+, SUSE 9 and SUSE 10, Red Hat 4, Fedora and Ubuntu. This product has received an award at the recent Linux World in Boston.

More information can be found here

Oracle and Novell to Offer Grid-Ready Solution

2006-04-05T01:16:00.000-04:00

Novell and Oracle today announced availability of a new Accelerator service designed to help customers streamline the deployment of a grid-ready infrastructure for the data center, featuring Oracle(r) Database 10g, Oracle Real Application Clusters, Oracle Application Server 10g, and Oracle Enterprise Manager 10g for customers running on SUSE(r) Linux Enterprise Server from Novell. The solution takes advantage of Oracle Enterprise Manager 10g Grid Control (Oracle Grid Control) and the Automated Storage Management feature of Oracle Database 10g to provide a complete, customer-ready management solution for monitoring and managing grid applications and infrastructure software and storage.

This new Accelerator is a service engagement wherein skilled personnel from Oracle will work with Novell, HP and Egenera to expedite implementation and deployment of Oracle's Grid Computing infrastructure software onto SUSE Linux Enterprise Server. Already field-proven with existing joint customers, this accelerator helps minimize risk while speeding time-to-market for enterprise grid-based applications. The new Accelerator is offered with flexible optional pricing designed to fit into customer budget and deployment requirements.

Back after a long Outage on this blog

2006-04-05T01:05:00.000-04:00

I had been away for a couple of weeks, in Hyderabad, India to meet some of my vendors and to see them in action.

Things are moving fast and the Indian Economy is on a fast pace to achieving record growth. China should be worried now, considering that this vibrant democracy is able to sustain an 8+% growth rate inspite of the corruption that is rampant in every corner of this country.

My host gave me a tour of the available real estate and land prices are comparable to Manhattan, NY

Anyway, I am back and lookfoward to more rants about Oracle Operations soon.

DBA's Learn Oracle in 2 days

2006-02-27T15:13:00.000-05:00

Today while browsing around on OTN I stumbled upon this link called "Getting Started with Oracle". Embedded in that page was a quote "DBA's : Learn Oracle in 2 days ". The page goes on to explain the 10 steps in Learning Oracle Database Administration.

Another link on this site took me a Oracle 10g 2 Day DBA Document that says that the audience of this material are Developers who want to acquire part-time DBA Skills, Folks who need to manage departmental servers and Administrators managing Oracle for small and medium businesses.

God Help Us All !!

Oracle Expands its Offerings in Embedded DB Software

2006-02-26T20:34:00.000-05:00

Oracle recently announced the acquisition of Sleepy Cat, a maker of embedded database systems. Sleepy cat is famous for its Berkeley DB Engine that comes as Berkeley DB, Java Optimized Berkeley DB and the Berkeley DB XML Edition. This is an exciting expansion of Oracle's product line since Oracle never had a strong hold in this area. The most prominent user of Berkeley's products has been google in all its personalization systems that include gmail, google groups etc.

Typically embedded databases are different from conventional databases by the fact that they run in process with the application and store the data locally instead of requiring a separate installation. They are used in many devices that we see and use in our daily lives including appliances, networking gear like switches and routers.

Oracle announced that it intends to continue the dual license mode where they will continue to let the database to be used in Open Source Implementations as well as a closed source distribution where the product Oracle has no plans to change the dual license, and we will continue to serve both open source and commercial users.

Google Desktop Saves the DAY

2006-02-15T09:09:00.001-05:00

We recently had a major outage in our shop floor systems due to a SAN Outage. The outage was due to an outdated SAN hardware and the supporting components that were not even available with the vendor when the outage happened. ETA for restoration was 3 to 4 hours.

Rewind to Feb 2005 : Our team reviewed all critical systems and provided a recommendation for replacing the SAN on the shop floor. One of the business leaders rejected the idea with a comment that went as " This is nothing but an attempt by systems group to buy some new toys.. rejected ". Why fix something thats not broken.

System is back to normal, but during the RCA phase, the CFO blasted the recently anointed manufacturing leader/SVP. The new leader walked out of the session with CFO called a meeting of the systems group and said that heads are going to roll for not taking care of this and that some one would have to pay for this in the next 24 hours.

I had been using google desktop since beta and thought that it was time to put it through the much awaited litmus test. A quick Search for "Manufacturing Proposal" pulls up the email chain where the SVP himself rejected the idea of replacing the old hardware. ... Quietly forwarded an archive of the email chain to Director of IT and rested my case and thought to myself.. "Wonder who is going to pay for this .. atleast I am not.. "

Oracle Application Express ?.. Who comes up with these names ?

2006-02-11T18:23:00.000-05:00

Oracle recently announced that it had renamed the HTMLDB tool as Oracle Application Express. Link Here ...

Now thats confusing as hell, considering that this product has nothing to do with the Express Products or Application Server. Lets hope that this product will live longer than WebDB which got integrated into App Server in the later stages. Considering that oracle moved metalink to this, I have high hopes for the longevity of Application Express aka HTMLDB

Routine Oracle DBA ? : A rant in support of TK

2006-02-09T08:00:00.000-05:00

I stumbled upon Tom Kyte's Rant about the people who are aiming for instant knowledge. My experience has been that "many" new entrants into the field start categorizing work as "Routine Oracle DBA" from the second day they are on the job.

Routine Work as defined by the newbies is Anything or Everything that they may have executed even if they didnt know what exactly they were doing. The trend seems to be on identifying an activity, learning the basics on the process and execution and then moving on to a newer job with additional skills added to the resume.

My org policies now dictate that every newbie is going "manual" for 3 months instead of automated Cloning and Replication Procedures. This helped some, but I dont think we as Managers or Tech Leaders can force a change in how they acuqire their knowledge.

Oh Well.. We can only take the horse to the water.. or is that a Routine Task ?

My Leap into Blogging..

2006-02-08T21:33:00.000-05:00

Hi,

Taking a big leap from Forums to Blogs..

I am Oracle King, a 14 year DBA Veteran in the South East, that kicks himself everyday for giving up technical line and taking a leap to become a "weepy" VP of database Operations.

Here is my foray back into sharing my perspectives on Life in the techno managerial operations world. Who am I kidding .. its just another outlet for me to vent ;-)..

DBA King