Re: configure listener.ora and tnsnames.ora
Date: Thu, 6 Aug 2009 00:44:08 -0700 (PDT)
Message-ID: <c1d8c36c-b33f-451a-8079-50e8e4aca8bc_at_k30g2000yqf.googlegroups.com>
On 5 Ago, 18:23, ddf <orat..._at_msn.com> wrote:
> On Aug 5, 10:57 am, ilbmbo <ilbi..._at_gmail.com> wrote:
>
>
>
> > On 5 Ago, 17:37, usenet2..._at_zacek.de (Viktor Zacek) wrote:
>
> > > ilbmbo <ilbi..._at_gmail.com> wrote:
> > > > in my software in visual C++ use:
> > > > String^ connectionString = gcnew String ("Data Source=(DESCRIPTION=
> > > > (ADDRESS=(PROTOCOL=TCP)(HOST= linux-gle)(PORT=1521))(CONNECT_DATA=
> > > > (SERVICE_NAME=AFTIDI)));User Id=XXXXXXXX;Password=XXXXXX");
> > > > System::Data::OracleClient::OracleConnection^ conn = gcnew
> > > > System::Data::OracleClient::OracleConnection(connectionString);
> > > > conn->Open();
>
> > > > so in this mode i can connect but sometimes i have error in
> > > > TNS:listener
>
> > > Interesting...
>
> > > I would do the following during development (you have to talk with your
> > > DBA about corresponding steps):
>
> > > - shutdown the database
> > > - delete all logfiles on server and client
> > > - sync time between client and server (or just note the difference)
> > > - start the database
> > > - use program only to test the connect (simply a loop which connects
> > > every 10 seconds, and disconnects, print time if connect not successful)
> > > - check logfiles on server (esp. listener and alert log and client (esp.
> > > sqlnet.log) at printed times for errors
>
> > > I only delete the logfiles for pure lazyness... its easier to search in
> > > nearly empty logfiles ;-)
>
> > > Best regards,
with this listener.ora i can't start the listener from OEM:
# listener.ora Network Configuration File: /opt/oracle/product/10.2/
db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST = (SID_DESC = (SID_NAME = AFTIDI) (ORACLE_HOME = /opt/oracle/product/10.2/db_1) (PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = linux-gle.Id)(PORT = 1521)))
)
if i type this command :
oracle_at_linux-gle:/> lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-AUG-2009 09:34:00
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /opt/oracle/product/10.2/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2/db_1/network/admin/
listener.or
a
Log messages written to /opt/oracle/product/10.2/db_1/network/log/
listener.log
TNS-01150: The address of the specified listener name is incorrect
Listener failed to start. See the error message(s) above...
- if i use a listener.ora empty i have:
oracle_at_linux-gle:/> lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-AUG-2009 09:39:05
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /opt/oracle/product/10.2/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /opt/oracle/product/10.2/db_1/network/admin/
listener.or a
Log messages written to /opt/oracle/product/10.2/db_1/network/log/ listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-gle.Id)
(PORT=1521) ))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 06-AUG-2009 09:39:05 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /opt/oracle/product/10.2/db_1/network/admin/ listener.o ra Listener Log File /opt/oracle/product/10.2/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-gle.Id)(PORT=1521))) The listener supports no services
The command completed successfully
oracle_at_linux-gle:/> lsnrctl stop
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-AUG-2009 09:40:07
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) The command completed successfully
but when i use EOM to start database and when i try to connect at Db with my Visual c++ software I have the problem that i have write yesterday.....
and my sqlnet.ora is:
# sqlnet.ora Network Configuration File: /opt/oracle/product/10.2/db_1/
network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) thanks a lot!!!
> > > Viktor
>
> > now i can't do this, because my DBA is on holiday....
>
> > but for me the problem is in listener.ora in server because is empty
> > and if i try to configure it the listener don't work when i start it!- Hide quoted text -
>
> > - Show quoted text -
>
> How are you trying 'to configure it the listener'? Show us your
> listener.ora file after you've modified it to 'configure' the listener
> so we can see if you have any syntax errors.
>
> David Fitzjarrell
Received on Thu Aug 06 2009 - 02:44:08 CDT