Friday, 13 November 2015

While install Oracle Database 11g Error in starting the service. The service OracleMTSRecoveryService was not found

Solution:
Keep the popup and move to:
Regedit > hkey_local_machine\system\controlset001\service\OracleMTSRecoveryService

In the ImagePath key, change the path to your actual home path. 

Saturday, 7 November 2015

root.sh failure while running Oracle clusterware installation

If the root.sh fails on a node and you try to re execute it after fixing the failure then it gives the following error:

CRS is already configured on this node for crshome=0 Cannot configure two CRS instances on the same cluster.Please deconfigure before proceeding with the configuration of new home.

In order to perform a cleanup you will need to execute the following two commands as the root user.
In all the nodes where the root.sh failed execute the following:
# perl $GRID_HOME/crs/install/rootcrs.pl -verbose -deconfig -force

On the last node of the cluster execute the following as the root user:
# perl $GRID_HOME/crs/install/rootcrs.pl -verbose -deconfig -force -lastnode

Now you will be in a state where you can re execute the root.sh command.

Wednesday, 4 November 2015

ORA-01653: unable to extend table SYS.AUD$

No body is able to connect :

ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.AUD$ by 8192 in tablespace SYSTEM
ORA-02002: error while writing to audit trail




server223[/home/oracle]>>sqlplus / as sysdba
SQL> truncate table aud$;

Table truncated.


SQL>

Tuesday, 3 November 2015

ORA-29285: file write error


We were extracting some data into text file and then we noticed the above error. I checked many things, everything seemed ok. I realized that i get this error only for certain write operations when length of buffer was more than 1024. We had used following call to open file

UTL_FILE.fopen(, , 'w'); 

Since 4th parameter to UTL_FILE.fopen was not passed, it was defaulted to 1024. Hence the error when buffer was more than 1024.

Solution: we changed the call to UTL_FILE.fopen and passed 4th parameter max_linesize as 32767.

Number of Visitors