I am trying to create an EXT table but is constantly having the following problem, not sure why. I have done a few checks and used the scripts used as a standard but still is experiencing an error.
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "minussign": expecting one of: "double-quoted-string, identifier, single-quoted-string"
KUP-01007: at line 9 column 1
ERROR at line 1: ORA-29913: error in executing ODCIEXTTABLEOPEN callout ORA-29400: data cartridge error KUP-00554: error encountered while parsing access parameters KUP-01005: syntax error: found "identifier": expecting one of: "binary_double,
[code].....
when I select count(*) on the external table created below.
SQL> select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME --------------- ---------------- HOST_NAME ---------------------------------------------------------------- VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
every day we have full backup of oracle database (9.2.0.1.0) on windows 2003 server. since couple of days i am getting following below error. i checked the solutions on google which talk about user quotas , i checked the user quotas by which i am taking full backup it is unlimited , even i tried another user which also have umlimited quota on its default tablespace still i getting below
E:ackup>exp system/manager file=full26022012.dmp log=full26022012.log full=y statistics=none EXP-00008: ORACLE error 933 encountered ORA-00933: SQL command not properly ended ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 311 ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 142 ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
even i go for full export by any other user which has full export privilege & unlimited quotas. i getting the same error.
E:ackup>exp username/password file=full26022012.dmp log=full26022012.log full=y statistics=none EXP-00008: ORACLE error 933 encountered ORA-00933: SQL command not properly ended ORA-06512: at "SYS.DBMS_RULE_EXP_RL_INTERNAL", line 311 ORA-06512: at "SYS.DBMS_RULE_EXP_RULES", line 142 ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.schema_info_exp
I have overwritten tnsnames.ora file with newone. In new tnsnames.ora file I have added new host string, remaining all unchanged.
after that, when trying to connect using sqlplus(from windows machine, sqlplusw.exe), working fine. But when trying to connect through putty getting error.
ORA-12154: TNS:could not resolve service name
for the same reason my scheduled cron tab can not run export backup. cron tab error is
EXP-00056: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve service name EXP-00000: Export terminated unsuccessfully
I am suspecting problem may be due to file accessing permission related issue. But cant solve it. Current tnsnames.ora files permission is
I am loading content of an XML file into a table using SQL loader.Below is my Control file script -
LOAD DATA INFILE * INTO TABLE xx_cc_response_xml_stg TRUNCATE xmltype(XML_DATA) FIELDS ( COLUMN_ID constant 1, file_name filler char(4000), XML_DATA LOBFILE(file_name) TERMINATED BY EOF) BEGINDATA B2B_MasterDataUpdate_20120906152137.xml ------------------------------------------------------------------------------------
The file B2B_MasterDataUpdate_20120906152137.xml is correct and XML is well formed.When i try to query for XML_DATA (datatype XMLType) column in the table, i cannot see any content in the record, and it appears as (XMLTYPE)When I parse this XML using the below,
select value(d) from xxnbn_cc_response_xml_stg a, table(xmlsequence(extract(a.xml_data,'/InventorySearch'))) d; ------------------------------------------------------------------------------------ I get this error: ------------------------------------------------------------------------------------ ORA-00600: internal error code, arguments: [qmcxdsSelf4], [], [], [], [], [], [], [], [], [], [], [] 00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]" *Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition. *Action: Report as a bug - the first argument is the internal error number ------------------------------------------------------------------------------------
I'm trying to create a relation from child block to the master block that I've created . Foreighn key is there from child to parent table.The error I get is below:
FRM-15004: Error while parsing join condition
The join condition is correct, but I'm still clueless as to what it could be.Is it a form bug?
I receive a "FRM-15004 Error while parsing join condition" when attempting to create a relation between block1 (parent table) and block2 (child table). If I do a simple straight join the statement is accepted but if I use a Decode then it results in an error. How to successfully use a decode or a nvl in a join statement of a relation?
LOAD DATA INFILE "gateway.csv" truncate INTO TABLE GATEWAY Fields terminated by "," Optionally enclosed by '"' trailing nullcols
[code]....
and I got the following error:
zcyds891:/opt/oracle> sqlldr gwcem/gwcem@pfs control=gateway.ctl log=/tmp/ldr.log bad=/tmp/bad.log SQL*Loader: Release 9.2.0.8.0 - Production on Tue Dec 7 05:07:59 2010 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL*Loader-350: Syntax error at line 12. Expecting "," or ")", found "INTERGER". GATEWAYPROTOCOL INTERGER, ^
Successfull installation of my Oracle Client was done.When i opened Enterprise Manage Console and i try to login to a database, the following error occurs
" The procedure entry point kpufhndl() could not be located in the dynamic link library OCI.dll "
When I am issuing below command from auxiliary database, getting ORA-00554.My tnsping is okay from both the side, remote login is exclusion. Password file is also okay.I ran UTLRP.sql twice to compile invalid packages.
From Auxiliary Database [ashish@localhost dbs]$ rman target sys/oracle@suman auxiliary / Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 11 19:04:03 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved.
I got an error while trying to install Oracle 9i on a Win XP machine. So, I decided to wipe out Oracle completely and starting again. I deleted all the Oracle entries from the registry and then tried deleting the folder. But while doing that, I am getting the following error - "Cannot delete oci:Access denied"
The disk is neither write-protected nor is the oci.dll file in use.
What i have to do to overcome the following error..whenever im using toad im getting this error since start writing and executing procedures and functions.
access violation at address 006b5b1b in module 'toad.exe' read of address 0000011d
I have a Database that has a frontend in MS Access and a backend in Oracle. When I try to open the Oracle Table/s in the MS Access Frontend, it gives me this error message:
Reserved error (-7711); there is no message for this error.
There is some stuff on the internet about this error but none of it fixes my issue. It seems to be an MS Access error rather than an Oracle error. Only thing is this issue is only on Machines that are running on XP. I have no problem on mine which is Windows 7.
We have an issue regarding OS level authentication to access Oracle 11gR2(11.2.0.1) database.
Our environment - UNIX - AIX 5.3 (OS user id password is having kerberos security). Oracle 11.2.0.1 (32 bit client) installed in server 1 Oracle 11.2.0.1 (64 bit server) installed in server 2. Everything works fine when we created a general userid test_db in the database and connect through sqlplus test_db@dbname.
But when we try to use the option of OS level authentication using "sqlplus /", it throws following error and could not be connected.
ERROR: ORA-12545: Connect failed because target host or object does not exist
I have created the same OS user name in database (with external password authentication) with prefix OPS$. we have set ORACLE_SID as well.
I am using oracle 11g client library on Linux 64bit machine and trying to connect to oracle database using jdbc thin driver.The url format what I am trying to use is:
I am able to connect with the above syntax. But when the service_name is having . e.g service_name = orcl.177.39.45, with the above format I get the above error.
If I change the URL syntax to following, it works
jdbc:oracle:thin:@IP address:port/service_name
But both seems to be valid syntax.So I would like to undestand the reason behind the same. When service_name is having ".", why ":" does not work and "/" works and when the service_name is without " ." , 1st format works. Is there any specific reason behind same?
Am getting the error ORA-03113: end-of-file on communication channel when am trying to run a query and when i checked the trace file the infromation i got is given below.....
CODEksedmp: internal or fatal error ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x363376E] [] [] [] [] Current SQL statement for this session: select count(av_sal)
CREATE OR REPLACE FUNCTION "ABS"."PROCESS_YEAR"(processYear DATE) RETURN NUMBER DETERMINISTIC IS year NUMBER:=NULL
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
* & = - + ; < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
employees emp_tab := emp_tab(); procedure test1 as g_ref sys_REFCURSOR; BEGIN employees.EXTEND(2); employees(1) := emp_type (1, 'name1'); employees(2) := emp_type (2, 'name2'); OPEN g_ref FOR SELECT * FROM TABLE (CAST (employees AS emp_tab)); END test1;
I got a error ERROR at line 11: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
begin end function package pragma procedure form
1. create or replace package body test as 2. employees emp_tab := emp_tab(); 3. procedure test1 as
ERROR: ====== LINE TEXT 2 ORA-06550: line 2, column 19: 1 PLS-00103: Encountered the symbol "NUMBER" when expecting one of the following: 1 := . ( @ % ; not null range default character 1 The symbol ":=" was substituted for "NUMBER" to continue.
SQL> select view_name , text from dba_views where VIEW_NAME='EMP1_VIEW';
VIEW_NAME TEXT
EMP1_VEW select empid , ename , qual, dept from emp1 where empid between 1000 and 1010
Now i tried to use create or replace option
SQL>create or replace view emp1_view as *2 select * from emp1_view with read only;* create or replace view emp1_view as *+ ERROR at line 1: ORA-01731: circular view definition encountered
Actually i want to make read only view (emp1_view) ; without doping ;
how to resolve the below error.. I am getting this error on the alert log .. oracle DB version is 11.2.0.1 and os is AIX6.1
ORA-1403 encountered when generating server alert SMG-4121 Thu Jun 07 13:38:27 2012 ORA-1403 encountered when generating server alert SMG-4121 Thu Jun 07 13:39:00 2012 ORA-1403 encountered when generating server alert SMG-3503 Thu Jun 07 13:43:27 2012 ORA-1403 encountered when generating server alert SMG-4121 Thu Jun 07 13:48:27 2012
While connecting to target database from stand database. I am getting below error.
calhost dbs]$ sqlplus system/oracle@proddb
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:10 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options [standdb@localhost dbs]$ rman target system/oracle@proddb auxiliary system/oracle@standdb
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:22 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.
I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.
ORA-24247: network access denied by access control list
<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI
<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?
DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production APEX: 4.0.2.00.07 Web-Server: EPG SELECT * FROM NLS_DATABASE_PARAMETERS;
I am having oracle database version 11.2.0.3.0 standard edition, where one of my users requirement is that he wanted to send mails from oracle database but he is getting below error
ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_TCP", line 17 ORA-06512: at "SYS.UTL_TCP", line 267 ORA-06512: at "SYS.UTL_SMTP", line 161 ORA-06512: at "SYS.UTL_SMTP", line 197 ORA-06512: at "HF_REPORTING.SEND_MAIL", line 12 ORA-06512: at line 18
is it possible to send mails from oracle database in STANDARD Edition?
While Running the proc,it's raising the below error.
Error report:
ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_TCP", line 17 ORA-06512: at "SYS.UTL_TCP", line 246 ORA-06512: at "SYS.UTL_SMTP", line 115 ORA-06512: at "SYS.UTL_SMTP", line 138 ORA-06512: at "LISTER_SHIFT.SOLN_GENERIC_SENDMAIL", line 33 ORA-06512: at line 1
I supposed that Title & Gender are realized through MiddleName field. If MiddleName's values in (Thi, Dieu) then Title is assigned as Ms, and Gender = "F". Otherwise, Title = "Mr", and Gender = "M".
2/ Another procedure/function is [i]ParseAddress with the requirement as:[/i]Address field is divided into Street, Group, Area, Ward, County fields E.g.:No 6 Sum Street - Group 8 - Area 2 - ABCD Ward - London
The result:
StreetGroupArea Ward County No 6 Sum StreetGroup 8Area 2ABCD London
I have tried coding by Visual Basic, it is OK. But if I interpret to PL/SQL ->it doesn't work.
