After upgrading many databases to Oracle 19c, I have faced an interesting error when I reached to the step of switch my environment variables to 19c binaries and starting the database in upgrade mode:
sqlplus / as sysdba
SQL> startup upgrade;
ORA-00119: invalid specification for system parameter DISPATCHERS
ORA-00109: invalid value for attribute PRESENTATION: oracle.aurora.server.SGiopServer
after checking I found out that currently this is the parameter vaule:
SQL> show parameter dispatchers
NAME TYPE VALUE
———————————— ———– ——————————
dispatchers string (PROTOCOL=TCP)(PRE=oracle.auro
ra.server.SGiopServer)
basically DISPATCHERS configures dispatcher processes in the shared server architecture: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DISPATCHERS.html
in 19c the expected value is ‘(PROTOCOL=TCP)
so, either use alter system command or update your init.ora file and startup the database again in upgrade mode !
SQL> ALTER SYSTEM SET dispatchers = ‘(PROTOCOL=TCP)’;