|
|
This Site Contains Articles, Scripts , Documentation on Oracle Technology, and Other Technologies like Unix etc. This site can be helpful for Aspiring Oracle DBA's. All the Articles and Scripts are written through years, While working as a Oracle DBA and Unix Administrator. The road does not end here , there is no end of gaining knowledge and learning/innovating new things. Knowledge is like a garden: if it is not cultivated, it cannot be harvested.
 Latest Articles
|
Oracle Exadata Troubleshooting
|
Published on 2013-05-13 | 0 Comments
|
|
Oracle Exadata Troubleshooting
|
 |
check full articles |
|
|
This article describes about Scan Listener Troubleshooting and connectivity.
|
Published on 2013-04-14 | 0 Comments
|
|
The following Steps can be used to troubleshoot the connectivity issue using scan and services. ( these are to be followed after the db is up and the remote listener is re-registered in the database.)
|
|
check full articles |
|
|
Changing the SYS and SYSTEM passwords in Primary and Standby db, when a broker configuration exists.
|
Modified on 2013-02-19 | 0 Comments
|
|
This Article describes in detais on how you can can change the SYS and SYSTEM passwords in the RAC Primary and Standby database with DG broker configured .
|
|
check full articles |
|
|
This Article describes step by step, How to flashback a RAC primary database, with standby database configured.
|
Modified on 2012-11-30 | 1 Comments
|
|
This Article describes step by step, How to flashback a RAC primary database, with standby database configured.
|
|
check full articles |
|
|
This article describes about Tablespace alerts, and other alerts, and how to change those through command line.
|
Published on 2012-10-17 | 1 Comments
|
|
This article describes about Tablespace alerts, and other alerts, and how to change those through command line.
|
|
check full articles |
|
|
Top Articles |
|
What is INACTIVE Sessions and How to kill those
|
Published on 2012-02-23 | 0 Comments
|
|
What is INACTIVE Sessions and How to kill those
|
|
check full articles |
|
|
TNS-operating system resource quota exceeded
|
Modified on 2011-10-23 | 1 Comments
|
|
This Article describes about TNS-operating system resource quota exceeded
|
|
check full articles |
|
|
Creating a Database in Exadata with dbca in silent mode.
|
Published on 2012-02-03 | 1 Comments
|
|
Creating a Database in Exadata with dbca in silent mode.
|
|
check full articles |
|
|
Location of Different Logfiles in Exadata Environment
|
Published on 2012-01-25 | 1 Comments
|
|
Location of Different Logfiles in Exadata Environment
|
|
check full articles |
|
|
How to call a shell script or operating system command from pl-sql or sqlplus
|
Published on 2012-01-19 | 0 Comments
|
|
How to call a shell script or operating system command from pl-sql or sqlplus
|
|
check full articles |
|
|
Latest Scripts |
|
Script for generating lsinventory logs for both ASM and Db
|
Published on 2012-12-07 | 0 Comments
|
|
Script for generating lsinventory logs for both ASM and Db
|
|
check full scripts |
|
|
Script for finding the rman backup process and for how many hours it is running.
|
Published on 2012-10-17 | 1 Comments
|
|
Script for finding the rman backup process and for how many hours it is running.
|
|
check full scripts |
|
|
Script for checking the Log Gap in the standby database.
|
Published on 2012-10-17 | 0 Comments
|
|
Script for checking the Log Gap in the standby database.
|
|
check full scripts |
|
|
Script to view the SNAP_ID for the database/instance for the last 48 hours.
|
Published on 2012-10-17 | 0 Comments
|
|
Script to view the SNAP_ID for the database/instance for the last 48 hours.
|
|
check full scripts |
|
|
Script for Showing smon memory usage
|
Modified on 2012-09-22 | 0 Comments
|
|
Script for Showing smon memory usage
|
|
check full scripts |
|
|
Top Scripts |
|
asmdiskgrp.sql
|
Modified on 2011-12-29 | 0 Comments
|
|
Script to find free and total size in a ASM disk group
|
|
check full scripts |
|
|
Script For Checking the ASM disk Usage, in Exadata
|
Published on 2012-02-23 | 0 Comments
|
|
Script For Checking the ASM disk Usage, in Exadata
|
|
check full scripts |
|
|
Database Size
|
Modified on 2011-10-22 | 0 Comments
|
|
Database Size
|
|
check full scripts |
|
|
top_cpu_consuming_process.ksh
|
Modified on 2011-11-14 | 0 Comments
|
|
List 3 most cpu consuming process in a database.
|
|
check full scripts |
|
|
tnsora
|
Modified on 2011-10-26 | 0 Comments
|
|
To start or stop all Oracle listeners when the host starts.
|
|
check full scripts |
|
|
|
|
