Hi folks,
my 'perldoc DBD::Oracle' says in 'CONNECTING TO ORACLE':
If a port number is not specified then the descriptor will
try both 1526 and 1521 in that order (e.g., new then old).
You can check which port(s) are in use by typing
$ORACLE_HOME/bin/lsnrctl stat on the server.
Hello,
did you try
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('any information you like') ;
to set the session dependend client information? You can retrieve this later
via
V$SESSION.CLIENT_INFO
or via
DBMS_APPLICATION_INFO.READ_CLIENT_INFO(:g_client_info );
where :g_client_info is a bind variable.
recently there were several postings, but you could try this:
# my_config.pl
$usr = 'scott';
$pass = 'tiger';
...
# my_script.pl
require my_config.pl;
...
if you are working with 'use strict' (recommended), you should declare your
var's 'our':
# my_config.pl
our $usr = 'scott';
...
#
Hello,
besides looking at your tnsnames.ora file (and validating with an ordinary
sqlplus connect) you should take care about your ORACLE_SID and TWO_TASK
environment Variables (on UNIX). See below.
ORA-03106: fatal two-task communication protocol error
This points to an Oracle nativ connection
Hello all,
this topic has been discussed several times, i know. But i have not seen a
solution by now.
On UNIX i can open an Oracle DB connect internal connection by
$ sqlplus / as sysdba
when i am in OS group 'dba' - there is no need to specify a password.
Whichever type of connection i
Hi Steve,
i can only imagine you made a rollback in a (long lasting and) so far
read-only transaction.
If there had been any insert/update/delete operations any required cursors
should be valid.
cu, Christian
- Original Message -
From: Steve Baldwin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
-disconnect;
__END__
---
$ perl -wT dummy.pl
ora920
SYS
---
- Original Message -
From: Andy Hassall [EMAIL PROTECTED]
To: Christian Merz [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 11:35 PM
Subject: Re: Oracle connect
Hi all,
I am about to develop a new backup module. When I do:
loop_over_all_tablespaces {
$dbh-do(ALTER TABLESPACE $tablespace BEGIN BACKUP);
... (backup data files)
$dbh-do(ALTER TABLESPACE $tablespace END BACKUP);
}
everything is fine.
But (not only for performance reasons) I would rather
Hi all,
lately I digged on this. Here is my solution:
1) Standard
#!/usr/local/bin/perl -T
use DBI;
use strict;
use warnings;
delete $ENV{ 'ENV' };
$ENV{ORACLE_SID}= CAT;
$ENV{ORACLE_HOME} = /oracle/CAT/817_64;
$ENV{NLS_LANG} = AMERICAN_AMERICA.WE8DEC;
$ENV{ORA_NLS}
Hello all,
I am still having problems to 'connect internal' when there are different
$ORACLE_HOMEs owned by different $ORACLE_OWNERs.
For example (SunOS sap09 5.7 Generic_106541-32 sun4us sparc FJSV,GPUSK):
user1: /oracle/elearn/app/oracle/product/9.2.0_32
user2: /oracle/S13/817_64
(On
another point is: how do you get a consistent snapshot (i.e. for backup)? if you
store things inside and outside the database neither database backup nor
filesystem backup will achieve this. one solution would be to shut down the
database and take a cold backup of the database and the file system
Hello Sangeeth,
the problem is a 32/64 bit mismatch of your perl (32bit) and your oracle (64bit)
libs: 'wrong ELF class'.
our system group fixed this problem by:
* before running
perl Makefile.PL
* edit your file
$ORACLE_HOME/rdbms/lib/env_rdbms.mk
* by changing
LIBDIR=lib to LIBDIR=lib32
*
Hello April,
my first impressions are:
1) use the ? placeholder (for security! and performance reasons):
--- source :
WHERE PartnerCode = $partnerCode
...
$sh-execute || throw util::backEndException -value = {code =
--- change to :
WHERE PartnerCode = ?
...
$sh-execute($partnerCode) || throw
- AFID 3.3 - Oracle DBA
C.A. Merz
- Original Message -
From: April Blumenstiel
To: Christian Merz
Sent: Monday, May 02, 2005 5:10 PM
Subject: Re: fetchrow_hashref stops returning data
Thank you.
This brings up something I'm unclear on when it comes to using the ?
placeholders
Hi giedrius,
the ORA-12154 is a typical error when you did not configure your
tnsnames.ora file on the remote host. Can you connect via SQL*Plus?
But i never tried interconnections of different database syseems. So
this mitht not help...
cu, Christian
[EMAIL PROTECTED] schrieb:
Hi all,
I
the statement
Has this changed since V. 1.43?
Yours,
Christian Merz
Douglas Wilson schrieb:
With DBI 1.602 and DBD::Sybase 1.08 I get:
Can't locate object method DELETE via package DBI::st
on the second selectrow_array call.
If I replace $sth with $sql in the selectrow_array calls, then it
works
Hi scoles,
i am already running DBD on all my old Oracle installations, upgrades
are not planned. Usually, i run DBD on the host where my Oracle is
installed, so no extra client is needed. For new oracle installations
(V10/V11) i will fetch a fresh DBD.
as to me, there is no more need to
Hello Dunston,
in my test script i set:
$ENV{ORACLE_SID}= ORCL;
$ENV{ORACLE_HOME} = /path/to/oracle/home;
$ENV{NLS_LANG} = AMERICAN_AMERICA.WE8DEC;
# or GERMAN_GERMANY.WE8ISO8859P15;
$ENV{ORA_NLS} = $ENV{ORACLE_HOME} .
input on resolving the above would be helpful!
Thanks
- Original Message
From: Christian Merz [EMAIL PROTECTED]
To: Dunston Rocks [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Sent: Wednesday, April 23, 2008 6:50:57 AM
Subject: Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client
.
I would greatly appreciate your help in identifying the problem, if possible!!!
Thanks much!
- Original Message
From: Christian Merz [EMAIL PROTECTED]
To: Dunston Rocks [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Sent: Thursday, April 24, 2008 3:38:12 AM
Subject: Re: OCIEnvNlsCreate error
Hello all,
i wrote a skript which works fine for several Oracle Versions on several
platforms (linux, solarias 8/9).
if i run that script ineractively on solaris 10 it also works fine.
if i run it as a cron job i get:
install_driver(Oracle) failed: Can't load
at (eval 7) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /oracle/dba/backup/ora19/DbOnline.pl line 514
Jonathan Leffler wrote:
On Wed, May 28, 2008 at 8:30 AM, Christian Merz
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote:
i wrote a skript which works
!
... But this is a workaround i do not like very much. Reexecuting the
skript might be a way (probably i will do this). Is there another
possibility?
cu, Christian
Jonathan Leffler wrote:
On Wed, May 28, 2008 at 11:47 PM, Christian Merz
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote:
i set the environment
: install_driver(Proxy) failed: Can't locate
RPC/PlClient.pm in @INC
DBD::Oracle : 1.16
Could this be a problem?
On Solaris 10 (i.e. 2.10) lots of changes took place. Especially in the
oracle installation. Did you follow the installation guide?
CU, Christian Merz
Rich White
Hi Martin,
this is not Perl stuff but Oracle PL/SQL.
Just take your 'get' procedure:
PROCEDURE get(
pdt OUT mytable.created%TYPE,
pcur OUT SYS_REFCURSOR) AS
BEGIN
pdt := utc_timestamp();
OPEN pcur FOR
SELECT DISTINCT(id) FROM mytable WHERE created =
Hi all,
the point is that before you can do a CURRVAL you _must_ have done a NEXTVAL
on any sequence in an Oracle session, as shown by Andy in the example below.
cu, Christian Merz
- Original Message -
From: Andy Hassall [EMAIL PROTECTED]
To: Tim Harsch [EMAIL PROTECTED]; [EMAIL PROTECTED
Hi,
has this problem already been solved?
a) On UNIX you may get informations on errors with the OERR function:
oerr ora 12154
12154, 0, TNS:could not resolve service name
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *Action: Make the
Hi,
the basic idea to find duplicate or multiple values is:
select id, count(*)
from table
group by id
having count(*) 1;
to delete ALL such values you may do this:
delete from table where id in
( select id
from table
group by id
having count(*)
[EMAIL PROTECTED]
09/19/2003 03:09 PM
To: Jeffrey Seger/Corporate/[EMAIL PROTECTED]
cc: Christian Merz [EMAIL PROTECTED],
[EMAIL PROTECTED],
Morrison, Trevor (Trevor) [EMAIL PROTECTED]
Subject:Re: SQL statement to find and delete double
entries
It's
Hi all,
you get
ld: fatal: file /oracle/P14/920_64/lib//libclntsh.so: wrong ELF class:
ELFCLASS64
ld: fatal: File processing errors. No output written to
blib/arch/auto/DBD/Oracle/Oracle.so
when you try to install DBD::Oracle (32bit Perl) on a 64bit Oracle.
This was discussed erlier. Our system
Hello all,
i am using a script on several Solaris servers (mostly 5.7) to connect to
Oracle DBs (Oracle 8.0.x ... 8.1.7).
but on my latest installation of that script i get an OCIInitialize error.
error message, environment and trace(1) output see below.
any suggestions? any magic tricks
Hallo,
probably you have to reistall your DBD driver with the correct perl environment.
In the beginning your trace says
- DBI-install_driver(mysql) for perl=5.008003
at the end there is
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi/DBI.pm
cu, Christian
- Original Message -
Hi Robert,
try this one:
my $sel1 = $dbh1-prepare(SELECT hostname,datetime,url,username,company FROM
processed);
$sel1-execute();
my $array_ref = $sel1-fetchall_arrayref();
$sel1-bind_columns( undef, \$hostname, \$datetime, \$url, \$username,
\$company );
foreach my $row (@$array_ref) {
my
Hi all,
my problem was quite different from Craigs (see below):
I've got a running DBI app on, say, instance ora1.
On the same host there is another instance, ora2, with a different ORACLE_HOME,
which causes the problems.
DBD::Oracle was built with ora1 environment.
I didn't find a satisfiying
Hi,
a few days ago I got a note dealing with character set problems (with German
umlauts).
(I didn't counter check the info)
In a Windows environment you have to cope with at least 4 character sets.
1. internally WinNT uses UCS-2 (2 bytes) Win2000 uses UTF16 (2 or 4 bytes)
2. graphical apps may
35 matches
Mail list logo