This content has been marked as final. Show 3 replies
I followed the tutorial step by step. There are no locks on this table or schema. The tutorial says that the user name and password is "hr" but when pressing run and entering this for both username and password it fails. If I enter the user as hr_apex and give the password I created I go to the next page which shows the data for the EMPLOYEES table. There seems to be a miss print in the instructions.
First, would you be able to connect using 'sql*plus' to the database user 'hr'?
SYSTEM@XE > connect hr/hr ERROR: ORA-28000: the account is locked Warning: You are no longer connected to ORACLE. @ > conn system@xe Enter password: Connected. Mon 08/22/2011 08:55 AM SYSTEM@xe > alter user hr account unlock; User altered. Elapsed: 00:00:00.01 SYSTEM@xe > connect hr/hr Connected. Mon 08/22/2011 08:56 AM HR@XE >