How to run sqlscript in the swinstall ?

UNIX HP-UX
1

hi,

I have prepared a script with contents

/dboracle/orabase/product/9.2.0.6/bin/sqlplus -s rcrp/rcrp<<EOF

CREATE TABLE ADDER_CUG_LIST
(
CUG_ID VARCHAR2(15) NOT NULL,
TEL_NO VARCHAR2(15),
START_DATE DATE,
END_DATE DATE
);

exit;
EOF

/cisa/INSTALLATION/THESEUS/ROUND4/rcrp_insert rcrp rcrp /cisa/INSTALLATION/THESEUS/ROUND4/Adder_Cug_List.csv

/dboracle/orabase/product/9.2.0.6/bin/sqlldr rcrp/rcrp control=/cisa/INSTALLATION/THESEUS/ROUND4/Numb_Gen_Method.ctl log=/ci
sa/INSTALLATION/THESEUS/ROUND4/Numb_Gen_Method.log

I put this script as post install script. i prepared the package using swpackage. The packaging was completed successfully.

but while runing sw install i am getting error

Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Error Can't Connect:Error while trying to retrieve text for error ORA-12545

please advice me?

Regards,
Plaban Rout

2

In your script , at the beginning, you have to set all oracle env...

3

I have set all oracle env in the scripts, but still no luck

ORACLE_SID=cisa2;export ORACLE_SID
export ORACLE_BASE=/dboracle/orabase
ORACLE_HOME=/dboracle/orabase/product/9.2.0.6;
SW_PATH=/dboracle/orabase/product/9.2.0.6;
PATH=$SW_PATH;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32
export TNS_ADMIN=/var/opt/oracle

Regards,
Plaban

4

You havent exported PATH, ORACLE_HOME...

If you have oracle already installed with a dba/oracle account I wonder if it would not be more simpe to
. $(dba_accoutn)/.profile in your script
maybe worth testing...