3 Replies Latest reply on Mar 1, 2015 9:51 AM by berx

VENDOR CODE 17008: CLOSED CONNECTION

goj Feb 28, 2015 3:06 AM

Hi All,

I am doing a database copy option using SQL DEV 4.0 from a physical server to an AWS RDS instance and get the above error after 2 minutes or so.

There is no SQLNET entries on my laptop, and I checked the server and dont see anything there.

Firewall rules are set to 2.5 hours for timeout.

any ideas are appreciated

thanks

1. Re: VENDOR CODE 17008: CLOSED CONNECTION

thatJeffSmith-Oracle Feb 28, 2015 10:45 PM (in response to goj)

Don't use SQL Developer's, Copy feature. That's intended for ad hoc/quick and dirty tasks. You'll want to want to probably use Data Pump and ship the data up to instance, and then import it in.
Like Show 0 Likes(0)

Actions
2. Re: VENDOR CODE 17008: CLOSED CONNECTION

goj Mar 1, 2015 6:03 AM (in response to thatJeffSmith-Oracle)

Thanks Jeff...
Do you have any advice for doing a Data PUMP Import from an inplace DB to an AWS RDS instance?

I did a DBMS FILE PUT of the dmp file from source to RDS target and the import creates the total amount of users halfway and dies out.
I am in the process of reviewing logs but wondered if you had any insight to this...

thank you
Like Show 0 Likes(0)

Actions
3. Re: VENDOR CODE 17008: CLOSED CONNECTION

berx Mar 1, 2015 9:51 AM (in response to goj)

Hi Goj,

it seems your primary goal is to find a proper way to migrate data from a local DB to an AWS RDS instance?
If you can create a database link, then I'd suggest to use data pump directly over this network.

But as this is not related to SQL Developer, I'd suggest to ask this question in the Database Forum instead?

Martin
Like Show 0 Likes(0)

Actions