Thursday 17 November 2011

RAC Category


Archive for the ‘RAC’ Category
Friends, would like to share some critical errors and their resolution while creating a RAC database
Today, I got a request to create a RAC database on a server (this server already contains 3 RAC databases up and running and I am creating 4th one)
when i export ORACLE_HOME and initiated DBCA, i got below error/warning messages
/export/home/oracle > setenv DISPLAY=10.91.173.153:0.0
/export/home/oracle >
/export/home/oracle > echo $DISPLAY
10.91.173.153:0.0=
/export/home/oracle >
/export/home/oracle > dbca &
[1] 1015
/export/home/oracle > [main] [3:23:2:534] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:23:2:535] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523)(IP=FIRST))
[main] [3:23:2:535] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:23:2:535] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523)(IP=FIRST))
[main] [3:23:2:536] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523)(IP=FIRST))
[main] [3:23:2:536] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523)(IP=FIRST))
[main] [3:23:2:536] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523)(IP=FIRST))
[main] [3:23:2:539] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:23:2:539] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:23:2:539] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523))
[main] [3:23:2:539] [NetworkUtils.getLocalListenerAddresses:999]  listener[0]=LISTENER_W276UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523))
[main] [3:23:2:540] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:23:2:541] [NetworkUtils.getOneLocalListenerProtocolAddress:2796]  returning bestAddrSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1521)(IP=FIRST))
[main] [3:23:2:541] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1521)(IP=FIRST))
[main] [3:23:2:541] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1521)(IP=FIRST))
[main] [3:23:2:541] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1521)(IP=FIRST))
[main] [3:23:2:541] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:23:2:542] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:23:2:542] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1521))
[main] [3:23:2:542] [NetworkUtils.getLocalListenerAddresses:999]  listener[1]=LISTENER_localhost address=null
[main] [3:23:2:543] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:23:2:543] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525)(IP=FIRST))
[main] [3:23:2:543] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:23:2:544] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525)(IP=FIRST))
[main] [3:23:2:544] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525)(IP=FIRST))
[main] [3:23:2:545] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525)(IP=FIRST))
[main] [3:23:2:545] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525)(IP=FIRST))
[main] [3:23:2:545] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:23:2:545] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:23:2:546] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525))
[main] [3:23:2:546] [NetworkUtils.getLocalListenerAddresses:999]  listener[2]=LISTENER_W271UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525))
[main] [3:23:2:547] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:23:2:548] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522)(IP=FIRST))
[main] [3:23:2:548] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:23:2:549] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522)(IP=FIRST))
[main] [3:23:2:549] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522)(IP=FIRST))
[main] [3:23:2:549] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522)(IP=FIRST))
[main] [3:23:2:549] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522)(IP=FIRST))
[main] [3:23:2:549] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:23:2:550] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:23:2:550] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522))
[main] [3:23:2:550] [NetworkUtils.getLocalListenerAddresses:999]  listener[3]=LISTENER_W203UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522))
[main] [3:23:2:551] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:23:2:551] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527)(IP=FIRST))
[main] [3:23:2:551] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:23:2:552] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527)(IP=FIRST))
[main] [3:23:2:552] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527)(IP=FIRST))
[main] [3:23:2:552] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527)(IP=FIRST))
[main] [3:23:2:552] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527)(IP=FIRST))
[main] [3:23:2:552] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:23:2:553] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:23:2:553] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527))
[main] [3:23:2:553] [NetworkUtils.getLocalListenerAddresses:999]  listener[4]=LISTENER_W282UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527))
[main] [3:23:2:554] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:23:2:554] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529)(IP=FIRST))
[main] [3:23:2:555] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:23:2:555] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529)(IP=FIRST))
[main] [3:23:2:555] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529)(IP=FIRST))
[main] [3:23:2:555] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529)(IP=FIRST))
[main] [3:23:2:556] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529)(IP=FIRST))
[main] [3:23:2:556] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:23:2:556] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:23:2:556] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529))
[main] [3:23:2:556] [NetworkUtils.getLocalListenerAddresses:999]  listener[5]=LISTENER_W294UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529))
[main] [3:23:2:558] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:23:2:558] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524)(IP=FIRST))
[main] [3:23:2:558] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:23:2:559] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524)(IP=FIRST))
[main] [3:23:2:559] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524)(IP=FIRST))
[main] [3:23:2:559] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524)(IP=FIRST))
[main] [3:23:2:559] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524)(IP=FIRST))
[main] [3:23:2:559] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:23:2:559] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:23:2:560] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524))
[main] [3:23:2:560] [NetworkUtils.getLocalListenerAddresses:999]  listener[6]=LISTENER_W214UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524))
[main] [3:23:2:560] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:23:2:561] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531)(IP=FIRST))
[main] [3:23:2:561] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:23:2:562] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531)(IP=FIRST))
[main] [3:23:2:562] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531)(IP=FIRST))
[main] [3:23:2:562] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531)(IP=FIRST))
[main] [3:23:2:562] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531)(IP=FIRST))
[main] [3:23:2:562] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:23:2:562] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:23:2:563] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531))
[main] [3:23:2:563] [NetworkUtils.getLocalListenerAddresses:999]  listener[7]=LISTENER_W306UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531))
[main] [3:23:2:564] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:23:2:564] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528)(IP=FIRST))
[main] [3:23:2:564] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:23:2:564] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528)(IP=FIRST))
[main] [3:23:2:565] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528)(IP=FIRST))
[main] [3:23:2:565] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528)(IP=FIRST))
[main] [3:23:2:565] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528)(IP=FIRST))
[main] [3:23:2:565] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:23:2:565] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:23:2:565] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528))
[main] [3:23:2:566] [NetworkUtils.getLocalListenerAddresses:999]  listener[8]=LISTENER_W280UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528))
[main] [3:23:2:566] [StepContext.setListenersToUpdate:702]  needLocalListener = true
Exception in thread “main”
[1]    Exit 1               dbca
So my DBCA failed and I couln’t initiate that. Then I had given a try by changing the SHELL. Till this time i used C shell and now i shifted to BASH shell and tried the same
/export/home/oracle > bash
bash-3.00$ export DISPLAY=10.91.173.153:0.0
bash-3.00$ echo $DISPLAY
10.91.173.153:0.0
bash-3.00$
bash-3.00$ dbca &
[1] 2042
bash-3.00$ [main] [3:24:9:80] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:24:9:81] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523)(IP=FIRST))
[main] [3:24:9:81] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:24:9:82] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523)(IP=FIRST))
[main] [3:24:9:82] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523)(IP=FIRST))
[main] [3:24:9:82] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523)(IP=FIRST))
[main] [3:24:9:82] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523)(IP=FIRST))
[main] [3:24:9:85] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:24:9:85] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:24:9:85] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523))
[main] [3:24:9:85] [NetworkUtils.getLocalListenerAddresses:999]  listener[0]=LISTENER_W276UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1523))
[main] [3:24:9:87] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:24:9:87] [NetworkUtils.getOneLocalListenerProtocolAddress:2796]  returning bestAddrSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1521)(IP=FIRST))
[main] [3:24:9:87] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1521)(IP=FIRST))
[main] [3:24:9:87] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1521)(IP=FIRST))
[main] [3:24:9:87] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1521)(IP=FIRST))
[main] [3:24:9:88] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:24:9:88] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:24:9:88] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1521))
[main] [3:24:9:89] [NetworkUtils.getLocalListenerAddresses:999]  listener[1]=LISTENER_localhost address=null
[main] [3:24:9:89] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:24:9:90] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525)(IP=FIRST))
[main] [3:24:9:90] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:24:9:90] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525)(IP=FIRST))
[main] [3:24:9:91] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525)(IP=FIRST))
[main] [3:24:9:91] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525)(IP=FIRST))
[main] [3:24:9:91] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525)(IP=FIRST))
[main] [3:24:9:91] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:24:9:91] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:24:9:91] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525))
[main] [3:24:9:92] [NetworkUtils.getLocalListenerAddresses:999]  listener[2]=LISTENER_W271UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1525))
[main] [3:24:9:92] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:24:9:93] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522)(IP=FIRST))
[main] [3:24:9:93] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:24:9:93] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522)(IP=FIRST))
[main] [3:24:9:93] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522)(IP=FIRST))
[main] [3:24:9:94] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522)(IP=FIRST))
[main] [3:24:9:94] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522)(IP=FIRST))
[main] [3:24:9:94] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:24:9:94] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:24:9:94] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522))
[main] [3:24:9:94] [NetworkUtils.getLocalListenerAddresses:999]  listener[3]=LISTENER_W203UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1522))
[main] [3:24:9:95] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:24:9:96] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527)(IP=FIRST))
[main] [3:24:9:96] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:24:9:96] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527)(IP=FIRST))
[main] [3:24:9:96] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527)(IP=FIRST))
[main] [3:24:9:96] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527)(IP=FIRST))
[main] [3:24:9:97] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527)(IP=FIRST))
[main] [3:24:9:97] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:24:9:97] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:24:9:97] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527))
[main] [3:24:9:97] [NetworkUtils.getLocalListenerAddresses:999]  listener[4]=LISTENER_W282UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1527))
[main] [3:24:9:98] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:24:9:98] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529)(IP=FIRST))
[main] [3:24:9:99] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:24:9:99] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529)(IP=FIRST))
[main] [3:24:9:100] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529)(IP=FIRST))
[main] [3:24:9:100] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529)(IP=FIRST))
[main] [3:24:9:100] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529)(IP=FIRST))
[main] [3:24:9:100] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:24:9:100] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:24:9:101] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529))
[main] [3:24:9:101] [NetworkUtils.getLocalListenerAddresses:999]  listener[5]=LISTENER_W294UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1529))
[main] [3:24:9:102] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:24:9:102] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524)(IP=FIRST))
[main] [3:24:9:103] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:24:9:103] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524)(IP=FIRST))
[main] [3:24:9:103] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524)(IP=FIRST))
[main] [3:24:9:103] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524)(IP=FIRST))
[main] [3:24:9:103] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524)(IP=FIRST))
[main] [3:24:9:104] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:24:9:104] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:24:9:104] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524))
[main] [3:24:9:104] [NetworkUtils.getLocalListenerAddresses:999]  listener[6]=LISTENER_W214UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1524))
[main] [3:24:9:105] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:24:9:105] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531)(IP=FIRST))
[main] [3:24:9:105] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:24:9:105] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531)(IP=FIRST))
[main] [3:24:9:106] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531)(IP=FIRST))
[main] [3:24:9:106] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531)(IP=FIRST))
[main] [3:24:9:106] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531)(IP=FIRST))
[main] [3:24:9:107] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:24:9:107] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:24:9:107] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531))
[main] [3:24:9:107] [NetworkUtils.getLocalListenerAddresses:999]  listener[7]=LISTENER_W306UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1531))
[main] [3:24:9:108] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=localhost.abcdefgh.com
[main] [3:24:9:108] [NetworkUtils.getOneLocalListenerProtocolAddress:2721]  bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528)(IP=FIRST))
[main] [3:24:9:108] [NetworkUtils.getOneLocalListenerProtocolAddress:2734]  host=null hostParam=10.28.210.234
[main] [3:24:9:109] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528)(IP=FIRST))
[main] [3:24:9:109] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528)(IP=FIRST))
[main] [3:24:9:109] [NetworkUtils.getOneLocalListenerProtocolAddress:2856]  Returning bestSoFar=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528)(IP=FIRST))
[main] [3:24:9:109] [NetworkUtils.getOneLocalListenerProtocolAddress:2636]  Checking for IP=FIRST in addr:(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528)(IP=FIRST))
[main] [3:24:9:109] [NetworkUtils.getOneLocalListenerProtocolAddress:2645]  IP=FIRST found! Removing it from pos:3
[main] [3:24:9:110] [NetworkUtils.getOneLocalListenerProtocolAddress:2647]  Initializing addr from NVPair
[main] [3:24:9:110] [NetworkUtils.getOneLocalListenerProtocolAddress:2649]  Updated address (ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528))
[main] [3:24:9:110] [NetworkUtils.getLocalListenerAddresses:999]  listener[8]=LISTENER_W280UR_localhost address=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.abcdefgh.com)(PORT=1528))
[main] [3:24:9:110] [StepContext.setListenersToUpdate:702]  needLocalListener = true
As you can see above, still i faced same errors/warnings, but my DBCA is working now….
http://pavandba.files.wordpress.com/2011/09/rac-error.jpg?w=300&h=240







For whom BASH shell is also not working, try to do silent db creation using DBCA (For steps, refer to Oracle doc)
Note : I whitened the server name here for security reasons
I entered all details like SID name, locations of database files (I am using ASM) etc and when finished, DBCA thrown me below error

http://pavandba.files.wordpress.com/2011/09/tns.jpg?w=300&h=212
The above error is clearly stating that there is some problem with manual entries in TNSNAMES.ORA file. So I checked and fixed that. (If it doesn’t work, you can take a backup of tnsnames.ora file and remove manual entries. But at same time be careful and check if those tns strings are in use)
Once I fixed it, DBCA started creating a database, but again failed at last with following error
PRKP-1001 : Error starting instance RACDB1 on node raclinux1
CRS-0215 : Could not start resource ‘ora.RACDB.RACDB1.inst’
when I checked the status of services from “crs_stat -t” command, its shown as below
ora.w306ur.db  application    ONLINE    ONLINE     pqrst4250b
ora….r1.inst application    ONLINE    OFFLINE    pqrst4250a
I tried to start the service using “crs_start <service_name” command… but landed with below error
crs_start ora.w306ur.w306ur1.inst
CRS-0215 : Could not start resource ‘ora.RACDB.RACDB1.inst’
Resource already running on pqrst4250a
Then I checked database and instance status which are showing fine
srvctl status database -d database_name
srvctl status instance -d database_name -i instance_name
Finally I got to know that the problem is with LOCAL_LISTENER and REMOTE_LISTENER entries are missing in TNSNAMES.ORA file. Once I added these entries on both nodes, database started without any issue now on node1. To be on safe side i restarted database on node 2 also.
Hope this post helps if you face same or similar issue….. Plz rate this if you like it

No comments:

Post a Comment