TN console Error - Can not access to profile store.

Hi All,

I have newly installed wM 7.1.1 with IS, TN and MWS. While connecting through TN console to trading networks, it showing following error and closing console automatically. I have recreated and dropped and created the TN tables through Database componenet configurator. But there i s no luck…

But If i do test connectivity from IS Administrator → JDBC Pools for TN → its showing “Test of TN successful”

I have restarted oracle 10g related service also and but didnt work.

Could you please advise how to resolve this issue?

Error Details:
.
can not access to profile store.
Error initializing ProfileStore

com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
com.wm.dd.jdbc.base.BaseSQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))
at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplConnection.makeConnectionHelper(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplConnection.makeConnection(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)
at com.wm.dd.jdbc.oracle.OracleImplConnection.open(Unknown Source)
at com.wm.dd.jdbc.base.BaseConnection.connect(Unknown Source)
at com.wm.dd.jdbc.base.BaseConnectionStartup.run(Unknown Source)

Thanks in advance.
ArulChristhuRaj

After you completed the TN Pool db configuration reload WmTN package or restart IS to re-initialize.Check the logs and make sure everything is OK and re-login to TNC.

HTH,
RMG

loads of thanks to you. It worked after reloading WmTN Package.

Your welcome!