For Oracle support & training call (800) 766-1884
Free Oracle Tips

Home
Oracle Tips
Oracle Code Depot
Oracle Monitoring
Oracle Consulting
Oracle Training
Oracle News
Oracle Forum
Oracle Support





 

Free Oracle Tips
image

 
HTML Text

Free Oracle App Server Tips
image

 
HTML Text


Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

 

 

Oracle Utilities - Using Hidden Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and More


oerr Alternatives

The greatest weakness of the oerr utility is the content of its messages. Getting rapid feedback about a particular error seems desirable until text like the following is returned:

$ oerr ora 00942
00942, 00000, "table or view does not exist"
// *Cause:
// *Action:

Getting paged at 2:00 AM is not fun, especially when oerr does not provide a “cause” and “action” for the error. Fortunately, there are two alternatives to oerr that do a better job of analyzing and resolving the problem.

• Oracle TechNet – The TechNet site (http://technet.oracle.com) can be a lifesaver. Full documentation is available online, including error messages.

TechNet is available to anyone that registers online.
• Oracle Metalink – This is the online support database (http://metalink.oracle.com) for Oracle. Operated by Oracle Corporation Support Services personnel, this site is likely to have the solution for a problem. A “quick search” capability specifies problem solutions.

The oerr utility should be used for quick identification of problem descriptions and actions. Custom facilities and message files can be created to respond to frequent errors specific to your environment. For detailed problem descriptions and analysis, access either TechNet or Metalink over the Internet.
 

The above is an excerpt from Oracle Utilities - Using Hidden Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and More by Rampant TechPress.


For more details on Oracle utilities, see the book "Advanced Oracle Utilities" by Bert Scalzo, Donald K. Burleson, and Steve Callan.

You can buy it direct from the publisher for 30% off directly from Rampant TechPress.

For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts. 

You can buy it direct from the publisher for 30%-off and get instant access to the code depot.


 
 


 

 

image

image

image  

image

image

image

 

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544

Email BC: