Solaris 10 - problem with connect to Oracle 10.2.0.2 with ORA_SYSDBA
- From: petitjean.franck@xxxxxxxxx (Olwin)
- Date: Thu, 31 Jul 2008 12:10:37 -0700 (PDT)
Sorry for my poor English.
After connect in SYSDBA to an Oracle 10.2.0.2 Database, all system
command return '-1' (No child processes).
Problem detect on a Solaris 10 x86 server :
Details :
perl -MDBI -e 'DBI->installed_versions'
Perl : 5.008006 (i86pc-solaris-thread-multi)
OS : solaris (2.10)
DBI : 1.42
DBD::Sponge : 11.10
DBD::Proxy : 0.2004
DBD::Oracle : 1.15
DBD::File : 0.30
DBD::ExampleP : 11.12
DBD::DBM : 0.01
It's a production server, I can't upgrade DBD::Oracle for the moment.
It's the first application on the server to use perl,others only use
shell/sqlplus
This code will show the problem :
use DBD::Oracle qw(:ora_session_modes);
my $dsn = "dbi:Oracle:"; # no dbname here
print "TWO_TASK not defined\n" if (not defined($ENV{TWO_TASK}));
print "ORACLE_SID : $ENV{ORACLE_SID} \n";
my $dbh = DBI->connect($dsn, "", "", { ora_session_mode =>
ORA_SYSDBA });
$dbh->{RaiseError} = 1;
my $sth = $dbh->prepare( "select sysdate from dual" );
$sth->execute();
my $date=$sth->fetchrow();
print "Date : $date \n";
$sth->finish();
$dbh->disconnect();
my $ret=system("date");
print "retour : $ret";
Result on my machine :
TWO_TASK not defined
ORACLE_SID : KJD00
Date : 30-JUL-08
mercredi, 30 juillet 2008, 14:32:22 MEST
retour : -1
Get you the same result as me?
.
- Follow-Ups:
- Re: Solaris 10 - problem with connect to Oracle 10.2.0.2 with ORA_SYSDBA
- From: Martin J. Evans
- Re: Solaris 10 - problem with connect to Oracle 10.2.0.2 with ORA_SYSDBA
- Prev by Date: Re: Why do I encounter this error ? ORA-12705 : Cannot access NLS data files or invalid environment specified
- Next by Date: Re: A Question about DBD-Informix
- Previous by thread: Why do I encounter this error ? ORA-12705 : Cannot access NLS data files or invalid environment specified
- Next by thread: Re: Solaris 10 - problem with connect to Oracle 10.2.0.2 with ORA_SYSDBA
- Index(es):
Relevant Pages
|
