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 NETBSD
npm-run-script
NPM-RUN-SCRIPT(1) NPM-RUN-SCRIPT(1)
NAME
npm-run-script - Run arbitrary package scripts
SYNOPSIS
npm run-script <command> [--silent] [-- <args>...]
alias: npm run
DESCRIPTION
This runs an arbitrary command from a package's "scripts" object. If no "command" is provided, it will list the available scripts.
run[-script] is used by the test, start, restart, and stop commands, but can be called directly, as well. When the scripts in the package
are printed out, they're separated into lifecycle (test, start, restart) and directly-run scripts.
As of ` https://blog.npmjs.org/post/98131109725/npm-2-0-0, you can use custom arguments when executing scripts. The special option -- is
used by getopt https://goo.gl/KxMmtG to delimit the end of the options. npm will pass all the arguments after the -- directly to your
script:
npm run test -- --grep="pattern"
The arguments will only be passed to the script specified after npm run and not to any pre or post script.
The env script is a special built-in command that can be used to list environment variables that will be available to the script at run-
time. If an "env" command is defined in your package, it will take precedence over the built-in.
In addition to the shell's pre-existing PATH, npm run adds node_modules/.bin to the PATH provided to scripts. Any binaries provided by
locally-installed dependencies can be used without the node_modules/.bin prefix. For example, if there is a devDependency on tap in your
package, you should write:
"scripts": {"test": "tap test/*.js"}
instead of
"scripts": {"test": "node_modules/.bin/tap test/*.js"}
to run your tests.
The actual shell your script is run within is platform dependent. By default, on Unix-like systems it is the /bin/sh command, on Windows it
is the cmd.exe. The actual shell referred to by /bin/sh also depends on the system. As of `
https://github.com/npm/npm/releases/tag/v5.1.0 you can customize the shell with the script-shell configuration.
Scripts are run from the root of the module, regardless of what your current working directory is when you call npm run. If you want your
script to use different behavior based on what subdirectory you're in, you can use the INIT_CWD environment variable, which holds the full
path you were in when you ran npm run.
npm run sets the NODE environment variable to the node executable with which npm is executed. Also, if the --scripts-prepend-node-path is
passed, the directory within which node resides is added to the PATH. If --scripts-prepend-node-path=auto is passed (which has been the
default in npm v3), this is only performed when that node executable is not found in the PATH.
If you try to run a script without having a node_modules directory and it fails, you will be given a warning to run npm install, just in
case you've forgotten.
You can use the --silent flag to prevent showing npm ERR! output on error.
You can use the --if-present flag to avoid exiting with a non-zero exit code when the script is undefined. This lets you run potentially
undefined scripts without breaking the execution chain.
SEE ALSO
o npm help 7 scripts
o npm help test
o npm help start
o npm help restart
o npm help stop
o npm help 7 config
January 2019 NPM-RUN-SCRIPT(1)