riplication avancie - Replication

When I launch the job of refreschment, that works without error, but when it is executed automatically, I get this error :
*** SESSION ID:(15.170) 2002-01-28 17:02:51.000
*** 2002-01-28 17:02:51.000
ORA-12012: erreur d'exicution automatique du Job 10
ORA-01005: Aucun mot de passe; connexion refusie
ORA-06512: ` "SYS.DBMS_SNAPSHOT", ligne 814
ORA-06512: ` "SYS.DBMS_SNAPSHOT", ligne 872
ORA-06512: ` "SYS.DBMS_IREFRESH", ligne 577
ORA-06512: ` "SYS.DBMS_REFRESH", ligne 195
ORA-06512: ` ligne 1
WHY
thank you
alain moizeau

When you built your database link did you build it with a password?
ORA 1005 is "null password given; logon denied"
Bev

Related

advenced replication : refreshment

When I launch the job of refreschment, that works without error, but when it is executed automatically, I get this error :
*** SESSION ID:(15.170) 2002-01-28 17:02:51.000
*** 2002-01-28 17:02:51.000
ORA-12012: erreur d'exicution automatique du Job 10
ORA-01005: Aucun mot de passe; connexion refusie
ORA-06512: ` "SYS.DBMS_SNAPSHOT", ligne 814
ORA-06512: ` "SYS.DBMS_SNAPSHOT", ligne 872
ORA-06512: ` "SYS.DBMS_IREFRESH", ligne 577
ORA-06512: ` "SYS.DBMS_REFRESH", ligne 195
ORA-06512: ` ligne 1
WHY
thank you
alain moizeau
I suspect your database link was not created correctly, or did not have the CONNECT TO ... IDENTIFIED BY ... clause. When you
run the job manually, it can use the information for the current session. But, when the job is run by an SNP process, there is no
current session information to use, so the job fails.
Recreate the database link, or create a private database link if only a PUBLIC database link exists, and the problem should go away.

rdf network problem

Hi
im testing rdf suppor in oracle 10 g r2 enterprise edition and
I can't create a rdf network
this is the error.
SQL> execute sdo_rdf.create_rdf_network('rdf_ejemplo');
BEGIN sdo_rdf.create_rdf_network('rdf_ejemplo'); END;
*
ERROR at line 1:
ORA-13199: RDF NETWORK already exists
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 2200
ORA-06512: en "MDSYS.SDO_RDF", línea 137
ORA-06512: en línea 1
then i execute this commands
SQL> create table familia_rdf(id number, triple sdo_rdf_triple_s);
Table created.
SQL> execute sdo_rdf.create_rdf_model('family', 'familia_rdf', 'triple');
BEGIN sdo_rdf.create_rdf_model('family', 'familia_rdf', 'triple'); END;
*
ERROR at line 1:
ORA-13199: RDF NETWORK or FAMILIA_RDF does not exist
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 1774
ORA-06512: en "MDSYS.SDO_RDF", línea 117
ORA-06512: en línea 1
so i try to create de rdf network but already exists so i try to droped
and i can't.
SQL> execute sdo_rdf.drop_rdf_network;
BEGIN sdo_rdf.drop_rdf_network; END;
*
ERROR at line 1:
ORA-13199: Drop RDF NETWORK error occurred
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 2301
ORA-06512: en "MDSYS.SDO_RDF", línea 146
ORA-06512: en línea 1
pleace help, help
thanks
Hi
im testing rdf suppor in oracle 10 g r2 enterprise edition and
I can't create a rdf network
this is the error.
SQL> execute sdo_rdf.create_rdf_network('rdf_ejemplo');
BEGIN sdo_rdf.create_rdf_network('rdf_ejemplo'); END;
*
ERROR at line 1:
ORA-13199: RDF NETWORK already exists
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 2200
ORA-06512: en "MDSYS.SDO_RDF", línea 137
ORA-06512: en línea 1
then i execute this commands
SQL> create table familia_rdf(id number, triple sdo_rdf_triple_s);
Table created.
SQL> execute sdo_rdf.create_rdf_model('family', 'familia_rdf', 'triple');
BEGIN sdo_rdf.create_rdf_model('family', 'familia_rdf', 'triple'); END;
*
ERROR at line 1:
ORA-13199: RDF NETWORK or FAMILIA_RDF does not exist
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 1774
ORA-06512: en "MDSYS.SDO_RDF", línea 117
ORA-06512: en línea 1
so i try to create de rdf network but already exists so i try to droped
and i can't.
SQL> execute sdo_rdf.drop_rdf_network;
BEGIN sdo_rdf.drop_rdf_network; END;
*
ERROR at line 1:
ORA-13199: Drop RDF NETWORK error occurred
ORA-06512: en "MDSYS.MD", línea 1723
ORA-06512: en "MDSYS.MDERR", línea 17
ORA-06512: en "MDSYS.SDO_RDF_INTERNAL", línea 2301
ORA-06512: en "MDSYS.SDO_RDF", línea 146
ORA-06512: en línea 1
pleace help, help
thanks
caro 
Hi,
To create an RDF network the following should be true - partitioning has to be enabled in the database, the database block size has to be 8K (the default block size during database creation), there should be enough disk space, and the user creating the RDF network has to have DBA privileges. In your case I see from the emails you have sent us that partitioning was not enabled in your database, causing the creation of the RDF network to fail. (I am investigating the different reasons why partitioning is not enabled in your database and will respond to that separately).
If the RDF network is not created properly for any of the above reasons, 'drop network' might not cleanly drop the RDF network. The following script will have to be manually run to drop the RDF network.
-- connect as the MDSYS user before running this script --
EXEC SDO_NET.DROP_NETWORK('RDF');
DELETE FROM sdo_network_metadata_table WHERE network='RDF';
DROP TABLE RDF_NODE$;
DROP TABLE RDF_LINK$;
DROP TABLE RDF_MODEL$;
DROP TABLE RDF_PATH$;
DROP TABLE RDF_PLINK$;
DROP TABLE RDF_NAMESPACE$; DROP TABLE RDF_BLANK_NODE$; DROP TABLE RDF_VALUE$; DROP SEQUENCE rdf_value_id_sq;
DROP SEQUENCE rdf_node_id_sq;
DROP SEQUENCE rdf_link_id_sq;
DROP SEQUENCE rdf_model_id_sq;
DROP SEQUENCE rdf_namesp_id_sq;
DROP SEQUENCE rdf_long_lit_id_sq;
Once you have dropped the network and we have figured out why partitioning is not enabled in your database you can re-create the RDF network and the model.
Melli 
I install the oracle enterprise edition, and know works very good
know i can create my rdf network whit no problem
is a cool option for rdf, and it looks easier that rdf/xml
thanks for the help
greeting from Chile, south america
Caro 
When I have create the RDF netwok correctly,I inpue"execute sdo_rdf.create_rdf_model('family', 'family_rdf_data', 'triple');".
the message is:
ORA-13199: Model error occurred
ORA-06512: 在 "MDSYS.MD", line 1723
ORA-06512: 在 "MDSYS.MDERR", line 17
ORA-06512: 在 "MDSYS.SDO_RDF_INTERNAL", line 1779
ORA-06512: 在 "MDSYS.SDO_RDF", line 117
ORA-06512: 在 line 1
My system is microsoft windows,and I install 10.2.01 for microsoft windows.
I want to know the reason and the method.
thankyou! 
have you resoved this problem of creating the rdf_model? I am running into the same problem
Thank you
ming 
Sorry. I am replying to myself, but I have figured it out.
This error happened because I was creating it as sys.
According to Oracle document, after creating the network as a privileged user, you should connect as a regular user to create the table and models. 
Hello.
I am trying to create an RDF network. I connect with sys as sysdba to the database and I execute the following:
EXECUTE SDO_RDF.CREATE_RDF_NETWORK('rdf_tblspace');
and i get:
BEGIN SDO_RDF.CREATE_RDF_NETWORK('rdf_tblspace'); END;
*
ERROR at line 1:
ORA-55321: network already exists
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 7726
ORA-06512: at "MDSYS.SDO_RDF", line 1089
ORA-06512: at line 1
After that, when i log in the database with mdsys user and try to create the semantic model, i execute the following:
SQL> EXECUTE SDO_RDF.CREATE_RDF_MODEL('articles', 'articles_rdf_data', 'triple');
BEGIN SDO_RDF.CREATE_RDF_MODEL('articles', 'articles_rdf_data', 'triple'); END;
*
ERROR at line 1:
ORA-13199: Tablespace "" does not exist
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.SDO_RDF", line 974
ORA-06512: at line 1
Can you please tell me what is the problem?
Thank you.
Catalin

Mpping get to hanged at night and completed at morning after rerun it. why

Hello guys ,
I Am working on OWB 10g.
we have a Process Life_asia which contains no of mappings .
this ETL execute 2 times at night and moring before Pre EOD and After PreEod..
In my main process flow i have one mapping called POLICY_AMOUNT_DD_M1
when i execute this mapping using process at night 12.30 am then after long wait i found following error . then i have killed the process coz delay.
RTV-20007: Map terminated due to cursor fetch error. N/A *
RPE-01003: An infrastructure condition prevented the request from completing.
ORA-20020: The specified status value is invalid ORA-06512: at "ODS_OWNER.WB_RTI_EXCEPTIONS", line 107 ORA-06512: at "ODS_OWNER.WB_RTI_SERVICE_EXECUTION", line 999 ORA-01403: no data found ORA-06512: at "ODS_OWNER.WB_RT_SERVICE_CONTROL", line 199 ORA-06512: at line 1
2001 ORA-01410: invalid ROWID
-----------------------
and when i run this same mapping sepratly with process and without process
at morning 7 am, then it got completed within 5-7 mnt.without any error.
can u tell me what can be problem.........and how can solve it................
Plz
# wait for reply
============ 
I am facing a similar kind of issue.I have scheduled my mapping to run at 10 pm and it hangs,But when i try to run it using the scheduler in morning it takes only 5 mins.The log file has
Thread terminating due to fatal exception of type oracle.wh.runtime.platform.adapter.InfrastructureException
RPE-01003: An infrastructure condition prevented the request from completing.
- ORA-20003: The object is not in a valid state for the requested operation
ORA-06512: at "OWBSYS.WB_RTI_EXCEPTIONS", line 119
ORA-06512: at "OWBSYS.WB_RTI_SERVICE_EXECUTION", line 882
ORA-06512: at "OWBSYS.WB_RT_SERVICE_CONTROL", line 188
ORA-06512: at line 1
------------------------
java.sql.SQLException: ORA-20003: The object is not in a valid state for the requested operation
ORA-06512: at "OWBSYS.WB_RTI_EXCEPTIONS", line 119
ORA-06512: at "OWBSYS.WB_RTI_SERVICE_EXECUTION", line 882
ORA-06512: at "OWBSYS.WB_RT_SERVICE_CONTROL", line 188
ORA-06512: at line 1
Please help!! 
2001 ORA-01410: invalid ROWID
========================
This error generally happens when there is a DML activity going on in the source table or if there is index rebuilding or any housekeeping activity and that is when you get an inconsistent read. It might be worth checking if any such activities are happening on the base table and re-schedule your mapping of 12.30 to run once the activities on source table is over and probably thats the reason why your second run in the morning does not give any error.
REgards 
Thanks but my log file does not have
2001 ORA-01410: invalid ROWID
It has the following errors
Thread terminating due to fatal exception of type oracle.wh.runtime.platform.adapter.InfrastructureException
RPE-01003: An infrastructure condition prevented the request from completing.
- ORA-20003: The object is not in a valid state for the requested operation
ORA-06512: at "OWBSYS.WB_RTI_EXCEPTIONS", line 119
ORA-06512: at "OWBSYS.WB_RTI_SERVICE_EXECUTION", line 882
ORA-06512: at "OWBSYS.WB_RT_SERVICE_CONTROL", line 188
ORA-06512: at line 1
------------------------
java.sql.SQLException: ORA-20003: The object is not in a valid state for the requested operation
ORA-06512: at "OWBSYS.WB_RTI_EXCEPTIONS", line 119
ORA-06512: at "OWBSYS.WB_RTI_SERVICE_EXECUTION", line 882
ORA-06512: at "OWBSYS.WB_RT_SERVICE_CONTROL", line 188
ORA-06512: at line 1
Appreciate your help. 
Hi
I was actually responding to the message posted by Umesh and it had "row id" problem. Will have to look at your issue. 
bump... 
Hi,
We are facing the same problem. Oracle 10G 10.2.0.3 & OWB 10G, AIX 5.3.
Here under an abstract of the OWB logs :
ORA-20211: Active job does not exist, cannot link to job record.
ORA-06512: à "WORK.WB_RT_MAPAUDIT", ligne 1864
ORA-06512: à "WORK.WB_RT_MAPAUDIT", ligne 2750
ORA-06512: à "IMART.VL_MAP_TRAIT_DPA", ligne 1739
ORA-06512: à "IMART.VL_MAP_TRAIT_DPA", ligne 1881
ORA-06512: à ligne 1
RPE-01003 : Une condition d'infrastructure a empêché l'exécution de la demande
ORA-20003: Le statut de l'objet n'est pas valide pour l'opération demandée.
ORA-06512: à "WORK.WB_RTI_EXCEPTIONS", ligne 119
ORA-06512: à "WORK.WB_RTI_SERVICE_EXECUTION", ligne 834
ORA-06512: à "WORK.WB_RT_SERVICE_CONTROL", ligne 188
ORA-06512: à ligne 1
We would appreciate any help on this problem as we have no idea of where to search now.
Thanks.
Edited by: user6751948 on 13 oct. 2008 07:29 
bump

ALTER_SEM_INDEX_ON_MODEL not found

Hi
I am trying to create semantic indexes. I am able to call "add_sem_index", but the call to "ALTER_SEM_INDEX_ON_MODEL" fails by saying "the component must be declared". I have upgraded from 11.1.0.6 to 11.1.0.7; is there something I missed while upgrading ?
Another question : which kind of semantic indexes are generally recommended, and are the most useful ?
Thanks
Thomas
SQL> execute sem_apis.drop_sem_index('pso');
BEGIN sem_apis.drop_sem_index('pso'); END;
*
ERREUR Ó la ligne 1 :
ORA-13199: SQLERRM=ORA-01418: l'index indiquÚ n'existe pas dss=DROP INDEX
RDF_LNK_PSO_IDX
ORA-06512: Ó "MDSYS.MD", ligne 1723
ORA-06512: Ó "MDSYS.MDERR", ligne 17
ORA-06512: Ó "MDSYS.SDO_RDF_INTERNAL", ligne 8189
ORA-06512: Ó "MDSYS.SDO_RDF", ligne 1420
ORA-06512: Ó "MDSYS.RDF_APIS", ligne 1137
ORA-06512: Ó ligne 1
SQL> execute sem_apis.add_sem_index('pso');
ProcÚdure PL/SQL terminÚe avec succÞs.
SQL> execute sem_apis.alter_sem_index_on_model('rdf_model','pso','rebuild');
BEGIN sem_apis.alter_sem_index_on_model('rdf_model','pso','rebuild'); END;
*
ERREUR Ó la ligne 1 :
ORA-06550: Ligne 1, colonne 16 :
PLS-00302: Le composant 'ALTER_SEM_INDEX_ON_MODEL' doit Ûtre dÚclarÚ
ORA-06550: Ligne 1, colonne 7 :
PL/SQL: Statement ignored
Thanks
Thomas 
The documentation assumes you have installed semantic technology patch 7600122. Once you install that patch on 11.1.0.7, sem_apis.ALTER_SEM_INDEX_ON_MODEL will be available for use.
Which indexes are better depends upon the workload: for example, if you SPCM index will allow quicker access via subject. 
OK thanks it works fine after applying the patch.
A followup question : what is the difference between the 'C' and the 'O' index. C corresponds to CANON_END_NODE_ID and O to END_NODE_ID, but what are the differences between these 2 things ? when to use one or the other ?
Thanks
Thomas 
Please see http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28397/sdo_rdf_concepts.htm#CIHEHAAD for more information.

Impossible to create a Semantic network

Hi,
i have pbm to create my semantic network. Below this is my pbm :
Configuration : Oracle 11gR1 (11.1.0.7.0)
Configuration MDSYS :
OBJECT_NAME STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
RDF_MATCH VALID
/c72364cb_RDFConstants VALID
/c1b762e5_RDFException VALID
RDF_APIS VALID
SDO_RDF_MIG VALID
RDF_APIS_OPER_INTERNAL VALID
RDF_APIS_INTERNAL VALID
SDO_RDF VALID
RDF_APIS_USER VALID
SDO_RDF_INTERNAL VALID
RDF_APIS_OPER_INTERNAL VALID
SDO_RDF VALID
SDO_RDF_INTERNAL VALID
RDF_APIS_USER VALID
RDF_APIS_INTERNAL VALID
RDF_APIS VALID
SDO_RDF_MIG VALID
RDF_MODELS VALID
RDF_RULEBASES VALID
RDF_ALIAS VALID
RDF_ALIASES VALID
RDF_VARCHARARRAY VALID
RDF_LONGVARCHARARRAY VALID
RDF_MATCH_IMPL_T VALID
SDO_RDF_TRIPLE VALID
SDO_RDF_TRIPLE_S VALID
SDO_RDF_TRIPLE_S VALID
RDF_MATCH_IMPL_T VALID
Rmq : rdf_tablespace exist...
So When i execute this query ....
Requete : EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tablespace');
-------
Error starting at line 1 in command:
EXECUTE SEM_APIS.CREATE_SEM_NETWORK('rdf_tablespace');
Error report:
ORA-13199: Error during RDF Network creation: step_num=1 SQLERRM=ORA-00001: violation de contrainte unique (MDSYS.UNIQUE_NETWORK_LAYER)
ORA-06512: à "MDSYS.SDO_NETWORK_TRIG_INS", ligne 30
ORA-04088: erreur lors d'exécution du déclencheur 'MDSYS.SDO_NETWORK_TRIG_INS'
ORA-06512: à "MDSYS.MD", ligne 1723
ORA-06512: à "MDSYS.MDERR", ligne 17
ORA-06512: à "MDSYS.SDO_RDF_INTERNAL", ligne 7737
ORA-06512: à "MDSYS.SDO_RDF", ligne 1089
ORA-06512: à "MDSYS.SDO_RDF", ligne 1105
ORA-06512: à "MDSYS.RDF_APIS", ligne 786
ORA-06512: à ligne 1
13199. 00000 - "%s"
*Cause:    This is an internal error.
*Action:   Contact Oracle Support Services.
Requete : EXECUTE sem_api.create_sem_model('nci','nci_rdf_data','triple');
-------
Error starting at line 1 in command:
EXECUTE sem_api.create_sem_model('nci','nci_rdf_data','triple');
Error report:
ORA-06550: Ligne 1, colonne 7 :
PLS-00201: l'identificateur 'SEM_API.CREATE_SEM_MODEL' doit être déclaré
ORA-06550: Ligne 1, colonne 7 :
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:
Can u help me plz ? 
Hi,
If there is no important data stored already, could you please try drop the semantic network and re-try creating it?
Thanks,
Zhe Wu

Categories

Resources