1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138
| TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-DÉC. -2007 18:07:06
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Le fichier de paramètres système est C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
Messages de journalisation écrits dans C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
Informations d'analyse écrites dans C:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc
Le niveau d'analyse actuel est 0
Démarré avec pid=424
Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ark3383.dickson-constant.com)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
14-DÉC. -2007 07:34:07 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Program Files\AppDis\dickson\Inspection.Exe)(HOST=ARK3383)(USER=Administrateur))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.2.77.5)(PORT=1429)) * establish * XE * 12514
TNS-12514: TNS : le processus d'écoute ne connaît pas actuellement le service indiqué dans le descripteur de connexion
14-DÉC. -2007 07:34:09 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\Program Files\AppDis\dickson\Inspection.Exe)(HOST=ARK3383)(USER=Administrateur))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.2.77.5)(PORT=1430)) * establish * XE * 12514
TNS-12514: TNS : le processus d'écoute ne connaît pas actuellement le service indiqué dans le descripteur de connexion
Ci-joint le contenu du fichier "alert_xe.log" :
------------------------------------------
Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
Fri Dec 14 07:35:30 2007
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 2
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:761M/990M, Ph+PgF:2255M/2387M, VA:1944M/2047M
Fri Dec 14 07:35:30 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
__shared_pool_size = 79691776
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
nls_length_semantics = CHAR
sga_target = 251658240
control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
__db_cache_size = 159383552
compatible = 10.2.0.1.0
db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 83886080
PMON started with pid=2, OS id=780
PSP0 started with pid=3, OS id=784
MMAN started with pid=4, OS id=800
DBW0 started with pid=5, OS id=812
LGWR started with pid=6, OS id=824
CKPT started with pid=7, OS id=836
SMON started with pid=8, OS id=852
RECO started with pid=9, OS id=500
CJQ0 started with pid=10, OS id=896
MMON started with pid=11, OS id=908
MMNL started with pid=12, OS id=904
Fri Dec 14 07:35:31 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 4 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Fri Dec 14 07:35:32 2007
alter database mount exclusive
Fri Dec 14 07:35:37 2007
Setting recovery target incarnation to 2
Fri Dec 14 07:35:37 2007
Successful mount of redo thread 1, with mount id 2522421636
Fri Dec 14 07:35:37 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Fri Dec 14 07:35:37 2007
alter database open
Fri Dec 14 07:35:38 2007
Beginning crash recovery of 1 threads
Fri Dec 14 07:35:38 2007
Started redo scan
Fri Dec 14 07:35:39 2007
Completed redo scan
108 redo blocks read, 57 data blocks need recovery
Fri Dec 14 07:35:39 2007
Started redo application at
Thread 1: logseq 61, block 3
Fri Dec 14 07:35:39 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 61 Reading mem 0
Mem# 0 errs 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_3NRBTGF5_.LOG
Fri Dec 14 07:35:40 2007
Completed redo application
Fri Dec 14 07:35:40 2007
Completed crash recovery at
Thread 1: logseq 61, block 111, scn 1585729
57 data blocks read, 57 data blocks written, 108 redo blocks read
Fri Dec 14 07:35:41 2007
Thread 1 advanced to log sequence 62
Thread 1 opened at log sequence 62
Current log# 1 seq# 62 mem# 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3NRBTCC7_.LOG
Successful open of redo thread 1
Fri Dec 14 07:35:41 2007
SMON: enabling cache recovery
Fri Dec 14 07:35:45 2007
Successfully onlined Undo Tablespace 1.
Fri Dec 14 07:35:45 2007
SMON: enabling tx recovery
Fri Dec 14 07:35:45 2007
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=1540
Fri Dec 14 07:35:58 2007
Completed: alter database open
Fri Dec 14 07:36:02 2007
db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup. |
Partager