Oracle Database Commands and Practical Examples: Siemens PLM Teamcenter -connection : Failed to initialize the pool manager

Scenario Preview:

We are getting error while starting teamcenter console below . Failed to initialize the pool manager.

Error:

sgdc:/u01/teamcenterdata #

sgdc:/u01/Dev/pool_manager/confs/dev # ./mgrstart

Siemens and the Siemens logo are registered trademarks of Siemens AG.

Teamcenter is a registered trademark of Siemens Product Lifecycle Management

Software Inc. or its subsidiaries in the United States and in other countries.

This software and related documentation are proprietary to Siemens Product

Lifecycle Management Software Inc.

Rights Reserved.

JBoss copyright notice

JBoss and its use are subject to license: pool_manager\JBoss_lgpl_license.txt

JacORB copyright notice

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2.3.0 <www.jacorb.org>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

JacORB and its use are subject to license: pool_manager\JacORB_license.txt

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS

"AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT

LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR

A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT

OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,

SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT

LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,

DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY

THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT

(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE

OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

2019/10/16-13:21:58,939 UTC MLD Log init: com.teamcenter.mld version V10000.1.0.51_20160206.00 (20160216)

log.properties found at /u01/SMRDev/pool_manager/confs/minddev/log.properties

INFO - None - 2019/10/16-13:22:24,632 UTC - sgdc.abc.com - Starting Server Pool Mananger.

INFO - None - 2019/10/16-13:22:24,633 UTC - sgdc.abc.com - Found pool configuration file: /u01/Dev/pool_manager/confs/minddev/serverPool.properties

INFO - None - 2019/10/16-13:23:04,808 UTC - sgdc.abc.com - Attempting to establish teamcenter environment ...

INFO - None - 2019/10/16-13:23:04,891 UTC - sgdc.abc.com - Teamcenter Environment established

INFO - None - 2019/10/16-13:24:45,213 UTC - sgdc.abc.com - Mux Address is http://sgdc.abc.com:8087

INFO - None - 2019/10/16-13:24:45,213 UTC - sgdc.abc.com - Found TreeCache configuration file: /u01/SMRDev/pool_manager/confs/dev/TreeCacheTCP.xml

INFO - None - 2019/10/16-13:24:45,295 UTC - sgdc.abc.com - TreeCache Configuration:

TreeCache Cluster Name=Cluster

TreeCache Mode=TCP

Local Service Port=17800

TreeCache Socket Connect Timeout=2000

TreeCache Peers=SGDCPL06[17810]

TreeCache Port Range=1

TreeCache Connection Timeout=15000

TreeCache Merge Min=5000

TreeCache Merge Max=10000

TreeCache Join Timeout=1250

ERROR - None - 2019/10/16-13:24:45,420 UTC - sgdc.abc.com - Error initializing JBoss Cache com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager

org.jgroups.ChannelException: failed to start protocol stack

at org.jgroups.JChannel.connect(JChannel.java:389)

at org.jboss.cache.TreeCache.startService(TreeCache.java:1548)

at com.teamcenter.jeti.SharedStore.init(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.initCache(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.finishInit(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerManager.main(Unknown Source)

Caused by: java.lang.Exception: exception caused by TCP.start()

at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:600)

at org.jgroups.stack.DownHandler.run(Protocol.java:118)

Caused by: java.net.BindException: No available port to bind to

at org.jgroups.blocks.ConnectionTable.createServerSocket(ConnectionTable.java:342)

at org.jgroups.blocks.ConnectionTable.start(ConnectionTable.java:174)

at org.jgroups.blocks.ConnectionTable.<init>(ConnectionTable.java:84)

at org.jgroups.protocols.TCP.getConnectionTable(TCP.java:98)

at org.jgroups.protocols.TCP.start(TCP.java:62)

at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:589)

... 1 more

Failed to initialize the pool manager

org.jgroups.ChannelException: failed to start protocol stack

at org.jgroups.JChannel.connect(JChannel.java:389)

at org.jboss.cache.TreeCache.startService(TreeCache.java:1548)

at com.teamcenter.jeti.SharedStore.init(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.initCache(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.finishInit(Unknown Source)

at com.teamcenter.jeti.serversubpoolmanager.ServerManager.main(Unknown Source)

Caused by: java.lang.Exception: exception caused by TCP.start()

at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:600)

at org.jgroups.stack.DownHandler.run(Protocol.java:118)

Caused by: java.net.BindException: No available port to bind to

at org.jgroups.blocks.ConnectionTable.createServerSocket(ConnectionTable.java:342)

at org.jgroups.blocks.ConnectionTable.start(ConnectionTable.java:174)

at org.jgroups.blocks.ConnectionTable.<init>(ConnectionTable.java:84)

at org.jgroups.protocols.TCP.getConnectionTable(TCP.java:98)

at org.jgroups.protocols.TCP.start(TCP.java:62)

at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:589)

... 1 more

Solution:

Add database details in the tc_profile file.

Location : /u01/Dev/pool_manager/confs/dev

Instance SID : ddev

sgdc:/u01/Dev/pool_manager/confs/dev #

pom_schema_sgdc.abc.com_ddev

TC_BUILD_DATE=100001020130604; export TC_BUILD_DATE

TC_DB_CONNECT=xxxx:xxxxxxxxx@ddev;
export TC_DB_CONNECT

ORACLE_SID=ddev; export ORACLE_SID

TC_DB_SERVER=sgdc.abc.com; export TC_DB_SERVER

Tnsnames.ora entery

sgdc:/u01/teamcenterdata # cat tnsnames.ora

###########

# FILENAME: tnsnames.ora

# DATE : Wed May 03 15:04:46 CEST 2017

###########

XXXRAC =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = sgdc.abc.com)(PORT = 1531))

)

(CONNECT_DATA =

(SERVICE_NAME = rac)

)

XXXDEV =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST =sgdc.abc.com)(PORT = 1531))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = DDEV)

)

Start teamcenter again

sgdc:/u01/Dev/pool_manager/confs/ddev # ./mgrstart