listener does not launch services

From: Jérôme VUIBERT <jerome.vuibert_at_fleximage.fr>
Date: Fri, 3 Oct 2003 11:43:07 +0200
Message-ID: <3f7d44a8$0$28898$626a54ce@news.free.fr>

Hi everybody,

I use an Oracle 9.2.0.1.0 on NT4SP6 for a database called PENTA. It works fine on a server (CERISIER).

Now i wanted to duplicate this database on an another server (PEUPLIER) which has exactly the same softwares.

When I start the listener on PEUPLIER, this one does not see (launch) the service of my database PENTA;

Here are the main files of the database and the output of the listener.

Can someone help me?

Thanks a lot.

Jerome

P.S: PEUPLIER is well declaredin the host file of PEUPLIER

LISTENER.ORA

# LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora # Generated by Oracle configuration tools.

STARTUP_WAIT_TIME_LISTENER = 10 LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = peuplier)(PORT = 1521))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)

    )
  )

SERVICE_LIST_LISTENER =
  (SERVICE_LIST =
    (SERVICE_DESC =
(SERVICE_NAME = PENTA)
(ORACLE_HOME = D:\orant\ora92)

    )
  )

TRACE_LEVEL_LISTENER = OFF

sqlnet.ora

AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 5
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
SQLNET.CRYPTO_SEED = "814047-17655492"

tnsname.ora

PENTA.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = peuplier)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = PENTA)

    )
  )

initPENTA.ora

db_name = "PENTA"
instance_name = PENTA
service_names = PENTA
db_files = 1024

control_files = ("E:\Databases\admin\PENTA\control\control01.ctl"
               , "E:\Databases\admin\PENTA\control\control02.ctl"
               , "E:\Databases\admin\PENTA\control\control03.ctl")

open_cursors = 300
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 3000
shared_pool_size = 176160768
java_pool_size = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 50
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240 # limit trace file size to 5M each global_names = false
oracle_trace_collection_name = ""
background_dump_dest = E:\Databases\admin\PENTA\trace\bdump user_dump_dest = E:\Databases\admin\PENTA\trace\udump db_block_size = 8192
remote_login_passwordfile = exclusive
os_authent_prefix = ""
compatible = 8.1.0
sort_area_size = 65536
sort_area_retained_size = 65536
utl_file_dir = E:\Databases\admin\PENTA\trace\debug O7_DICTIONARY_ACCESSIBILITY = TRUE
SERVICE_NAMES= PENTA
LOCAL_LISTENER="(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=peuplier)(port=15 21)))"
DISPATCHERS=
"(ADDRESS=(PARTIAL=TRUE)(PROTOCOL=TCP)(HOST=peuplier)(PORT=1528))(DISPATCHER S=1)"
DISPATCHERS=
"(ADDRESS=(PARTIAL=TRUE)(PROTOCOL=TCP)(HOST=peuplier)(PORT=1529))(DISPATCHER S=1)"
SHARED_SERVERS=2

LISTENER OUTPUT AFTER STARTING

LSNRCTL> start
Lancement de tnslsnr: Veuillez patienter...

TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production Le fichier de paramÞtres systÞme est
D:\oracle\ora92\network\admin\listener.ora Messages de journalisation Úcrits dans
D:\oracle\ora92\network\log\listener.log Ecoute sur :
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cerisier)(PORT=1521))) Ecoute sur :
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))

Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cerisier)(PORT=1521))) STATUT du MODULE D'ECOUTE

Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 -
Production
Date de dÚpart                       03-OCT-2003 11:42:03
DurÚe d'activitÚ                    0 jours 0 heures 0 min. 12 sec
Niveau de trace           off
SÚcuritÚ                  OFF
SNMP                      OFF

Fichier de paramÞtres du module d'Úcoute (listener) D:\oracle\ora92\network\admin\listener.ora Fichier journal du module d'Úcoute (listener) D:\oracle\ora92\network\log\listener.log RÚcapitilatif d'Úcoute des points d'extrÚmitÚ... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cerisier)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) RÚcapitulatif services...
Le service "PLSExtProc" comporte 1 instance(s). L'instance "PLSExtProc", statut UNKNOWN, comporte 1 gestionnaire(s) pour ce service...
La commande a rÚussi
LSNRCTL> Received on Fri Oct 03 2003 - 04:43:07 CDT