ORA-06512 Error in Oracle 10g


 
Thread Tools Search this Thread
Operating Systems HP-UX ORA-06512 Error in Oracle 10g
# 1  
Old 01-13-2012
ORA-06512 Error in Oracle 10g

HI All ,
I am using oracle 10g and HP AIX . I am getting the below error while running the package.

Code:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "DW_APP.PKG_ASS_FVC", line 595
ORA-06512: at line 2

Permission Details
Code:
cd /RM/upload/
drwxrwxr-x    3 nmpadm   nmpapp         4096 Jan 13 00:42 recreate

Package DW_APP.PKG_ASS_FVC Line 595 has below code snippet

Code:
var_file_handle := sys.utl_file.fopen('/RM/upload/recreate',   'Reject' || runday || '.csv',   'w');

I am unable to get the csv formatted file.Is it problem with permissions ? If not anythg wrong with line 599 ? Please guide

Last edited by Scott; 01-15-2012 at 02:01 PM.. Reason: Please use code tags, and less formatting
# 2  
Old 01-13-2012
You should check if/RM/upload/recreate is listed as a accessible location in the utl_file_dir parameter.
# 3  
Old 01-15-2012
OR if it is listed as a directory object in ALL_DIRECTORIES view.
# 4  
Old 01-15-2012
Quote:
OR if it is listed as a directory object in ALL_DIRECTORIES view.
Just to add that in that case the OP should be using the database directory object name rather than the OS path.
This User Gave Thanks to radoulov For This Post:
# 5  
Old 01-23-2012
Oracle should have access to that directory, either chmod 777 it or chown it to the oracle user
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. AIX

Oracle 10g on AIX7

Hi, anyone know if Oracle Database 10g is AIX 7 certified??? thanks in advance. Regards. Mario (2 Replies)
Discussion started by: Zio Bill
2 Replies

2. UNIX for Advanced & Expert Users

grep all ORA errors except one ORA error

Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command? In following "grep" command I want to exclude "ORA-01653" error grep -i ORA alert.log >>/tmp/ora_errors.txt ... (7 Replies)
Discussion started by: Mansoor8810
7 Replies

3. Solaris

maxuprc and maxusers - ORA-27300, ORA-27301, ORA-27302

Hi all, Am intermittently getting the following errors on one of my databases. Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc: ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302:... (1 Reply)
Discussion started by: newbie_01
1 Replies

4. Shell Programming and Scripting

error ORA-06512 while running query in script

1 #!/bin/ksh 2 ################################################################ 3 # Written by Johnson 12/03/2008 4 # Version 1.0 5 # This script executes some SQL to provide Spike Check Report to TNS team. 6 ... (3 Replies)
Discussion started by: shivanete
3 Replies

5. AIX

oracle 10g on AIX 5

hi can anyone help me by telling step by stem oracle10g installation in AIX 5 . Munir mondolsoft Bangladesh (3 Replies)
Discussion started by: dbamunir
3 Replies

6. UNIX for Advanced & Expert Users

ORA-12157 error installing Oracle 10g on Fedora 5

Hi, Im installing Oracle 10g on Fedora 5, I did it once, but when I tried to set it up again I got this error on the last part of the install... ORA-12157: TNS: internal network communication error Anybody know what might cause this? I think I have installed all required RPMs and set... (1 Reply)
Discussion started by: Joncamp
1 Replies

7. UNIX for Advanced & Expert Users

oracle 10g

I have download Oracle 10g for Solaris and I have configurate environment than I will start runInstaller and I have a messege that my version of solaris is not 5.7 , 5.8 and 5,9 I have 5.10 Solaris version what I shoud do I have download most actuall Oracle databases. (4 Replies)
Discussion started by: Deux
4 Replies
Login or Register to Ask a Question