Friday, July 9, 2010

Exception setting "ViewEntireForest": "Could not find any Domain Controller in domain myoffice.local

Tried to run Exchange 2007 server EMS(Exchange management shell), and most of time, I got this error:

Exception setting "ViewEntireForest": "Could not find any Domain Controller in domain myoffice.local. The myoffice.local is up and running and all other machines did not complain the main. I run nslookup against this domain in the exchange server without any error. I remember I can use the lmhosts file to define the location of the domain, so I put a line below in the end of the lmhosts file, and it fixed my error:

192.168.1.20 MylocalDomain #PRE #DOM:myoffice.local

Tuesday, July 6, 2010

Bad public user name or password. Database Server Error: ORA-28001: the password has expired

One of our Primavera user tried to login to Project Management it is coming up with , and the user select to configure the database connection, but in the end, it gave the following error message:
"Bad public user name or password. Database Server Error: ORA-28001: the password has expired;"

I helped them to fix by the steps below:

1. Open a DOS Prompt, and type the command below:
sqlplus /as sysdba

2. After you see the SQL prompt, type the SQL statement below:

CREATE PROFILE Primavera_Profile LIMIT PASSWORD_LIFE_TIME UNLIMITED;

alter user pubuser PROFILE Primavera_Profile;
alter user privuser PROFILE Primavera_Profile;

NOTE: the user above may need to be changed if pubuser1 or privuser1 is used.
3. Try to launch your PM6 again.