Saturday, June 5, 2010

Bad public user name or password. Database Server Error: ORA-12170: TNS:Connect timeout occurred

Today I received a phone call from a client, he said when he tried to connect to Oracle from Primavera P6 V7, he got the error below:

Bad public user name or password. Database Server Error: ORA-12170: TNS:Connect timeout occurred

Because he was able to connect to the database in oracle 10g XE with Prmavera project management, and he claimed he did not change the configuration , so firewall or Oracle Instantclient settings should be fine. I further contacted his IT people about the Oracle server. He mentioned he did disable the Large Send Offload for the network adapter in the Oracle server yesterday, and the IT guy said he did not find any connection problem yet. But I think the ORA-12170 error should be caused by this change, and I asked him to disable the network adapter, then enable it again, finally restart the Oracle instance. After that, the ORA-12170 error's gone.

No comments:

Post a Comment