Oracle 11g user password expired locked

To find the details of the users in your DB, execute the following statement:

select username, account_status, expiry_date, lock_date from dba_users;

To unlock the account, execute the following:

alter user se account unlock;

To change the password, execute following:

alter user se identified by sepm;

NOTE:  Old and new password can be same.


Changing default oracle XE http port

Default port after installation in oracle is 8080; You can check and change it it by doing the following on the command prompt:

sqlplus system@xe 

Enter password:

Verbunden mit:
Oracle Database 10g Express Edition Release - Production

SQL>select dbms_xdb.gethttpport as "httpport" from DUAL;  


Change the port:

2 dbms_xdb.sethttpport('8085');
3 end;
4 /

SQL> select dbms_xdb.gethttpport as "httpport" from dual;

There you go! cheers!