Home » SQL & PL/SQL » Client Tools » SP2-0606: Cannot create SPOOL file "password/hr_main.log" (Oracle Database 18c)
icon4.gif  SP2-0606: Cannot create SPOOL file "password/hr_main.log" [message #674212] Thu, 10 January 2019 14:51 Go to next message
Kinto
Messages: 1
Registered: January 2019
Junior Member
I trying to get the sample schemas HR set up for testing in Oracle DB 18c but I am getting error.

specify password for SYS as parameter 4: 
Enter value for 4: Pass1
SP2-0606: Cannot create SPOOL file "Pass1/hr_main.log"
PL/SQL procedure successfully completed.

User created. 
User alerted. 
User alerted. 
Grand succededd.
Grand succededd. 
... 
Commennt created. 
Commit complete. 
PL/SQL procedure successfully completed.
not spooling currently

Anyone have an idea how to solve it? In third line:
SP2-0606: Cannot create SPOOL file "Pass1/hr_main.log"
and in the last line:
not spooling currently
Re: SP2-0606: Cannot create SPOOL file "password/hr_main.log" [message #674215 is a reply to message #674212] Thu, 10 January 2019 15:52 Go to previous messageGo to next message
BlackSwan
Messages: 26643
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read


OS user does not have OS permissions to write OS file "Pass1/hr_main.log"

Does directory "Pass1" now exist?
Does OS user have write permission into "Pass1" directory?
Re: SP2-0606: Cannot create SPOOL file "password/hr_main.log" [message #674218 is a reply to message #674212] Fri, 11 January 2019 00:37 Go to previous messageGo to next message
Michel Cadot
Messages: 66728
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SP2-00606: Cannot create %s file \"%s\"\n
 *Cause:  The STORE or SPOOL command was unable to create the specified
          file. There may be insufficient disk space, too many open
          files, or read-only protection on the output directory.
 *Action:Check that there is sufficient disk space and that the
          protection on the directory allows file creation.

[Updated on: Fri, 11 January 2019 00:38]

Report message to a moderator

Re: SP2-0606: Cannot create SPOOL file "password/hr_main.log" [message #674220 is a reply to message #674212] Fri, 11 January 2019 04:15 Go to previous message
John Watson
Messages: 8085
Registered: January 2010
Location: Global Village
Senior Member
What file are you running? The hr_main.sql file in the db-sample-schemas-18c.zip that you should have downloaded from Github gives you two more prompts before enabling spooling. From the top of the file:
PROMPT 
PROMPT specify password for HR as parameter 1:
DEFINE pass     = &1
PROMPT 
PROMPT specify default tablespeace for HR as parameter 2:
DEFINE tbs      = &2
PROMPT 
PROMPT specify temporary tablespace for HR as parameter 3:
DEFINE ttbs     = &3
PROMPT 
PROMPT specify password for SYS as parameter 4:
DEFINE pass_sys = &4
PROMPT 
PROMPT specify log path as parameter 5:
DEFINE log_path = &5
PROMPT
PROMPT specify connect string as parameter 6:
DEFINE connect_string     = &6
PROMPT

-- The first dot in the spool command below is 
-- the SQL*Plus concatenation character

DEFINE spool_file = &log_path.hr_main.log
SPOOL &spool_file

Previous Topic: UTTL_HTTP to POST CLOB request
Next Topic: VMware Installation
Goto Forum:
  


Current Time: Sat Dec 14 18:00:18 CST 2019