Export from 8.1.7.4 and Import to 8.0.5

[Adrian Sobers2]

ok thanks

[Adrian Sobers2]

I was running the export by putting an entry in my tnsnames.ora. I strarted the export but I got an error about end of oracle communication channel. I tried to start the export again between the servers now I get the error, no listener. I've checked both listeners and they are running. Do you have any suggestions on what else I should look at?

[Patti Johnson]

Verify your sqlnet configuration.
From the 8i server - tnsping the service name of your 8i database. Take note of the port and host name. Then run the tnsping on the 8.0 server. Make sure these are the same and the 8.0 server can resolve the service name for the 8i database.
No Listener often means that the tnsnames.ora entry is not correct - if the port or host name are different it will fail.
Did the export start and then fail with ora-3113? Were you able to export any data?
Also look in the udump directory for any trace files that were created at the time of the export on the 8i database.

[Yogeeraj_1]

hi,

can you post the switches that you are using for your export?

are you using DIRECT=Y?

is the network connection between the two servers reliable?

regards
Yogeeraj

[Adrian Sobers2]

Patti,

From the old server I can tnsping the local database on that server as well as the remote database (production server)

From the production server I can tnsping the local database on that server but not the remote database (test server)

I'm sure the tnsnames.ora files are correct, help!

[Jean-Luc Oudart]

Hi

could you check entries in the sqlnet.ora file ?

Regards
Jean-Luc

[Adrian Sobers2]

attached are two text files with output from the netstat -rn commands. I think it might be a routing (networking) issue. Does anyone know how I can/should modify my routing tables so that the servers can see each other? Thanks...

attachement is route.zip which contains

- old.txt > routing table for old server

- new.txt > routing table for new server

[Jean-Luc Oudart]

Can you just ping the server or is this just tnsping the issue ?

Regards
Jean-Luc

[Adrian Sobers2]

I cannot ping or tnsping the oldserver from the newserver.

I can ping and tnsping the newserver from the oldserver.

[Jean-Luc Oudart]

try traceroute

should be in /usr/contrib/bin

what output are you getting ?

Regards
Jean-Luc