f sqlplus responds, enter the user name and password. If you have
installed with all defaults the users (OE, SH, HR, and SCOTT) will be
created but not unlocked so you would probably log onto SYSTEM something
like
----------
sqlplus
system
******* (<< the password you set during installation)
alter user OE identified by new_password account unlock;
alter user SCOTT identified by new_password account unlock;
exit
sqlplus
scott
****** (<< the password you set above)
SELECT *
FROM EMP;
-------------
http://groups.google.de/group/comp.databases.oracle.server/browse_thread/thread/8e3a8fe8b45ed27f/34a4cb0b265626ee?lnk=st&q=10g+sqlplus+user&rnum=2&hl=de#34a4cb0b265626ee