(none)" <""tof\"@(none)"> wrote in message
news:421ef015$0$3119$8fcfb975_at_news.wanadoo.fr...
> Hi,
>
> I think i have a problem with network, but how i can find this. This this
> the question.
>
> Environnement : Linux Slackware 10, Oracle 10G
>
> Explanation :
>
> I create a database, with listener and tnsname.
> When i use the port 1521, all run. But when i run on 1523 for sample, it
> don't run.
> No services is active !!! Why ???
>
> Listener.ora
> oracle_at_future:/oracle/product/10.1.0/network/admin$ cat listener.ora
> # listener.ora Network Configuration File:
> /oracle/product/10.1.0/network/admin/listener.ora
> # Generated by Oracle configuration tools.
>
> TRACE_FILE_LISTENER = listener.trc
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /oracle/product/10.1.0)
> (PROGRAM = extproc)
> )
> )
>
> TRACE_DIRECTORY_LISTENER =
> /oracle/product/10.1.0/network/trace/oracle/product/10.1.0/network/trace
>
> LISTENER =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = future)(PORT = 1521))
> )
>
> TRACE_LEVEL_LISTENER = USER
>
> oracle_at_future:/oracle/product/10.1.0/network/admin$ cat tnsnames.ora
> # tnsnames.ora Network Configuration File:
> /oracle/product/10.1.0/network/admin/tnsnames.ora
> # Generated by Oracle configuration tools.
>
> CATRMAN =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = future)(PORT = 1521))
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = CATRMAN)
> )
> )
>
> DBT =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = future)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = DBT)
> )
> )
>
> oracle_at_future:/oracle/product/10.1.0/network/admin$ tnsping DBT
>
> TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005
> 10:46:01
>
> Copyright (c) 1997, 2003, Oracle. All rights reserved.
>
> Used parameter files:
> /oracle/product/10.1.0/network/admin/sqlnet.ora
>
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL
> = TCP)(HOST = future)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME =
> DBT)))
> OK (20 msec)
> oracle_at_future:/oracle/product/10.1.0/network/admin$ lsnrctl status
>
> LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005 10:46:24
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=future)(PORT=1521)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 10.1.0.2.0 -
> Production
> Start Date 24-FEB-2005 22:19:18
> Uptime 0 days 12 hr. 27 min. 6 sec
> Trace Level user
> Security ON: Local OS Authentication
> SNMP OFF
> Listener Parameter File
> /oracle/product/10.1.0/network/admin/listener.ora
> Listener Log File /oracle/product/10.1.0/network/log/listener.log
> Listener Trace File
> /oracle/product/10.1.0/network/trace/oracle/product/10.1.0/network/trace/listener.trc
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=future.linux.org)(PORT=1521)))
> Services Summary...
> Service "CATRMAN" has 1 instance(s).
> Instance "CATRMAN", status READY, has 2 handler(s) for this service...
> Service "DBT" has 1 instance(s).
> Instance "DBT", status READY, has 1 handler(s) for this service...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> The command completed successfully
> oracle_at_future:/oracle/product/10.1.0/network/admin$
>
> ALL IS OK
>
> Now, i change port on 1524 for example
> oracle_at_future:/oracle/product/10.1.0/network/admin$ lsnrctl
>
> LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005 10:47:15
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> Welcome to LSNRCTL, type "help" for information.
>
> LSNRCTL> stop
> Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=future)(PORT=1521)))
> The command completed successfully
> LSNRCTL> exit
>
> Listener.ora
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = future)(PORT = 1524))
>
> Tnsnanes.ora
> for DBT and CATRMAN
> (ADDRESS = (PROTOCOL = TCP)(HOST = future)(PORT = 1524))
>
>
>
> oracle_at_future:/oracle/product/10.1.0/network/admin$ lsnrctl start
>
> LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005 10:48:57
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> Starting /oracle/product/10.1.0/bin/tnslsnr: please wait...
>
> TNSLSNR for Linux: Version 10.1.0.2.0 - Production
> System parameter file is /oracle/product/10.1.0/network/admin/listener.ora
> Log messages written to /oracle/product/10.1.0/network/log/listener.log
> Trace information written to
> /oracle/product/10.1.0/network/trace/oracle/product/10.1.0/network/trace/listener.trc
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=future.linux.org)(PORT=1524)))
>
> Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=future)(PORT=1524)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 10.1.0.2.0 -
> Production
> Start Date 25-FEB-2005 10:48:57
> Uptime 0 days 0 hr. 0 min. 0 sec
> Trace Level user
> Security ON: Local OS Authentication
> SNMP OFF
> Listener Parameter File
> /oracle/product/10.1.0/network/admin/listener.ora
> Listener Log File /oracle/product/10.1.0/network/log/listener.log
> Listener Trace File
> /oracle/product/10.1.0/network/trace/oracle/product/10.1.0/network/trace/listener.trc
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=future.linux.org)(PORT=1524)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> The command completed successfully
> oracle_at_future:/oracle/product/10.1.0/network/admin$ lsnrctl services
>
> LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005 10:49:17
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=future)(PORT=1524)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> Handler(s):
> "DEDICATED" established:0 refused:0
> LOCAL SERVER
> The command completed successfully
> oracle_at_future:/oracle/product/10.1.0/network/admin$
>
> There is no services!
> I try to shutdown and startup my database
>
>
>
> SQL> startup
> ORACLE instance started.
>
> Total System Global Area 100663296 bytes
> Fixed Size 777616 bytes
> Variable Size 95429232 bytes
> Database Buffers 4194304 bytes
> Redo Buffers 262144 bytes
> Database mounted.
> Database opened.
> SQL> exit
> Disconnected from Oracle Database 10g Enterprise Edition Release
> 10.1.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
> oracle_at_future:/oracle/product/10.1.0/network/admin$ lsnrctl services
>
> LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005 10:51:55
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=future)(PORT=1524)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> Handler(s):
> "DEDICATED" established:0 refused:0
> LOCAL SERVER
> The command completed successfully
> oracle_at_future:/oracle/product/10.1.0/network/admin$ lsnrctl reload
>
> LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005 10:52:14
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=future)(PORT=1524)))
> The command completed successfully
> oracle_at_future:/oracle/product/10.1.0/network/admin$ lsnrctl status
>
> LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005 10:52:18
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=future)(PORT=1524)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 10.1.0.2.0 -
> Production
> Start Date 25-FEB-2005 10:48:57
> Uptime 0 days 0 hr. 3 min. 21 sec
> Trace Level user
> Security ON: Local OS Authentication
> SNMP OFF
> Listener Parameter File
> /oracle/product/10.1.0/network/admin/listener.ora
> Listener Log File /oracle/product/10.1.0/network/log/listener.log
> Listener Trace File
> /oracle/product/10.1.0/network/trace/oracle/product/10.1.0/network/trace/listener.trc
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=future.linux.org)(PORT=1524)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> The command completed successfully
> oracle_at_future:/oracle/product/10.1.0/network/admin$ lsnrctl services
>
> LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 25-FEB-2005 10:52:23
>
> Copyright (c) 1991, 2004, Oracle. All rights reserved.
>
> Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=future)(PORT=1524)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> Handler(s):
> "DEDICATED" established:0 refused:0
> LOCAL SERVER
> The command completed successfully
> oracle_at_future:/oracle/product/10.1.0/network/admin$
>
>
> Always NO servies, but why !!!
> And if i take port on 1521, all run !
>
> How to find this problem ?
>
> Thanks,
> Christophe
>
Check out the Database Parameter local_listener. You can download the docs
from oracle. The deal is there is an Oracle process called PMON. It will by
default look for port 1521 to register with. If it finds a listener running
on 1521 it registers and you have a service. However if you are not using
1521 you must tell PMON where to register. The parameter local_listerner is
telling PMON where the port to register at is.
Received on Fri Feb 25 2005 - 06:15:41 CST
