Import problem, end-of-file-communication channel
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Import problem, end-of-file-communication channel

  1. #1
    Join Date
    Apr 2002
    Posts
    291
    Hi all
    I've a DB of 16 Gigs and RAM of 6 Gigs on production. I got a full database export(All schemas of DB, not FULL=Y). I want to import it on another test machine of 500Megs. For this import, do i need to have the same values in my init.ora file as in production on my test server?? B'coz, when i'm trying to import, its saying end-of-file communication channel. Import terminated unsuccessfully finishig half the way. I tried for thrice,and got the same error at different tables. Can any help me why is this happening??

    Thanks in advance,


    Here i'm posting my Exporting script.

    USERID=system/manager
    LOG=/opt/oracle/admin/cms/logs/export.log
    OWNER=cms,cmsit,cmsapp,cmsadhoc,cms2adm
    CONSISTENT=Y
    COMPRESS=N
    ROWS=Y
    #FULL=Y
    FILE=/opt/oracle/admin/cms/exp/expdat1.dmp,
    /opt/oracle/admin/cms/exp/expdat2.dmp,
    /opt/oracle/admin/cms/exp/expdat3.dmp,
    /opt/oracle/admin/cms/exp/expdat4.dmp,
    /opt/oracle/admin/cms/exp/expdat5.dmp,
    /opt/oracle/admin/cms/exp/expdat6.dmp,
    /opt/oracle/admin/cms/exp/expdat7.dmp,
    /opt/oracle/admin/cms/exp/expdat8.dmp,
    /opt/oracle/admin/cms/exp/expdat9.dmp,
    /opt/oracle/admin/cms/exp/expdat10.dmp,
    /opt/oracle/admin/cms/exp/expdat11.dmp,
    /opt/oracle/admin/cms/exp/expdat12.dmp,
    /opt/oracle/admin/cms/exp/expdat13.dmp,
    /opt/oracle/admin/cms/exp/expdat14.dmp,
    /opt/oracle/admin/cms/exp/expdat15.dmp
    FILESIZE= 2000M
    --------------------

    Here i's my import script: (On different machine)

    userid=system/manager
    log=/home/oracle/import.log
    file=/u01/expdat1.dmp,
    /u01/expdat2.dmp,
    /u01/expdat3.dmp

    Please help me
    PNRDBA

  2. #2
    Join Date
    Jun 2002
    Posts
    62
    Have u installed NT SP6?
    Regards,
    Jack

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    On the new machine -

    Is the instance running?
    If so, is the shell window you are using set with the correct ORACLE_SID? If you want to be sure about the connection, add the net service name descriptor after system/manager (so userid=system/manager@dbname), presuming, of course, your Net8 configuration files have been updated to reflect the dname for your database.

    What would you be changing in the init.ora between databases? I'd do the import with the same parameters, then make any init.ora changes after the import completed in a successful manner.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width