Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> The file convSID.dbf is not created after running the mig command
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C06C2F.3296A4D0
Content-Type: text/plain;
charset="iso-8859-1"
While trying to migrate a database instance from 7.3.4 to 8.1.5, the command did not create the convSID.dbf file. I don't have any error message. Here is what I've done
1. I'm connected as an oracle user (7.3.4) 2. I stopped the 7.3.4 database instance 3. I moved to the 8.1.5 oracle home 4. I set up environment variables
setenv ORACLE_SID bdell11
setenv NLS_LANG AMERICAN_AMERICA.US7ASCII
setenv ORANLS33
/export/home/users/oradev/app/oracle/product/7.3.4/ocommon/nls/admin/data
5. I run the migration command
mig spool=\"/export/home/users/oradev/app/oracle/product/7.3.4/mig.log\" check_only=true
But this does not generate the convSID.dbf file.
What step did I omit ?
Help !!!!!
------_=_NextPart_001_01C06C2F.3296A4D0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.2722.2800" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>While trying to
migrate a database instance from 7.3.4 to 8.1.5, the command did not create the
convSID.dbf file. I don't have any error message. Here is what I've
done</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>1. I'm
connected as an oracle user (7.3.4)</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>2. I stopped
the 7.3.4 database instance</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>3. I moved to the
8.1.5 oracle home</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>4. I set up
environment variables</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>
setenv ORACLE_SID bdell11</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>
setenv NLS_LANG AMERICAN_AMERICA.US7ASCII</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>
setenv ORANLS33
/export/home/users/oradev/app/oracle/product/7.3.4/ocommon/nls/admin/data</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>5. I run the
migration command</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>
mig spool=\"/export/home/users/oradev/app/oracle/product/7.3.4/mig.log\"
check_only=true</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=890305215-22122000></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>But this does not
generate the convSID.dbf file.</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=890305215-22122000></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>What step did I
omit ?</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=890305215-22122000></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN
class=890305215-22122000></SPAN></FONT> </DIV>
<DIV><FONT face=Tahoma size=2><SPAN class=890305215-22122000>Help
!!!!!</SPAN></FONT></DIV>
<DIV><FONT color=#ff0000 face=Arial
size=2>------------------------------------------------------------------------------------</FONT></DIV>
![]() |
![]() |