I struggled a bit trying to get my local Oracle XE up and running after a couple months of being dormant.
Firstly:
Oracle XE 11g sets password expiry by default. Quiet annoying...
So my system account was locked.
How to unlock that I did the following on the window command prompt:
set ORACLE_SID=XE
set ORACLE_HOME= "ORACLE_PATH" (D:\OracleXe\app\oracle\product\11.2.0\server) in my case.
sqlplus / as sysdba
ALTER USER SYSTEM identified by password;
If the account is locked run:
ALTER USER system ACCOUNT UNLOCK;
Then, to ensure that it does not expire again:
ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED;
One more thing I needed to change since I had installed a local Tomcat, is the default HTTP port for XE.
This can be done with 3010 is the new port:
Exec DBMS_XDB.SETHTTPPORT(3010)
This message is great.
ReplyDeleteĐặt vé tại phòng vé Aivivu, tham khảo
ReplyDeletevé máy bay đi Mỹ hạng thương gia
giá vé máy bay đi từ mỹ về việt nam
vé máy bay khứ hồi từ đức về việt nam
vé máy bay từ nga về tphcm
khi nào có chuyến bay từ anh về việt nam
vé máy bay từ pháp về việt nam giá rẻ
vé máy bay cho chuyên gia nước ngoài