1. If the SCOTT user is locked, you need to unlock it:
    sqlplus sys@orcl as sysdba
    alter user scott identified by tiger account unlock;
    
  2. If the demo tables in the SCOTT schema have not been created, you can create them:
    1. Create a copy of the d:\ora1012infra\rdbms\admin\scott.sql script:
      cd /d D:\ora1012infra\rdbms\admin
      copy scott.sql scott_orcl.sql
      
    2. Edit the copy of the script, adding the TNS alias to the CONNECT statement:
      CONNECT SCOTT/TIGER@ORCL
      
    3. Run the modified script as SYS:
      cd /d D:\ora1012infra\rdbms\admin
      sqlplus sys@orcl as sysdba @scott_orcl.sql
      
  3. Connect as SCOTT:
    sqlplus scott/tiger@orcl
    
  4. (Optional) Do some serious work:
    select ename from emp order by 1;