My Oracle Support Banner

INST-07064 Upgrading Portal to 11g if Schema Name Is Not 'PORTAL' (Doc ID 1358501.1)

Last updated on MARCH 12, 2020

Applies to:

Portal - Version to [Release 10gR2 to FMW11g]
Information in this document applies to any platform.


This problem occurs when attempting a 10g-> 11g upgrade on a Portal environment where the Portal schema uses a custom schema name. i.e. the schema name is different from the standard default schema name of 'Portal'.

Oracle® Fusion Middleware Upgrade Guide for Oracle Portal, Forms, Reports, and Discoverer 11g Release 1 (11.1.1) 

Chapter 3 Upgrading Your Oracle Portal, Forms, Reports, and Discoverer Environment, Task 5c.

WLS 10.3.4 is installed.
The FMW binaries have been installed and upgraded to the latest version (

Running from the Fusion Middleware Oracle Home to configure Portal.
At step " Specifying the PORTAL Schema Name and Password", entering the correct connection details for the portal schema results in an error:

INST-07064: Unable to connect to the database with the given credentials.

The log file shows this error:] [tid: <TID>] [ecid: <ECID>] Exception[[
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.SQLStateMapping.newSQLException(

Database tracing shows the ORA-00942 error is related to this statement:

Error encountered: ORA-00942

The same problem does not occur when connecting to a default Portal seeded schema.


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

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