My Oracle Support Banner

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

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.4 [Release 10.2 to 11.2]
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


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

 

Changes

 

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
Changes
Cause
Solution
References

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