HiI have made a simple webservice that returns cityID and CityName using Jdeveloper 10.1.3.3.0I have implemented it in my Apex application using Application Express 3.0.1.00.07. The service function ok when testing it using the BPEL Control and when testing it in Apex from the shared Components, web ...
ORA-19025 EXTRACTVALUE returns value of only one node When this error occurs, would you please provide some or all of the following information:(1) row number(2) row id(3) the name of the offending column(5) the XQuery expression(6) the node name(7) the text value being parsed, in which an excess no ...
I am trying to extract the data from an xmltype table where there is possibility of just one node. I am running into ORA-19025 error when there is only one node. Can someone please help me to handle this error when I come across only one node.Here is my sql: SELECTT_ID,EXTRACTVALUE(value(input_data_ ...
Taken from Oracle documentation the following:<PurchaseOrder><Reference>ADAMS-20011127121040988PST</Reference><Actions><Action><User>SCOTT</User><Date>2002-03-31</Date></Action></Actions><Reject/><Requestor>Julie P. Adams ...
When i'm starting the oracle workspace manager software and trying to create a new workspace related to a schema, after to be connected to a database instance,I get those error messages: ora - 37118, ora - 06512 ...
I am having a wft program, which checks a function activity and depending on the value returned sends difference notifications.The package body completed successfully from backend and while running the workflow program it sends a notification also. But while opening the notification it gives the fol ...
I made a table like below,==============================CREATE TABLE ser_1m_det (time TIMESTAMP,proto NUMBER(3,0),port NUMBER(5,0),pkts NUMBER(17,0),vol_m NUMBER(17,4));====================================Then I want to use below SQL====================================SELECT proto, port, SUM(pkts) p ...
When the database was upgraded to 10gR2 from 9i a customer is getting ORA-06502 ORA-06512 errors. It happens for Oracle Apps installationThey have removed the database initialization parameter "_optimizer_cost_model" as per the Oracle Apps standards. But when they reintroduce it and assign as "io", ...
Application Express Installation Guide3.3.6.1 Granting Connect PrivilegesThe following example demonstrates how to grant connect privileges to any host for the APEX_030200 database user.DECLAREACL_PATH VARCHAR2(4000);ACL_ID RAW(16);BEGIN-- Look for the ACL currently assigned to '*' and give APEX_030 ...
got a strange problem here.The following script execute perfectlyCREATE OR REPLACE TRIGGER VersionInsertTrigger BEFORE INSERT ON Version FOR EACH ROW BEGIN SELECT VersionSequence.nextval INTO :new.Idx FROM dual;SELECT UID INTO :new.UserIdent FROM dual;SELECT UPPER(:new.Entity) INTO :new.Entity FROM ...
hii have a problem with the spatial index.i have the next codemy table isCREATE TABLE MBTE_BLQ_BLOCK(BL_ID NUMBER NOT NULL,BLM_ID NUMBER,BL_COORX NUMBER(10,3) NOT NULL,BL_COORY NUMBER(10,3) NOT NULL,BL_COORZ NUMBER(10,3) NOT NULL,BL_HASDATA NUMBER(1))/* función obtener geometria dado un punto*/cr ...
I wrote a procedure and am getting the following error message about 20 minutes into the processing:*ERROR at line 1:ORA-20001: ORA-0000: normal, successful completionORA-06512: at "APPHARRIS.P_HARRIS_BULK_COLLECT", line 502ORA-06512: at line 1I have a fairly large amount of data that gets processed ...
I'm hitting this error for the first time. Anyone encountered this before? Any suggestions will be very appreciated. Thanks!141 EXCEPTION142 143 when others then144 raise_application_error('-20100',SQLERRM);145 End;146 /2008020720080312Declare*ERROR at line 1:ORA-20100: ORA-01116: error in opening d ...
when i add comments on some columns, ORA-00604 ORA-01401 occurhow to deal?comment on column zxinsag.sag_mms_downrequest.needreceipt is '????' ORA-00604: error occurred at recursive SQL level 1ORA-01401: inserted value too large for columnORA-06512: at line 2 ...
We have a requirement where two tables should be in sync at any given pointin time with respect to the structure of the tables.Any change on table/column via ALTER (MODIFY, ADD, RENAME COLUMN, DROPCOLUMN) on the parent table should be replicated to the replica table.I created a DDL_TRIGGER on the sc ...
i have the the following err msg while updating a remote database..-2147217873 ....ora-01110...ora-01578..from the oracel err msg, it seems the block is corruptted..not really understand wat is this...i am using VB6 ADODB recordset with .Addnew and .update to create a new record.... ...
I'm getting these two Oracle Error messages while I try to login to sqlplus using any login. I've tried all the steps from this thread:Ora-01034 / Ora-27101except when I got to this point:SET ORACLE_SID=ilnksqlplus /nologconn sys/change_on_install as sysdbastartupI received an error 'ORA-01031: insu ...
i have a problem with the intermedia thesaurs search.When i use a thesaurus function in my querySELECT rowid FROM wag_vlb_storage WHERE CONTAINS(xml, 'pt( Kinder) within title') > 0 AND storage_type='PRD'an oracle error ORA-29902 / ORA-01455 occurs.My thesaurus have 470.000 term (TT) (2.5 Mill al ...
repost Hi, i have a problem with the intermedia thesaurs search. When i use a thesaurus function in my query SELECT rowid FROM wag_vlb_storage WHERE CONTAINS(xml, 'pt( Kinder) within title') > 0 AND storage_type='PRD' an oracle error ORA-29902 / ORA-01455 occurs. My thesaurus have 470.000 term (T ...
repost - anybody from the intermedia team out there ??? Hi, i have a problem with the intermedia thesaurs search. When i use a thesaurus function in my query SELECT rowid FROM wag_vlb_storage WHERE CONTAINS(xml, 'pt( Kinder) within title') > 0 AND storage_type='PRD' an oracle error ORA-29902 / OR ...
According to the installation guide, I have TNS_ADMIN=/opt/oracle/config/9.2.0; export TNS_ADMINin the .profile at home directory of user "oracle"After installation succeeded, I found that there are two places that have tnsnames.ora & listener.oraOne is at /opt/oracle/config/9.2.0Other one is at ...
While using the direct loading in SQL-LOADER when we get the ORA-01847/ORA-01839 all the other records are getting errorred out. It goes fine with the conventional loading. Should I use some parameters or anything to make sure that all the other records are not rejected when we get the ORA-01847/ORA ...
I created simple application base on view. When I try to update something I get ORA-02019,ORA-02063. Same update from SqlPlus works as expected. Help me, Stanislav. ...
I'm using the following querySELECT O.TRAIN_NO_C, O.OUT_DATE_D, OD.COACH_NO_C, C.CLASS_CODE_C, C.AC_NAC_TYPE_C, R.LAST_DEALT_DATE_D FROM MECD_PF_OUTTRN_T O, MECD_PF_OUTTRN_DTL2_T OD, MECD_PL_RS19_DTL1_T R, MECD_COACH_M C, MECD_TRAIN_M T WHERE O.TRAIN_NO_C = T.OUT_TRAIN_NO_C AND O.OUT_DATE_D + T.INTD ...
I have oracle running on Redhat linux. It was working fine previously and I had to change the IP address to roll it into production.I have changed tnsnames.ora, listener.ora, snmp_ro.ora and sqlnet.ora files to new IP address.Now, I get ORA-01034 error, saying that Oracle is not available. And somet ...
Created 3 separate homes for Oracle CRS, Oracle ASM and Oracle instance1 under Oracle 10g R2 RAC setup. where should i keep listener.ora, tnsnames.ora & init.ora files? should i keep them in ASM home or Oracle instance1 home directory? ...
I uninstalled my Oracle 10g and when I re installed I got success, but when I went to the folder \network\admin didn't have the files listener.ora, tnsnames.ora and sql.ora. I have been trying during more than one month start my listener only because I need access the Oracle database from my Java ap ...
we are getting following errors on one of our databasei found the following on metalink to resolve TIP: Click help for a detailed explanation of this page. Bookmark Go to End Subject: Ora-354 Ora-353 And Ora-312 Reported On Mirrored Redo Log Files Doc ID: Note:332672.1 Type: PROBLEM Last Revision Da ...
I'm not sure if it ok to post this error message here, let me know. I've searched Google and didn't find anything...My company is migrating data from one old version of Oralce (8.1.7.2) to Oracle Version 9.2.0.6.The database is basically personal information and when we migrated a record over to the ...
I have this error again - and really don't know where to begin looking for the answer.I find it very worrying that this error is generated by the internals of Apex which I cannot see. There is no indication as to why / what causes this in a general sense. Could someone explain in english / pseudo co ...
hi, we are using 9i database it was normally working but today when attemp to make a connection gives errors ora-01034 , ora-27101 and srv4 error 2: no such file or directory cannot restart cannot shutdown , cheched the sid its ok, the value is correct (i checked case sensitiveness ) the db is on so ...
When we are opening the database following errors are coming in sequence as follows:ORA-01122, ORA-01110 and ORA-01251Other facts:We dont have any backup.Database is not in archive mode.Personally I don't see any hope.What you guys think? ...
Some body please tell me the jobs of tnsnames.ora, listener.ora, and config.ora ...
I created a trigger to check out and insert the servererror to a table. but all i see the errors are: ora-25228, ora-25254, ora-1. so i eliminated these errors by doing: if var_errnum 25228 AND var_errnum 25254 AND var_errnum 1 THENselect username, osuser, machine, process, programinto var_user, var ...
DB version: 10.2Hello All,I just joined the project and notice tnsnames.ora, sqlnet.ora & listener.ora files are not exit under $ORACLE_HOME/network/admin.But still we can connect to the database,From command prompt or via enterprise manager studio from client site.Any idea? OR what is the best ...
I have a page that has a form to my issue table and on the same page, in a different region, I have a tabular report that shows the issue_activity for the specified issue. The primary key on the issue table is the issue_no which is a sequence and the primary key on the issue_activity table is (issue ...
When I use expdp and impdp on a database inside the same machine or between 2 machines using the same OS everything is OK.But when I want to cross the same database expdp and impdp, for instance:I expdp on linux RedHat 4 ES and want to impdp on Windows XPthen I have the folowwing errors:ORA-39001, O ...
I am framing one dynamic insert statement for a table which contains 208 columns in a procedure.While i execute a procedure i got an error like this ERROR at line 1:ORA-20020: ORA-21000: error number argument to raise_application_error of 20001 is out of range Please advice ...
I am trying to install a client on a remote computer with Net Configuration-Assistant. When testing connection as user system I always get oracle errorsora-00604 / ora-0224.When I try connection with sys the reaction is : should be done with sysdba or sysoper privilege.On command line level I can lo ...
DBAs,some how I used different port than port 1521 in my DB installation.DB works fine.But we have some rule for our firewall.So I need to bring back my listener to use port 1521.What should I do?Here are the steps I planned to do, please confirm.Stop listener.ora.Change port 1521 in tnsnames.ora ...
I am getting ORA-01113,ORA-01110 these error while mounting my database.Plz give solution immediately .Advance ...
Till yesterday the database runs fine but today it throws error as,#sqlplus sys/pass as sysdbaConnected to Idle instance.sql>startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00132: syntax error or unresolved network name 'LISTENER_ELA'sql>I cant bring it up,any ty ...
I have the transparent gateway(10g) installed for sql server 7 and when I realize some consultation returns to me the mistake ORA-00910 ORA-02063 Someone knows something of this mistake ...
I've read quite a few posts on changes to the tnsadmin.ora and listener.ora files and I'm still not quite getting what I need to do to get the listener to automatically connect client requests to their respective DB's. Apologies if this is a basic question, but here's my problem....I've got two DBs ...
i got this error in my front end .....any idea what might be the reason?Failed: ORA-20500: ORA-20500: ORA-20500: ORA-20500: ORA-02055: distributed update operation failed; rollback requiredORA-02068: following severe error from MUDR2SEBL(db_link name)ORA-03113: end-of-file on communication channel ...
DBMS: Oracle 9i Rel. 9.2.0.8 EEPlatform: AIX 5.3 ML51st Instance: pkms2nd instance (New): pkconfigCase:Configuring The Network Connection for New Instance on The Same Machine.Description:I have instance already available on the machine and I created a new instance on the same machine but there the l ...
I have Oracle 9i DB and DevSuite 10g installed on my laptop. There are three databases on my machine.Recently, I tried to install Oracle Discoverer 10g and that's where the problem started. I could no longer connect to the databse using either SQL*Plus, TOAD or even from the front end application.I ...
HiCan any body send me link of documentation which tells the relation betweentnsnames.ora, listner.ora, init.ora file.and any link which tells what is sid, Service_name, db_name and service. and how to see them allthanksMessage was edited by: umesh049 ...
I am seeing ORA-00610 & ORA-07445 in differenct DB in there alert log file generated in mid march , Now its gone, wondering should i ignore these or still fix it ?I found metalink notes asking for adjust SQL>alter system set JOB_QUEUE_PROCESSES=50 scope=both; & SQL>alter system set "_d ...
I am having trouble obtaining an ODBC connection from a client XE to a server XE. ora-12541 ORA-12154: TNS:could not resolve the connect identifier specified I am new to Oracle.I have oracle client XE running on my XP pro box.I have oracle server XE running on an XP pro box on the LAN.I am trying to ...