SQL & PL/SQL :: ORA-22288 / File Or LOB Operation FILEOPEN Failed

May 3, 2011

My Login is System

Already created Directory MY_DIR in c:mydir

Showing Following error

1 DECLARE
2 src_lob BFILE := BFILENAME('MY_DIR','C:
mi2Blue.jpg');
3 dest_lob BLOB;
4 BEGIN
5 INSERT INTO lob_table VALUES(2, EMPTY_BLOB())
6 RETURNING doc INTO dest_lob;

[code].....

View 21 Replies


ADVERTISEMENT

The Operation (getPrincipal) Failed Exception?

Aug 21, 2012

I am getting the below exception when i access the WebPage.This only happens sometimes, so if i try again to hit the URL, it works. Not getting why this is behaving unusual.

StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exception
(wt.fc.fcResource/0) wt.util.WTException: The operation: "getPrincipal" failed.
Nested exception is: wt.util.WTRemoteException: Unable to invoke remote method; nested exception is:
     java.lang.OutOfMemoryError

View 1 Replies View Related

Listener Operation - Log Entry Corresponding To Failed Connection?

Dec 10, 2012

I have a DB on my local machine and it was working fine till yesterday.Today suddenly I started receiving error "IO Error : The Network Adapter Could not establish the connection".

1) My first question is that is there some log entry corresponding to this failed connection attempt in listener.log or alert.log ? If yes, how to identify it ?

2) My second question is : What to deduct from listener logs pasted below?I know about "service_update" messages, but what about others (having CONNECT_DATA in them) ? Also, what is "WARNING: Subscription for node down event still pending" in below logs ?

......
10-DEC-2012 12:48:18 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=B_ADMIN))(SERVER=dedicated)(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=58460)) * establish * orcl * 0
10-DEC-2012 12:48:20 * service_update * orcl * 0
10-DEC-2012 12:51:35 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=B_ADMIN))

[code]...

View 4 Replies View Related

SQL & PL/SQL :: FDPSTP Failed Due To ORA-29277 / Invalid SMTP Operation

Apr 18, 2011

in the following program i am submitting a request and sending concurrent program log file (.REQ file)as an attachment but getting following error

ORACLE error 29277 in FDPSTP
Cause: FDPSTP failed due to ORA-29277: invalid SMTP operation
ORA-06512: at "SYS.UTL_SMTP", line 44
ORA-06512: at "SYS.UTL_SMTP", line 150
ORA-06512: at "SYS.UTL_SMTP", line 383
ORA-06512: at "SYS.UTL_SMTP", line 399

[code]....

View 3 Replies View Related

RAC & Failsafe :: ORA-15080 / Synchronous I / O Operation To A Disk Failed

Aug 1, 2013

I am getting below errors on one of the node of my RAC server while starting the database. how to get the rsolution.

ORA-27091: unable to queue I/O
ORA-27072: File I/O error
Solaris-AMD64 Error: 5: I/O error
Additional information: 4
Additional information: 331776
Additional information: -1
Thu Aug 1 22:29:42 2013
Errors in file /software/oracle/admin/dixie/udump/dixie1_ora_23644.trc:
ORA-00202: control file: '+DGDIXIE/dixie/controlfile/current.265.647198019'

[code].....

View 4 Replies View Related

ORA-29273 - HTTP Request Failed ORA-12535 - TNS - Operation Timed Out?

Jun 19, 2013

SQL*Plus: Release 11.2.0.3.0Solaris 10 SPARC I get the following error when trying to make an HTTP request. Below is the snippet of code I run. I get the error after exactly 60 seconds(default timeout?). The problem does not exist in the rest of our environments, only our test environment.

DECLARE
   p_mid_tier    VARCHAR2 (500);
   responsestr   VARCHAR2 (500);
BEGIN
  
[code]...

View 3 Replies View Related

SQL & PL/SQL :: Invalid File Operation

May 5, 2010

i have created an file in my local system (sys name : System1). i have created a directory as below

SQL>CREATE DIRECTORY test_dir AS '\System1TEMP';

I gave rights as

SQL>GRANT ALL ON DIRECTORY TEST_DIR TO PUBLIC;

DECLARE
fileHandler UTL_FILE.FILE_TYPE;
BEGIN
IF utl_file.is_open(fileHandler) THEN
utl_file.fclose_all;
END IF;
[code]......

but while executing the above procedure, Invalid File Operation error occurs.

View 10 Replies View Related

SQL & PL/SQL :: ORA-29283 - Invalid File Operation?

Dec 29, 2012

We are using the below procedure to generate the files on the DB server.

SQL>
SQL> create or replace procedure write_to_file(p_dir varchar2,
2 p_file varchar2,
3 p_mode varchar2,
4 p_clob clob) as
5 l_output utl_file.file_type;
6 l_amt number default 32767;
7 l_offset number default 1;
8 l_length number default dbms_lob.getlength(p_clob);
9 new_clob clob;
10 BEGIN
11
12 l_output := utl_file.fopen(p_dir, p_file, p_mode, 32767);
13 while (l_offset < l_length) loop
14 new_clob:= SUBSTR(p_clob,l_offset,l_amt);
15 utl_file.put_line(l_output, new_clob,true);
16 l_offset := l_offset + dbms_lob.getlength(new_clob);
17 end loop;
18 utl_file.new_line(l_output);
19 utl_file.fclose(l_output);
20 end write_to_file;
21 /

Procedure created

SQL>

This works fine we call this from PL/SQL developer tool. However, when this procedure is called from Java JDBC, it is giving error

java.sql.SQLException: ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at "SYS.OBP_UPGRADE_UTIL", line 2816
ORA-06512: at "SYS.OBP_UPGRADE_UTIL", line 3029
ORA-06512: at line 1

DB schema used for both are same (SYS) Verified the directory on the DB server This Procedure called from package with AUTHID CURRENT_USER option.

View 1 Replies View Related

Forms :: ORA-29283 - Invalid File Operation

May 22, 2013

My Application is running on the unix server - user oracle. My DB is in different unix box. I had created the folder called OUT with the permission of 777 in DB server. I created ORacle Directory DMPDIR for that folder /OUT. and executed grant read/write to that schema.

1) when i use the below code in sqlplus its writing the file into that folder.
DECLARE
vInHandle utl_file.file_type;
vNewLine VARCHAR2(4000);

[Code].....

But, when the same piece of code is executed from the package ( which called from the application)its throwing the ORA-29283: invalid file operation.

even i am able to copy the files into that folder with the user oracle.

View 39 Replies View Related

PL/SQL :: ORA-29283 Invalid File Operation On Windows System

Jul 31, 2012

Windows 2003, DB 10.2.0.3...I have to read some files from remote folder, so on remote Windows machine I shared folder c:est (grant Everyone first, and Administrator then) and on DB Server I mapped the remote folder with letter T..All these operations were made with administrator privileges.

In Oracle I create a directory object with this command:
CREATE OR REPLACE directory T_DIR AS 'T:';

Then I granted read and write privileges to my user
GRANT READ, WRITE ON DIRECTORY T_DIR TO <user>; (I tried also to set PUBLIC and SYSTEM)

But when I try to open a file with UTL_FILE with this command

file_handler := UTL_FILE.fopen( 'T_DIR', 'Dati.ini', 'r' ) ;

the error is
Exception: ORA-29283: operazione file non valida
ORA-06512: a "SYS.UTL_FILE", line 475
ORA-29283: operazione file non valida

If I change my directory object in 'C: est' (local folder) it works correctly.I tried also restart DB while shared folders were connected but with the same result.I tried, from sqlplus, the command host (dir t:) and it works (folder is accessible)

Is it an Oracle bug? Is it a Windows bug?

View 5 Replies View Related

SQL & PL/SQL :: Possible To Perform Any Operation Using Oracle Like Addition And Division In CSV File

Dec 2, 2010

Is it possible to perform any operation using oracle like addition and division in csv file before loading data in oracle. and after the operation changes must save.

Is it possible or not.

View 2 Replies View Related

SQL & PL/SQL :: Using Procedure Triggered By Dbms_scheduler / ORA-29283 / Invalid File Operation

Nov 10, 2010

This is regarding a problem we are facing during report(.xls) creation which is done using a procedure triggered by a job run.

The report file(.xls) file is not getting created when the job(using dbms_scheduler) calls.

The procedure uses utl_file to create an .xls file

We have a folder on the path /oracle/tata_aig_life/websales/dnld . This folder( dnld ) has the all the priviliges drwxrwxrwx.

We have a job scheduler as the attachment which in turn triggers a procedure(check the code attachment for the scheduler and the procedure).

In the procedure we first remove the file(.xls) created in the path and then recreate a new .xls file.

The reason for first removing the file and recreating is that the existing file is not getting updated with a new file when the job is run.

We capture the exceptions in a table. In the table the following exception is logged :ORA-29283: invalid file operation

The job is triggered and the files are created on the path mentioned in the procedure on the UAT Environment..

Also the files are created when we manually run the same procedure in the path.

The Oracle version is Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

The OS flavour is SunOS otlpsr5cora01 5.10 Generic_127111-11 sun4u sparc SUNW,Sun-Fire-V490 -------

View 1 Replies View Related

SQL & PL/SQL :: Writing Data To A Network Shared Folder / ORA-29283 / Invalid File Operation

Jul 13, 2010

I am trying to write data to a network shared folder. When I write to a local file it works perfectly. Below is my procedure.

CREATE OR REPLACE procedure nbpsbp_file as
type r_cursor is ref cursor;
refr r_cursor;
tab_name varchar2(20):= null;
tab_name1 varchar2(20) := null;
tab_name2 varchar2(20) := null;

[code]....

When I execute the above procedure, it gives me the following error

ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation
ORA-06512: at "NBPSBP_FILE", line 36
ORA-06512: at line 1

I have also set the parameter utl_file_dir = '\10.16.10.225 emp' When I set the utl_file_sir to a local folder, for example, c: emp, and use the same path in UTL_FILE.FOPEN, then it works fine and writes the desired output to text file. But when I give it a network address, it raises the above error.

View 3 Replies View Related

Creation Control File Failed?

Nov 30, 2004

I am cloning a database from a cold backup in archivelog mode using the control file script but failes:

STARTUP NOMOUNT
CREATE CONTROLFILE DATABASE PROD NORESETLOGS ARCHIVELOG
:
:
:
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\ORADATA\PROD\TEMP01.DBF'

[code]...

Tried again with RESETLOGS:

STARTUP NOMOUNT
CREATE CONTROLFILE DATABASE PROD RESETLOGS ARCHIVELOG
:

ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-00344: unable to re-create online log 'D:\ORADATA\PROD\REDO01B.ORA'
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

View 3 Replies View Related

Database File 1 Failed Verification Check

Apr 3, 2011

i did the following steps for resolving.

1 alter database backup controlfile to trace;

2 startup nomount;

3 recover database using backup controlfile;//in this step generate error msg "database not mounted"

4 alter database open// this is also happend above error

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/u01/app/oracle/oradata/DB11G/system01.dbf'
ORA-01207: file is more recent than control file - old control file

View 6 Replies View Related

RMAN :: Recovery Failed In Control File?

Sep 27, 2013

I took database backup without "change the controlfile configuration autobackup on".. and unfortunately i deleted my controlfile. Then I tried to restore my controlfile but it gives error,now how can i restore controlfile is there any other way to restore controlfile with aautobackup..

View 17 Replies View Related

Trace File - MVs Failed (ORA-10980 Error Encountered)

Oct 19, 2010

In Trace file I am always geeting one error "Error encountered: ORA-10980" due to which MVs fails . how to overcome from this error?

View 2 Replies View Related

(failed To Close File) Error Message While Backing Up DB?

May 30, 2012

We have been getting the below error message, while backing up the DB(Full DB backup) via netbackup. The DB version is 10.2.0.3 (64bit). The archive backup goes fine. the problem is with the full backup.

input datafile fno=00241 name=/u106/oradata/iwhdbqa/iwh_mvlog_01x.dbf
channel CH02: starting piece 1 at 29-MAY-12
RMAN-03009: failure of backup command on CH01 channel at 05/29/2012 21:41:28
ORA-19506: failed to create sequential file, name="iwhdbqa_20120529210533_db_ipnc7n6l_1_1", parms=""

[code]...

I came to know that this is a netbackup configuration/client bug. Can we do something from the oracle side.

The RMAN COMMAND STRINGS we use is as follows:

SET SNAPSHOT CONTROLFILE NAME TO '/u101/app/oracle/product/10.2.0.5/db_1/dbs/iwhdbqa_snapshot_db.snap';
RUN {
ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE' parms='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1' ;
SEND 'NB_ORA_SERV=atlbackupmaster, NB_ORA_POLICY=iwh-dbqa_oracle, NB_ORA_CLIENT=iwh-dbqa-bu';
ALLOCATE CHANNEL CH02 TYPE 'SBT_TAPE' parms='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64.1' ;

[code]...

View 3 Replies View Related

SQL & PL/SQL :: ORA-01994 - GRANT Failed / Password File Missing Or Disabled

Apr 5, 2012

When I create the orapwd file the sys user is not in the file,The problem started when I tried to grant sysdba privileges to sys

[oracle@bg2mo08i3 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on Thu Apr 5 18:47:06 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production

SQL> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled

SQL> shutdown immediate;

From the postings I read I shutdown the DB and I created a new orapwd file:
$ orapwd file=$ORACLE_HOME/dbs/orapwSID password=password entries=30 force=y

SQL> startup;

Started the DB, verified that the password parameter is set to EXCLUSIVE.

SQL>show parameter password;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>

SQL> select * from v$pwfile_users;
no rows selected
SQL>

Shouldn't the sys user be listed in the v$pwfile_users?

[oracle@bg2mo08i3 dbs]$ ls -l ora*
-rw-r----- 1 oracle oinstall 1536 Apr 5 18:02 orapwSID

Are these permissions and ownership correct?

I can connect using sys's password: SQL> connect sys/sysPASSWORD as sysdba Connected

View 12 Replies View Related

Precompilers, OCI & OCCI :: Compile ProC File - Failed Assertion

Aug 13, 2010

I am trying to compile a pro c file. Rest of the pro c file is compiling fine. But one particular file is showing following error.

INTERNAL ERROR: Failed Assertion [Code=40706]

View 11 Replies View Related

Database Failed To Start Up - ORA-03113 / End-of-file On Communication Channel

Jun 19, 2012

We had power failure, and i had to restore the database from offline backup.after restore i tried to start the database and i received following errors.

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 663961600 bytes
Fixed Size 2184056 bytes
Variable Size 394267784 bytes
Database Buffers 260046848 bytes
Redo Buffers 7462912 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

[code]....

I reviewed the /oracle/PRD/saptrace/diag/rdbms/prd/PRD/incident/incdir_583361/PRD_ora_7179_i583361.trc, it hugh file with alot of Jargon.

View 7 Replies View Related

Server Utilities :: Not A Valid Export File Header Failed Verification

Nov 22, 2012

Sometimes during recovery I encountered the following message "

This error occurs when Backup And Restore Occur between different versions

View 4 Replies View Related

Server Utilities :: ORA-01187 / Cannot Read From File 203 Because It Failed Verification Tests

Apr 26, 2011

I want to export all db using data pump. I got this error when using it:

Export: Release 10.2.0.4.0 - Production on Thu Nov 25 11:46:48 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export the entire database ...

. exporting tablespace definitions
EXP-00068: tablespace TISDATA is offline
EXP-00008: ORACLE error 1187 encountered
ORA-01187: cannot read from file 203 because it failed verification tests
ORA-01110: data file 203: '/u03/app/oracle/product/10.2.0/oradata/unidev/TISTEMP01.dbf'
EXP-00000: Export terminated unsuccessful

View 2 Replies View Related

Export/Import/SQL Loader :: DMP File In Oracle XE - Failed To Process Parameters

Jul 18, 2012

I am getting the following error while trying to import dmp file in oracle xe:

D:>imp system/manager file=pune_ucf.dmp tables=(ARR_TOT, DE
P_TOT) grants=no indexes=no rows=yes ignore=yes log=loc.log buffer=100000000;
LRM-00104: '100000000;' is not a legal integer for 'buffer'

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully.

View 2 Replies View Related

Merge Operation By ROW-ID?

Sep 8, 2011

run down of the implications of MERGE by ROWID in such a fashion:

CODE        MERGE
        INTO   XXWT_AP_ACCRUALS_RECEIPT_F EXT
        USING  (
                 SELECT PO_DISTRIBUTION_ID,
           
[code]...

Can this lead to an "Unstable Set of Rows?". Is it possible for the ROWID's to change during the execution of this statement - meaning certain ROWIDs identified in the SELECT will not actually be updated when it comes to the MERGE operation?

Basically, is it sound practice to use ROWID to merge on - in cases where you dont have a WHEN NOT MATCHED condition?

View 8 Replies View Related

Distributed Operation Not Supported

Jun 12, 2013

I am using the dblink to merge the data. I am using the following merge statement.

merge into APP_USER.USR_NEW_RIGHTS@NEW_RIGHTS t
Using (select 'test' GRANTEE,'TESTxxx'ROLE from dual ) s
on (t.GRANTEE = s.GRANTEE and t.ROLE = s.ROLE)
when not matched then
insert (ID,GRANTEE,ROLE,XRIGHT,COMPANY,OWNER,TABLENAME)
values ('','test','TESTxxx',null, null, null, null);

I know that I have to set a commit and it's working when I insert information's with a normal insert statement via database link, but it seems that merging doesn't work.

View 1 Replies View Related

SQL & PL/SQL :: All DML Operation Can Be Done In DUAL Table?

Apr 29, 2010

What are all the DML operation can be done in DUAL table.?

View 5 Replies View Related

SQL & PL/SQL :: Like Operation For Multiple Values

Jun 12, 2013

I have a source view where I have some invalid records and those should be found based on codes present in another table.

For eg. from source the records come like

****************SIINNSFDFD****FDFDF2******8
**********TABLE****************FDFSFSSFASFAS********

and if my reference table has values

SIINNSFDFD
TABLE

then these values are present as substring in the particular column in the source view. So I need to flag those records. For every record, I need to check whether all the values present in the reference table matches or not. If it matches then it should be flagged.

I can use in operator as we are not checking for the exact match and we are checking whether that value is present anywhere in that column record.

Looping results in performance issue. We can use PL/SQL for this. As the source view is put into a ETL internal file.

View 2 Replies View Related

SQL & PL/SQL :: Values Before / After The Operation Is Performed

Dec 2, 2011

I want to create one sql script with the followings-

1.Show the values before the operation is performed
2.Display the values after the operation is performed.

How it can be done in a proper sql script format.

View 10 Replies View Related

TNS-12535 - Operation Timed Out?

Apr 26, 2013

Frequently getting below error in alert log file. to sort out this issue.
Database: Active standby database
OS: Windows Server
Db Version: 11.2.0.2

Error:
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.2.0 - Production

[code]...

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved