My Oracle Support Banner

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

Last updated on AUGUST 15, 2018

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.