title: SP2-0606: Cannot create SPOOL file
body: <p>I use Oracle 12c R2 on Windows 10 pro x64. I get sample script by</p>
  
  <pre><code>cd E:\github.com\oracle
  git clone https://github.com/oracle/db-sample-schemas.git
  </code></pre>
  
  <p>in CMD</p>
  
  <pre><code>E:\github.com\oracle\db-sample-schemas\human_resources&gt;sqlplus sys/summer as sysdba
  
  SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 28 11:15:24 2017
  
  Copyright (c) 1982, 2014, Oracle.  All rights reserved.
  
  
  Connected to:
  Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
  
  SQL&gt; @hr_main.sql
  
  specify password for HR as parameter 1:
  Enter value for 1: 123456
  
  specify default tablespeace for HR as parameter 2:
  Enter value for 2: hr_tablespace
  
  specify temporary tablespace for HR as parameter 3:
  Enter value for 3: hr_temp_tablespace
  
  specify password for SYS as parameter 4:
  Enter value for 4: summer
  
  specify log path as parameter 5:
  Enter value for 5: C:\vy\
  
  specify connect string as parameter 6:
  Enter value for 6: localhost:1521/orcl
  
  SP2-0606: Cannot create SPOOL file "C:\vy\hr_main.log"
  DROP USER hr CASCADE
            *
  ERROR at line 1:
  ORA-01918: user 'HR' does not exist
  
  
  CREATE USER hr IDENTIFIED BY 123456
              *
  ERROR at line 1:
  ORA-65096: invalid common user or role name
  
  
  ALTER USER hr DEFAULT TABLESPACE hr_tablespace
             *
  ERROR at line 1:
  ORA-01918: user 'HR' does not exist
  
  
  ALTER USER hr TEMPORARY TABLESPACE hr_temp_tablespace
             *
  ERROR at line 1:
  ORA-01918: user 'HR' does not exist
  
  
  GRANT CREATE SESSION, CREATE VIEW, ALTER SESSION, CREATE SEQUENCE TO hr
                                                                       *
  ERROR at line 1:
  ORA-01917: user or role 'HR' does not exist
  
  
  GRANT CREATE SYNONYM, CREATE DATABASE LINK, RESOURCE , UNLIMITED TABLESPACE TO hr
                                                                                 *
  ERROR at line 1:
  ORA-01917: user or role 'HR' does not exist
  
  
  ERROR:
  ORA-12514: TNS:listener does not currently know of service requested in connect
  descriptor
  
  
  Warning: You are no longer connected to ORACLE.
  SP2-0640: Not connected
  ERROR:
  ORA-12514: TNS:listener does not currently know of service requested in connect
  descriptor
  
  
  SP2-0640: Not connected
  SP2-0640: Not connected
  SP2-0310: unable to open file "E:\github.com\oracle\db-sample-schemas\human_resources\human_resources\hr_cre.sql"
  SP2-0310: unable to open file "E:\github.com\oracle\db-sample-schemas\human_resources\human_resources\hr_popul.sql"
  SP2-0310: unable to open file "E:\github.com\oracle\db-sample-schemas\human_resources\human_resources\\hr_idx.sql"
  SP2-0310: unable to open file "E:\github.com\oracle\db-sample-schemas\human_resources\human_resources\\hr_code.sql"
  SP2-0310: unable to open file "E:\github.com\oracle\db-sample-schemas\human_resources\human_resources\\hr_comnt.sql"
  SP2-0310: unable to open file "E:\github.com\oracle\db-sample-schemas\human_resources\human_resources\\hr_analz.sql"
  not spooling currently
  SQL&gt;
  </code></pre>
  
  <p>How to fix these error:</p>
  
  <pre><code>SP2-0606: Cannot create SPOOL file
  ORA-01918: user 'HR' does not exist
  ORA-65096: invalid common user or role name
  </code></pre>