"Jérôme VUIBERT" <jerome.vuibert_at_fleximage.fr> wrote in message news:<3f7d44a8$0$28898$626a54ce_at_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>
The database needs to register itself with the listener.
This will take a while
Sybrand Bakker
Senior Oracle DBA
Received on Fri Oct 03 2003 - 07:33:36 CDT
