Visit Our UNIX and Linux User Community


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


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Permission to Oracle server to create a directory in a particular path
# 8  
Old 08-12-2013
Check the permissions of the directory where you want this process/user to create new directories/files and use chmod to change the permissions accordingly.

--ahamed
# 9  
Old 08-12-2013
Quote:
Originally Posted by ahamed101
Check the permissions of the directory where you want this process/user to create new directories/files and use chmod to change the permissions accordingly.

--ahamed
hI AHMAD,
i also got this

Code:
ls -lrt  $ORACLE_HOME  
lrwxrwxrwx   1 oracle   100            8 Mar 10  2008 /var/opt/oracle/product/10g -> 10.2.0.1

In the above case user is oracle
# 10  
Old 08-12-2013
Check the permissions of 10.2.0.1

--ahamed
# 11  
Old 08-12-2013
Quote:
Originally Posted by ahamed101
Check the permissions of 10.2.0.1

--ahamed
You mean
Code:
/var/opt/oracle/product/10g -> 10.2.0.1

Its permission and user is
Code:
lrwxrwxrwx   1 oracle

For ls -lrt 10.2.0.1
it gives 10.2.0.1: No such file or directory
# 12  
Old 08-12-2013
Ask your DBA what account the database runs as. If you are the DBA, ask the OS SysAdmin. If you are both, then ........ Smilie

You will need to know who runs the database, not the user running the SQL with the "write to directory" code in it.



Robin
This User Gave Thanks to rbatte1 For This Post:
# 13  
Old 08-12-2013
Quote:
Originally Posted by rbatte1
Ask your DBA what account the databasde runs as. If you are the DBA, ask the OS SysAdmin. If you are both, then ........



Robin
Probably database runs as oracle user and i use it as usr_1 user.
I am not the admin nor DBA Smilie
# 14  
Old 08-12-2013
Okay, well you will need to consult them to achieve this, assuming that you have the Oracle privilege to so this. Smilie



Robin

Previous Thread | Next Thread
Test Your Knowledge in Computers #397
Difficulty: Medium
HP-UX 11i offers a common shared disks for its clustered file system.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

What is the difference ../directory path and ./directory path in ksh?

What is the difference ../directory path and ./directory path in ksh? (1 Reply)
Discussion started by: TestKing
1 Replies

2. UNIX for Beginners Questions & Answers

Convert Relative path to Absolute path, without changing directory to the file location.

Hello, I am creating a file with all the source folders included in my git branch, when i grep for the used source, i found source included as relative path instead of absolute path, how can convert relative path to absolute path without changing directory to that folder and using readlink -f ? ... (4 Replies)
Discussion started by: Sekhar419
4 Replies

3. Solaris

Permission for files in the path

Hi All, I have this file system /sys/app/ and application creating many file under that path. I want any created file under that path to be created with 644 permission Any help support in this please! (2 Replies)
Discussion started by: AbuAliiiiiiiiii
2 Replies

4. AIX

How to set owner and permission for files/directory in directory in this case?

Hi. My example: I have a filesystem /log. Everyday, log files are copied to /log. I'd like to set owner and permission for files and directories in /log like that chown -R log_adm /log/* chmod -R 544 /log/*It's OK, but just at that time. When a new log file or new directory is created in /log,... (8 Replies)
Discussion started by: bobochacha29
8 Replies

5. Shell Programming and Scripting

Permission to Oracle server

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

6. Red Hat

Mkdir: cannot create directory `/home/phpmy/html': Permission denied centos

for incompatibility installation problems, I've decided to reinstall Centos 6.3 as can be seem from the df output, I've partitioned both / and and /home directories $ df -h Filesystem Size Used Avail Use% Mounted on /dev/sda8 12G 5.3G 6.5G 45% / tmpfs ... (2 Replies)
Discussion started by: jediwannabe
2 Replies

7. UNIX and Linux Applications

DSCC can not create Directory Server

Hi all, I have a problem when I try to create a Directory Server on Directory Service Control Center - DSCC. The log shows the following: Creating Directory Server test1:389. Server Logs: couldn't set locale correctly couldn't set locale correctly Directory '/var/ds/' already exists... (1 Reply)
Discussion started by: Yohanna Flores
1 Replies

8. UNIX for Dummies Questions & Answers

mkdir: cannot create directory `/builds/somedir/': Permission denied

Hi, I am trying to run a shell script which contains an mkdir command as part of the execution. The script fails with the following error: mkdir: cannot create directory `/builds/somedir/': Permission denied The user running the script is 'harry' and belongs to group 'school'.... (5 Replies)
Discussion started by: Technext
5 Replies

9. Shell Programming and Scripting

Retrieve directory path from full file path through sh

Hi, I have a file abcd.txt which has contents in the form of full path file names i.e. $home> vi abcd.txt /a/b/c/r1.txt /q/w/e/r2.txt /z/x/c/r3.txt Now I want to retrieve only the directory path name for each row i.e /a/b/c/ /q/w/e/ How to get the same through shell script?... (7 Replies)
Discussion started by: royzlife
7 Replies

10. 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

Featured Tech Videos