Le processus Oracle.exe ne veu plus se lancer au démarrage ?

**belokan** · 25/10/2005, 11h49

Bonjour tout le monde,

J'ai installé l'autre jour Oracle 10g et tout marchait nikel ... jusqu'à hier soir ! En effet, je venais de redémarrer et je m'apprétais à aller dans iSQL plus : je me log .... et bam, un message d'erreur de ce type :

ERROR - ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist

Je regarde dans le gestionnaire des tâches et je découvre que le processus oracle.exe est en route mais ne consomme que 12Mo au lieu des 120Mo habituels (c'est d'ailleurs pour cette raison que j'avis tant de ram dispo

).

Je me dis qu'en rebootant, ça ira mieux .... et ce matin, même problème !
Que se passe-t-il ?

Merci d'avance pour votre aide ....

**bouyao** · 25/10/2005, 11h59

1. Supprimer le service avec

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

c:\> oradim -delete -sid <sid_name>

2. Vérifier que la statu du service est DISABLED sinon rebooter la machine

3. Créer le service

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

c:\> oradim -new -sid <sid> -startmode auto -pfile <le fichier init.ora avec chemin complet>

**belokan** · 25/10/2005, 12h45

J'ai essayé ta méthode bouyao et le processus oracle.exe est bien reparti ... mais avec toujours une charge de seulement 12Mo. Et je me retrouve avec le même message d'errur lors de la connection à iSQL plus !

**bouyao** · 25/10/2005, 13h04

Tu peut coller ici le fichier init.ora ?

**Jaouad** · 25/10/2005, 13h07

et également le fichier trace de la base ?

**belokan** · 25/10/2005, 13h16

Envoyé par bouyao

Tu peut coller ici le fichier init.ora ?

Voici le fichier init.ora :

#
# $Header: init.ora 25-jul-01.18:03:38 rajayar Exp $
#
# Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved. */
#
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you customize
# your RDBMS installation for your site. Important system parameters
# are discussed, and example settings given.
#
# Some parameter settings are generic to any size installation.
# For parameters that require different values in different size
# installations, three scenarios have been provided: SMALL, MEDIUM
# and LARGE. Any parameter that needs to be tuned according to
# installation size will have three settings, each one commented
# according to installation size.
#
# Use the following table to approximate the SGA size needed for the
# three scenarious provided in this file:
#
# -------Installation/Database Size------
# SMALL MEDIUM LARGE
# Block 2K 4500K 6800K 17000K
# Size 4K 5500K 8800K 21000K
#
# To set up a database that multiple instances will be using, use the
# same file for all instance. Place all instance-specific parameters
# at the end of the file using the <sid>.<parameter_name> = <value> syntax.
# This way, when you change a public
# parameter, it will automatically change on all instances. This is
# necessary, since all instances must run with the same value for many
# parameters. For example, if you choose to use private rollback segments,
# these must be specified differently for each instance, but since all gc_*
# parameters must be the same on all instances, they should be in one file.
#
# INSTRUCTIONS: Edit this file and the other INIT files it calls for
# your site, either by using the values provided here or by providing
# your own.
###############################################################################

# replace "clustdb" with your database name
db_name = clustdb
compatible=9.0.0

db_files = 1024 # INITIAL
#INITIAL
#db_files=80
#SMALL
#DB_files=400
#MEDIUM
#db_files=1000
#LARGE

control_files = ("\\.\clustdb_control1", "\\.\clustdb_control2")

db_file_multiblock_read_count = 8 # INITIAL

# db_file_multiblock_read_count = 8
#SMALL
#db_file_multiblock_read_count = 16
#MEDIUM
#db_file_multiblock_read_count = 32
#LARGE

#Datawarehouse
db_block_size=8192
# Transaction processing
# db_block_size=4096

open_cursors=300

#Transaction processing
#sort_area_size=524288
#Datawarehouse
sort_area_size=1048576
large_pool_size=1048576 #Transaction processing, Datawarehouse
db_cache_size=50331648 #Datawarehouse, Transaction processing
java_pool_size=67108864 #Datawarehouse, Transaction processing

# db_block_buffers = 200 # INITIAL
# db_block_buffers=100 #SMALL
# db_block_buffers =550 # MEDIUM
# db_block_buffers=3200 #LARGE

#shared_pool_size = 52428800 # INITIAL
shared_pool_size = 67108864 # datewarehouse, transaction processing

log_checkpoint_interval = 10000

processes = 59 # INITIAL

# processes = 50
#SMALL
#processes = 100
#MEDIUM
#processes = 200
#LARGE

parallel_max_servers = 5
#SMALL
# parallel_max_servers = 4 x (number of CPUs)
#MEDIUM
# parallel_max_servers = 4 x (number of CPUs)
# LARGE

log_buffer = 8192 # INITIAL
#log_buffer = 8192
#SMALL
#log_buffer = 32768
#MEDIUM
#log_buffer = 163840
#LARGE

# audit_trail = true # if you want auditing
# timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 10 K each

# Uncommenting the line below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest = %ORACLE_HOME%/admin/clustdb/arch
# log_archive_format = "%%ORACLE_SID%%T%TS%S.ARC"

# If using private rollback segments, place lines of the following
# form at the end of this file:
# <sid>.rollback_segments = (name1, name2)

# If using public rollback segments, define how many
# rollback segments each instance will pick up, using the formula
# # of rollback segments = transactions / transactions_per_rollback_segment
# In this example each instance will grab 40/10 = 4:
# transactions = 40
# transactions_per_rollback_segment = 10

# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = TRUE

# Edit and uncomment the following line to provide the suffix that will be
# appended to the db_name parameter (separated with a dot) and stored as the
# global database name when a database is created. If your site uses
# Internet Domain names for e-mail, then the part of your e-mail address after
# the '@' is a good candidate for this parameter value.

# db_domain = us.acme.com # global database name is db_name.db_domain

# Uncomment the following line if you wish to enable the Oracle Trace product
# to trace server activity. This enables scheduling of server collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as enabling you
# to schedule future collections from the console.

# oracle_trace_enable = TRUE

# define directories to store trace and alert files
background_dump_dest=%ORACLE_HOME%/admin/clustdb/bdump
user_dump_dest=%ORACLE_HOME%/admin/clustdb/

db_block_size = 4096

remote_login_passwordfile = exclusive

# text_enable = TRUE

# The following parameters are needed for the Advanced Replication Option

job_queue_processes = 2
# job_queue_processes = 4 #datawarehouse

# job_queue_interval = 10
# job_queue_keep_connections = false

distributed_transactions = 5

open_links = 4

# The following parameters are instance-specific parameters that are
# specified for two instances named clustdb1 and clustdb2

undo_management=AUTO # For automatic undo management
# = MANUAL For manual/RBS undo management
cluster_database= true
cluster_database_instances=2
remote_listener=LISTENERS_CLUSTDB

# First instance specific parameters
clustdb1.thread=1
clustdb1.instance_name=clustdb1
clustdb1.instance_number=1
clustdb1.local_listener=listener_clustdb1
clustdb1.remote_login_passwordfile = exclusive
# Comment out clustdb1.undo_tablespace and uncomment clustdb1.rollback_segments
# when undo_management=MANUAL
clustdb1.undo_tablespace = UNDOTBS1
# clustdb1.rollback_segments = (rbs1_1,rbs1_2)

# Second instance specific parameters

clustdb2.thread=2
clustdb2.instance_name = clustdb2
clustdb2.instance_number = 2
clustdb2.local_listener = listener_clustdb2
clustdb2.remote_login_passwordfile = exclusive
# Comment out clustdb2.undo_tablespace and uncomment clustdb2.rollback_segments
# when undo_management=MANUAL
clustdb2.undo_tablespace = UNDOTBS2
# clustdb2.rollback_segments = (rbs2_1,rbs2_2)

**belokan** · 25/10/2005, 13h17

Envoyé par Jaouad

et également le fichier trace de la base ?

Hum ... je trouve ça où ?

**Jaouad** · 25/10/2005, 13h20

background_dump_dest=%ORACLE_HOME%/admin/clustdb/bdump

**belokan** · 25/10/2005, 13h25

En effet, dans ce répertoire j'ai plusieurs fichier .trc, tu veux lequel ?

**bouyao** · 25/10/2005, 13h28

Le fichier qui contient le mot Alert

**belokan** · 25/10/2005, 13h30

Envoyé par bouyao

Le fichier qui contient le mot Alert

Je l'ai trouvé ... mais il est énorme ....

Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Sat Oct 22 18:56:58 2005
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:231M/510M, Ph+PgF:991M/1505M, VA:1941M/2047M
Sat Oct 22 18:56:58 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
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 =18
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:
processes = 150
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=2916
PSP0 started with pid=3, OS id=3820
MMAN started with pid=4, OS id=3180
DBW0 started with pid=5, OS id=4004
LGWR started with pid=6, OS id=296
CKPT started with pid=7, OS id=3452
SMON started with pid=8, OS id=3456
RECO started with pid=9, OS id=3716
CJQ0 started with pid=10, OS id=3272
MMON started with pid=11, OS id=1224
MMNL started with pid=12, OS id=532
Sat Oct 22 18:57:04 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Oct 22 18:57:09 2005
The input backup piece C:\ORACLE\PRODUCT\10.2.0\DB_1\ASSISTANTS\DBCA\TEMPLATES\SEED_DATABASE.DFB is in compressed format.
Full restore complete of datafile 4 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF. Elapsed time: 0:00:01
checkpoint is 534906
Full restore complete of datafile 2 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF. Elapsed time: 0:00:08
checkpoint is 534906
Sat Oct 22 18:57:47 2005
Full restore complete of datafile 3 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF. Elapsed time: 0:00:38
checkpoint is 534906
Sat Oct 22 18:58:12 2005
Full restore complete of datafile 1 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF. Elapsed time: 0:01:03
checkpoint is 534906
Sat Oct 22 18:58:12 2005
Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\orcl\redo01.log') SIZE 51200K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\orcl\redo02.log') SIZE 51200K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\orcl\redo03.log') SIZE 51200K RESETLOGS
Sat Oct 22 18:58:12 2005
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Sat Oct 22 18:58:15 2005
Successful mount of redo thread 1, with mount id 1100152645
Sat Oct 22 18:58:15 2005
Completed: Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\orcl\redo01.log') SIZE 51200K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\orcl\redo02.log') SIZE 51200K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\orcl\redo03.log') SIZE 51200K RESETLOGS
Shutting down instance: further logons disabled
Sat Oct 22 18:58:16 2005
Stopping background process CJQ0
Sat Oct 22 18:58:16 2005
Stopping background process MMNL
Sat Oct 22 18:58:17 2005
Stopping background process MMON
Sat Oct 22 18:58:17 2005
Shutting down instance (immediate)
License high water mark = 1
Sat Oct 22 18:58:17 2005
Stopping Job queue slave processes
Sat Oct 22 18:58:17 2005
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Sat Oct 22 18:58:19 2005
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Sat Oct 22 18:58:19 2005
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Oct 22 18:58:22 2005
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 =18
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:
processes = 150
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_no_recovery_through_resetlogs= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=2640
PSP0 started with pid=3, OS id=1424
MMAN started with pid=4, OS id=2580
DBW0 started with pid=5, OS id=2508
LGWR started with pid=6, OS id=2340
CKPT started with pid=7, OS id=2232
SMON started with pid=8, OS id=2608
RECO started with pid=9, OS id=2288
MMON started with pid=10, OS id=3844
Sat Oct 22 18:58:22 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=11, OS id=652
Sat Oct 22 18:58:22 2005
starting up 1 shared server(s) ...
Sat Oct 22 18:58:22 2005
Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\orcl\redo01.log') SIZE 51200K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\orcl\redo02.log') SIZE 51200K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\orcl\redo03.log') SIZE 51200K RESETLOGS
Sat Oct 22 18:58:22 2005
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Setting recovery target incarnation to 1
Sat Oct 22 18:58:25 2005
Successful mount of redo thread 1, with mount id 1100144206
Sat Oct 22 18:58:25 2005
Completed: Create controlfile reuse set database "orcl"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'C:\oracle\product\10.2.0\oradata\orcl\SYSTEM01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\SYSAUX01.DBF',
'C:\oracle\product\10.2.0\oradata\orcl\USERS01.DBF'
LOGFILE GROUP 1 ('C:\oracle\product\10.2.0\oradata\orcl\redo01.log') SIZE 51200K,
GROUP 2 ('C:\oracle\product\10.2.0\oradata\orcl\redo02.log') SIZE 51200K,
GROUP 3 ('C:\oracle\product\10.2.0\oradata\orcl\redo03.log') SIZE 51200K RESETLOGS
Sat Oct 22 18:58:25 2005
Stopping background process MMNL
Sat Oct 22 18:58:26 2005
Stopping background process MMON
Starting background process MMON
Starting background process MMNL
MMON started with pid=10, OS id=3708
Sat Oct 22 18:58:27 2005
ALTER SYSTEM enable restricted session;
Sat Oct 22 18:58:27 2005
alter database "orcl" open resetlogs
Sat Oct 22 18:58:27 2005
RESETLOGS after incomplete recovery UNTIL CHANGE 534906
Sat Oct 22 18:58:27 2005
Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_1936.trc:
ORA-00313: echec d'ouverture des membres du groupe de journaux 1, thread 1
ORA-00312: journal en ligne 1 thread 1 : 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'
ORA-27041: ouverture du fichier impossible
OSD-04002: ouverture impossible du fichier
O/S-Error: (OS 2) Le fichier spécifié est introuvable.

MMNL started with pid=11, OS id=3620
Sat Oct 22 18:58:30 2005
Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_1936.trc:
ORA-00313: echec d'ouverture des membres du groupe de journaux 2, thread 1
ORA-00312: journal en ligne 2 thread 1 : 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
ORA-27041: ouverture du fichier impossible
OSD-04002: ouverture impossible du fichier
O/S-Error: (OS 2) Le fichier spécifié est introuvable.

Sat Oct 22 18:58:33 2005
Errors in file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_1936.trc:
ORA-00313: echec d'ouverture des membres du groupe de journaux 3, thread 1
ORA-00312: journal en ligne 3 thread 1 : 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG'
ORA-27041: ouverture du fichier impossible
OSD-04002: ouverture impossible du fichier
O/S-Error: (OS 2) Le fichier spécifié est introuvable.

Sat Oct 22 18:58:38 2005
Setting recovery target incarnation to 2
Sat Oct 22 18:58:40 2005
Assigning activation ID 1100144206 (0x4192de4e)
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Sat Oct 22 18:58:41 2005
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Oct 22 18:58:41 2005
SMON: enabling cache recovery
Sat Oct 22 18:58:44 2005
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tablespace 'TEMP' #3 found in data dictionary,
but not in the controlfile. Adding to controlfile.
Dictionary check complete
Sat Oct 22 18:58:44 2005
SMON: enabling tx recovery
Sat Oct 22 18:58:44 2005
*********************************************************************
WARNING: The following temporary tablespaces contain no files.
This condition can occur when a backup controlfile has
been restored. It may be necessary to add files to these
tablespaces. That can be done using the SQL statement:

ALTER TABLESPACE <tablespace_name> ADD TEMPFILE

Alternatively, if these temporary tablespaces are no longer
needed, then they can be dropped.
Empty temporary tablespace: TEMP
*********************************************************************
Database Characterset is US7ASCII
Threshold validation cannot be done before catproc is loaded.
Threshold validation cannot be done before catproc is loaded.
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=15, OS id=2596
Sat Oct 22 18:58:54 2005
LOGSTDBY: Validating controlfile with logical metadata
Sat Oct 22 18:58:55 2005
LOGSTDBY: Validation complete
Global Name changed to ORCL
Completed: alter database "orcl" open resetlogs
Sat Oct 22 18:59:03 2005
alter database rename global_name to "orcl"
Completed: alter database rename global_name to "orcl"
Sat Oct 22 18:59:04 2005
ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\product\10.2.0\oradata\orcl\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Completed: ALTER TABLESPACE TEMP ADD TEMPFILE 'C:\oracle\product\10.2.0\oradata\orcl\TEMP01.DBF' SIZE 20480K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
Sat Oct 22 18:59:05 2005
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Sat Oct 22 18:59:05 2005
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
Sat Oct 22 18:59:16 2005
ALTER SYSTEM disable restricted session;
Sat Oct 22 18:59:17 2005
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Sat Oct 22 18:59:25 2005
The input backup piece C:\ORACLE\PRODUCT\10.2.0\DB_1\ASSISTANTS\DBCA\TEMPLATES\EXAMPLE01.DFB is in compressed format.
Sat Oct 22 18:59:28 2005
Starting background process CJQ0
CJQ0 started with pid=19, OS id=1052
Sat Oct 22 18:59:42 2005
Full restore complete of datafile 5 to datafile copy C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF. Elapsed time: 0:00:16
checkpoint is 552765
Sat Oct 22 18:59:45 2005
Plug in tablespace EXAMPLE with datafile
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF'
Sat Oct 22 19:00:29 2005
ALTER TABLESPACE example READ WRITE
Sat Oct 22 19:00:32 2005
Completed: ALTER TABLESPACE example READ WRITE
Sat Oct 22 19:00:41 2005
Memory Notification: Library Cache Object loaded into SGA
Heap size 2206K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Sat Oct 22 19:01:42 2005
Starting background process EMN0
EMN0 started with pid=14, OS id=3892
Sat Oct 22 19:01:42 2005
Shutting down instance: further logons disabled
Sat Oct 22 19:01:45 2005
Stopping background process QMNC
Sat Oct 22 19:01:45 2005
Stopping background process CJQ0
Sat Oct 22 19:01:46 2005
Stopping background process MMNL
Sat Oct 22 19:01:47 2005
Stopping background process MMON
Sat Oct 22 19:01:49 2005
Shutting down instance (immediate)
License high water mark = 5
All dispatchers and shared servers shutdown
Sat Oct 22 19:01:56 2005
ALTER DATABASE CLOSE NORMAL
Sat Oct 22 19:01:56 2005
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Oct 22 19:01:58 2005
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Sat Oct 22 19:01:58 2005
Completed: ALTER DATABASE CLOSE NORMAL
Sat Oct 22 19:01:58 2005
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Oct 22 19:02:01 2005
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 =18
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:
processes = 150
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
_no_recovery_through_resetlogs= TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=3528
PSP0 started with pid=3, OS id=3724
MMAN started with pid=4, OS id=1224
DBW0 started with pid=5, OS id=2568
LGWR started with pid=6, OS id=3916
CKPT started with pid=7, OS id=3448
SMON started with pid=8, OS id=3756
RECO started with pid=9, OS id=2972
MMON started with pid=10, OS id=2316
MMNL started with pid=11, OS id=3804
Sat Oct 22 19:02:02 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Oct 22 19:02:02 2005
ALTER DATABASE MOUNT
Sat Oct 22 19:02:07 2005
Setting recovery target incarnation to 2
Sat Oct 22 19:02:07 2005
Successful mount of redo thread 1, with mount id 1100169002
Sat Oct 22 19:02:07 2005
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sat Oct 22 19:02:07 2005
ALTER DATABASE OPEN
Sat Oct 22 19:02:08 2005
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Sat Oct 22 19:02:08 2005
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Oct 22 19:02:08 2005
SMON: enabling cache recovery
Sat Oct 22 19:02:09 2005
Successfully onlined Undo Tablespace 1.
Sat Oct 22 19:02:09 2005
SMON: enabling tx recovery
Sat Oct 22 19:02:10 2005
Database Characterset is US7ASCII
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=14, OS id=532
Sat Oct 22 19:02:22 2005
Completed: ALTER DATABASE OPEN
Sat Oct 22 19:02:22 2005
Stopping background process MMNL
Sat Oct 22 19:02:22 2005
Stopping background process MMON
Sat Oct 22 19:02:22 2005
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Sat Oct 22 19:02:24 2005
Starting background process MMON
Starting background process MMNL
MMON started with pid=10, OS id=2792
Sat Oct 22 19:02:24 2005
ALTER SYSTEM enable restricted session;
MMNL started with pid=17, OS id=3620
Sat Oct 22 19:02:24 2005
alter database character set INTERNAL_CONVERT WE8MSWIN1252
Sat Oct 22 19:02:41 2005
Thread 1 advanced to log sequence 2
Current log# 1 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Oct 22 19:02:43 2005
Updating character set in controlfile to WE8MSWIN1252
Synchronizing connection with database character set information
Refreshing type attributes with new character set information
Completed: alter database character set INTERNAL_CONVERT WE8MSWIN1252
Sat Oct 22 19:02:52 2005
ALTER SYSTEM disable restricted session;
Sat Oct 22 19:02:57 2005
Starting background process CJQ0
CJQ0 started with pid=18, OS id=3808
Sat Oct 22 19:03:07 2005
Starting background process EMN0
EMN0 started with pid=19, OS id=812
Sat Oct 22 19:03:07 2005
Shutting down instance: further logons disabled
Sat Oct 22 19:03:12 2005
Stopping background process CJQ0
Sat Oct 22 19:03:12 2005
Stopping background process QMNC
Sat Oct 22 19:03:13 2005
Stopping background process MMNL
Sat Oct 22 19:03:13 2005
Stopping background process MMON
Sat Oct 22 19:03:14 2005
Shutting down instance (immediate)
License high water mark = 1
All dispatchers and shared servers shutdown
Sat Oct 22 19:03:20 2005
ALTER DATABASE CLOSE NORMAL
Sat Oct 22 19:03:22 2005
SMON: disabling tx recovery
SMON: disabling cache recovery
Sat Oct 22 19:03:24 2005
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 2
Successful close of redo thread 1
Sat Oct 22 19:03:24 2005
Completed: ALTER DATABASE CLOSE NORMAL
Sat Oct 22 19:03:24 2005
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sat Oct 22 19:03:27 2005
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 =18
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:
processes = 150
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=3664
PSP0 started with pid=3, OS id=3604
MMAN started with pid=4, OS id=3716
DBW0 started with pid=5, OS id=3464
LGWR started with pid=6, OS id=2896
CKPT started with pid=7, OS id=696
SMON started with pid=8, OS id=3228
RECO started with pid=9, OS id=3976
CJQ0 started with pid=10, OS id=2180
MMON started with pid=11, OS id=3044
MMNL started with pid=12, OS id=3216
Sat Oct 22 19:03:28 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Oct 22 19:03:29 2005
ALTER DATABASE MOUNT
Sat Oct 22 19:03:33 2005
Setting recovery target incarnation to 2
Sat Oct 22 19:03:33 2005
Successful mount of redo thread 1, with mount id 1100120961
Sat Oct 22 19:03:33 2005
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sat Oct 22 19:03:34 2005
ALTER DATABASE OPEN
Sat Oct 22 19:03:34 2005
Thread 1 opened at log sequence 2
Current log# 1 seq# 2 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Sat Oct 22 19:03:34 2005
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Oct 22 19:03:34 2005
SMON: enabling cache recovery
Sat Oct 22 19:03:42 2005
Successfully onlined Undo Tablespace 1.
Sat Oct 22 19:03:42 2005
SMON: enabling tx recovery
Sat Oct 22 19:03:43 2005
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=15, OS id=4092
Sat Oct 22 19:04:00 2005
Completed: ALTER DATABASE OPEN
Sat Oct 22 19:04:03 2005
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Sat Oct 22 19:29:38 2005
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:165M/510M, Ph+PgF:1184M/1505M, VA:1942M/2047M
Sat Oct 22 19:29:38 2005
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 =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Sat Oct 22 19:29:49 2005
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:
processes = 150
__shared_pool_size = 75497472
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 79691776
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 16777216
PMON started with pid=2, OS id=3792
PSP0 started with pid=3, OS id=3796
MMAN started with pid=4, OS id=3800
DBW0 started with pid=5, OS id=3812
LGWR started with pid=6, OS id=3816
CKPT started with pid=7, OS id=3820
SMON started with pid=8, OS id=3824
RECO started with pid=9, OS id=3828
CJQ0 started with pid=10, OS id=3832
MMON started with pid=11, OS id=3836
MMNL started with pid=12, OS id=3840
Sat Oct 22 19:29:53 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Oct 22 19:30:00 2005
alter database mount exclusive
Sat Oct 22 19:30:09 2005
Setting recovery target incarnation to 2
Sat Oct 22 19:30:11 2005
Successful mount of redo thread 1, with mount id 1100131512
Sat Oct 22 19:30:11 2005
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Sat Oct 22 19:30:12 2005
alter database open
Sat Oct 22 19:30:15 2005
Beginning crash recovery of 1 threads
Sat Oct 22 19:30:17 2005
Started redo scan
Sat Oct 22 19:30:20 2005
Completed redo scan
471 redo blocks read, 86 data blocks need recovery
Sat Oct 22 19:30:20 2005
Started redo application at
Thread 1: logseq 2, block 55004
Sat Oct 22 19:30:22 2005
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Sat Oct 22 19:30:25 2005
Completed redo application
Sat Oct 22 19:30:25 2005
Completed crash recovery at
Thread 1: logseq 2, block 55475, scn 594534
86 data blocks read, 86 data blocks written, 471 redo blocks read
Sat Oct 22 19:30:34 2005
Thread 1 advanced to log sequence 3
Thread 1 opened at log sequence 3
Current log# 2 seq# 3 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
Sat Oct 22 19:30:36 2005
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Oct 22 19:30:37 2005
SMON: enabling cache recovery
Sat Oct 22 19:31:08 2005
Successfully onlined Undo Tablespace 1.
Sat Oct 22 19:31:08 2005
SMON: enabling tx recovery
Sat Oct 22 19:31:11 2005
Database Characterset is WE8MSWIN1252
Sat Oct 22 19:31:21 2005
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=3472
Sat Oct 22 19:32:20 2005
Completed: alter database open
Sat Oct 22 19:32:33 2005
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Sat Oct 22 23:37:37 2005
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:168M/510M, Ph+PgF:1198M/1505M, VA:1942M/2047M
Sat Oct 22 23:37:37 2005
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 =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Sat Oct 22 23:37:49 2005
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:
processes = 150
__shared_pool_size = 75497472
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 79691776
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 16777216
PSP0 started with pid=3, OS id=3472
MMAN started with pid=4, OS id=3476
PMON started with pid=2, OS id=3468
DBW0 started with pid=5, OS id=3480
LGWR started with pid=6, OS id=3484
CKPT started with pid=7, OS id=3488
SMON started with pid=8, OS id=3492
RECO started with pid=9, OS id=3496
CJQ0 started with pid=10, OS id=3500
MMON started with pid=11, OS id=3504
MMNL started with pid=12, OS id=3508
Sat Oct 22 23:37:52 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sat Oct 22 23:37:58 2005
alter database mount exclusive
Sat Oct 22 23:38:04 2005
Setting recovery target incarnation to 2
Sat Oct 22 23:38:05 2005
Successful mount of redo thread 1, with mount id 1100190166
Sat Oct 22 23:38:05 2005
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Sat Oct 22 23:38:05 2005
alter database open
Sat Oct 22 23:38:07 2005
Beginning crash recovery of 1 threads
Sat Oct 22 23:38:08 2005
Started redo scan
Sat Oct 22 23:38:10 2005
Completed redo scan
1490 redo blocks read, 91 data blocks need recovery
Sat Oct 22 23:38:11 2005
Started redo application at
Thread 1: logseq 3, block 4265
Sat Oct 22 23:38:12 2005
Recovery of Online Redo Log: Thread 1 Group 2 Seq 3 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Sat Oct 22 23:38:14 2005
Completed redo application
Sat Oct 22 23:38:15 2005
Completed crash recovery at
Thread 1: logseq 3, block 5755, scn 616989
91 data blocks read, 91 data blocks written, 1490 redo blocks read
Sat Oct 22 23:38:25 2005
Thread 1 advanced to log sequence 4
Thread 1 opened at log sequence 4
Current log# 3 seq# 4 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Sat Oct 22 23:38:26 2005
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Oct 22 23:38:27 2005
SMON: enabling cache recovery
Sat Oct 22 23:38:49 2005
Successfully onlined Undo Tablespace 1.
Sat Oct 22 23:38:49 2005
SMON: enabling tx recovery
Sat Oct 22 23:38:51 2005
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Sat Oct 22 23:39:07 2005
Starting background process QMNC
QMNC started with pid=16, OS id=3780
Sat Oct 22 23:39:55 2005
Completed: alter database open
Sat Oct 22 23:40:46 2005
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Sun Oct 23 11:33:17 2005
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:260M/510M, Ph+PgF:1297M/1505M, VA:1942M/2047M
Sun Oct 23 11:33:17 2005
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 =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Sun Oct 23 11:33:29 2005
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:
processes = 150
__shared_pool_size = 83886080
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 71303168
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 16777216
MMAN started with pid=4, OS id=1588
PMON started with pid=2, OS id=1444
PSP0 started with pid=3, OS id=1436
DBW0 started with pid=5, OS id=1624
LGWR started with pid=6, OS id=1592
CKPT started with pid=7, OS id=1560
SMON started with pid=8, OS id=1584
RECO started with pid=9, OS id=1576
CJQ0 started with pid=10, OS id=1520
MMON started with pid=11, OS id=1556
MMNL started with pid=12, OS id=1548
Sun Oct 23 11:33:31 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Sun Oct 23 11:33:34 2005
alter database mount exclusive
Sun Oct 23 11:33:39 2005
Setting recovery target incarnation to 2
Sun Oct 23 11:33:40 2005
Successful mount of redo thread 1, with mount id 1100191374
Sun Oct 23 11:33:40 2005
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Sun Oct 23 11:33:41 2005
alter database open
Sun Oct 23 11:33:42 2005
Beginning crash recovery of 1 threads
Sun Oct 23 11:33:44 2005
Started redo scan
Sun Oct 23 11:33:45 2005
Completed redo scan
511 redo blocks read, 108 data blocks need recovery
Sun Oct 23 11:33:45 2005
Started redo application at
Thread 1: logseq 4, block 10625
Sun Oct 23 11:33:46 2005
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Sun Oct 23 11:33:47 2005
Completed redo application
Sun Oct 23 11:33:47 2005
Completed crash recovery at
Thread 1: logseq 4, block 11136, scn 641275
108 data blocks read, 108 data blocks written, 511 redo blocks read
Sun Oct 23 11:33:50 2005
Thread 1 advanced to log sequence 5
Thread 1 opened at log sequence 5
Current log# 1 seq# 5 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Successful open of redo thread 1
Sun Oct 23 11:33:51 2005
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Oct 23 11:33:52 2005
SMON: enabling cache recovery
Sun Oct 23 11:34:02 2005
Successfully onlined Undo Tablespace 1.
Sun Oct 23 11:34:02 2005
SMON: enabling tx recovery
Sun Oct 23 11:34:04 2005
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Sun Oct 23 11:34:20 2005
Starting background process QMNC
QMNC started with pid=16, OS id=2344
Sun Oct 23 11:35:42 2005
Completed: alter database open
Sun Oct 23 11:35:59 2005
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Sun Oct 23 21:48:29 2005
Thread 1 advanced to log sequence 6
Current log# 2 seq# 6 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Dump file c:\oracle\product\10.2.0/admin/orcl/bdump\alert_orcl.log
Mon Oct 24 01:14:08 2005
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 1
CPU : 1 - type 586
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:200M/510M, Ph+PgF:1222M/1505M, VA:1941M/2047M
Mon Oct 24 01:14:08 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Mon Oct 24 01:14:20 2005
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 =18
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:
processes = 150
__shared_pool_size = 75497472
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = C:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
sga_target = 167772160
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 79691776
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 16777216
MMAN started with pid=4, OS id=3068
PSP0 started with pid=3, OS id=3064
PMON started with pid=2, OS id=3056
DBW0 started with pid=5, OS id=3084
LGWR started with pid=6, OS id=3088
CKPT started with pid=7, OS id=3092
SMON started with pid=8, OS id=3096
RECO started with pid=9, OS id=3100
CJQ0 started with pid=10, OS id=3104
MMON started with pid=11, OS id=3108
MMNL started with pid=12, OS id=3112
Mon Oct 24 01:14:30 2005
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Mon Oct 24 01:14:36 2005
alter database mount exclusive
Mon Oct 24 01:14:41 2005
Setting recovery target incarnation to 2
Mon Oct 24 01:14:42 2005
Successful mount of redo thread 1, with mount id 1100282620
Mon Oct 24 01:14:42 2005
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Oct 24 01:14:42 2005
alter database open
Mon Oct 24 01:14:43 2005
Beginning crash recovery of 1 threads
Mon Oct 24 01:14:44 2005
Started redo scan
Mon Oct 24 01:14:47 2005
Completed redo scan
345 redo blocks read, 78 data blocks need recovery
Mon Oct 24 01:14:47 2005
Started redo application at
Thread 1: logseq 6, block 9090
Mon Oct 24 01:14:48 2005
Recovery of Online Redo Log: Thread 1 Group 2 Seq 6 Reading mem 0
Mem# 0 errs 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Mon Oct 24 01:14:49 2005
Completed redo application
Mon Oct 24 01:14:49 2005
Completed crash recovery at
Thread 1: logseq 6, block 9435, scn 700251
78 data blocks read, 78 data blocks written, 345 redo blocks read
Mon Oct 24 01:14:56 2005
Thread 1 advanced to log sequence 7
Thread 1 opened at log sequence 7
Current log# 3 seq# 7 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Mon Oct 24 01:14:57 2005
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Oct 24 01:14:58 2005
SMON: enabling cache recovery
Mon Oct 24 01:15:17 2005
Successfully onlined Undo Tablespace 1.
Mon Oct 24 01:15:18 2005
SMON: enabling tx recovery
Mon Oct 24 01:15:20 2005
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Mon Oct 24 01:15:36 2005
Starting background process QMNC
QMNC started with pid=16, OS id=2580
Mon Oct 24 01:16:24 2005
Completed: alter database open
Mon Oct 24 01:16:39 2005
db_recovery_file_dest_size of 2048 MB is 0.00% 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.

**bouyao** · 25/10/2005, 14h13

Je ne vois pas de problème seulement la réstauration des données par les redo logs ce qui est normal suite à un crash.

Est ce que tu a modifié ton listener.ora ?
Ca peut venir du ORACLE_HOME dans le listener.ora
est ce que tu peut le coller ici ?

**belokan** · 25/10/2005, 14h21

En fait, le seul changement que j'aipu voir c'est que ... ben ça marche plus

... et que Oracle.exe ne prend plus que 12Mo (120Mo avant le pb).

Je n'ai pas modifié le listener.ora ... et d'ailleurs je ne saurais même pas comment, je débute tout juste. Je comprend pas, j'ai pas eu de reboot sauvage, tout marchait nikel ... et bam, c'est la chute !

Voici mes listener.ora (je ne sais pas lequel tu voulais, alors cadeau, t'en auras 2

) :

celui situé dans C:\oracle\product\10.2.0\db_1\network\admin\

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = beloport)(PORT = 1521))
)
)

[Jaouad] le sample ne sert à rien c'est juste un exemple

**belokan** · 25/10/2005, 14h28

Oki, merci de l'avoir supprimé ...

EDIT : je vais devoir m'absenter et je n'aurai pas le net avant ... je ne sais pas quand dans la semaine !

Je viendrai voir l'évolution des choses dès que possible. Merci beaucoup pour votre aide, @+

**belokan** · 27/10/2005, 14h20

Me revoilà ...

J'ai trouvé une parade à mon problème : il faut que j'aille dans l'Assistant de configuration de base de données ; puis je clic sur "Configurer les options de base de données" et je sélectionne ma base orcl. A ce moment là, il y a une étape qui dure 3-4 minutes et qui s'appelle "Extraction des informations de la base de donénes". Pendant que cette étape se déroule, je vois dans le gestionnaire des tâches qu'un processus oracle.exe s'est mis en route et qu'il augmente de taille petit à petit jusqu'à arriver à la taille initiale (cad env. 120 mo). Une fois les infos extraites, je quitte cet assistant et je peux enfin accéder à SQL plus ou iSQL plus !!! tadada ....

Par contre, je n'ai plus accès au Database Control (http://localhost:1158/em) !

Une petite idée ?

**belokan** · 27/10/2005, 16h47

Ouinnnnnn .... pourquoi oracle s'acharne sur moi, qu'est-ce que j'ai bien plus faire au bon dieu pour mériter ça ...

C'est vraiment un truc de fou ... un jour, ça marche ... le lendemain, sans aucune explication, a marche pu ....

Je jetais une dernière bouteille à la mer .... dans un dernier soupir ...

**ducho** · 27/10/2005, 17h29

bonjour,

je viens de remarquer que le fichier d' init du post ne correspond pas
à la base orcl, peux-tu vérifier que tu n' en as pas plusieurs
correspondant à la même base ...

cdlt

**belokan** · 27/10/2005, 17h35

Envoyé par ducho

bonjour,

je viens de remarquer que le fichier d' init du post ne correspond pas
à la base orcl, peux-tu vérifier que tu n' en as pas plusieurs
correspondant à la même base ...

cdlt

Je vais vérifier ça de suite, ne bouge pas ....

EDIT : le fichier init.ora en page 1 de ce post, je l'ai trouvé dans C:\oracle\product\10.2.0\db_1\srvm\admin

Autrement, il y a un autre fichier intitulé init.ora.92220051937 qui se stitue dans C:\oracle\product\10.2.0\admin\orcl\pfile :

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# Cache and I/O
###########################################
db_block_size=8192
db_file_multiblock_read_count=16

###########################################
# File Configuration
###########################################
control_files=("C:\oracle\product\10.2.0\oradata\orcl\control01.ctl", "C:\oracle\product\10.2.0\oradata\orcl\control02.ctl", "C:\oracle\product\10.2.0\oradata\orcl\control03.ctl")
db_recovery_file_dest=C:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size=2147483648

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=C:\oracle\product\10.2.0/admin/orcl/bdump
core_dump_dest=C:\oracle\product\10.2.0/admin/orcl/cdump
user_dump_dest=C:\oracle\product\10.2.0/admin/orcl/udump

###########################################
# Miscellaneous
###########################################
compatible=10.2.0.1.0

###########################################
# Job Queues
###########################################
job_queue_processes=10

###########################################
# Database Identification
###########################################
db_domain=""
db_name=orcl

###########################################
# SGA Memory
###########################################
sga_target=167772160

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS1

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=orclXDB)"

###########################################
# Security and Auditing
###########################################
audit_file_dest=C:\oracle\product\10.2.0/admin/orcl/adump
remote_login_passwordfile=EXCLUSIVE

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=16777216

C'est mieux ?

CD · 27/10/2005, 18h07

Je pense qu'il ne prend pas le bon fichier d'initialisation au démarrage des services, d'où le process oracle.exe à 12 Mo.

Essaye de générer un spfile pour le démarrage de la base :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
sqlplus "/ as sysdba"
SQL> shutdown immediate;
SQL> startup pfile=C:\oracle\product\10.2.0\admin\orcl\pfile\init.ora.92220051937
SQL> create spfile from pfile=C:\oracle\product\10.2.0\admin\orcl\pfile\init.ora.92220051937
SQL> shutdown immediate
SQL> startup

**belokan** · 28/10/2005, 13h46

Hum ... je tape tout cela une fois connecté sous SQL Plus, c'est ça ?

Et il faut que je me connecte sous sysdba uniquement ? sysman, c'est pô bien ?

:

EDIT : c'est bizarre mais je peux pas me connecter sous sysdba ??? Il me dit

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

error: ORA-01017: invalid username/password; logon denied

Où peut-on gérer les utilisateurs et mots de passe pour oracle ?

Le processus Oracle.exe ne veu plus se lancer au démarrage ?

Oracle

Discussions similaires

Partager

Partager