08-01-2001
rsh command
Hi,
I'm performing a data migration from an Ingres db to an Oracle db. The ingres database lives on a unix host running "UNIX(r) System V Release 4.0 (SunOS 5.5.1) ", while the Oracle database lives on another unix host running "SunOS 5.8".
Part of the migration is to remotely run Oracle's "sqlplus" and "sqlloader" utilities on the destination machine (the Oracle host machine).
I decided to use "rsh", but I ran into some problems. I tried the following:
rsh -l [username] [hostname] '/product/oracle/8.1.6/bin/sqlplus username/password@targetDB < create_table.sql'
When I run the above command, I get the following error:
"Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus"
Being a Unix begginer doesn't really help either :-).
Any help would be greatly appreciated.
ST
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Newbie here,
I want to add a line to our 3D rendering scripts that will
send an email to the animators once a scene has finished rendering. The 3D scripts are on the client hosts and the sendmail setup on the server.
I tried using a rsh line in the script as follows
rsh root@blah echo... (2 Replies)
Discussion started by: flamethrower
2 Replies
2. UNIX for Dummies Questions & Answers
Hello all,
Ok. Here it the scope I have two Redhat 7.2 machine which I use to test things on. I have a home directory which is NFS mounted via NIS. I have a .rhosts file in the directory with the name of the machine and username, with permission 600. Be when I try to run a rsh command I get... (6 Replies)
Discussion started by: larry
6 Replies
3. Shell Programming and Scripting
Hi ,
reading a "file1" with 2 data in each line (VAR1 and VAR2) , i'm using a while loop like this :
cat file1|awk '{print $1,$2}'|while read VAR1 VA2
do
echo $VAR1
echo $VAR2
done
as this example shows , it works but if between do and done i use
a "rsh" command , the script reads... (6 Replies)
Discussion started by: Nicol
6 Replies
4. Shell Programming and Scripting
Hello,
I am trying to determine 2 things on a remote host.
1. Is file a directory or file
2. Does the file or directory exist
Not too familiar with "find" command although I believe that may be a possible way. I have tried:
remsh "$HOST" test -e /home/test.script && echo "yes"
This... (3 Replies)
Discussion started by: bestbuyernc
3 Replies
5. UNIX for Dummies Questions & Answers
Hi, I am a beginner and i want to seek help
I want to use the rsh command.
Is there a possibility that i can do it without the system password
I am planning to make a csh script that could browse/copy files from diferent workstations.
thank you.... (5 Replies)
Discussion started by: wramonzon
5 Replies
6. Linux
we want to execute remote script via rsh (we just only should use rsh except others),but rsh command can not set environment variable for specify user, then scripts can not be executed correctly,anyone knows how to fix this problem? thanks. (8 Replies)
Discussion started by: Frank2004
8 Replies
7. Solaris
Hello guys, I have a script in a Linux server, from where I go to 3 Sun servers and run process.
Now i have done an upgrade and increase 1 Sun server more, now i need to run the shell in the Linux Server (into the shell is rsh command), but when i try to do ir with the new Sun server, i hace the... (3 Replies)
Discussion started by: lestat_ecuador
3 Replies
8. Shell Programming and Scripting
Hi
Does anybody know how to to return the exit code of a remote
command when using rsh?
I know that "rsh" has no built-in ability for that.
The echo $? is showing the results of the rsh command. Not the
remotely executed command.
I am trying to get the return code of psef command from... (4 Replies)
Discussion started by: aoussenko
4 Replies
9. Shell Programming and Scripting
Hello,
I am doing an rsh connection to server2.
I want to perform several command on server2.
I.E:
i=1
rsh server1 -l username "z=$i;`script.ksh`"
(1)Is this the right way to give z value to be used on server2?
(2) Is this the right way to run a script on server2? (1 Reply)
Discussion started by: LiorAmitai
1 Replies
10. Shell Programming and Scripting
Hello,
I am trying to run a remote file (y.ksh) using rsh.
In this action i want to use an environment variable TOOL=/home/macc1
i am running the rsh from profile macc on server1.
rsh server2 -l macc1 "$TOOL/y.ksh"
but i can see that the executable command = /home/macc/y.ksh and not... (1 Reply)
Discussion started by: LiorAmitai
1 Replies
LEARN ABOUT SUSE
apache::session::store::oracle
Session::Store::Oracle(3) User Contributed Perl Documentation Session::Store::Oracle(3)
NAME
Apache::Session::Store::Oracle - Store persistent data in a Oracle database
SYNOPSIS
use Apache::Session::Store::Oracle;
my $store = new Apache::Session::Store::Oracle;
$store->insert($ref);
$store->update($ref);
$store->materialize($ref);
$store->remove($ref);
DESCRIPTION
Apache::Session::Store::Oracle fulfills the storage interface of Apache::Session. Session data is stored in a Oracle database.
SCHEMA
To use this module, you will need at least these columns in a table called 'sessions':
id varchar2(32) # or however long your session IDs are.
a_session long
To create this schema, you can execute this command using the sqlplus program:
CREATE TABLE sessions (
id varchar2(32) not null primary key,
a_session long
);
If you use some other command, ensure that there is a unique index on the table's id column.
CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the
options hash (see Apache::Session documentation). The options are DataSource, UserName, and Password.
Example:
tie %hash, 'Apache::Session::Oracle', $id, {
DataSource => 'dbi:Oracle:database',
UserName => 'database_user',
Password => 'K00l'
};
Instead, you may pass in an already-opened DBI handle to your database.
tie %hash, 'Apache::Session::Oracle', $id, {
Handle => $dbh
};
The last option is LongReadLen, which specifies the maximum size of the session object. If not supplied, the default maximum size is 8 KB.
AUTHOR
This modules was written by Jeffrey William Baker <jwbaker@acm.org>
A fix for the commit policy was contributed by Michael Schout <mschout@gkg.net>
SEE ALSO
Apache::Session, Apache::Session::Store::DBI
perl v5.12.1 2007-09-28 Session::Store::Oracle(3)