Advertisements

Tuesday, February 17, 2015

When oracle db password expires

Use this instructions to unlock the user account when the password is expired:

--check user status
select username, expiry_date, account_status from dba_users where username = 'USERACC';


1--To unlock an user:
2 
3alter user USERACC ACCOUNT UNLOCK;

1--To reset the password:
2 
3alter user USERACC identified by ARISBP01;


--But we'd like to use the existing password so we proceed with:

01--To Keep same Password:
02 
03 
04 
05select 'alter user "'||d.username||'" identified by values '''||u.password||''';'
06 
07from dba_users d, sys.user$ u
08 
09where d.username = upper('USERACC ')
10 
11and u.user# = d.user_id;


1alter user "USERACC " identified by values '4301288F751F9615';
2 
3 
4 
5 
6 
7--On a production system, has to change this limit to unlimited to solve this and to avoid this in future.
8 
9ALTER PROFILE DEFAULT LIMIT password_life_time UNLIMITED;
1<span style="font-family: Arial, Helvetica, sans-serif; white-space: normal;">Don't forget to commit;</span>

SOA Error - "Failed to compile bpel generated classes"

When trying to compile an AIA composite project I'm getting the following error:


Error(13,63): Instantiation exception for implementation type "implementation.bpel", validating component "CreateCustomerPartyLAProvABCSImplProcess". Exception is "Failed to compile bpel generated classes.
failure to compile the generated BPEL classes for BPEL process "CreateCustomerPartyLAProvABCSImplProcess" of composite "default/CreateCustomerPartyLAProvABCSImpl!1.0"
The class path setting is incorrect.
Ensure that the class path is set correctly. If this happens on the server side, verify that the custom classes or jars which this BPEL process is depending on are deployed correctly. Also verify that the run time is using the same release/version."

This is because I'm missing a library:

Go to project preference/Library classpath

Add the library aia.jar:


Solved!