SSOMIG Fails With Errors SP2-0310 and SSO-80051 (Doc ID 1064435.1)

Last updated on JANUARY 24, 2013

Applies to:

Oracle Application Server Single Sign-On - Version 10.1.4 to 10.1.4.3 [Release 10gR3]
Information in this document applies to any platform.

Symptoms

SSOMIG utility fails during export from repository.

 Example:

SP2-0310: unable to open file "ssomvrck.sql"

SSO Migration Tool: Release 10.1.2.0.0 - Production on Wed Feb 17 09:32:22 2010
Copyright (c) 2002-2004 Oracle. All rights reserved.

Data export started at Wed Feb 17 09:32:22 2010

Log Directory : C:\log
Log File Name : C:\log\ssomig.log
Export File Name : C:\log\ssomig.dmp
SSO Schema Name : orasso
SSO Schema Password : ******
Connect string : <SID>

****** EXPORT:: DETERMINE NLS INFORMATION ******
Running ssomnls.sql
sqlplus -s orasso/***** @ssomnls.sql UNIX C:\log\ssonlse.log
Setting NLS_LANG to: AMERICAN_AMERICA.WE8ISO8859P1

****** EXPORT:: COPY DATA FROM SSO SCHEMA ******
Running ssomex1a.sql
sqlplus -s orasso/***** @ssomex1a.sql
SP2-0310: unable to open file "ssomex1a.sql"

Writing all subscriber ids and names to file C:\log\ssomexsu.log
Running ssomexs1.sql
sqlplus -s orasso/***** @ssomexs1.sql
SP2-0310: unable to open file "ssomexs1.sql"

Selected subscriber(s)...
maysteel [1]

Running ssomexa1.sql
sqlplus -s orasso/***** @ssomexa1.sql
SP2-0310: unable to open file "ssomexa1.sql"

Selected External Application(s)...

Writing all partner application ids and names to file C:\log\ssomexpa.log
Running ssomexp1.sql
sqlplus -s orasso/***** @ssomexp1.sql
SP2-0310: unable to open file "ssomexp1.sql"

Selected Partner Application(s)...

Running ssomex1b.sql
sqlplus -s orasso/***** @ssomex1b.sql C:\log\0.438201904296875 TRUE
SP2-0310: unable to open file "ssomex1b.sql"

SSO-80051: Copying data into the temporary tables failed.

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