Re: configure listener.ora and tnsnames.ora
From: ddf <oratune_at_msn.com>
Date: Thu, 6 Aug 2009 05:15:55 -0700 (PDT)
Message-ID: <db55692e-cacc-4032-90fc-aaf5f029fc05_at_d4g2000yqa.googlegroups.com>
On Aug 6, 2:44 am, ilbmbo <ilbi..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
)
)
)
Date: Thu, 6 Aug 2009 05:15:55 -0700 (PDT)
Message-ID: <db55692e-cacc-4032-90fc-aaf5f029fc05_at_d4g2000yqa.googlegroups.com>
On Aug 6, 2:44 am, ilbmbo <ilbi..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
You must define the LISTENER before you can define the SID_LIST_LISTENER so reverse thos entries in your listener.ora:
LISTENER =
(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = linux-gle.Id)(PORT = 1521)))
)
SID_LIST_LISTENER =
(SID_LIST = (SID_DESC = (SID_NAME = AFTIDI) (ORACLE_HOME = /opt/oracle/product/10.2/db_1) (PROGRAM = extproc)
)
)
David Fitzjarrell Received on Thu Aug 06 2009 - 07:15:55 CDT