Unlock Oracle- Scott ID

After installation of Oracle10g, there was a problem ..couldnt login using SQL+. None of the accounts(scott/tiger) worked . At last a quick web search gave the solution . Here is what it is:

From your command prompt, type

sqlplus "/ as sysdba"

Once logged in as SYSDBA, you need to unlock the SCOTT account
SQL> alter user scott account unlock;
SQL> grant connect, resource to scott;

Accessing the "em" web application ?
http://hostname:1158/em

http://database-host:1158/em

Login as:
username : sysdba
password : <password>
Connect : Sysdba

Source


0 Response to "Unlock Oracle- Scott ID"

Post a Comment