| Unable to connect DB through Perl [message #414187] |
Mon, 20 July 2009 16:06  |
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 #414345 is a reply to message #414189] |
Tue, 21 July 2009 13:06  |
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 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
