How to Connect and Unlock user in Oracle Database 11g Express edition


When users click on SESSION, oracle application ask for session ID and password. The default user HR session are locked.


Click on ALL PROGRAM
Find the Oracle Database 11g Express Edition
Click ob Run SQL Command Line


Type CONNECT and execute the query



  • Enter username like system
  • Enter password - password of the database which you input at the time of database installing
  • After password press enter
  • Connected

  • UNLOCK USER
  • Run SQL query "ALTER USER HR ACCOUNT UNLOCK"
  • Press Enter

  • CHANGE USER PASSWORD


Enter in Oracle Database.

Thanks
Labels:
Reactions:

Post a Comment

[disqus][facebook][blogger]

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget