Oracle Installation - How To Unlock the Sample User Account

How To Unlock the Sample User Account

Q

How To Unlock the Sample User Account? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition

✍: FYIcenter.com

A

Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it:

Log into the server home page as SYSTEM.
Click the Administration icon, and then click Database Users.
Click the HR schema icon to display the user information for HR.
Enter a new password (hr) for HR, and change the status to Unlocked.
Click Alter User to save the changes.

Now user account HR is ready to use.

2007-04-24, 4531👍, 0💬

How To Change Program Global Area (PGA)
How To Change Program Global Area (PGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Your 10g XE server has a default setting for Program Global Area (PGA) of 40MB. The PGA size can be changed to a new value depending on how much data a single session should be allocated. ... 2007-04-24, 4537👍, 0💬

How To Unlock the Sample User Account
How To Unlock the Sample User Account? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it: Log into the server home page as SYSTEM. Click t... 2007-04-24, 4532👍, 0💬

How To Shutdown Your 10g XE Server from Command Line
How To Shutdown Your 10g XE Server from Command Line? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition You can shutdown your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StopDB.bat. The ... 2007-04-24, 4369👍, 0💬

How To Start Your 10g XE Server from Command Line
How To Start Your 10g XE Server from Command Line? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition You can start your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StartDB.bat. The batch... 2007-04-24, 4221👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.