Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

shellscripting question

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting shellscripting question
# 1  
Old 11-14-2005
shellscripting question
I have been “commissioned” to write a shellscript to automate Oracle cold refeshes.. right now we perform about 20 refresh each 300gb in size which takes up our time. my goal is to write a shellscript which can be executed by a user on serverA to refresh any of the 7 databases on ServerA. I am trying to figure out how to tell the script how based on SID that is passed with the script how to figure out which mountpoints/directories are owned by that sid?

any ideas?
# 2  
Old 11-16-2005
find /path -xdev -user ID -print


(Not sure what an SID is, I assume it's related to a UNIX UID, which is the ID in the find command above).
# 3  
Old 11-16-2005
actually Sid is an Oracle_SID.. A databasename.
# 4  
Old 11-16-2005
Are you saying that you have a unix user for each SID?
# 5  
Old 11-16-2005
Objects (directories and files) in the UNIX filesystem are owned by UID's. If you want to find anything in them, you need to have a mapping between SID's and UID's somewhere.
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shellscripting -z option

Can someone explain the -z option in shellscripting. I did this. When I was in both ksh and bash it echoed back hi. #!/bin/ksh if then echo hi fi When I echoed $BASH_VERSION in bash it gave a version. When I echoed $BASH_VERSION in ksh it was blank. I thought -z was... (4 Replies)
Discussion started by: cokedude
4 Replies

2. Shell Programming and Scripting

small error in shellscripting -archival part

Hi All, I have run the below script but getting one small error. please help me to solve this. ERROR: tar: Error exit delayed from previous errors CODE: #! /bin/bash CEP=/home/user01/exercise/CEP ARCH=/home/user01/exercise/archive LOG=/home/user01/exercise/logs... (3 Replies)
Discussion started by: aish11
3 Replies

3. Shell Programming and Scripting

shellscripting to edit xml file

I have an xml file where every line which has the word CDATA in it follows this pattern (line number) <word1><!]></>I need only these lines editing so that the end result is that (line number) <word1><!]></word1>so it copies the first bit to the end. Anyone know how I can do this I am... (10 Replies)
Discussion started by: legolad
10 Replies

4. Shell Programming and Scripting

Timeout in shellscripting

#!/bin/sh for ip in $(cat /root/Desktop/ftp.txt) do HOST=$ip USER='bob' PASS='bob' ftp -n $HOST <<EOF user bob bob EOF echo "$ip" done the Above code i want to use check and verify login works on multiple ftp servers on my network. However the ftp servers are dynamic in setup... (5 Replies)
Discussion started by: Noledge
5 Replies

5. Shell Programming and Scripting

csv file to excel file with shellscripting

Hi all, Please help me out How to write a shell script which converts abc.csv file into abc.xls example file abc.csv AP_RQ_ID,TXN_IER,AP_RS_RESP_CD,TXN_CNT,TOTAL_AMT 60000002,ACTIVATION,00,490,14657.52 60000002,ACTIVATION,08,1,100 This needs to be converted into excel format using a... (3 Replies)
Discussion started by: dudd9
3 Replies

6. Shell Programming and Scripting

New to shellscripting error: ./emailnotifications.sh: line 43: [: FH: integer expression expected

Hi , I'm a beginner in unix shell scripting need help in rectifying an error Source file :test.txt with Header ------ ----- Trailer ex: FH201010250030170000000000000000 abc def jke abr ded etf FE2 I was validating whether the header begin... (2 Replies)
Discussion started by: dudd9
2 Replies

7. Shell Programming and Scripting

New to shellscripting....need some help!

I have 3 shell scripts below.... I need to write a command line parser for these 3 utilities. basically the parser will accept ANY number of commands in this syntax -r = right -f = findtext -c = count so you do something like mu.s -r 3 4 5 -f hello goodbye.txt -c *.c -h 5 4 3 right... (5 Replies)
Discussion started by: TurboArkhan
5 Replies

8. Shell Programming and Scripting

Running SQLPLUS from Shellscripting ...

Hi guys, I am facing issues while triggering sqlplus with "/" option I can connect to database with USER ID and password. but, if i just specify "/" option since it is "externally identiifed user" it doesn't work Any suggestions? mail me @ Removed. Regards, Giri (2 Replies)
Discussion started by: chittari
2 Replies
Login or Register to Ask a Question