Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Permission to Oracle server

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Permission to Oracle server
# 8  
Old 07-22-2013
Quote:
Originally Posted by vidyadhar85
Could you please post the Oracle user and entry from ALL_DIRECTORIES also the owner and permission details of directory?

Also the exact error message

USER DIRECTORY PATH
SYS R_TEST /arbor/integ_fx/rahul_raj/sqlloader_test/sample.txt

i raised this question OTN FORUM https://forums.oracle.com/thread/2554473

Code:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout  
ORA-29400: data cartridge error  
KUP-04063: unable to open log file T_EXT_17082.log  
 OS error No such file or directory  
ORA-06512: at "SYS.ORACLE_LOADER", line 19  
29913. 00000 -  "error in executing %s callout"  
*Cause:    The execution of the specified callout caused an error.  
*Action:   Examine the error messages take appropriate action.

---------- Post updated at 12:12 PM ---------- Previous update was at 11:48 AM ----------

Quote:
Originally Posted by millan
Can u check if you have write permission to the folder inside which you are creating another folder.

Code:
 
ls -ld foldername

Hi i checked

its drwxr-xr-x
# 9  
Old 07-22-2013
Are you the owner of this folder?
Form the permission, it looks only the owner has write access ..not the group or others.

try changing the permission of the folder to 775 or 777.

Code:
 
chmod 775 foldername

or

Code:
 
chmod 777 foldername

# 10  
Old 07-22-2013
Quote:
Originally Posted by millan
Are you the owner of this folder?
Form the permission, it looks only the owner has write access ..not the group or others.

try changing the permission of the folder to 775 or 777.

Code:
 
chmod 775 foldername

or

Code:
 
chmod 777 foldername

drwxrwxrwx sqlloader_test

I have changed the permission now

# 11  
Old 07-22-2013
Is it still giving the error after you changed the permission of that folder?
# 12  
Old 07-22-2013
Quote:
Originally Posted by millan
Is it still giving the error after you changed the permission of that folder?

I am still getting the error.

What should i do?
Last edited by rafa_fed2; 08-12-2013 at 06:18 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Strange permission issue on Linux server.

Starting sendmail throws this error: I decided to see the permission on the files under /etc/mail and this is the output: # ls -ltr total 284 -rwxr-xr-x. 1 root root 1847 Jan 27 2014 virtusertable -rwxr-xr-x. 1 root root 127 Jan 27 2014 trusted-users -rwxr-xr-x. 1 root root 92... (3 Replies)
Discussion started by: mohtashims
3 Replies

2. Shell Programming and Scripting

Permission to Oracle server to create a directory in a particular path

i need to give permission to ORACLE SERVER to create a directory in a particular path. How to do it?Oracle server is installed on SOLARIS (16 Replies)
Discussion started by: rafa_fed2
16 Replies

3. Web Development

You don't have permission to access / on this server.

Hello, I've set all permissions for all on my Server folders: chmod a+rwx ServerFolder When I browse to localhost:8000 I receive the following error: You don't have permission to access / on this server. why ? thanks (9 Replies)
Discussion started by: aneuryzma
9 Replies

4. Solaris

root can not change the permission of old oracle archive directory in solaris 8

I am using oracle 9i with sun solaris 8 on Sun E 250 server.earlier we are taking backup of oracle archive files on /orabackup directory.in which archive file are stored with ...arc.Z extension. now we have changed the archive backup directory.now when we are trying to delete earlier directory... (3 Replies)
Discussion started by: mahanalok
3 Replies

5. UNIX for Dummies Questions & Answers

security permission logging onto Oracle database

Hello, I'm trying to login to an Oracle databse without entering the user/passwd. The server resides on an AIX 5.1 system, and using LDAP. I'm entering the following command >sqlplus / @ORACLE_SID This should work but for some odd reason I get a login denied. But if I enter the user id... (1 Reply)
Discussion started by: ctcuser
1 Replies

6. UNIX for Advanced & Expert Users

mount: failed, reason given by server: Permission denied

Hi , I have a filesystem on AIX 4.3.3 which i need to share with other clients who use Windows NT and Redhat linux 7.3. I use samba to share this with Windows NT Clients. Now i was to share this with Linux clients. When i try to nfs mount this on Linux i get "mount: failed, reason given by... (1 Reply)
Discussion started by: Sushesh
1 Replies
Login or Register to Ask a Question