ssomig Fails When the MRDB Database Version is 10.2 or 11g (Doc ID 1369360.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Server Single Sign-On - Version 10.1.2 to 10.1.4 [Release 10gR2 to 10gR3]
Information in this document applies to any platform.
***Checked for relevance on 05-SEP-2013***

Symptoms

Symptom 1: ssomig -export fails

Oracle Single Sign-On (SSO) 10g is deployed with Oracle database 11g (11.2.0.x) for Metadata Repository Database (MRDB).

Exporting OracleAS Single Sign-On External Applications data by running ssomig -export fails with error:

$ORACLE_HOME/sso/bin/ssomig -s orasso -p XXXX -c -log_d /tmp/ssoexp_01112012 -export -log_f ssoexpmig.log -d ssoexpmig.dmp

****** EXPORT:: EXPORT DATA FROM SSO SCHEMA ******
Exporting sso data...
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
Note: indexes on tables will not be exported
Note: constraints on tables will not be exported

About to export specified tables via Conventional Path ...
. . exporting table WWSSOUM_WWSUB_MODEL$ 1 rows exported
. . exporting table WWSSOUM_PREFS_STORE$ 1 rows exported
. . exporting table WWSSOUM_SPREFS_STORE$ 5 rows exported
. . exporting table WWSSOUM_USER$ 1 rows exported
. . exporting table WWSSOUM_PAPP_CFG$ 6 rows exported
. . exporting table WWSSOUM_EXTAPP_CFG$ 1 rows exported
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully

SSO-80050: Data export unsuccessful.
Please check the log file /app/oracle/work/ssomig.log .



Symptom 2: ssomig -import hangs

The Oracle SSO 10g data from an existing Identity Management environment is being migrated to a new server. The target environment MRDB is RDBMS 10.2.x or 11.2.x.

Importing OracleAS Single Sign-On External Applications data by running ssomig -import hangs or freezes with no further output. There is no activity in the target database at this time.

Example ssomig command and output:

/app/oracle/product/infra/sso/bin/ssomig -import -overwrite -s orasso -p X6f3j2bF -c infra -d ssomig.dmp -log_d /app/oracle/work/import_OID

SSO Migration Tool: Release 10.1.4.3.0 - Production on Sat Mar 31 20:35:58 2012
Copyright (c) 2002,2007 Oracle. All rights reserved.

Verifying SSO schema information...

Data import started at Sat Mar 31 20:35:58 2012

Log Directory : /app/oracle/work
Log File Name : /app/oracle/work/ssomig.log
Import File Name : ssomig.dmp
SSO Schema Name : orasso
SSO Schema Password : ******
Connect String : infra
Mode : overwrite




There is no further output for the command and it does not complete/return to operating system prompt.

There is a stderr.log file generated in the log directory specified in the ssomig command, containing something like the following:

Import: Release 10.1.0.5.0 - Production on Sat Mar 31 20:35:58 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Username:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.01.00 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
. importing ORASSO's objects into ORASSO
. . importing table "WWSSOUM_WWSUB_MODEL$" 1 rows imported
. . importing table "WWSSOUM_PREFS_STORE$" 1 rows imported
. . importing table "WWSSOUM_SPREFS_STORE$" 5 rows imported
. . importing table "WWSSOUM_USER$" 115 rows imported
. . importing table "WWSSOUM_PAPP_CFG$" 11 rows imported
. . importing table "WWSSOUM_EXTAPP_CFG$" 1 rows imported
. . importing table "WWSSOUM_EXTAPP_INFO$" 0 rows imported
. . importing table "WWSSOUM_EXTAPP_USER_INFO$" 0 rows imported
. . importing table "WWSSOUM_CONF$" 3 rows imported
. . importing table "WWSSOUM_WWSEC_ENABLER_CFG$" 0 rows imported
. . importing table "WWSSOUM_PSEX_USER_INFO$" 14 rows imported
. . importing table "WWSSOUM_PSEX_APP_INFO$" 2 rows imported




The previous ssomig -export command succeeded without errors.

The solution in <Document 954090.1> 'Ssomig Import Operation Hangs' cannot be implemented because the MRDB is located on a different server.


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