|
|
Dear Erman,
We are upgrading to 11.2.0.4 using DBUA. We are facing the below error during the upgrade. Below is the pfile. We are not using spfile.
. ORA-00001: unique constraint (SYS.I_STMT_AUDIT_OPTION_MAP) violated
Any suggestions please?
pfile:
-bash-3.2$ cd /u02/TEST/db/tech_st/11.1.0/dbs
-bash-3.2$ cat initSSSEBSTR.ora
aq_tm_processes=1
audit_sys_operations=TRUE
compatible=11.1.0
control_files=/u02/TEST/db/apps_st/data/cntrl01.dbf, /u02/TEST/db/apps_st/data/cntrl02.dbf, /u02/TEST/db/apps_st/data/cntrl03.dbf
cursor_sharing=EXACT
db_block_checking=FALSE
db_block_checksum=TRUE
db_block_size=8192
db_file_name_convert='/u02/PROD/db/apps_st/data','/u02/TEST/db/apps_st/data'
db_files=512
db_name="SSSEBSTR"
diagnostic_dest=/u02/TEST/db/tech_st/11.1.0/admin/SSSEBSTR_ssstindcpopx02
dml_locks=10000
job_queue_processes=2
log_archive_dest_1='LOCATION=/u02/TEST/db/apps_st/data/archive'
log_archive_format=%t_%s_%r.dbf
log_buffer=10485760
log_checkpoint_interval=100000
log_checkpoint_timeout=1200
log_checkpoints_to_alert=TRUE
log_file_name_convert='/u02/PROD/db/apps_st/data','/u02/TEST/db/apps_st/data'
max_dump_file_size=20480
nls_comp=binary
nls_date_format="DD-MON-RR"
nls_length_semantics=BYTE
nls_numeric_characters=".,"
nls_sort=binary
nls_territory="america"
olap_page_pool_size=4194304
open_cursors=600
optimizer_secure_view_merging=FALSE
os_authent_prefix=""
parallel_max_servers=8
parallel_min_servers=0
pga_aggregate_target=1073741824
plsql_code_type=INTERPRETED
plsql_optimize_level=2
processes=200
sec_case_sensitive_logon=FALSE
session_cached_cursors=500
sessions=400
sga_target=1073741824
shared_pool_reserved_size=41943040
shared_pool_size=419430400
sql92_security=TRUE
undo_management=AUTO
undo_tablespace=APPS_UNDOTS1
utl_file_dir=/usr/tmp, /usr/tmp, /u02/TEST/db/tech_st/11.1.0/appsutil/outbound/SSSEBSTR_ssstindcpopx02, /usr/tmp
workarea_size_policy=AUTO
#event=""
Thanks,
Satish
|
Locked
