[EMAIL PROTECTED] [[EMAIL PROTECTED]] wrote:
>
> The listener is running, sqlplus is working...
> Some days ago I moved our sqlnet.ora to sqlnet.ora.old, stopped the
> listener and restarted the listener. No success. the same error.
>
> backgrund:
> december 2001 - dbi worked and NO sqlnet.ora was located in
>$ORACLE_HOME/network/admin
>
> 02.01. - a sqlnet.ora was created
>
> 05.01. - we discovered that dbi does not work
>
How about listener.ora and tnsnames.ora - verify those as well.
Hardy
>
> Hardy Merrill writes:
> > See below.
> >
> > [EMAIL PROTECTED] [[EMAIL PROTECTED]] wrote:
> > > I want connect to a oracle database with a connect string in the form:
> > >
> > > dbi:Oracle:host=my_host;sid=my_sid;port=1521
> > >
> > > This failes with a the real hostname, but it works with IP-address of
> > > the
> > > host.
> > > Curious enough, a nslookup for this machine works too!
> > > There is a entry in /etc/hosts for this machine.
> > >
> > > I can also connect to this database from another host with exact the
> > > same
> > > kind of connect string. In this case the connect works with both,
> > > the real name and IP address.
> > > I think it is a DNS problem, but why the nslookup work?
> > >
> > > I attach a debug session:
> > >
> > > Name "main::ORACLE_HOME" used only once: possible typo at test_dbi.pl
> > > line 4.
> > > main::(test_dbi.pl:4): $ORACLE_HOME='/opt/oracle/product/8.1.7';
> > > DB<1> n
> > > main::(test_dbi.pl:7): my $dbh =
> > > DBI->connect('dbi:Oracle:host=my_host;sid=my_sid;port=1521',"nutzer","pw")
> > > DB<1> n
> > > DBI->connect(host=my_host;sid=my_sid;port=1521) failed: ORA-12541:
> > > TNS:no listener (DBD ERROR: OCIServerAttach) at test_dbi.pl line 7
> > ^^^^^^^^^^^^^^^
> > Did you make sure the Oracle Listener is up and running? If it
> > is up and running, verify your SQLnet settings(tnsnames?).
> >
> > --
> > Hardy Merrill
> > Mission Critical Linux, Inc.
> > http://www.missioncriticallinux.com
> >
> > > Carp::carp('DBI->connect(host=my_host;sid=my_sid;port=1521)
> > > failed: ORA-12541: T...') called at /opt/perl5/lib/site_perl/DBI.pm
> > > line 412
> > > DBI::connect('DBI',
> > > 'dbi:Oracle:host=my_host;sid=my_sid;port=1521', 'nutzer', 'pw') called
> > > at test_dbi.pl line 7
> > > Can't connect to 1st Oracle database: ORA-12541: TNS:no listener (DBD
> > > ERROR: OCIServerAttach)
> > >
> > > every help appreciate
> > > thomas
> > >
> > > --
> > > PALOMA-system is a treasure, hanger or large item and stored in the wrong area
>(Loc. 1/K/99/91/1)
>
> --
> PALOMA-system is a treasure, hanger or large item and stored in the wrong area (Loc.
>1/K/99/91/1)