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??
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.