help about 8i replication
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: help about 8i replication

  1. #1
    Join Date
    Oct 2002
    Location
    Germany (offenburg)
    Posts
    4

    help about 8i replication

    hi,
    i'm a beginner with the oracle software. And so I have many questions about the replication process.
    I use the oracle 8.1.7.0 standard server with the adcanced replication. Now i should find a solution about the replication between one master site and one snapshot site environement.
    I read the oracle online replication description and replication refernce but I don't understand some description.

    I execute followed steps:
    master site:
    1. installed oracle 8.1.7.0 standart server edition with advanced replication
    2. modified the init.ora paramateres for the replication
    3. create user scott (included dept, emp and bonus table)
    4. start to build the master site via the oracle online replication reference descriotion (it was sucessfull)
    5. create the master group (it was sucessfull)
    6. the status from the replication is running (dba_studio)
    7. create snapshot logs for the scott tables(it was sucessfull)
    8. create deployment tablespace (it was sucessfull)
    9. ctry to create offline script. Than I get alway the same error message
    ------------------
    ORROR at line 1:
    ORA-02019: connection description for remote database not found
    ORA-06512: at "SYS.DBMS_REPCAT_RGT_CUST", line 1324
    ORA-06512: at "SYS.DBMS_REPCAT_RGT", line 1308
    ORA-06512: at line 4
    ------------------------
    I don't know the Solution!!

    snapshot site
    1. installed oracle 8.1.7.0 standart server edition with advanced replication
    2. modified the init.ora file like the server
    3. create user scott (included dept, emp and bonus table)
    4. create snapshot site (it was sucessfull)


    perhaps some one can help to find the solution. I don't find a description about this error message wich were helpful.
    My goal is to create on the master site a replicate with the included datas abd procedure. Than i would safe the replication file on disk and execute the replication maual on the snapshot site.

    I attached some spool files from the execution. perhaps it is helpfull for you.

    If you know a good descripten or you have a example how create a snapshot replication , it will be helpfull for me.
    Thanks and have a good weekend!!!

    ciao toto
    ps.sorry for my english
    Attached Files Attached Files
    Mobilia Salvatore

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width