ORA-600 [Kspsetpao2] When Creating SPFILE From PFILE (Doc ID 434228.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Getting this error when trying to create SPFILE from PFILE or alter SPFILE.


create spfile from pfile
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kspsetpao2], [1724], [1700], [*], [utl_file_dir], [21], [], []

OR

ORA-00600: internal error code, arguments: [kspsetpao1], [1583], [1563], [*], [UTL_FILE_DIR], [1], [], []

Current SQL statement for this session:

alter system set shared_pool_size=550M scope=spfile



Call Stack Trace:

ksedst ksedmp ksfdmp kgerinv kgesinv ksesin kspsetpao ksplrmpt lrmaikv lrmpzax pzmove pz5strt7
lrmpzpparse lrmpst kspcsetsp kspsetsp ksplrmpt lrmaikv lrmpzax pzmove pz5strt7 lrmpzpparse lrmpfi
kspcspfp kspocte opiexe opiosq0 kpooprx kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv

Changes

Changed PFILE to include extra UTL_FILE_DIR directories as in below, stopped and restarted database using PFILE.


*.utl_file_dir='/ora/shared/peps/pps_transfers','/ora/shared/peps/umms','/ora/shared/peps/interfacedata','/ora/shared/peps/interfacedata/tillogfiles','/ora/shared/peps/interfacedata/sddfiles','/ora/shared/peps/uploads','/ora/shared/peps/uploads/cesfiles_dev','/ora/shared/peps/uploads/cesfiles_dev/pims_logfiles','/ora/shared/peps/uploads/cesfiles_dev/pims_logfiles_loaded','/ora/shared/peps/uploads/cesfiles_dev/tempa_logfiles_loaded','/ora/shared/peps/uploads/cesfiles_dev/rdar_logfiles','/ora/shared/peps/uploads/cesfiles_dev/rdar_logfiles_loaded',','/ora/shared/peps/uploads/cesfiles_dba/umms_logfiles'','/ora/shared/peps/uploads/cesfiles_dba/umms_logfiles_loaded','/ora/shared/peps/uploads/cesfiles_dba/tempa_logfiles'

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