Archive for June, 2008
New ASM Background Processes in 11G
Few hours back I installed Oracle Database 11g(Though still DB is yet to be created), so I started playing with the ASM instance. First thing I did was to check ASM alert.log. I used ADRCI (11g) to see it adrci> show incident ADR Home = [Read More]
11.1.0.6 ASM installation on Solaris fails -II
Some time back, I had written about CSS service not starting in my post 11.1.0.6 ASM installation on Solaris fails -I After doing some research, I came across Metalink Document Note:397238.1 – How to Convert init.cssd as a SMF service for Solaris 10 This document [Read More]
ORA- 4031 – A Case Study
Today I will be taking up one ORA-4031 issue we faced on one of our client database. Please note that SQL statements mentioned below have been changed and does not reveal any confidential information. Our client was facing ORA-4031 on a 9.2 database.This was a new Database [Read More]
Can ASM DiskGroup Be Renamed?
This was actually a question on Oracle forum which I had replied to. Basically the Poster, wanted to know if he could rename the ASM Diskgroup name by renaming/editing ASM Disk header. He had also mentioned that he had heard about this being done by Oracle for its few [Read More]
kfed in 11g
While carrying out Oracle Database 11g install, I noticed that kfed is automatically created. This is in contrast to 10.2 where you had to create it using “make” command. In case you are looking for 10.2 method, you can find it in my previous post ORA-15063 [Read More]
11.1.0.6 ASM installation on Solaris fails -I
Looks like that there is no easy way for me to install/configure Oracle components. And every install/configuration leads me to some or the other problems. Anyways I was trying to install Oracle Database 11g on a Solaris 10 but the CSS does not seems to come up. While [Read More]
We are here to Stay !!
I had actually planned to write this post last week. It’s our Third web address till date with first being http://askoracledba.blogspot.com and second one being http://askoracledba.wordpress.com . Now we are on http://askdba.org/weblog/ and hope to continue this. We [Read More]
DBConsole Issue on RAC -Part II
Continuing with DBConsole issue, we were able to get the cluvfy return success for the nodes. Basically Oracle suggested us that when we use ssh we should not get any banner. E.g $ ssh PROD02 date Fri Jun 13 02:00:41 IST 2008 But in our case it was displaying a banner which [Read More]
DBConsole Issue on RAC -Part I
Currently I am working on issue where DBConsole is not starting on our 2 Node RAC system. When I try to start, I get following errors $ emctl status dbconsole TZ set to US/Pacific Exception in getting local host java.net.UnknownHostException: PROD01: PROD01 at [Read More]
Easy and Free X-Windowing Setup with Cygwin
Today I had to carry out Oracle client Installation on one of the server. Normally I use vncviewer to connect to one of my Linux machine (having vncserver setup) and then get the display on to that machine. But my colleague suggested me about one more approach, which I [Read More]
Adding new ASM disk to RAC database fails
Many times i came across a common problem in RAC databases where trying to add an asm disk is not possible due to errors like ORA-15075 “disk(s) are not visible cluster-wide” ORA-15020 “discovered duplicate ASM disk “DISK1″ and ORA-15054 [Read More]
Transparent Application Failover – TAF
Transparent Application Failover (TAF) is a client-side feature that allows for clients to reconnect to surviving databases in the event of a failure of a database instance. Note that this is not used for purpose of load balancing or for Connect Time Failover. TAF [Read More]
