Database Reference
In-Depth Information
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk rac_off ioracle
…
/usr/bin/ar d /opt/oracle/product/db10.2/rdbms/lib/libknlopt.a kcsm.o
/usr/bin/ar cr /opt/oracle/product/db10.2/rdbms/lib/libknlopt.a /opt/oracle/product/
db10.2/rdbms/lib/ksnkcs.o
- Linking Oracle
gcc -o /opt/oracle/product/db10.2/rdbms/lib/oracle ... -lknlopt ...
…
mv /opt/oracle/product/db10.2/rdbms/lib/oracle /opt/oracle/product/db10.2/bin/oracle
chmod 6751 /opt/oracle/product/db10.2/bin/oracle
The most interesting parts are the
ar
commands. First
ar
is used to remove the object file
kcsm.o
from
libknlopt.a
(kernel options library), then the object file
ksnkcs.o
is added to
libknlopt.a
. This removes the RAC option. Another startup attempt yields this:
$ env ORACLE_SID=TEN1 sqlplus / as sysdba
SQL> STARTUP
ORA-00439: feature not enabled: Real Application Clusters
The reason for ORA-00349 is that DBMS instances in a RAC environment are run with the
parameter setting
CLUSTER_DATABASE=TRUE
. But this parameter can only have the value
TRUE
if
RAC is linked in. So we need to set
CLUSTER_DATABASE=FALSE
. In case you're using an
SPFILE
, you
won't be able to modify it without starting an instance, which is currently impossible. So you
need to transform the
SPFILE
by removing the binary contents, such that you get a plain text
file, and remove the parameter
CLUSTER_DATABASE
, which defaults to
FALSE
. The next attempt
then yields this:
$ cd $ORACLE_HOME/dbs
$ strings spfileTEN1.ora | grep -v cluster > pfileTEN1.ora
$ env ORACLE_SID=TEN1 sqlplus / as sysdba
SQL> STARTUP NOMOUNT PFILE=pfileTEN1.ora
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1261564 bytes
Variable Size 201326596 bytes
Database Buffers 104857600 bytes
Redo Buffers 7127040 bytes
SELECT value FROM v$option WHERE parameter='Real Application Clusters';
VALUE
----------------------------------------------------------------
FALSE
Finally the RDBMS instance has started. As long as it does not use ASM storage you are all
set. But what if ASM is used? Let's attempt to start an ASM instance with CRS down, the RAC
option removed, and the initialization parameter setting
CLUSTER_DATABASE=FALSE
.
