Pavan DBA's Blog

The DBA Knowledge Store

Archive for the ‘RAC’ Category

How to resolve DBCA shell issues and TNS-04612 error

Posted by Pavan DBA on September 22, 2011


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….

 

 

 

 

 

 

 

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

 

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

Posted in RAC | Tagged: , , , , , , , , , | 1 Comment »

 
%d bloggers like this: