SQLPLUS Hangs when Using "spool out" Command on Solaris (Doc ID 459004.1)

Last updated on OCTOBER 28, 2016

Applies to:

SQL*Plus - Version 10.1.0.3 to 11.1.0.6 [Release Oracle10g to 11.1]
Oracle Solaris on SPARC (64-bit)
Sun 386i Sun/OS
Solaris Operating System (SPARC 64-bit)
"Checked for relevance on 21-Mar-2013"


Symptoms

When spool out command issued from SQLPLUS for versions 10.1.0.3 to 10.2.0.3.0 on Solaris platform, the spool file is printed but SQLPLUS hangs. The session has to be manually killed.

Changes

This can occur after upgrading RDBMS to one of the reported version (10.1.0.3 to 10.2.0.3).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms