Prev
Next
Forums S3 Systems Administration

sqldbcopy

Sort:
You are not authorized to post a reply.
Author
Messages
DavidV
Veteran Member
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
    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
      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
        You are not authorized to post a reply.