Posts Tagged ‘oracle’
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]
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]
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]
Resolving Shutdown Immediate Hang Situations
Many times Oracle DBA’s are faced with a situation where shutting down the instance with shutdown immediate seems to take infinite time and gives a impression that the session is hung. In most of the cases this is not a hang. Hang can be defined as a scenario when few [Read More]
Solving ORA-1031 while connecting as “/ as sysdba” :
Many times we see an issue like this: SQL> conn / as sysdba ERROR: ORA-01031: insufficient privileges This is a very common and frequent error that can occur after the new oracle software install or due to some permissions changes at OS level. I will dicuss the approach [Read More]
AWE -What is It and How to use it?
32-bit Operating systems provide 4Gb of addressable space to applications. This includes memory for the user application and also for the system. When running Oracle on 32-Bit Windows, we can have total memory limited to 1.7 Gb only. If you allocate memory more then 1.7 GB [Read More]
Recovering from ORA-1578 ORA-8103 (Logical Corruption)
1. For ORA-1578: There are two ways in which we can extract the data from a corrupted table: a) Using DBMS_REPAIR.SKIP_CORRUPT_BLOCKS b) Using Event 10231 a) Connect as sysdba user: execute [Read More]
CRSCTL CheatSheet
You can find below various commands which can be used to administer Oracle Clusterware using crsctl. This is for purpose of easy reference. Start Oracle Clusterware #crsctl start crs Stop Oracle Clusterware #crsctl stop crs Enable Oracle Clusterware #crsctl enable crs It [Read More]
