Server Manager hangs on startup and Method Server fails to launch in Windchill PDMLink

[dnpermadhy-2]

Version: Windchill 11.0

Use Case: Windchill in our customer; methode server cann't start with error: "ORA-01017: invalid username/password; logon denied".

Description:

We are using Windchill PDMLink Version 11.0 M030/Oracle 11

1. Since last week, CAD Creo users cannot/slowresponse access to the server. First I was check via status server >> average response time (red).
2. Then, I restarted Windchill services (WC shell ; Stop >> Start).
3. But in this point, windchill methode server cann't start back to stopped status in services.msc windows. Users can not acces anymore (Service unavailable).
4. We checked  log,result at screenshot below :

• Next ,we checked the DB server ( we use separate server for DB Oracle).

Storage almost full,then we extended storage tablespace.

Then we try again to start the Windchill,but unfortunelly it stills no started.

Do you know what happen? Server manager likes hangUp! methodserver fails to start.

Information in log :

We follow the resolution CS125275 below,but still not works:

Do you have any others ideas/suggestions?

Thank you for helps.

==deddy==

[VladimirN]

Articles:

• "Method Server fails to start and throws error "java.sql.SQLException: ORA-01017: invalid username/password; logon denied" in Windchill PDMLink": https://www.ptc.com/en/support/article/CS50219 
• "Data Extraction returns ORA-01017: invalid username/password; logon denied in Windchill Bulk Migrator": https://www.ptc.com/en/support/article/CS100167 

[dnpermadhy-2]

Hi Vladimir ,

Problem still not resolved(methode server nor starting), I have followed the steps in the article CS50219.

Does anyone have another solution or Best Practise Windchill PDMLink with Oracle DB?

Regards

Deddy

[HelesicPetr · Accepted solution]

Hi @dnpermadhy-2 

If the log file says wrong user name or password, I would really check if the user name and password is correct in  the db.properties.

Yes the password is encrypted but I would test the login to the DB with the user that is used for Windchill db connection.

For example, the password could expired in DB based on policies or something else. 

Also reset the password in db.propertioes that works with login in a sqlplus

PetrH

[dnpermadhy-2]

Hi PetrH & Vladimir , ,

Thanks for your helps.

But I have some next questions: How to control the connections/network between the method server and the database?? Whats properties should I adjust? how to control caches in Windchill. Our Windchill manages a lot of files (large assemblies) then DB server in separate VM server. Have you best practise for this?

To what extent does the network problem affect communication between windchill and the database? what causes this to happen? as in my case at the beginning (invalid username/password - ORA0107).

Thanks again for your help.

==deddy==

[vnamboodheri]

Hello @dnpermadhy-2, 

Looks like you have a response for your question. If it helped to answer your question please mark the reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.