Hi,

I have installed wM8.2 IS, MWS (also DB).
IS started, when I start MWS, I'm keep getting this error:

Error creating database connection to: jdbc:wm:oracle://localhost:1521;serviceName=XE
java.sql.SQLNonTransientConnectionException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))

Any views please.

Rgds,
Sam

To add on to the above.
when i tested the JDBCPool connection test in IS admin page, I got the below. Previously it was working.
Can you tell me what is serviceName in this?

Test of wM8DB Failed
[sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-12514 Connection refused, the specified service name (XE) was not recognized by the Oracle server.

Hi Sam,

Please Refer http://idnxchange.com/webmethods-blogs/webmethods-712-step-by-step-installation.html step 7 in Blog which shows configuration of MWS while installing and also check your DB Config settings.

The service name in your case is "XE"

Since its a SQLNonTransient Connection Exception and your connection was previously working, check whether your DB is available or not. Restart your DB if required and check it again.

Let me know if this works.

Thanks

Yes after restart, DB connectivity test from IS is working fine.

To increase the session because of the below error: ( I did the session increase in SPFILEXE.ORA, that could be the reason DB connectivity test from IS was not working fine. Not sure). Once I revert back the change and restart, DB Connectivity was working fine.

Error creating database connection to: jdbc:wm:oracle://localhost:1521;serviceName=XE
java.sql.SQLNonTransientConnectionException: [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]Connection refused, (DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12516)(ERROR_STACK=(ERROR=(CODE=12516)(EMFI=4))))

But, still MWS is not coming up.I see this error as below:


2012-12-27 08:24:56 EST (Framework:DEBUG) - [Pool - default]. Added new connection to check out pool. MaxSize = 100; total pool size = 1; idle pool size = 0; check out size = 1
2012-12-27 08:24:56 EST (Framework:INFO) - No registered exception delegate
2012-12-27 08:24:56 EST (Framework:FATAL) - [POP.004.0201] Cannot initialize MWS, invalid database schema is specified
com.webmethods.portal.system.init.InitializationException: [POP.004.0201] Cannot initialize MWS, invalid database schema is specified
at com.webmethods.portal.service.sql.core.ConnectionManager.validateDatasource(ConnectionManager.java:716)
at com.webmethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:285)
at com.webmethods.portal.service.sql.core.ConnectionManager.init(ConnectionManager.java:208)

Regards,
Sam

Hi,

The error indicates, '[b]Invalid Database Schema[/b]'..

[b]-> [/b]Look for [b]mws.db.xml[/b] file and see if the db information provided there matches with the db details
that you used in database configurator wizard while creating tables..

[b] ->[/b] You may check the JDBC Pools from IS Admin page. Meanwhile verify the Central Users Pool association to the MWS db schema.

Always follow the below steps while configuring your MWS DB:

1. Please use the Database Component Configurator to create a unique database or tablespace for this server instance. You can refer to the webMethods Installation Guide.

2. Make sure \MWS\server\test\config\mws.db.xml exists and the database information in the file are correct.


please take note that
1. each MWS instance must have its own database. for a given database server,
the following configuration entries must be unique among all mws instances that use the same database server:
- database user name
- database name

2. For MWS instances running concurrently on the same machine, the following host/port number,
if used, must be unique among all servers:
- HTTP port
- HTTPS port (if used)
- AJP13 port and IIS or Apache Web server host and port (if Used)


Thanks

Hi,

Even this error got resolved once I recreated the tables using DCC.
:( But couldn't access MWS: Now got this error: "HTTP Error 503".... trying hard ...

Regards,
Sam

Wow the main page has come up...
It took more than 30 min... Since it showed me "Done Complete" I tried accessing MWS. But now it auto restarted MWS and MWS is up... Thanks for your guidance all the way...

Regards,
Sam

Main page has come up ... Thanks.
Since it showed up "Done Complete" tried accessing MWS... but it did the auto restart... now I able to access MWS. Thanks for the guidance...

Regards,
Sam