Добрый день,
Обновился до
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
При старте получил ошибку (ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance)
, но база стартанула и запустилась все работает нормально ..

в Log

2020-10-13T17:16:54.003340+03:00
db_recovery_file_dest_size of 307200 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

Пробовал менять параметр db_recovery_file_dest_size но все знаю когда он 100% но вот когда 0% задумался
ORA гуру есть идеи ?

проходил мимо...,

Patch Id: 27923415
Patch Description: OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)
Patch Apply Time: 2018-07-18T20:41:38+03:00
Bugs Fixed: 27304131,27461740,27539876,27636900,27642235,27952586

Patch Id: 27908644
Patch Description: UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U171
Patch Apply Time: 2018-07-18T20:44:11+03:00
Bugs Fixed: 27908644
===========================================================
2020-10-13T17:51:25.447571+03:00
Starting background process CJQ0
2020-10-13T17:51:25.462856+03:00
CJQ0 started with pid=68, OS id=31393
Completed: ALTER DATABASE OPEN
2020-10-13T17:52:55.795888+03:00

У меня fast recovery area не заполняется

SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
db_recovery_file_dest_size big integer
1G

and

DB_RECOVERY_FILE_DEST_SIZE = 1G
DB_RECOVERY_FILE_DEST = ''

Идея есть убрать
DB_RECOVERY_FILE_DEST_SIZE = 1G
DB_RECOVERY_FILE_DEST = ''
из spfile

путем create pfile from spfile

удалить
DB_RECOVERY_FILE_DEST_SIZE = 1G
DB_RECOVERY_FILE_DEST = ''

Далее стартуем базу
startup pfile = ""

далее
Create spfile from pfile

flexgen,
Включена и работает Oracle можно архивировать несколькими способами не обязательно использовать опцию fast recovery area

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oracle/oradata/MWIDBWEB/archive/
Oldest online log sequence 7099
Next log sequence to archive 7101
Current log sequence 7101

Убрал
Идея есть убрать
DB_RECOVERY_FILE_DEST_SIZE = 1G
DB_RECOVERY_FILE_DEST = ''
из spfile

пересоздал spfile,,,
Не помогло ошибка при старте ORA-32004 осталась.
Но в Log больше нет ругани на DB_RECOVERY_FILE_DEST.
Архивация настроена как standby
.... (PID:26695): Using STANDBY_ARCHIVE_DEST parameter default value as /u01/oracle/oradata/MWIDBWEB/archive/ [krsd.c:17692]

Полный лог
**********************************************************************
2020-10-14T09:04:01.422041+03:00
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2020-10-14T09:04:01.452680+03:00
Initial number of CPU is 8
Number of processor cores in the system is 8
Number of processor sockets in the system is 4
Capability Type : Network
capabilities requested : 1 detected : 0 Simulated : 0
Capability Type : Runtime Environment
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems
capabilities requested : 3 detected : 0 Simulated : 0
Autotune of undo retention is turned on.
IMODE=BR
ILAT =51
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Using default ASM root directory ASM
NOTE: Cluster configuration type = NONE [2]
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0.
ORACLE_HOME: /u01/oracle/product/18.3/dbhome_1
System name: Linux
Node name: wellinfo01ora
Release: 4.12.14-95.24-default
Version: #1 SMP Thu Jul 11 13:05:06 UTC 2019 (7b265b8)
Machine: x86_64
Using parameter settings in server-side spfile /u01/oracle/product/18.3/dbhome_1/dbs/spfileMWIDBWEB.ora
System parameters with non-default values:
processes = 300
sga_target = 8G
control_files = "/u01/oracle/oradata/MWIDBWEB/control01.ctl"
control_files = "/u01/oracle/fast_recovery_area/MWIDBWEB/control02.ctl"
db_block_size = 8192
db_16k_cache_size = 512M
db_32k_cache_size = 512M
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/u01/oracle/oradata/MWIDBWEB/archive/ MANDATORY REOPEN=300"
undo_tablespace = "UNDOTBS1"
sec_case_sensitive_logon = FALSE
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=MWIDBWEBXDB)"
local_listener = "LISTENER_MWIDBWEB"
audit_file_dest = "/u01/oracle/admin/MWIDBWEB/adump"
audit_trail = "DB"
db_name = "MWIDBWEB"
db_unique_name = "MWIDBWEB"
open_cursors = 300
pga_aggregate_target = 8759M
diagnostic_dest = "/u01/oracle"
Deprecated system parameters with specified values:
sec_case_sensitive_logon
End of deprecated system parameter listing
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2020-10-14T09:04:01.716005+03:00
============================================================
NOTE: PatchLevel of this instance 0
============================================================
2020-10-14T09:04:07.512811+03:00
WARNING: Invalid value for listener related parameter MIXED LISTENER
2020-10-14T09:04:07.512913+03:00
ORA-00141: all addresses specified for parameter LOCAL_LISTENER are invalid
ORA-00132: syntax error or unresolved network name 'LISTENER_MWIDBWEB'
Starting background process PMON
2020-10-14T09:04:07.530798+03:00
PMON started with pid=2, OS id=26524
Starting background process CLMN
2020-10-14T09:04:07.549657+03:00
CLMN started with pid=3, OS id=26526
Starting background process PSP0
2020-10-14T09:04:07.568657+03:00
PSP0 started with pid=4, OS id=26528
Starting background process VKTM
2020-10-14T09:04:08.591310+03:00
VKTM started with pid=5, OS id=26600 at elevated (RT) priority
2020-10-14T09:04:08.591331+03:00
Starting background process GEN0
2020-10-14T09:04:08.593031+03:00
VKTM running at (1)millisec precision with DBRM quantum (100)ms
2020-10-14T09:04:08.605802+03:00
GEN0 started with pid=6, OS id=26608
Starting background process MMAN
2020-10-14T09:04:08.622285+03:00
MMAN started with pid=9, OS id=26610
Starting background process GEN1
2020-10-14T09:04:08.670832+03:00
GEN1 started with pid=8, OS id=26614_26615
Starting background process DIAG
Starting background process OFSD
2020-10-14T09:04:08.688209+03:00
DIAG started with pid=11, OS id=26617
2020-10-14T09:04:08.711502+03:00
Oracle running with ofslib:'Oracle File Server Library' version=2
2020-10-14T09:04:08.724434+03:00
DBRM started with pid=14, OS id=26626
Starting background process VKRM
2020-10-14T09:04:08.741286+03:00
VKRM started with pid=15, OS id=26628
Starting background process SVCB
2020-10-14T09:04:08.756417+03:00
SVCB started with pid=16, OS id=26630
Starting background process PMAN
Starting background process DIA0
2020-10-14T09:04:08.775499+03:00
PMAN started with pid=17, OS id=26632
2020-10-14T09:04:08.790405+03:00
DIA0 started with pid=18, OS id=26646
Starting background process DBW0
2020-10-14T09:04:08.812175+03:00
DBW0 started with pid=19, OS id=26648
Starting background process LGWR
2020-10-14T09:04:08.828892+03:00
LGWR started with pid=20, OS id=26650
Starting background process CKPT
2020-10-14T09:04:08.845384+03:00
CKPT started with pid=21, OS id=26652
2020-10-14T09:04:08.861594+03:00
LGWR slave LG00 created with pid=22, OS pid=26656
Starting background process SMON
2020-10-14T09:04:08.877327+03:00
SMON started with pid=24, OS id=26660
Starting background process SMCO
LGWR slave LG01 created with pid=23, OS pid=26662
2020-10-14T09:04:08.910745+03:00
SMCO started with pid=25, OS id=26664
Starting background process RECO
2020-10-14T09:04:08.926679+03:00
RECO started with pid=26, OS id=26666
Starting background process LREG
2020-10-14T09:04:08.962717+03:00
LREG started with pid=28, OS id=26670
Starting background process PXMN
2020-10-14T09:04:08.996898+03:00
PXMN started with pid=30, OS id=26678
Starting background process FENC
2020-10-14T09:04:09.013837+03:00
FENC started with pid=31, OS id=26680
Starting background process MMON
Starting background process MMNL
2020-10-14T09:04:09.031896+03:00
MMON started with pid=32, OS id=26682
2020-10-14T09:04:09.048134+03:00
MMNL started with pid=31, OS id=26684
2020-10-14T09:04:09.048190+03:00
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Starting background process TMON
2020-10-14T09:04:09.096697+03:00
TMON started with pid=35, OS id=26690
ORACLE_BASE from environment = /u01/oracle
2020-10-14T09:04:09.156405+03:00
ALTER DATABASE MOUNT
2020-10-14T09:04:11.869309+03:00
Using default pga_aggregate_limit of 17518 MB
2020-10-14T09:04:13.416102+03:00
.... (PID:26695): Redo network throttle feature is disabled at mount time
2020-10-14T09:04:13.434613+03:00
Successful mount of redo thread 1, with mount id 2292378249
2020-10-14T09:04:13.434982+03:00
Database mounted in Exclusive Mode
Lost write protection disabled
.... (PID:26695): Using STANDBY_ARCHIVE_DEST parameter default value as /u01/oracle/oradata/MWIDBWEB/archive/ [krsd.c:17692]
Completed: ALTER DATABASE MOUNT
2020-10-14T09:04:13.540260+03:00
ALTER DATABASE OPEN
2020-10-14T09:04:13.557189+03:00
Ping without log force is disabled:
instance mounted in exclusive mode.
Endian type of dictionary set to little
2020-10-14T09:04:13.579664+03:00
LGWR (PID:26650): STARTING ARCH PROCESSES
Starting background process ARC0
2020-10-14T09:04:13.595711+03:00
TT00 (PID:26895): Gap Manager starting
2020-10-14T09:04:13.609290+03:00
ARC0 started with pid=36, OS id=26897
2020-10-14T09:04:13.619525+03:00
LGWR (PID:26650): ARC0: Archival started
LGWR (PID:26650): STARTING ARCH PROCESSES COMPLETE
2020-10-14T09:04:13.619709+03:00
ARC0 (PID:26897): Becoming a 'no FAL' ARCH
ARC0 (PID:26897): Becoming the 'no SRL' ARCH
2020-10-14T09:04:13.621567+03:00
Redo log for group 3, sequence 7101 is not located on DAX storage
2020-10-14T09:04:13.625295+03:00
TMON (PID:26690): STARTING ARCH PROCESSES
Starting background process ARC1
2020-10-14T09:04:13.642230+03:00
ARC1 started with pid=42, OS id=26901
Starting background process ARC2
2020-10-14T09:04:13.650825+03:00
Thread 1 opened at log sequence 7101
Current log# 3 seq# 7101 mem# 0: /u01/oracle/oradata/MWIDBWEB/redo03.log
Successful open of redo thread 1
2020-10-14T09:04:13.651316+03:00
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
stopping change tracking
2020-10-14T09:04:13.657777+03:00
ARC2 started with pid=43, OS id=26903
Starting background process ARC3
2020-10-14T09:04:13.674005+03:00
ARC3 started with pid=44, OS id=26905
2020-10-14T09:04:13.674104+03:00
TMON (PID:26690): ARC1: Archival started
TMON (PID:26690): ARC2: Archival started
TMON (PID:26690): ARC3: Archival started
TMON (PID:26690): STARTING ARCH PROCESSES COMPLETE
2020-10-14T09:04:13.824933+03:00
Undo initialization recovery: err:0 start: 1154456959 end: 1154456961 diff: 2 ms (0.0 seconds)
[26889] Successfully onlined Undo Tablespace 2.
Undo initialization online undo segments: err:0 start: 1154456962 end: 1154456994 diff: 32 ms (0.0 seconds)
Undo initialization finished serial:0 start:1154456959 end:1154456998 diff:39 ms (0.0 seconds)
Verifying minimum file header compatibility for tablespace encryption..
Verifying file header compatibility for tablespace encryption completed for pdb 0
Database Characterset is CL8MSWIN1251
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process AQPC
2020-10-14T09:04:14.222243+03:00
AQPC started with pid=46, OS id=26929
2020-10-14T09:04:17.913341+03:00
Shared IO Pool defaulting to 368MB. Trying to get it from Buffer Cache for process 26682.
Patch Description: OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)
Patch Apply Time: 2018-07-18T20:41:38+03:00
Bugs Fixed: 27304131,27461740,27539876,27636900,27642235,27952586

Patch Id: 27908644
Patch Description: UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U171
Patch Apply Time: 2018-07-18T20:44:11+03:00
Bugs Fixed: 27908644
===========================================================
2020-10-14T09:04:19.494775+03:00
Starting background process CJQ0
2020-10-14T09:04:19.509919+03:00
CJQ0 started with pid=67, OS id=27190
Completed: ALTER DATABASE OPEN

Точно, спасибо не заметил ...
Решение
alter system reset sec_case_sensitive_logon scope=both;

И вуаля
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 8589933416 bytes
Fixed Size 12217192 bytes
Variable Size 1375731712 bytes
Database Buffers 7197425664 bytes
Redo Buffers 4558848 bytes
Database mounted.
Database opened.
вопрос ЗАКРЫТ ..
спасибо большое