INST-07064 Upgrading Portal to 11g if Schema Name Is Not 'PORTAL'

(Doc ID 1358501.1)

Last updated on MARCH 08, 2017

Applies to:

Portal - Version and later
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) 

We are at 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 FusionMiddleware 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: 13] [ecid: 0000IzVU75O3j4CXBDYBVh1Dmdqm000004,0] 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 :


SELECT MR_TYPE FROM schema_version_registry WHERE UPPER(OWNER)=UPPER('portallive')
Error encountered: ORA-00942

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


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms