Unlock Oracle10g scott

We know that scott must be unlocked before conn to scott/tiger for the first time. The steps for unlocking are as follows:

1: Start the database and run @ $ Oracle_HOME/db_1/rdbms/admin/utlsampl. SQL.

2: access the database through sqlplus again

3: alter user scott identified by tiger account unlock (if we do not know scott's password tiger at this time, we will directly use alter user scott account unlock, you can set the password again later) --- when we try to go to conn scott/tiger at this time, we can run pupbld on the conn, but the prompt says we want to run pupbld on the system user. SQL. We do not know the system password, so we can use the following method to set

4: alter user system identified by oracle -- after setting the system password, you can log on.

5: conn system/oracle

6: @ $ ORACLE_HOME/sqlplus/admin/pupbld. SQL -- run this SQL statement on the system user

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12