Grep unique ORA- errors in the alert.log
Need to see how many unique ORA- errors your alert log contains ?
cat alert_DBID.log | grep ORA- | sort | uniq
That’s all there is to it..
Posted: February 27th, 2010
The Oracle-Database-Tips Blog will keep you up to date with new articles and tutorials
as they are addedd to the oracle-database-tips website.
Check out the categories on the left-hand side to look for handy Oracle tutorials.
Look below for the most recent articles.
as they are addedd to the oracle-database-tips website.
Check out the categories on the left-hand side to look for handy Oracle tutorials.
Look below for the most recent articles.
Oracle database hosting companies
List of companies who offer Oracle database hosting
Posted: October 23rd, 2009
Troubleshoot Oracle database links
Read up here to find solutions to common db link setup mistakes and errors.
Posted: October 23rd, 2009
Manage Oracle database links
How many database links are in existence on your database, how many are in use ?
Posted: October 23rd, 2009
Limit Oracle database links per session
Limit the number of allowable db links per session for your database
Posted: October 23rd, 2009
Hide Oracle database link
Want to spare yourself the db link syntax in daily use ?
Hide it with a view or a synonym.
Posted: October 23rd, 2009
Create Oracle database link
Syntax and explanation on creating Oracle database links.
Posted: October 23rd, 2009
Oracle Database Links Background
Oracle Database Links Background information
Posted: October 23rd, 2009
Standby database commands.
oracle standby databases: quick command reference
Posted: October 23rd, 2009
Kill oracle processes using grep only
Use grep to kill a range of similar oracle processes
Posted: October 23rd, 2009
Open Cursors
Open Cursors
What they are, How to manage them,
Resolving ORA-01000
Posted: October 23rd, 2009
Match OS process to Oracle session
Identify the oracle session whose shadow process is using excessive resources, with these ‘Match os process to oracle session’ instructions
Posted: October 23rd, 2009
Raise alert.log error
Use this unsupported but useful package to log your user error code in the database’s alert.log
Posted: October 23rd, 2009
Compile another’s Oracle schema
How to compile another Oracle user schema.
Posted: October 23rd, 2009
NFS Mount article
NFS Mount a linux server’s filesystem to another server
Posted: October 23rd, 2009
Foreign key constraints and other type of constraints in an Oracle database
A foreign key is one of the different types of Oracle constraints.
Posted: October 23rd, 2009
Oracle Delete syntax
The Oracle Delete statement allows you to remove rows from a table.
Posted: October 23rd, 2009
Oracle Update syntax
Look at these examples of the Oracle SQL Update statement
Posted: October 23rd, 2009
Oracle Insert
The Oracle Insert statement allows you to add data to a table using the following syntax:
Posted: October 23rd, 2009
Oracle SQL Select
This tutorial will show you how to use the correct syntax to query data in the Oracle database.
Posted: October 23rd, 2009
SQL Background
SQL is short for Structured Query Language.
It is the language you will use to access any data structure or its data in the Oracle database.
Posted: October 23rd, 2009
Solaris: How to Find Large Files and Directories
Finding Large Directories and files on SunOs
Posted: September 13th, 2009
Get rid of large listener.log file while the listener is still running.
Your listener.log file can get quite large if you do not make it part of your housekeeping scripts, and renaming it while the listener is running is not a good idea.
Here is the method to follow to clean it up while your listener is still running.
Posted: September 13th, 2009
Quick SQL to determine your Database size. (excluding tempfiles)
quick sql to determine your database size exluding tempfiles.
Posted: June 30th, 2009
Kill Oracle processes
Kill a bunch of related orphan Oracle processes with one command.
Permalink — click for full blog post
Related Blogs
Related Blogs on kill oracle process
Related Blogs on oracle process
Posted: January 15th, 2009
Free technology webcasts
We’ve partnered with Insight24 to bring you great free technology-focused webcasts and videos.
Permalink — click for full blog post
Related Blogs
Related Blogs on technology webcasts
Posted: January 15th, 2009
VNC Tutorial
Quick tutorial to download, install and use Free VNC for Linux.
This will give you ‘remote desktop’-type functionality on UNix.
Permalink — click for full blog post
Posted: January 15th, 2009
Linux du command : options used to summarize directory space usage.
Quick page to remind myself what options to use with the linux du command to summarize the list of directories,
not all the files.
Permalink — click for full blog post
Posted: January 15th, 2009
VSFTPD
Installing and running vsftpd on your CentOS 4.5 server
Permalink — click for full blog post
Posted: January 15th, 2009
AWR reports
Use these steps to publish oracle awr reports regularly and mail them to yourself
Permalink — click for full blog post
Posted: January 15th, 2009
Oracle FTP Script
Automate the transfer of files across servers with this oracle ftp script.
Permalink — click for full blog post
Posted: January 15th, 2009