----- Original Message -----
From: "Byron Wise" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 12, 2001 5:44 AM
Subject: Trouble connecting to Oracle!
> I need help!! I'm running Personal Oracle8i and
> ActiveState's perl on the same win98 machine. All I'm
> trying to do is make a connection. If anyone would
> please help me do this I'd appreciate it.
>
[...]
> my $dbh = DBI->connect('DBI:Oracle:MyDB2', $username,
> $passwd, {RaiseError => 1, AutoCommit => 0}) || die
> "Unable create database handle: $!\n";
>
> Error(STDERR):
>
> C:\WINDOWS\Desktop>perl oracle.pl
> DBI 1.14-nothread dispatch trace level set to 1
> -> DBI->connect(DBI:Oracle:MyDB2, SYS, ****,
> HASH(0x176f13c))
> -> DBI->install_driver(Oracle) for perl=5.006001
> pid=1782017 ruid=0 euid=0
> install_driver: DBD::Oracle loaded (version
> 1.06)
> <- install_driver= DBI::dr=HASH(0x1809518)
> !! ERROR: 12541 'ORA-12541: TNS:no listener (DBD
> ERROR: OCIServerAttach)'
> <- connect= undef at DBI.pm line 408.
> <- errstr= 'ORA-12541: TNS:no listener (DBD ERROR:
I think here is your error. You dont have a Oracle listener running on your
PC.
Either start the oracle listener (using lsnrctl) or dont connect trough sql
net.
See the DBD::Oracle documentation for examples using a local connection.
Maarten.
