Monthly Archive: October 2015

ASM Not starting after changing the Hostname or IP Address of the Server

I just wanted to share my small experience with ASM. In our organization, the OS Admins changed the Hostname of one our database servers where Grid Infrastructure is installed. But after changing it, ASM services were not able to start. So here is the scenario and try outs of mine,.

Changing HOSTNAME and IP ADDRESS in GI (Standby Alone Server)

SERVER1:/usr2/oracle />hostname SERVER1-OLD
hostname: 0821-267 The sethostname system call failed.
: Operation not permitted.
SERVER1:/usr2/oracle />hostname SERVER1-OLD
hostname: 0821-267 The sethostname system call failed.
: Operation not permitted.
SERVER1:/usr2/oracle />hostname
SERVER1-OLD

SERVER1:/usr2/oracle />crsctl start has
SERVER1:/usr2/oracle />crsctl check has
CRS-4639: Could not contact Oracle High Availability Services

Continue reading…

COLS and COLSEXCEPT in Oracle GoldenGate

COLS | COLSEXCEPT

These parameters are used to Replicat only specific columns from the Source to Target. Suppose, let us consider a scenario, we have 10 columns in the source and we need only 9 columns to be replicated to the target table. Yes, this is possible using the above parameters.

COLS and COLSEXCEPT controls the columns for which data is captured. It means, only data of specific columns are captured and not all the columns.

This parameters are valid for Extract Process and should. Upon using this parameters, only the specified columns values are captured by the Extract Process and not all column’s values.
Continue reading…