I was running an Oracle Database Upgrade of version 12.2.0.0 to 19c (patched up to 19.16) using the DBUA, in a Windows server machine.
In the process of the upgrade, in the post-upgrade steps, the upgrade failed because it could not start the new Listener service (though it was correctly configured).
There was no specific error in the logs, except from the message that it could not start the Listener service:
Oracle Net Services Configuration:
Configuring Listener:LISTENER Default local naming configuration complete.
Listener configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
D:\app\oracle\product\19.0.0\dbhome_1\bin\lsnrctl.exe start LISTENER Listener Control complete.
Listener start failed.
After a lot of retries and searching, I could not make the upgrade process finish successfully. Also the step was not available for ignore in the DBUA interface.
I had to abort the upgrade process and restore the Oracle home.
In my next attempt, after a lot of investigation, I used a flag to bypass the listener migration process as part of the database upgrade.
The way that I used the flag was:
dbua -skipListenersMigration
In the listener part of the interface I ignored and did not check any checkbox there.
So in post-upgrade steps, the listener migration was not included at all and the upgrade was completed successfully.
After that of course, I had to create manually the new 19c Listener service which worked successfully.
Written by Nikos Minaidis
09/11/2022
Nikos Minaidis 