Home » Open Source » Programming Interfaces » Unable to connect DB through Perl (Oracle 10g on Windows 64bit)
Unable to connect DB through Perl [message #414187] Mon, 20 July 2009 16:06 Go to next message
kishore_001
Messages: 2
Registered: July 2009
Junior Member
I am trying to connect Oracle DB through Perl using below script. It is not connecting. I would appreciate if there is anything else I can check in the environment to make it work.

#!C:\perl\bin\perl.exe

#print "Enter Opera Database Server IP Address - 10.xxx.xxx.2\n";

#chop ($ipad = <>);

use DBI;

# define local variables

my($dbh, $db, $user, $passwd);

$db="host=localhost;SID=orcl;port=1521";

$user="scott";

$passwd="tiger";

print (" Connecting with out any parameters");

my $dbh1 = DBI->connect( "dbi:Oracle:orcl", "scott", "tiger" )
or die "Can't connect to 1st Oracle database: $DBI::errstr . \n";
Re: Unable to connect DB through Perl [message #414189 is a reply to message #414187] Mon, 20 July 2009 17:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
remove the last line (or die ....) & run again. What error?

I need some diagnostic information.

lsnrctl start
lsnrctl status
sqlplus
/ as sysdba
startup
select * from v$version;
exit
tail -20 $ORACLE_HOME/network/log/listener.log

Log onto the OS as the user which owns Oracle s/w tree. CUT the lines above & PASTE into a command window.

CUT the commands & results from command window & PASTE back here
Re: Unable to connect DB through Perl [message #414345 is a reply to message #414189] Tue, 21 July 2009 13:06 Go to previous messageGo to next message
kishore_001
Messages: 2
Registered: July 2009
Junior Member
Below is the detailed error message:
Error while trying to retrieve text for error ORA-01019 (DBD: login failed, probably a symptom of a deeper problem)

As this is a Production system- we can not stop and start the database..

But I have re-started listener and below is the lines from listener.log..

22-JUL-2009 00:00:05 * service_update * orcl * 0

22-JUL-2009 00:00:08 * service_update * orcl * 0

22-JUL-2009 00:03:18 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.x)(PORT=1825)) * establish * orcl * 0

22-JUL-2009 00:03:27 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\oracle\10gappr2\bin\frmweb.exe)(HOST=appserver)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.x)(PORT=1830)) * establish * orcl * 0

22-JUL-2009 00:03:29 * service_update * orcl * 0

22-JUL-2009 00:04:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SID=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.x)(PORT=1845)) * establish * orcl * 0

22-JUL-2009 00:04:09 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SID=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.x)(PORT=1846)) * establish * orcl * 0

22-JUL-2009 00:04:10 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SID=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.x)(PORT=1847)) * establish * orcl * 0

22-JUL-2009 00:05:08 * service_update * orcl * 0

22-JUL-2009 00:07:41 * service_update * orcl * 0

22-JUL-2009 00:11:39 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SID=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.x)(PORT=1944)) * establish * orcl * 0

22-JUL-2009 00:12:53 * service_update * orcl * 0

22-JUL-2009 00:14:33 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=scott))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870080)) * status * 0

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\orclipc)))

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver.domain.com)(PORT=1521)))

Listener completed notification to CRS on stop

22-JUL-2009 00:14:41 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=scott))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870080)) * stop * 0


TNSLSNR for 64-bit Windows: Version 10.2.0.3.0 - Production on 22-JUL-2009 00:14:50


Copyright (c) 1991, 2006, Oracle. All rights reserved.


System parameter file is D:\\oracle\1020\network\admin\listener.ora

Log messages written to D:\oracle\1020\network\log\listener.log

Trace information written to D:\oracle\1020\network\trace\listener.trc

Trace level is currently 0


Started with pid=6548

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\orclipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver.domain.com)(PORT=1521)))

Listener completed notification to CRS on start


TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

22-JUL-2009 00:14:56 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=scott))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870080)) * status * 0

22-JUL-2009 00:15:31 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\oracle\10gappr2\jdk\jre\bin\javaw.exe)(HOST=appserver)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.x)(PORT=2010)) * establish * orcl * 0

22-JUL-2009 00:15:44 * service_register * orcl * 0

22-JUL-2009 00:16:03 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\oracle\10gappr2\jdk\jre\bin\javaw.exe)(HOST=appserver)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.x)(PORT=2022)) * establish * orcl * 0

22-JUL-2009 00:16:13 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=D:\oracle\10gappr2\jdk\jre\bin\javaw.exe)(HOST=appserver)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xxx.xxx.x)(PORT=2032)) * establish * orcl * 0

22-JUL-2009 00:16:14 * service_update * orcl * 0
Re: Unable to connect DB through Perl [message #414354 is a reply to message #414345] Tue, 21 July 2009 13:44 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01019: unable to allocate memory in the user side
 *Cause: The user side memory allocator returned error.
 *Action: Increase the processes heap size or switch to the old set of calls.

Regards
Michel
Previous Topic: -2147467259 : Data type is not supported
Next Topic: how do i call oracle stored procedure by using oledb.net
Goto Forum:
  


Current Time: Thu Mar 28 10:26:02 CDT 2024