Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

XDOLoad.sh Korn shell errors out while loading

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting XDOLoad.sh Korn shell errors out while loading
# 1  
Old 06-29-2012
XDOLoad.sh Korn shell errors out while loading
Hi All,

O/S :AIX 6.1 64 bits

The following shell script errors out while loading:


Code:
cat XDOLoad.sh

#!/usr/bin/ksh

%s_contextfile%

%s_adjvaprg% oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME %s_apps_user% -DB_PASSWORD ${1} -JDBC_CONNECTION %s_dbhost%.xyz:%s_dbport%:%s_db_serv_sid% -LOB_TYPE DATA_TEMPLATE -APPS_SHORT_NAME XX -LOB_CODE XX_SUBACC -LANGUAGE en -TERRITORY US -XDO_FILE_TYPE XML -NLS_LANG AMERICAN -FILE_CONTENT_TYPE 'text/html' -FILE_NAME %c_xxcno_top%/patch/115/publisher/defs/XX.xml -OWNER ORACLE -CUSTOM_MODE FORCE

exit 0


$ ./XDOLoad.sh apps
./XDOLoad.sh[3]: %s_contextfile%:  not found
./XDOLoad.sh[5]: %s_adjvaprg%:  not found

What is the fix for this please?

Thanks for your time!

Regards,
# 2  
Old 06-29-2012
What are these %..% strings, are those DOS variables, or preprocessing markers? They are alien to ksh syntax...
# 3  
Old 06-29-2012
preprocessing markers to get the values from variables of xml files

For example,

Code:
grep s_apps_user $CONTEXT_FILE
            <username oa_var="s_apps_user">APPS</username>

What is the fix for this issue?

Thanks,
Last edited by Scrutinizer; 06-29-2012 at 07:56 AM.. Reason: code tags
# 4  
Old 06-29-2012
First preprocess the script and then execute the resulting script, I suppose...
# 5  
Old 06-29-2012
The %..% variables are defined to accept the values from the xml file -> $CONTEXT_FILE

How can we fix that in the shell script as above?

Thanks,
# 6  
Old 06-29-2012
A quick Google revealed this post on oracle.com about the unix syntax.

https://forums.oracle.com/forums/thr...readID=2330229
# 7  
Old 06-29-2012
Hi,

But the requirement is such, we need to get the shell script executed by using:

%..% variables defined to accept the values from the xml file -> $CONTEXT_FILE


Could anyone please help?

Thanks & Regards,
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Loading data in oracle using shell scripts

Hi , I have a scenario, i have a directory where i receive around 14-15 files at a interval of 20-40 min not fixed, i want to write a unix scripts which invoke sqlldr command to load files into oracle automatically as soon as the file hit the directory. Any help will be appreciated. ... (4 Replies)
Discussion started by: guddu_12
4 Replies

2. Shell Programming and Scripting

Loading a tar file into the shell script

Hi All, I am trying to write a shell script in which the contents of a small tar file is loaded into a variable and the same variable contents is moved into another file and finally untaring of the newly created file is done. The Shell Script is as follows: #----Start Of The... (11 Replies)
Discussion started by: wini008
11 Replies

3. Shell Programming and Scripting

Bourne shell & Korn shell

Could some one tell me the difference btw Bourne shell and the Kshell? Which is more flexible and reliable in terms of portability and efficiency. When i type the following command .. $ echo $SHELL yields me /bin/sh Does this tells me that I am in Bourne shell. If yes, how can i get... (6 Replies)
Discussion started by: bobby1015
6 Replies

4. Shell Programming and Scripting

How to activate Korn Shell functionnalities in Bourne Shell

Hi All I have writing a Korn Shell script to execute it on many of our servers. But some servers don't have Korn Shell installed, they use Borne Shell. Some operations like calculation don't work : cat ${file1} | tail -$((${num1}-${num2})) > ${file2} Is it possible to activate Korn Shell... (3 Replies)
Discussion started by: madmat
3 Replies

5. Shell Programming and Scripting

Function loading in a shell scripting like class loading in java

Like class loader in java, can we make a function loader in shell script, for this can someone throw some light on how internally bash runs a shell script , what happenes in runtime ... thanks in advance.. (1 Reply)
Discussion started by: mpsc_sela
1 Replies

6. Shell Programming and Scripting

Shell Script for Data loading in Oracle

Hi All I am new to unix. I need a shell script to load a datafile in to oracle. I already have a control file, and data file. all I need is if i execute the shell it must load the data using the ctl file to table. Control file : PAY0001.ctl Datafile : mon_grs_det.dat log file :... (3 Replies)
Discussion started by: raghuraja_r
3 Replies

7. Shell Programming and Scripting

how to convert from korn shell to normal shell with this code?

well i have this code here..and it works fine in kornshell.. #!/bin/ksh home=c:/..../ input=$1 sed '1,3d' $input > $1.out line="" cat $1.out | while read a do line="$line $a" done echo $line > $1 rm $1.out however...now i want it just in normal sh mode..how to convert this?... (21 Replies)
Discussion started by: forevercalz
21 Replies

8. Shell Programming and Scripting

KORN Shell - Spawn new shell with commands

I want to be able to run a script on one server, that will spawn another shell which runs some commands on another server.. I have seen some code that may help - but I cant get it working as below: spawn /usr/bin/ksh send "telnet x <port_no>\r" expect "Enter command: " send "LOGIN:x:x;... (2 Replies)
Discussion started by: frustrated1
2 Replies

9. UNIX for Dummies Questions & Answers

Korn Shell Errors

I am new at the korn shell and have inherited a script i am trying to make work the errors im getting are as follows: ERRORS + pa_batching.ksh pa_batching.ksh: factset: not found pa_batching.ksh: automation.: not found pa_batching.ksh: CT: not found pa_batching.ksh: syntax error at line... (6 Replies)
Discussion started by: chambala5
6 Replies

10. UNIX for Dummies Questions & Answers

shell loading

how do we change our default shell so it will be loaded everytime we login, automatically. i want to use bash instead of the ksh shell that is default. but it irritates me when i have to type it in everytime, just lazy but i´m sure its a simple way someone could tell me? (8 Replies)
Discussion started by: eeldivady
8 Replies
Login or Register to Ask a Question