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


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)

Reply via email to