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
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)
All times are GMT -4. The time now is 06:01 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy