> SQLPLUS /NOLOG
>
> CONNECT / AS SYSDBA
When I run this command, I get a ORA-12560: TNS:Protocol Adapter
Error. Thanks for the suggestions.
> ALTER USER SCOTT IDENTIFIED BY newpassword;
> EXIT;
>
> The connect as ultra-super-duper user "/" (which is really SYS) is a last
> resort. Under normal circumstances you would do
>
>
> SQLPLUS SYSTEM/system_password
> ALTER USER SCOTT IDENTIFIED BY newpassword;
> EXIT;
>
>
> While in SQL Plus, you may need to unlock SCOTT using
>
> ALTER USER SCOTT ACCOUNT UNLOCK;
>
> (The indents are to indicate this gets typed into SQLPLUS.)
>
> You really should consider spending a bit more time in the ORACLE CONCEPTS
> manual and skip the ORACLE DATABASE ADMINISTRATION manual at
> http://docs.oracle.com
>
> HTH
> /Hans
Received on Mon Jul 19 2004 - 11:19:11 CDT
