Last updated on MARCH 08, 2017
Applies to:Portal - Version 10.1.4.2 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'.
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 (220.127.116.11).
Running config.sh from the FusionMiddleware 18.104.22.168 Oracle Home to configure Portal.
At step "22.214.171.124 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:
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms