This happened with a fresh installation of the Oracle 10G Express Edition downloaded from Oracle’s website. TechieDan was playing with Qlikview, and in order to connect to a database using the OLE DB method, an installation to test out the connection was done.
Tested with one of the test users for the db with the username scott. Looks like it came out with this message.
User Account Scott is Locked
Seemingly, though, Oracle 10G has an administration website and it’s just easy to change the settings for this user.
This is the main screen for the Oracle Enterprise Manager 10G. On the Internet there are loads and loads of instruction to modify the username using SQL which is indeed confusing to the a certain few, so why not something straightforward to just modify the user direct from the administration panel.
From that screen scroll down some more until one finds the User & Privileges Menu options.
The next screen will bring a display of the many users of the Oracle DB, and the one we’re interested in now is the username Scott. Click the radio button next to it and click on Edit.
By doing this, you will now be on the next screen, which is the most critical and important part to modify it’s privileges and also to finally unlock this user.
By following the steps above, you have finally unlocked the user Scott. Finally one can access their DB using scott.
Wished I learned Oracle 🙂
🙁 when i open the databse control it dont shows the tabs which includes administration tab… bt shows the following message
”
Database Instance: orcl
Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.
Page Refreshed
Feb 20, 2012 12:15:06 AM
Database Instance
Host
saMi
Port
1521
SID
orcl
Oracle Home
C:\oracle\product\10.2.0\db_1
Listener
Status
Up
Host
saMi
Port
1521
Name
LISTENER
Oracle Home
C:\oracle\product\10.2.0\db_1
Location
C:\oracle\product\10.2.0\db_1\network\admin
Agent Connection to Instance
Status
Failed
Details
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)
please help me 🙁
”
thanks…alot
I have installed oracle express edition, but there is no scott user found to be unlock.
Please help me to get the SCOTT schema.
Thanks.
Try to install oracle but paging file size is big blockage for my site is there any solution 🙁
tech forum