OraFAQ Forum: Replication » replication script ERROR .. help me urgent .. script attached..

Home » Server Options » Replication » replication script ERROR .. help me urgent .. script attached..

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

replication script ERROR .. help me urgent .. script attached.. [message #75423]

Mon, 08 December 2003 03:02

Cherrish Vaidiyan
Messages: 7
Registered: November 2003

Junior Member

HELLO ,
I HAVE USED SCRIPT FOR IMPLEMENTING REPLICATION. I HAVE FOLLOWED THE FOLLOWING GUIDELINES.. ..my 2 database are CAMRY AND TATA..the spooled result is camry_alert.doc & tata_alert.doc

HERE ARE THE BASIC GUIDELINES I FOLLOWED.

spool readme.lst
prompt Create Surrogate and Replication users
conn sys/sys@camry
@cresurrogate.sql
@creusr.sql
conn sys/sys@tata
@cresurrogate.sql
@creusr.sql

prompt Create the necessary database links in the schemas
conn repadmin/repadmin@camry
@linkrep1.sql
conn repadmin/repadmin@tata
@linkrep3.sql

conn repadmin/repadmin@camry
@demobld.sql
@crm_repgroup.sql
@crm_repobj.sql
@cr_snaplog.sql
@register_propagator.sql

conn repadmin/repadmin@tata
@register_propagator.sql

conn repadmin/repadmin@camry
@gen_support.sql -- Can Only gen Support for tables,packages and procedures
-- Only IN parameters supported With Packages and Procedures
@add_mastdb.sql

conn repadmin/repadmin@tata
@crs_repgroup.sql
@crs_repobj.sql
@gen_snap_support.sql
@schedule.sql

conn repadmin/repadmin@camry
@schedmast.sql -- Schedule for master site
@exec_ddl.sql
@gen_support_one.sql

conn repadmin/repadmin@tata
@drs_repobj_one.sql
@crs_repobj_one.sql
@gen_snap_support_one.sql

conn repadmin/repadmin@camry
@conf_make_colgrp.sql -- drop with conf_drop_colgrp.sql
@conf_add_colgrp.sql -- drop with conf_drop_grpcol.sql
prompt Problem with EMP$RR @conf_update_reso drop with conf_drop_upd_reso
@conf_unique_reso.sql -- drop with conf_drop_unique_reso.sql
@gen_support_one.sql

conn repadmin/repadmin@camry
@suspend_master_act.sql -- Should be suspended in any Case
@siteprio_exec_ddl.sql
@siteprio_gen_support_one.sql

conn repadmin/repadmin@tata
@siteprio_drs_repobj_one.sql
@siteprio_crs_repobj_one.sql
@siteprio_gen_snap_support_one.sql

conn repadmin/repadmin@camry
@suspend_master_act.sql -- Should be still suspended in any Case
@siteprio_make_colgrp.sql -- drop with siteprio_drop_colgrp.sql
@siteprio_def.sql -- drop with siteprio_drop_site.sql
@siteprio_add.sql --
@siteprio_upd_reso.sql
@siteprio_gen_support_one.sql
@resume_master_act.sql
prompt To change site priority use siteprio_alter first suspend exec then resume
spool off

ALERT LOG OF CAMRY DATABASE........

SQL> select name from v$database;
NAME
---------
CAMRY
SQL> @ mycode/cresurrogate.sql
User dropped.
User created.
PL/SQL procedure successfully completed.
SQL> @ mycode/creusr.sql
User dropped.
User created.
PL/SQL procedure successfully completed.
Grant succeeded.
SQL> prompt create database links
create database links
SQL> conn repadmin/repadmin@camry
Connected.
SQL> @ mycode/linkrep1.sql
Connected.
drop public database link dblink
*
ERROR at line 1:
ORA-02024: database link not found

Database link created.
Connected.
drop database link dblink
*
ERROR at line 1:
ORA-02024: database link not found

Database link created.
SQL> conn repadmin/repadmin@camry
Connected.
SQL> @ mycode/demobld.sql
Building demonstration tables. Please wait.
Session altered.
Session altered.
DROP TABLE EMP
*
ERROR at line 1:
ORA-00942: table or view does not exist

DROP TABLE DEPT
*
ERROR at line 1:
ORA-00942: table or view does not exist

DROP TABLE BONUS
*
ERROR at line 1:
ORA-00942: table or view does not exist

DROP TABLE SALGRADE
*
ERROR at line 1:
ORA-00942: table or view does not exist

Table created.
1 row created.
1 row created.
1 row created.
1 row created.
Table created.
1 row created.
1 row created.
1 row created.
1 row created.
Table created.
Table created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.
SQL> begin
2 dbms_repcat.create_master_repgroup(
3 gname => 'acct',
4 group_comment => 'Master site created by Nico',
5 master_comment => 'Master group');
6 end;
7 /
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 548
ORA-06512: at line 2

SQL> begin
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'emp',
type => 'table',
use_existing_object => FALSE,
comment => 'create table emp in master group',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'dept',
type => 'table',
use_existing_object => FALSE,
comment => 'create table dept in master group',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'bonus',
type => 'table',
use_existing_object => FALSE,
comment => 'create table bonus in master group',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'salgrade',
type => 'table',
use_existing_object => FALSE,
comment => 'create table salgrade in master group',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'emp_pk',
type => 'index',
use_existing_object => FALSE,
ddl_text => 'alter table emp add constraint emp_pk primary key(empno)',
comment => 'create index on table emp',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'dept_pk',
type => 'index',
use_existing_object => FALSE,
ddl_text => 'alter table dept add constraint dept_pk primary key(deptno)',
comment => 'create index on table dept',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'bonus_pk',
type => 'index',
use_existing_object => FALSE,
ddl_text => 'alter table bonus add constraint bonus_pk primary key(ename)',
comment => 'create index on table bonus',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'salgrade_pk',
type => 'index',
use_existing_object => FALSE,
ddl_text => 'alter table salgrade add constraint salgrade_pk primary key(grade)',
comment => 'create index on table salgrade',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'emp_syn',
type => 'synonym',
use_existing_object => FALSE,
ddl_text => 'create synonym emp_syn for emp',
comment => 'create emp synonym',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'emp_view',
type => 'view',
use_existing_object => FALSE,
ddl_text => 'create view emp_view as select empno,ename,comm from emp',
comment => 'create emp_view on table emp',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'val_name',
type => 'function',
use_existing_object => FALSE,
ddl_text => 'create or replace function val_name (name in varchar2) return boolean is begin if name = ''NICO'' then return FALSE; else return FALSE; end if; end;',
comment => 'create function val_name',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
dbms_repcat.create_master_repobject(
sname => 'repadmin',
oname => 'emp_proc',
type => 'procedure',
use_existing_object => FALSE,
ddl_text => 'create or replace procedure emp_proc
(var_empno in number,var_ename in varchar2) is
begin
if var_empno = 1 then
dbms_output.put_line(''1'');
else
dbms_output.put_line(''not 1'');
end if;
end;',
comment => 'create procedure emp_proc to return ename accept empno as arg',
retry => FALSE,
copy_rows => TRUE,
gname => 'acct');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 562
ORA-06512: at line 2
SQL> create snapshot log on emp;
create snapshot log on dept;
create snapshot log on bonus;
create snapshot log on salgrade;

create snapshot log on emp
*
ERROR at line 1:
ORA-12014: table 'EMP' does not contain a primary key constraint
create snapshot log on dept
*
ERROR at line 1:
ORA-12014: table 'DEPT' does not contain a primary key constraint
create snapshot log on bonus
*
ERROR at line 1:
ORA-12014: table 'BONUS' does not contain a primary key constraint
create snapshot log on salgrade
*
ERROR at line 1:
ORA-12014: table 'SALGRADE' does not contain a primary key constraint
SQL> begin
dbms_defer_sys.register_propagator(
username => 'repadmin');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_DEFER_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
SQL> conn repadmin/repadmin@camry
Connected.
SQL> begin
dbms_repcat.generate_replication_support(
sname => 'repadmin',
oname => 'emp', type => 'table', distributed => TRUE);
end;
/
begin
dbms_repcat.generate_replication_support(
sname => 'repadmin',
oname => 'dept', type => 'table', distributed => TRUE);
end;
/
begin
dbms_repcat.generate_replication_support(
sname => 'repadmin',
oname => 'bonus', type => 'table', distributed => TRUE);
end;
/
begin
dbms_repcat.generate_replication_support(
sname => 'repadmin',
oname => 'salgrade', type => 'table', distributed => TRUE);
end;
/
begin
dbms_repcat.generate_replication_support(
sname => 'repadmin',
oname => 'emp_proc', type => 'procedure', distributed => TRUE);
end;
/
begin
*0
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2

begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2

begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2

begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2

begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2
SQL> begin
dbms_repcat.add_master_database(
gname => 'acct',
master => 'dblink_tata',
use_existing_objects => TRUE,
copy_rows => TRUE,
comment => 'master site added to support rep1',
propagation_mode => 'asynchronous');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 146
ORA-06512: at line 2
SQL> conn repadmin/repadmin@camry
Connected.
SQL> begin
dbms_defer_sys.schedule_execution(
dblink => 'dblink_tata',
interval => 'sysdate+1/1440',
next_date => sysdate,
stop_on_error => FALSE,
execute_as_user => FALSE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_DEFER_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2
SQL> begin
dbms_repcat.execute_ddl(
gname => 'acct',
ddl_text => 'alter table emp add(update_time date)');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 735
ORA-06512: at line 2
SQL> begin
dbms_repcat.generate_replication_support(
sname => 'repadmin',
oname => 'emp', type => 'table', distributed => TRUE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2
SQL> conn repadmin/repadmin@camry
Connected.
SQL>begin
dbms_repcat.make_column_group(
sname => 'repadmin',
oname => 'emp',
column_group => 'emp_summ',
list_of_column_names => 'empno,ename,update_time');
end;
/
begin
dbms_repcat.make_column_group(
sname => 'repadmin',
oname => 'emp',
column_group => 'emp_sal',
list_of_column_names => 'sal,comm');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 2402
ORA-06512: at "SYS.DBMS_REPCAT", line 776
ORA-06512: at line 2

begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 2402
ORA-06512: at "SYS.DBMS_REPCAT", line 776
ORA-06512: at line 2
SQL> begin
dbms_repcat.add_grouped_column(
sname => 'repadmin',
oname => 'emp',
column_group => 'emp_summ',
list_of_column_names => 'deptno');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_SNA_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_UTL2", line 668
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 979
ORA-06512: at "SYS.DBMS_REPCAT", line 132
ORA-06512: at line 2

SQL> begin
dbms_repcat.add_unique_resolution(
sname => 'repadmin',
oname => 'emp',
constraint_name => 'emp_pk',
sequence_no => 1,
method => 'DISCARD',
parameter_column_name => 'empno');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 814
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 1579
ORA-06512: at "SYS.DBMS_REPCAT", line 261
ORA-06512: at line 2

SQL> begin
dbms_repcat.generate_replication_support(
sname => 'repadmin',
oname => 'emp', type => 'table', distributed => TRUE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2
SQL> conn repadmin/repadmin@camry
Connected.
SQL> @begin
dbms_repcat.suspend_master_activity('acct');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 946
ORA-06512: at line 2
SQL> begin
dbms_repcat.execute_ddl(
gname => 'acct',
ddl_text => 'alter table bonus add(site varchar2(30))');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 735
ORA-06512: at line 2
SQL> begin
dbms_repcat.generate_replication_support(
sname => 'repadmin',
oname => 'bonus', type => 'table', distributed => TRUE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2
SQL> conn repadmin/repadmin@camry
Connected.
SQL> begin
dbms_repcat.suspend_master_activity('acct');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 946
ORA-06512: at line 2
SQL> begin
dbms_repcat.make_column_group(
sname => 'repadmin',
oname => 'bonus',
column_group => 'siteprio_col',
list_of_column_names => 'SITE');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 2402
ORA-06512: at "SYS.DBMS_REPCAT", line 776
ORA-06512: at line 2
SQL>begin
dbms_repcat.define_site_priority(
gname => 'acct',
name => 'SITE PRIORITY');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 951
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 1809
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 2345
ORA-06512: at "SYS.DBMS_REPCAT", line 589
ORA-06512: at line 2
SQL> begin
dbms_repcat.add_site_priority_site(
gname => 'acct',
name => 'SITE PRIORITY',
site => 'dblink_tata',
priority => 400);
end;
/

begin
dbms_repcat.add_site_priority_site(
gname => 'acct',
name => 'SITE PRIORITY',
site => 'dblink_camry',
priority => 500);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 951
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 990
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 1188
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 1522
ORA-06512: at "SYS.DBMS_REPCAT", line 220
ORA-06512: at line 2

begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 951
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 990
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 1188
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 1522
ORA-06512: at "SYS.DBMS_REPCAT", line 220
ORA-06512: at line 2

SQL> @mycode/siteprio_upd_reso.sql
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 814
ORA-06512: at "SYS.DBMS_REPCAT_CONF", line 1639
ORA-06512: at "SYS.DBMS_REPCAT", line 307
ORA-06512: at line 2

SQL> begin
dbms_repcat.add_update_resolution(
sname => 'repadmin',
oname => 'bonus',
column_group => 'siteprio_col',
sequence_no => 1,
method => 'SITE PRIORITY',
parameter_column_name => 'SITE',
priority_group => 'SITE PRIORITY');
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2

SQL> begin
dbms_repcat.resume_master_activity('acct',TRUE);
end;
/
begin
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MAS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 826
ORA-06512: at line 2

SQL> spool off

HERE ARE THE ERRORS WHICH I GOT FROM TATA DATABASE:
SQL> @ mycode/cresurrogate.sql
drop user repsys cascade
*
ERROR at line 1:
ORA-01918: user 'REPSYS' does not exist
User created.
PL/SQL procedure successfully completed.
SQL> @ mycode/creusr.sql
User dropped.
User created.
PL/SQL procedure successfully completed.
Grant succeeded.
SQL> @ mycode/linkrep3.sql
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
Warning: You are no longer connected to ORACLE.
SP2-0640: Not connected
SP2-0640: Not connected
Connected.
drop database link dblink_camry
*
ERROR at line 1:
ORA-02024: database link not found
Database link created.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> @ mycode/linkrep3.sql
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
Warning: You are no longer connected to ORACLE.
SP2-0640: Not connected
SP2-0640: Not connected
Connected.
Database link dropped.
Database link created.
SQL> begin
dbms_defer_sys.register_propagator(
username => 'repadmin');
end;
/
PL/SQL procedure successfully completed.
SQL> conn repadmin/repadmin@tata
Connected.
SQL> begin
dbms_repcat.create_snapshot_repgroup(
gname => 'acct',
master => 'dblink_camry',
comment => 'created by nico for tests',
propagation_mode => 'asynchronous');
end;
/
begin
*
ERROR at line 1:
ORA-04054: database link DBLINK_CAMRY does not exist
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 4262
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1698
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
ORA-06512: at "SYS.DBMS_REPCAT", line 1262
ORA-06512: at "SYS.DBMS_REPCAT", line 1250
ORA-06512: at line 2
SQL> begin
dbms_repcat.create_snapshot_repobject(
sname => 'repadmin',
oname => 'emp',
ddl_text => 'create snapshot repadmin.emp for update as select * from emp@dblink_camry',
type => 'snapshot',
comment => 'emp snapshot created for MAST table temp',
gname => 'acct');

dbms_repcat.create_snapshot_repobject(
sname => 'repadmin',
oname => 'dept',
ddl_text => 'create snapshot repadmin.dept for update as select * from dept@dblink_camry',
type => 'snapshot',
comment => 'dept snapshot created for MAST table temp',
gname => 'acct');

dbms_repcat.create_snapshot_repobject(
sname => 'repadmin',
oname => 'bonus',
ddl_text => 'create snapshot repadmin.bonus for update as select * from
bonus@dblink_camry',
type => 'snapshot',
comment => 'bonus snapshot created for MAST table temp',
gname => 'acct');

dbms_repcat.create_snapshot_repobject(
sname => 'repadmin',
oname => 'salgrade',
ddl_text => 'create snapshot repadmin.salgrade for update as select * from salgrade@dblink_camry',
type => 'snapshot',
comment => 'salgrade snapshot created for MAST table temp',
gname => 'acct');

dbms_repcat.create_snapshot_repobject(
sname => 'repadmin',
oname => 'emp_view',
type => 'view',
comment => 'view on table emp',
gname => 'acct');

dbms_repcat.create_snapshot_repobject(
sname => 'repadmin',
oname => 'emp_proc',
type => 'procedure',
comment => 'procedure input arg empno output arg ename',
gname => 'acct');

dbms_repcat.create_snapshot_repobject(
sname => 'repadmin',
oname => 'emp_syn',
type => 'synonym',
comment => 'synonym for table emp',
gname => 'acct');

dbms_repcat.create_snapshot_repobject(
sname => 'repadmin',
oname => 'val_name',
type => 'function',
comment => 'function to validate names',
gname => 'acct');
end;
/
begin
*
ERROR at line 1:
ORA-23373: object group "PUBLIC"."ACCT" does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 716
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5494
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 82
ORA-06512: at "SYS.DBMS_REPCAT", line 1332
ORA-06512: at "SYS.DBMS_REPCAT", line 1307
ORA-06512: at line 3
SQL> begin
dbms_repcat.generate_snapshot_support(
sname => 'repadmin',
oname => 'emp',
type => 'snapshot');
end;
/
begin
dbms_repcat.generate_snapshot_support(
sname => 'repadmin',
oname => 'dept',
type => 'snapshot');
end;
/
begin
dbms_repcat.generate_snapshot_support(
sname => 'repadmin',
oname => 'bonus',
type => 'snapshot');
end;
/
begin
dbms_repcat.generate_snapshot_support(
sname => 'repadmin',
oname => 'salgrade',
type => 'snapshot');
end;
/
begin
*
ERROR at line 1:
ORA-23308: object REPADMIN.EMP does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2865
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5986
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 157
ORA-06512: at "SYS.DBMS_REPCAT", line 1366
ORA-06512: at "SYS.DBMS_REPCAT", line 1352
ORA-06512: at line 2

begin
*
ERROR at line 1:
ORA-23308: object REPADMIN.DEPT does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2865
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5986
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 157
ORA-06512: at "SYS.DBMS_REPCAT", line 1366
ORA-06512: at "SYS.DBMS_REPCAT", line 1352
ORA-06512: at line 2

begin
*
ERROR at line 1:
ORA-23308: object REPADMIN.BONUS does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2865
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5986
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 157
ORA-06512: at "SYS.DBMS_REPCAT", line 1366
ORA-06512: at "SYS.DBMS_REPCAT", line 1352
ORA-06512: at line 2

begin
*
ERROR at line 1:
ORA-23308: object REPADMIN.SALGRADE does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2865
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5986
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 157
ORA-06512: at "SYS.DBMS_REPCAT", line 1366
ORA-06512: at "SYS.DBMS_REPCAT", line 1352
ORA-06512: at line 2
SQL> begin
dbms_defer_sys.schedule_execution(
dblink => 'dblink_camry',
interval => 'sysdate+1/1440',
next_date => sysdate,
stop_on_error => FALSE,
execute_as_user => FALSE);
end;
/
PL/SQL procedure successfully completed.
SQL> conn repadmin/repadmin@tata
Connected.
SQL> @mycode/drs_repobj_one.sql
begin
*
ERROR at line 1:
ORA-23308: object REPADMIN.EMP does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2865
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1912
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 126
ORA-06512: at "SYS.DBMS_REPCAT", line 1385
ORA-06512: at "SYS.DBMS_REPCAT", line 1377
ORA-06512: at line 2
SQL> begin
dbms_repcat.create_snapshot_repobject(
sname => 'repadmin',
oname => 'emp',
ddl_text => 'create snapshot repadmin.emp for update as select * from emp@dblink_camry',
type => 'snapshot',
comment => 'emp snapshot created for MAST table temp',
gname => 'acct');
end;
/
begin
*
ERROR at line 1:
ORA-23373: object group "PUBLIC"."ACCT" does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 716
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5494
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 82
ORA-06512: at "SYS.DBMS_REPCAT", line 1332
ORA-06512: at "SYS.DBMS_REPCAT", line 1307
ORA-06512: at line 3
SQL> begin
dbms_repcat.generate_snapshot_support(
sname => 'repadmin',
oname => 'emp',
type => 'snapshot');
end;
/
begin
*
ERROR at line 1:
ORA-23308: object REPADMIN.EMP does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2865
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5986
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 157
ORA-06512: at "SYS.DBMS_REPCAT", line 1366
ORA-06512: at "SYS.DBMS_REPCAT", line 1352
ORA-06512: at line 2
SQL> conn repadmin/repadmin@tata
Connected.
SQL> begin
dbms_repcat.drop_snapshot_repobject(
sname => 'repadmin',
oname => 'bonus',
type => 'snapshot',
drop_objects => TRUE);
end;
/
begin
*
ERROR at line 1:
ORA-23308: object REPADMIN.BONUS does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2865
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1912
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 126
ORA-06512: at "SYS.DBMS_REPCAT", line 1385
ORA-06512: at "SYS.DBMS_REPCAT", line 1377
ORA-06512: at line 2
SQL> begin
dbms_repcat.create_snapshot_repobject(
sname => 'repadmin',
oname => 'bonus',
ddl_text => 'create snapshot repadmin.bonus for update as select * from
bonus@dblink_camry',
type => 'snapshot',
comment => 'bonus snapshot created for MAST table bonus',
gname => 'acct');
end;
/
begin
*
ERROR at line 1:
ORA-23373: object group "PUBLIC"."ACCT" does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 716
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5494
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 82
ORA-06512: at "SYS.DBMS_REPCAT", line 1332
ORA-06512: at "SYS.DBMS_REPCAT", line 1307
ORA-06512: at line 3
SQL> begin
dbms_repcat.generate_snapshot_support(
sname => 'repadmin',
oname => 'bonus',
type => 'snapshot');
end;
/
begin
*
ERROR at line 1:
ORA-23308: object REPADMIN.BONUS does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2865
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5986
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 157
ORA-06512: at "SYS.DBMS_REPCAT", line 1366
ORA-06512: at "SYS.DBMS_REPCAT", line 1352
ORA-06512: at line 2
SQL> spool off

can anyone help me with the ERRORS..

regards,
Cherrish Vaidiyan

Report message to a moderator

Re: replication script ERROR .. help me urgent .. script attached.. [message #75428 is a reply to message #75423]

Mon, 15 December 2003 03:42

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

See http://www.orafaq.net/msgboard/replication/messages/847.htm

Best regards.

Frank

Report message to a moderator

Re: replication script ERROR .. help me urgent .. script attached.. [message #254209 is a reply to message #75423]

Thu, 26 July 2007 03:06

ankurjain
Messages: 11
Registered: July 2007
Location: Vadodara, Gujarat, India

Junior Member

Hi frank,

the link u pointed has now been removed ( i know the topic is too old ) ..... can any1 please help me with the error mentioned in the post above

ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors.

i m using oracle 10g

Thanks in advance

Report message to a moderator

Re: replication script ERROR .. help me urgent .. script attached.. [message #254379 is a reply to message #254209]

Thu, 26 July 2007 11:14

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

CHECK dbams_repcat status
Use gname

http://forums.oracle.com/forums/thread.jspa?messageID=1603408

SQL> select object_name,status
  2  from dba_objects
  3  where object_name='DBMS_REPCAT';

OBJECT_NAME
--------------------------------------------------------------------------------
STATUS
-------
DBMS_REPCAT
VALID

DBMS_REPCAT
VALID

Attachment: Oracle Replication Survival Guide.doc
(Size: 394.50KB, Downloaded 3656 times)

Report message to a moderator

Previous Topic:	error encountered while refreshing materialized view
Next Topic:	shareplex login query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:45:34 CDT 2024