My Oracle Support Banner

Database upgrade fails with Error:ORA-00119 ,ORA-00132 ,ORA-01078,ORA-01034 (Doc ID 431437.1)

Last updated on DECEMBER 12, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.




Symptoms

        Upgrade from 9.2.0.7 to 10.2.0.3.
    
        DBUA starts.
        Pick the database to be upgraded.
        DBUA prompts for pfile.
        Enter "$ORACLE_HOME/dbs/init<SID>_for_upgrade.ora" 
        Then DBUA throws a pop-up window, saying:

 

        --------
        The Upgrade Assistant failed in bringing up the database <SID>. Oracle Home
        $ORACLE_HOME obtained from file /var/opt/oracle/oratab was used to connect to
        the database. Either the database is not running from Oracle Home $ORACLE_HOME or
        the pfile $ORACLE_HOME/dbs/init<SID>_for_upgrade.ora used is incorrect.  Correct
        the error and run the Upgrade Assistant again.
        --------


    
        "startup upgrade" using the same pfile from an OS prompt has no error.

         If the database is already started under 9.2 then the error changes to:
    

         DBUA gave errors on init parameter local_listener:
           ORA-00119: invalid specification for system parameter local_listener
           ORA-00132: syntax error or unresolved network name <LISTENER NAME>
           ORA-01078: failure in processing system parameters

or


DBUA Upgrade to 11.2.0.4 shows errors:

PreUpgrade.log of DBUA logs  shows the following  error:

select count(*) from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER NAME'
select username from dba_users
*
ERROR at line 1:
ORA-01034: ORACLE not available

 or

dbupgrade to 19c fails with:

*********** Executing Change Scripts ***********
Serial Phase #:0 [ORCL] Files:1
Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at $ORACLE_HOME/rdbms/admin/catcon.pm line 18176, <Reader> line 21.
at $ORACLE_HOME/rdbms/admin/catcon.pm line 18176, <Reader> line 21.
catcon::catcon_HandleSigINT("INT") called at /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catcon.pm line 1203
eval {...} called at $ORACLE_HOME/rdbms/admin/catcon.pm line 1203
catcon::exec_DB_script(ARRAY(0x110967f00), "C:A:T:C:O:N", "\x{a}host sqlplus -v >", "$ORACLE_HOME/cfgtoollogs/SPKB_STB/"..., "$ORACLE_HOME/bin/sqlplus") called at

 alert log shows:

WARNING: Invalid value for listener related parameter MIXED LISTENER
ORA-00141: all addresses specified for parameter LOCAL_LISTENER are invalid
ORA-00132: syntax error or unresolved network name '1551'

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.