Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Listener NO services

Listener NO services

From: <_at_(none)>
Date: Fri, 25 Feb 2005 10:22:47 +0100
Message-ID: <421ef015$0$3119$8fcfb975@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
Received on Fri Feb 25 2005 - 03:22:47 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US