Sponsored Content
Operating Systems HP-UX How to run sqlscript in the swinstall ? Post 302255184 by plaban.rout on Thursday 6th of November 2008 03:47:58 AM
Old 11-06-2008
Bug How to run sqlscript in the swinstall ?

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
 

8 More Discussions You Might Find Interesting

1. HP-UX

help with swinstall

I'm trying to install gcc from hp with swinstall but what happens is the following: I change source to the correct depot, it complains it can't find anything, when I change target to /usr/local, it shows the depot in the list. Next, I mark it for install, install it, but then it gets installed... (4 Replies)
Discussion started by: rein
4 Replies

2. HP-UX

Help with swinstall HP patches

I am having trouble installing some HPUX patches on my B1000 11.11. I am a novice at this so bear with me. I understand how to install depots. Very easy. Now I'm trying to patch my system so I can get the Oracle client installed. Oracle says I need these two patches: PHCO_23770, PHCO_23092 I... (4 Replies)
Discussion started by: natter
4 Replies

3. HP-UX

swinstall and autoreboot

HI I am new on unix admin. I would like to know, if it is possible to a. install the patch (like phss_25277) during normal business hours and b. reboot the server during off peak hours on a production box c. what is the normal practise for the patch installs on hp-ux (PA-RISC, B.11.11)... (6 Replies)
Discussion started by: schilukuri
6 Replies

4. HP-UX

swinstall

Hi, I am new to HP-UX. I am attempting some pre-requisites to an Oracle upgrade, part of which requires some OS patching. When I check using show_patches or swlist -l patch the patches do not exist. On visiting ItResource web page I see the patches and later "recommended" patches (that unlike... (2 Replies)
Discussion started by: malcqv
2 Replies

5. HP-UX

swinstall issues

what the heck am I doing wrong? Im trying to install bastille and i keep getting errors. # cd - /var/spool/sw # ls B6849AA_B.02.01.03.depot catalog swagent.log var # swinstall -s /var/spool/sw B6849AA ======= 10/04/07 09:47:43 EDT BEGIN swinstall... (4 Replies)
Discussion started by: csaunders
4 Replies

6. HP-UX

swinstall and swremove

can it have any command that swinstall and swremove without gui thanks (1 Reply)
Discussion started by: alert0919
1 Replies

7. Solaris

swinstall: not found

i am having this error when i try to execute # swinstall -s /cdrom/volume_manager3.5/pkgs swinstall: not found anyone know why was it having this error? Thanks in advance. (2 Replies)
Discussion started by: beginningDBA
2 Replies

8. Shell Programming and Scripting

Problems in execution of sqlscript in unix

I am new to unix and trying to execute sql script from unix. I have function already in database and trying to execute it from Cygwin unix and getting stuck. Can someone guide me where I wrote the shell script wrong sqlplus -s scott/tiger declare a number:=3; b number:=4; c number; d... (2 Replies)
Discussion started by: pyerragudi
2 Replies
ARRAY_PRODUCT(3)							 1							  ARRAY_PRODUCT(3)

array_product - Calculate the product of values in an array

SYNOPSIS
number array_product (array $array) DESCRIPTION
array_product(3) returns the product of values in an array. PARAMETERS
o $array - The array. RETURN VALUES
Returns the product as an integer or float. CHANGELOG
+--------+---------------------------------------------------+ |Version | | | | | | | Description | | | | +--------+---------------------------------------------------+ | 5.3.6 | | | | | | | The product of an empty array is now 1, when | | | before this function would return 0 for an empty | | | array. | | | | +--------+---------------------------------------------------+ EXAMPLES
Example #1 array_product(3) examples <?php $a = array(2, 4, 6, 8); echo "product(a) = " . array_product($a) . " "; echo "product(array()) = " . array_product(array()) . " "; ?> The above example will output: product(a) = 384 product(array()) = 1 PHP Documentation Group ARRAY_PRODUCT(3)
All times are GMT -4. The time now is 06:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy