Sunday, July 31, 2011

Unable to create database at 11g release 2 grid, scan IP was not running on both nodes

After successful installation of Oracle 11g release2 patchset1 grid and database software, I tried to create a new 11g RAC database using DBCA, but it stuck at an error 'database creation requires scan IP to be running, can not create database', on further investigation I found SCAN IP was not configured at my grid infrastructure by default, so I follwed the below sequence of commands to create and start the SCAN

On node1
========
srvctl add vip -n testnode01 -k 1 -A testnode01-vip/255.255.255.0/en0

srvctl add scan -n 
<scan-name>  in my case scan name is 'testnode-scan'

srvctl add scan_listener

srvctl start vip -n testnode01
srvctl start scan
srvctl start scan_listener

On node2
========
srvctl add vip -n testnode02 -k 1 -A testnode02-vip/255.255.255.0/en0

srvctl start vip -n testnode02
srvctl start scan
srvctl start scan_listener


       After completing above steps I am able to create a new database.

Regards,

Farrukh Salman.

No comments:

Post a Comment