Error starting ORMI-Server. Unable to bind socket: The socket name is already in use.

Error starting ORMI-Server. Unable to bind socket: The socket name is already in use.
Thread-1 WARN http: snmehl_connect: connect failed to (node1:xx): A remote host refused an attempted connect operation. (error = 79)

I face with that error on 10.2.0.4 RAC system on AIX 6.1. While I am trying to start dbconsole it fails.

[oracle@node1] emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.

http://node1:1158/em/console/aboutApplication

ps: 0509-048 Flag -o was used with invalid list.
ps: Not a recognized flag: -
Usage: ps [-AMNZaedfklm] [-n namelist] [-F Format] [-o specifier[=header],…]
[-p proclist][-G|-g grouplist] [-t termlist] [-U|-u userlist] [-c classlist] [ -T pid] [ -L pidlist ]
[-@ [wparname] ]
Usage: ps [aceglnsuvwxX] [t tty] [processnumber]
Starting Oracle Enterprise Manager 10g Database Control ………………………..
When I checked $ORACLE_HOME/node1_Instance1/sysman/log I noticed 2 error messages at log files:

ORA-39726: unsupported add/drop column operation on compressed tables

You can hit this error during drop column on your compressed tables

For the 10.2 there is no solution for this error. But there are some options to workaround for can pass this error.

These are:

Upgrade your db to 11gR2
Can keep unused columns on tables
You may recreate table without such columns which you try to drop
Do not to use compress

RCA: LMON (ospid: XXXX) detects hung instances during IMR reconfiguration

We have 11.2.0.1.6 2 node RAC system which is belong r12.1.3 EBS system.

Our node 1 is goes down by below errors:
opiodr aborting process unknown ospid (11075852) as a result of ORA-28
LMON (ospid: 63767522) detects hung instances during IMR reconfiguration
LMON (ospid: 63767522) tries to kill the instance 2.
Please check instance 2′s alert log and LMON trace file for more details.
Tue Mar 19 10:58:36 2013
USER (ospid: 32900426): terminating the instance due to error 481
Tue Mar 19 10:58:36 2013
Errors in file /oracle11g/PROD00/db/diag/rdbms/PROD00/PROD001/trace/PROD001_lmon_63767522.trc:
ORA-29702: error occurred in Cluster Group Service operation
System state dump is made for local instance
System State dumped to trace file /oracle11g/PROD00/db/diag/rdbms/PROD00/PROD001/trace/PROD001_diag_9373174.trc
Instance terminated by USER, pid = 32900426
Error Codes
—————————————————

PRKP-1001&CRS-0215 errors while starting RAC database

I have 11.2.0.1 2 node RAC database. We need to recreate spfile and delete old one.

My old spfile location was SPFILE=+orafra/PROD00/PARAMETERFILE/spfilePROD00.ora,

my current spfile location is SPFILE=+oradata/PROD00/PARAMETERFILE/spfilePROD00.ora

Recreating the Spfile for RAC Instances.

In this post, I am going to explain how we can create Recreating the Spfile for RAC Instances.

We had issue on our EBS R12.1.3 system with 11.2.0.1 2 node RAC system on AIX 6.1. We need to recreate our spfile on ASM. So here is the steps:

By default init<SID>.ora file represent at $ORACLE_HOME/dbs path.

In this case the parameter file was saved to /u01/app/oracle/11.2.0/dbs/initPROD001.ora

1. Using this text based format of the parameter file after having corrected the parameters that have caused the issue, start one of the RAC instances to the mount phase.

SQL> startup mount pfile=’/u01/app/oracle/11.2.0/home/oracle/initPROD01.ora’;

2. The current location for spfile is; +oradata/PROD00/spfilePROD00.ora so the new file will need to replace with this file. ASM itself stores the spfile in +oradata/PROD00/PARAMETERFILE/spfile.267.737949031 and links or aliases the spfile in the location +oradata/PROD00/spfilePROD00.ora

ORA-01578: ORACLE data block corrupted with ORA-01110: data file #: string

You can hit this error on your alert.log. Error could be similar as:

ORA-01578: ORACLE data block corrupted (file # 12, block # 4207)

ORA-01110: data file 11: ‘/xx/sytem.dbf’

There are many possible causes of a block corruption including:

- Bad IO hardware / firmware
- OS problems
- Oracle problems
- Recovering through “UNRECOVERABLE” or “NOLOGGING” database actions
(in which case ORA-1578 is expected behaviour

My Oracle Cloud Computing Presentation

I had a speech at Istanbul Bilgi University. I met with new new engineers&young people  and it was pretty nice  experience to share something with fresh brains…

Here is the my Cloud Computing Presentation

Cloud_Computing