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 CENTOS
commit_prepared
COMMIT
PREPARED(7) PostgreSQL 9.2.7 Documentation COMMIT PREPARED(7)
NAME
COMMIT_PREPARED - commit a transaction that was earlier prepared for two-phase commit
SYNOPSIS
COMMIT PREPARED transaction_id
DESCRIPTION
COMMIT PREPARED commits a transaction that is in prepared state.
PARAMETERS
transaction_id
The transaction identifier of the transaction that is to be committed.
NOTES
To commit a prepared transaction, you must be either the same user that executed the transaction originally, or a superuser. But you do not
have to be in the same session that executed the transaction.
This command cannot be executed inside a transaction block. The prepared transaction is committed immediately.
All currently available prepared transactions are listed in the pg_prepared_xacts system view.
EXAMPLES
Commit the transaction identified by the transaction identifier foobar:
COMMIT PREPARED 'foobar';
COMPATIBILITY
COMMIT PREPARED is a PostgreSQL extension. It is intended for use by external transaction management systems, some of which are covered by
standards (such as X/Open XA), but the SQL side of those systems is not standardized.
SEE ALSO
PREPARE TRANSACTION (PREPARE_TRANSACTION(7)), ROLLBACK PREPARED (ROLLBACK_PREPARED(7))
PostgreSQL 9.2.7 2014-02-17 COMMIT PREPARED(7)