11-06-2008
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
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
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
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
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
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
can it have any command
that swinstall and swremove without gui
thanks (1 Reply)
Discussion started by: alert0919
1 Replies
7. Solaris
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
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
LEARN ABOUT PHP
array_product
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)