• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

sqldbcopy

 2 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
DavidV
Veteran Member Send Private Message
Posts: 101
Veteran Member
3/13/2015 12:26 PM

sqldbcopy keeps failing with ORA-12505, TNS: listener does not currently know of SID given in connect descriptor

dbcopy ends up taking over for sqldbcopy, but I'd like to get sqldbcopy working.

sqldbcopy -d  -h :1521 -l ORA11     CUCODES

The IP of Oracle DB Server is the IP of the source DB Server.  I also tried host name of srouce DB server.

The source apps/DB is on server1 and the target apps/DB are on server2

I have DB links between target and source and they work, but I can't get sqldbcopy to work. 

One knowledge base arcticle said to add ORACLE_SID of tns/service name to the ORACLE file.  I did that to the source ORACLE file and same error.

 

Has anyone else run into this issue?

DavidV
Veteran Member Send Private Message
Posts: 101
Veteran Member
3/13/2015 12:29 PM

Sorry not sure why the sqldbcopy command line parameters where stripped away

sqldbcopy -d  -h "IP of source DB Server":1521 -l "TNS name of srouce DB" ORA11 "Source PL"  "Target PL"  CUCODES

DavidV
Veteran Member Send Private Message
Posts: 101
Veteran Member
3/17/2015 10:51 AM
I figured it out. I should have used the target server IP instead of the source server

sqldbcopy -d -h "IP of target DB Server and not soure DB Server":1521 -l "TNS name of srouce DB" ORA11 "Source PL" "Target PL" CUCODES