In the past personal oracle didn't come with a listener, hence "personal".
I'm not sure if that's the case anymore. If so, you can download for free
at technet.oracle.com
----- Original Message -----
From: "M.W. Koskamp" <[EMAIL PROTECTED]>
To: "Byron Wise" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 12, 2001 5:17 AM
Subject: Re: Trouble connecting to Oracle!
>
> ----- 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.
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
