Oracle DB Express Edition Command Cheat Sheet

If you are trying to Connect for the first time to Oracle Express Edition(any version later to 10g) whose SID = "orcl".Then go to cmd and start with the below :

TRY TO CONNECT AS SYSDBA FIRST, WITHOUT GIVING THE PASSWORD:
sqlplus / as sysdba;

ALTER THE PASSWORD NOW WITH THE BELOW COMMAND , WHERE NEW PASSWORD IS "my_password"
alter user sys identified by my_password;

NOW EXIT THE CONNECTION
exit

TRY TO CONNECT WITH THE BELOW COMMAND WITH THE HELP OF NEW PASSWORD FOR SYS ACCOUNT
sqlplus sys/my_password@orcl as sysdba;

AFTER CONNECTING SUCCESSFULLY ,ALTER THE PASSWORD OF HR ACCOUNT(if you forgot password for hr account) WITH THE HELP OF BELOW COMMAND WITH THE NEW PASSWORD my_password_hr:
alter user hr identified by my_password_hr;

NOW EXIT THE CONNECTION
exit

TRY TO CONNECT WITH THE BELOW COMMAND WITH THE HELP OF NEW PASSWORD FOR HR ACCOUNT
sqlplus hr/hr;

IF THE HR ACCOUNT IS LOCKED , THEN USE THE BELOW COMMAND FOR UNLOCKING THE HR ACCOUNT:
alter user hr account unlock identified by [my_password_hr];

Problem with Oracle 11g Database Release 2

After you download both the zipped files File 1 and File 2 , we will run into a problem with the installation of the database.
Problem : We would be getting the error "WFALSNRscvapp.ear" file not found".
Solution to this is you need to extract the two unzipped files to a same/single folder/directory.
Please refer the following link if you cannot still solve this .
https://community.oracle.com/thread/1061283