Friday, February 6, 2009

RAC : SPFILE configuration

Query : consider RAC setup having 2 nodes. first node showing the value of spfile parameter while on the second node it display as null value. spfile is on shared location.
Solution : although this config. is working without any error upto restart both the nodes individually but recommended is : both nodes are to provides the value for spfile parameter shoulb be same,because as this spfile is at shared location.
Edit this value on node2 as below:
(login to : 192.175.18.16)
SQL> !hostname
node1
SQL> show parameter spfile
NAME TYPE VALUE
------- ------- -------------------------------------------------------------------
spfile string /u001/DB_Config/spfile/testdb/spfiletestdb.ora
*NOTE : this /u001 is mount point for shared location...
(login to : 192.175.18.17)
SQL> !hostname
node2
SQL> show parameter spfile
NAME TYPE VALUE
--------- ------ ------------------------------------------------------------
spfile string
how to enable spfile value on both the nodes?
check the below config.
From node1:
1)check the value of init file:
$cat $ORACLE_HOME/dbs/initnode1.ora
SPFILE='/u001/DB_Config/spfile/testdb/spfiletestdb.ora'
From node2:
1)check the value of init file:
$cat $ORACLE_HOME/dbs/initnode2.ora
node2.__db_cache_size=1493172224
node2.__java_pool_size=16777216
node2.__large_pool_size=16777216
node2.__shared_pool_size=419430400
node2.__streams_pool_size=0
*.cluster_database_instances=2
*.cluster_database=true......
Needs to create new init file for node2 which is having the same value of spfile as node1 have it:
1)create new initfile for node2:
$vi initnode2.ora
SPFILE='/u001/DB_Config/spfile/testdb/spfiletestdb.ora'
2)shutdown node2 instance
SQL>shut immediate
3)startup this node2 and check the spfile parameter
SQL> show parameter spfile
NAME TYPE VALUE
------- ------- -----------------------------------------------------------
spfile string /u001/DB_Config/spfile/testdb/spfiletestdb.ora

No comments:

Post a Comment