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.

Advertisements

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 10.2.0.1.0 - Production

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

  httpport
----------
      8080

Change the port:

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

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

There you go! cheers!