Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Hi,
I want to input unix variable to sqlplus.The following is working fine
sqlplus username/password @dummy.sql param1 param2 << EOF
create user $1 identified by $2;
EOF
But I dont want any file name to be passed,I just want to pass the parameter. Is there any way to that??
Thanks... (3 Replies)
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 Replies)
Hi,
I am writing a script which creates an external table using a shell script. My requirement is like this.
Usage: . ./r.ksh <table_name> - this should create an external table.
e.g . ./r.ksh abc - this should create an external table as abc_external.
How do i achieve this? Please... (5 Replies)
Hi there,
I am trying to call a shell script from a Perl script. here is the code:
@args = ("sh", "someshellprg.sh", "a file handler", "an array");
system(@args) == 0
or die "system @args failed: $?";
in the shell program, I examine if the arguments exits using:
if
then echo... (5 Replies)
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Hi All,
I'm new to Linux and scripting, apologies in advance for 'stupid' questions.
Please help... Im writing a script that calls a sqlplus script but the sqlplus requires inputs and i cant seem to get this to work.
here is my code.
#!/bin/sh
TERM=vt100
export TERM... (4 Replies)
Hi ,
I am using below code :
for i in `ps -ef|grep pmon|awk {' print $8 '}|cut -f3 -d'_'|grep -v '^grep'`
do
ORACLE_SID=$i
export ORACLE_SID;
dest=`sqlplus "/ as sysdba" <<EOF
set heading off feedback on verify off
select DESTINATION from v\\$archive_dest where target in... (5 Replies)
Apologies if this is the incorrect forum.There is an issue in the function call I am facing while calling the same from a unix shell scripts.
Basically, I want the ref cursor to return values to a variable in sqlpus. The function call is currently saved in a ".txt" file
in a unix location. I want... (7 Replies)
Hello,
I have file (PARFILE) with string on first line:
INCLUDE=SCHEMA:"IN\( 'SCHEMA1','SCHEMA2','SCHEMA3' \)"In .sh script I use:
....
IMPORT_SCHEMA=`awk 'NR==1{print $2}' ${PARFILE}`
...print $2 is because 'SCHEMA1','SCHEMA2','SCHEMA3' is 2nd column in file
echo "$IMPORT_SCHEMA"... (5 Replies)
Discussion started by: DjukaZg
5 Replies
LEARN ABOUT SUNOS
fruadm
fruadm(1M) System Administration Commands fruadm(1M)NAME
fruadm - prints and updates customer data associated with FRUs
SYNOPSIS
/usr/platform/sun4u/sbin/fruadm
/usr/platform/sun4u/sbin/fruadm -l
/usr/platform/sun4u/sbin/fruadm [-r] path [text]
DESCRIPTION
fruadm prints or sets the customer data for Field-Replaceable Units (FRUs).
Without arguments, fruadm prints the paths of all FRU ID-capable FRUs (containers) in the system, along with the contents of the customer
data record, if present, for each such FRU; for FRUs without customer data, fruadm prints only the container's path.
Only a privileged user can create or update data in containers. The privileges required to perform these write operations are hardware
dependent. Typically, a default system configuration restricts write operations to the superuser or to the platform-administrator user.
OPTIONS
The following options are supported:
-l List the system's frutree paths.
-r Recursively display or update the data for all containers rooted at the argument path.
OPERANDS
The following operands are supported:
path A full or partial system frutree path for or under which to print or set the customer data. The first field of each
line of output of fruadm -l gives the valid full frutree paths for the system.
Paths can include shell meta-characters; such paths should be quoted appropriately for the user's shell. For par-
tial paths, the first matching full path is selected for display or update. Without the -r option, the path must be
that of a container; with the -r option, all containers (if any) under path will be selected.
text Up to 80 characters of text set as the customer data. If the text contains white space or shell metacharacters, it
should be quoted appropriately for the user's shell.
EXAMPLES
Example 1: Displaying All Customer Data
The following example prints all customer data available from FRUs on the system. For containers with no customer data, only the contain-
ers' paths will be listed.
example% fruadm
Example 2: Displaying Customer Data For a Single FRU
The following command prints the customer data, if present, for the specified FRU:
example% fruadm /frutree/chassis/system-board
Example 3: Displaying Customer Data For a Single FRU
The following command prints the customer data, if present, for the first mem-module found:
example% fruadm mem-module
Example 4: Setting Customer Data
The following example sets the customer data for a FRU:
example# fruadm system-board 'Asset Tag 123456'
Example 5: Setting Customer Data
The following command sets the customer data for all FRUs under chassis:
example# fruadm -r /frutree/chassis "Property of XYZ, Inc."
EXIT STATUS
The following exit values are returned:
0 Successful completion.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWfruip.u |
+-----------------------------+-----------------------------+
|Interface Stability |Unstable |
+-----------------------------+-----------------------------+
SEE ALSO prtfru(1M), attributes(5)SunOS 5.10 22 Feb 2002 fruadm(1M)