Using Designer 10.1.2 RAU to Upgrade a Repository in a 9i Database Fails with CDR-21244, ORA-2248 (Doc ID 334484.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Repository - Version 10.1.2 and later
Information in this document applies to any platform.
Repository Administration Utility
Upgrade

"Checked for relevance on 05-Aug-2014"


Symptoms

Updating a repository from the Repository Administration Utility (RAU) fails with:
   CDR-21244: This process has been aborted.

The following errors are found in ckprereq.log.
   IMP-00003: ORACLE error 2248 encountered
   ORA-02248: invalid option for ALTER SESSION
   IMP-00000: Import terminated unsuccessfully

Versions:
   Designer Client: Oracle Designer 10g Release 2 Version 10.1.2.0.2
   Designer Repository: Oracle Designer 9i Release 9.0.2.8
   Database: RDBMS 9.2.0.5

Cause

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