OraFAQ Forum: Programming Interfaces » Unable to change Oracle SID with Net::SSH::Perl

Home » Open Source » Programming Interfaces » Unable to change Oracle SID with Net::SSH::Perl (All)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to change Oracle SID with Net::SSH::Perl [message #429421]

Tue, 03 November 2009 11:53

fairgame
Messages: 29
Registered: October 2008

Junior Member

Hi,

I am running a Perl code from Linux machine and doing SSH to Windows machine.

When I am trying to change SID with this command, it's not working. The SID does not change and it keeps the default SID.

#-- set up a new connection
	my $ssh = Net::SSH::Perl->new($host);
#-- authenticate
	$ssh->login($user, $password);
#-- execute the command
        $ssh->cmd('SET ORACLE_SID=testsid');

Report message to a moderator

[Message index]

		Unable to change Oracle SID with Net::SSH::Perl By: fairgame on Tue, 03 November 2009 11:53
		Re: Unable to change Oracle SID with Net::SSH::Perl By: Michel Cadot on Tue, 03 November 2009 12:15
		Re: Unable to change Oracle SID with Net::SSH::Perl By: fairgame on Tue, 03 November 2009 12:18
		Re: Unable to change Oracle SID with Net::SSH::Perl By: ThomasG on Tue, 03 November 2009 13:05
		Re: Unable to change Oracle SID with Net::SSH::Perl By: fairgame on Tue, 03 November 2009 15:24
		Re: Unable to change Oracle SID with Net::SSH::Perl By: fairgame on Tue, 03 November 2009 20:14
		Re: Unable to change Oracle SID with Net::SSH::Perl By: ThomasG on Wed, 04 November 2009 05:13

Previous Topic:	ODBC log shows ORA error even though the procedure runs fine on the backend.
Next Topic:	DBD::Oracle install problem on 64-bit RHEL51

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:09:38 CDT 2024