Latest Topics
Effect Of Multiple SHMMAX Settings
Last week I saw a warning message at database startup time saying: WARNING: EINVAL creating segment of size [Read More]
Finding blogging tough? Just copy and do find and replace
Well this is motto followed by Guenadi Jilevski for his blog http://gjilevski.wordpress.com and he seems to get result [Read More]
Physical Corruption: ORA-1578 part 3
Recently we encountered a block corruption issue in 10g database on Linux x86 64 bit and using ASM for storing database [Read More]
Subscribe To Feed
GRID
‘Metric execution timed out’ error reported by Grid
We use 10.2 Enterprise Manager Grid control to monitor our oracle database environments . Apart from the normal metrics provided by oracle we also use host based and sql [Read More]
ASM
11gR2: Steps to Rename ASM Diskgroup with DB files
11gR2 introduced renamedg utility to rename diskgroups. I would discuss renaming a diskgroup on a Standalone Grid Infrastructure installation with Oracle [Read More]
11gR2 – SysAsm vs SysDba
SYSASM role was introduced in 11gR1 and was designed to administer ASM instances. In 11gR1 , if you connected with SYSDBA role , you used to get a warning which was only [Read More]
Question:Sizing ASM LUN
We received following question from Mr Orlando through our Contact Page How about a discussion on how to size our LUNS to use with ASM. For instance we have a Dell [Read More]
RAC
11gR2: CVU needs SCAN Listeners’ Manual Startup During Grid-Infrastructure Configuration
During configuration phase of Grid Infrastructure for cluster, CVU failed while performing post-checks. Following message is displaced in the Installation Log file: Checking [Read More]
Performance
11gR2: Monitoring Real Time SQL Plan Execution from Oracle Enterprise Manager
Ever since 11gR2 has been released, it has created a lot of buzz in Oracle Blogosphere [Read More]
dbms_stats.copy_table_stats does not alter low/high value
I was working on a performance issue arising due to missing table stats on a new [Read More]
Connections to DataBase Hang Including “/ as sysdba”
Recently I faced one issue where all the connection to database hung and it was also not [Read More]
Install
Downloading Oracle Software directly to Server
This article is based on Pythian’s aricle DOWNLOADING FROM OTN DIRECTLY TO YOUR DATABASE SERVER. Article tell’s about using lynx (text based web browser available on linux) to generate the cookies file which can be then used with wget to download software. But [Read More]
11gR2 Silent Install errors with [SEVERE] – Invalid My Oracle Support credentials
While performing 11gR2 RAC Database Software installation with response file (silent mode), I got this error. - Invalid [Read More]
11gR2 Database Installation with ASM on OEL5
I will be listing down steps for 11g Release 2 installation on Linux x86. There has been few changes incorporated in 11gR2 [Read More]
Installing 10.2.0.5 EM using software-only on 10.2.0.4/11g DB (GUI)
In this article , I will discuss how to install 10.2.0.5 EM Grid using 10.2.0.4 database. This method can also be used [Read More]
AskDba.org Forum
- Amit Bansal on "ASM DiskGroup" August 30, 2010
- taraldesai on "ASM DiskGroup" August 29, 2010
- Amit Bansal on "Checking Listener log in 11g" August 12, 2010
- Amit Bansal on "tns issue / sqlnet issue" August 10, 2010
