Home » RDBMS Server » Networking and Gateways » ora-12514 after i restart the service
ora-12514 after i restart the service [message #273613] Thu, 11 October 2007 01:34 Go to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
during i loading data i have restart the PACCMIN service then i start the service again after that i can't login PACCMIN database got ora-12514

below is listener.ora
----------------------------------------------------------------------------
# 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 = TACD620-12)(PORT = 1521))
)
)
----------------------------------------------------------------------------
below is sqlnet.ora
----------------------------------------------------------------------------
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
----------------------------------------------------------------------------
and TNSNAME.ORA

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_3\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

GIADW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = GIADW)
)
)

CCA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TACINS)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CCA)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

PACCMIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PACCMIN)
)
)

----------------------------------------------------------------------------
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TACINS)(PORT=1521)))
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
LSNRCTL>
----------------------------------------------------------------------------
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TACINS)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 11-OCT-2007 03:03:52
Uptime 0 days 11 hr. 23 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_3\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.2.0\db_3\network\log\listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TACINS)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
----------------------------------------------------------------------------
D:\oracle\product\10.2.0\db_1\BIN>tnsping PACCMIN

TNS Ping Utility for 64-bit Windows: Version 10.2.0.1.0 - Production on 11-OCT-2
007 14:28:34

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
D:\oracle\product\10.2.0\db_3\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = PACCMIN)))
OK (10 msec)

D:\oracle\product\10.2.0\db_1\BIN>
---------------------------------------------------------------------------

After i have read in this forums
i tried to connect database but stilll cannot ,,, show below.


D:\oracle\product\10.2.0\db_1\BIN>SET ORACLE_SID=PACCMIN

D:\oracle\product\10.2.0\db_1\BIN>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 11 14:30:26 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys/oracle as sysdba
Connected to an idle instance.
SQL> startup
ORA-00439: feature not enabled: Real Application Clusters
SQL>
----------------------------------------------------------------------------

Please kindly to help me this problem. i very want to use those data.
Re: ora-12514 after i restart the service [message #273627 is a reply to message #273613] Thu, 11 October 2007 02:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a service name for a service (usually a database service)
 that either has not yet dynamically registered with the listener or has
 not been statically configured for the listener.  This may be a temporary
 condition such as after the listener has started, but before the database
 instance has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel
Re: ora-12514 after i restart the service [message #273650 is a reply to message #273627] Thu, 11 October 2007 03:35 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
hi Michel
after i have checked by use below

D:\oracle\product\10.2.0\db_3\BIN>lsnrctl services paccmin

LSNRCTL for 64-bit Windows: Version 10.2.0.1.0 - Production on 11-OCT-2007 16:34
:13

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=TACINS)(PORT=1521))(CONN
ECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PACCMIN)))
Services Summary...
Service "CCAXDB" has 1 instance(s).
Instance "cca", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: TACINS, pid: 4104>
(ADDRESS=(PROTOCOL=tcp)(HOST=TACINS)(PORT=2706))
Service "CCA_XPT" has 1 instance(s).
Instance "cca", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:18 refused:0 state:ready
LOCAL SERVER
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
Service "cca" has 1 instance(s).
Instance "cca", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:18 refused:0 state:ready
LOCAL SERVER
The command completed successfully

D:\oracle\product\10.2.0\db_3\BIN>
------------------------------------------------------------------------------

could you please tell me step by step for check ?, i don't really know how to modify or change Listener,
Re: ora-12514 after i restart the service [message #273664 is a reply to message #273650] Thu, 11 October 2007 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You posted many things but not the very first one: the statement you executed when you gave the error.
Do what you did for other things: copy and paste your screen.

Regards
Michel
Re: ora-12514 after i restart the service [message #273670 is a reply to message #273664] Thu, 11 October 2007 05:05 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
D:\oracle\product\10.2.0\db_1\BIN>SET ORACLE_SID=PACCMIN

D:\oracle\product\10.2.0\db_1\BIN>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 11 14:30:26 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys/oracle as sysdba
Connected to an idle instance.
SQL> startup
ORA-00439: feature not enabled: Real Application Clusters

Hi michel after i tried to start the database i got this ora-00439 how to solve it? but i sill got the error ora-12514
Re: ora-12514 after i restart the service [message #273692 is a reply to message #273670] Thu, 11 October 2007 06:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I still don't see any ora-12514 error.

For ora-00439, you likely have a RAC specific parameter in your configuration file (for instance parallel_server).

Regards
Michel
Re: ora-12514 after i restart the service [message #273702 is a reply to message #273692] Thu, 11 October 2007 07:32 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
Hi michel
Thank you very much for your answer
1.I have attached a picture that while login to paccmin database
2. how do i disable the instance by manually because now i can't open the database ? please help advice to me.
  • Attachment: 1.jpg
    (Size: 94.29KB, Downloaded 546 times)
Re: ora-12514 after i restart the service [message #273709 is a reply to message #273702] Thu, 11 October 2007 08:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't download the file but if you can't open the database it is normal you can't connect to it.
Stop the instance (shutdown), find which parameter is incorrect, fix it.

Regards
Michel
Re: ora-12514 after i restart the service [message #273715 is a reply to message #273709] Thu, 11 October 2007 08:39 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
find the parameter
i'm not sure where the file that stored that parameter.
it is ini.ora or what is file ?
if init.ora i don't know what somthing in the parameter.

thus, i tried to disable some word of cluster that have shows on the buttom but still not work.

Thanks you very much for you advice.

init.ora show following

#
# $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)


Re: ora-12514 after i restart the service [message #273722 is a reply to message #273715] Thu, 11 October 2007 08:55 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
COMENT THESE and try again..

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

[Updated on: Thu, 11 October 2007 08:56]

Report message to a moderator

Re: ora-12514 after i restart the service [message #273723 is a reply to message #273715] Thu, 11 October 2007 08:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't want to scan hundred of lines.
First remove all comments, keep only active lines.
Then use code tags.

Regards
Michel

[Updated on: Thu, 11 October 2007 08:56]

Report message to a moderator

Re: ora-12514 after i restart the service [message #273732 is a reply to message #273715] Thu, 11 October 2007 09:18 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
Hi DeamzZ

i already comment that you shown me but the result still same.
Please see following.
------------------------------------------------------------------------------
C:\oracle\product\10.2.0\db_1\BIN>SET ORACLE_SID=PACCMIN

C:\oracle\product\10.2.0\db_1\BIN>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on พฤ. ต.ค. 11 22:15:15 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn sys/oracle as sysdba
idle stance
SQL> startup
ORA-00439: feature not enabled: Real Application Clusters
SQL>
Re: ora-12514 after i restart the service [message #273736 is a reply to message #273732] Thu, 11 October 2007 09:27 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Post last 50 lines or 100 lines from alert log.


distributed_transactions = 5
Obsolete.
Re: ora-12514 after i restart the service [message #273746 is a reply to message #273736] Thu, 11 October 2007 09:49 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member


C:\oracle\product\10.2.0\db_1\log\tacd620-12\client\css.log


2007-10-11 21:58:54.406: [ OCRRAW][2512]proprinit: Could not open raw device
2007-10-11 21:58:54.406: [ default][2512]a_init:7!: Backend init unsuccessful : [33]
2007-10-11 21:58:54.406: [ CSSCLNT][2512]clsssinit: error(33 ) in OCR initialization

2007-10-11 22:08:33.171: [ OCROSD][1596]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

2007-10-11 22:08:33.171: [ OCRRAW][1596]proprinit: Could not open raw device
2007-10-11 22:08:33.171: [ default][1596]a_init:7!: Backend init unsuccessful : [33]
2007-10-11 22:08:33.171: [ CSSCLNT][1596]clsssinit: error(33 ) in OCR initialization

2007-10-11 22:19:58.765: [ OCROSD][2280]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

2007-10-11 22:19:58.765: [ OCRRAW][2280]proprinit: Could not open raw device
2007-10-11 22:19:58.765: [ default][2280]a_init:7!: Backend init unsuccessful : [33]
2007-10-11 22:19:58.765: [ CSSCLNT][2280]clsssinit: error(33 ) in OCR initialization

2007-10-11 22:20:10.734: [ OCROSD][5248]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

2007-10-11 22:20:10.734: [ OCRRAW][5248]proprinit: Could not open raw device
2007-10-11 22:20:10.734: [ default][5248]a_init:7!: Backend init unsuccessful : [33]
2007-10-11 22:20:10.734: [ CSSCLNT][5248]clsssinit: error(33 ) in OCR initialization

2007-10-11 22:20:17.281: [ OCROSD][3592]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

2007-10-11 22:20:17.281: [ OCRRAW][3592]proprinit: Could not open raw device
2007-10-11 22:20:17.281: [ default][3592]a_init:7!: Backend init unsuccessful : [33]
2007-10-11 22:20:17.281: [ CSSCLNT][3592]clsssinit: error(33 ) in OCR initialization

2007-10-11 22:20:26.421: [ OCROSD][5212]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

2007-10-11 22:20:26.421: [ OCRRAW][5212]proprinit: Could not open raw device
2007-10-11 22:20:26.421: [ default][5212]a_init:7!: Backend init unsuccessful : [33]
2007-10-11 22:20:26.421: [ CSSCLNT][5212]clsssinit: error(33 ) in OCR initialization

2007-10-11 22:20:39.000: [ OCROSD][4028]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

2007-10-11 22:20:39.000: [ OCRRAW][4028]proprinit: Could not open raw device
2007-10-11 22:20:39.000: [ default][4028]a_init:7!: Backend init unsuccessful : [33]
2007-10-11 22:20:39.000: [ CSSCLNT][4028]clsssinit: error(33 ) in OCR initialization

2007-10-11 22:20:47.046: [ OCROSD][4028]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

2007-10-11 22:20:47.046: [ OCRRAW][4028]proprinit: Could not open raw device
2007-10-11 22:20:47.046: [ default][4028]a_init:7!: Backend init unsuccessful : [33]
2007-10-11 22:20:47.046: [ CSSCLNT][4028]clsssinit: error(33 ) in OCR initialization

2007-10-11 22:21:27.984: [ OCROSD][1000]utgdv:1:could not open registry key SOFTWARE\Oracle\ocr os error The system could not find the environment option that was entered.

2007-10-11 22:21:27.984: [ OCRRAW][1000]proprinit: Could not open raw device
2007-10-11 22:21:27.984: [ default][1000]a_init:7!: Backend init unsuccessful : [33]
2007-10-11 22:21:27.984: [ CSSCLNT][1000]clsssinit: error(33 ) in OCR initialization
Re: ora-12514 after i restart the service [message #273757 is a reply to message #273732] Thu, 11 October 2007 10:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe I should help you if you post what I requested.

Regards
Michel
Re: ora-12514 after i restart the service [message #273763 is a reply to message #273746] Thu, 11 October 2007 10:29 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
Hi Michel
thanks you very much for you kindly
i'm quite sleepy ,let continue tomorrow,
now Singapore time 11:30 pm.
Re: ora-12514 after i restart the service [message #273843 is a reply to message #273763] Thu, 11 October 2007 21:32 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
HI Michel

following is Alert log

Wed Oct 10 18:24:54 2007
Started redo application at
Thread 1: logseq 1358, block 28
Wed Oct 10 18:24:54 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1358 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:24:55 2007
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1359 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:25:00 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1360 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:25:08 2007
Completed redo application
Wed Oct 10 18:25:11 2007
Completed crash recovery at
Thread 1: logseq 1360, block 8092, scn 11239150
16651 data blocks read, 16651 data blocks written, 191936 redo blocks read
Wed Oct 10 18:25:11 2007
Thread 1 advanced to log sequence 1361
Thread 1 opened at log sequence 1361
Current log# 2 seq# 1361 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Successful open of redo thread 1
Wed Oct 10 18:25:11 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Oct 10 18:25:11 2007
SMON: enabling cache recovery
Wed Oct 10 18:25:12 2007
Successfully onlined Undo Tablespace 1.
Wed Oct 10 18:25:12 2007
SMON: enabling tx recovery
Wed Oct 10 18:25:12 2007
Database Characterset is TH8TISASCII
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=24, OS id=4792
Wed Oct 10 18:25:31 2007
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.
Wed Oct 10 18:25:33 2007
Completed: alter database open
Wed Oct 10 18:26:01 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 3623K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Wed Oct 10 18:26:05 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 3686K exceeds notification threshold (2048K)
Details in trace file d:\oracle\product\10.2.0\admin\paccmin\udump\paccmin_ora_4588.trc
KGL object name :XDB.XDGsQoAKuASp+S/RkOapfGzw==

Wed Oct 10 18:26:31 2007
Thread 1 advanced to log sequence 1362
Current log# 3 seq# 1362 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:27:26 2007
Thread 1 advanced to log sequence 1363
Current log# 1 seq# 1363 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:28:38 2007
Thread 1 advanced to log sequence 1364
Current log# 2 seq# 1364 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:29:05 2007
Thread 1 cannot allocate new log, sequence 1365
Checkpoint not complete
Current log# 2 seq# 1364 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:29:17 2007
Thread 1 advanced to log sequence 1365
Current log# 3 seq# 1365 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:30:29 2007
Thread 1 advanced to log sequence 1366
Current log# 1 seq# 1366 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:31:29 2007
Thread 1 advanced to log sequence 1367
Current log# 2 seq# 1367 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:32:24 2007
Thread 1 cannot allocate new log, sequence 1368
Checkpoint not complete
Current log# 2 seq# 1367 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1368
Current log# 3 seq# 1368 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:32:55 2007
Thread 1 advanced to log sequence 1369
Current log# 1 seq# 1369 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:33:52 2007
Thread 1 cannot allocate new log, sequence 1370
Checkpoint not complete
Current log# 1 seq# 1369 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:34:09 2007
Thread 1 advanced to log sequence 1370
Current log# 2 seq# 1370 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:34:32 2007
ALTER SYSTEM SET parallel_server=TRUE SCOPE=SPFILE;
Wed Oct 10 18:34:49 2007
Thread 1 advanced to log sequence 1371
Current log# 3 seq# 1371 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:35:37 2007
Thread 1 cannot allocate new log, sequence 1372
Checkpoint not complete
Current log# 3 seq# 1371 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1372
Current log# 1 seq# 1372 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:36:00 2007
Thread 1 advanced to log sequence 1373
Current log# 2 seq# 1373 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:36:12 2007
Starting background process EMN0
EMN0 started with pid=27, OS id=4688
Wed Oct 10 18:36:12 2007
Shutting down instance: further logons disabled
Wed Oct 10 18:37:15 2007
Stopping background process CJQ0
Wed Oct 10 18:37:16 2007
Stopping background process QMNC
Wed Oct 10 18:37:16 2007
Stopping background process MMNL
Wed Oct 10 18:37:17 2007
Stopping background process MMON
Wed Oct 10 18:37:18 2007
Shutting down instance (immediate)
License high water mark = 13
Wed Oct 10 18:37:18 2007
Stopping Job queue slave processes
Wed Oct 10 18:37:18 2007
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Oct 10 18:37:21 2007
alter database close normal
Wed Oct 10 18:37:26 2007
Thread 1 advanced to log sequence 1374
Current log# 3 seq# 1374 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Re: ora-12514 after i restart the service [message #273849 is a reply to message #273843] Thu, 11 October 2007 23:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You siad your database did not open and there we see the database is opened.
Post the part containing the whole startup, from "startup" to "alter database open completed".

Regards
Michel
Re: ora-12514 after i restart the service [message #273893 is a reply to message #273849] Fri, 12 October 2007 02:30 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
Hi Michel

that is the last time(Wed Oct 10 18:xx:xx 2007 ) can open and shutdown database PACCMIN

while was loading data i have stop database suddenly after that time i try to open the database PACCMIN then got error ora-15214
Re: ora-12514 after i restart the service [message #273894 is a reply to message #273893] Fri, 12 October 2007 02:37 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
HI michel

i have created New Database name CCA i don't know why that datbase can open whithout the error and using same listener for open CCA database.

Please kindly to help me to solve this database i very very urgent to use database.
Re: ora-12514 after i restart the service [message #273899 is a reply to message #273894] Fri, 12 October 2007 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what I requested.

Regards
Michel
Re: ora-12514 after i restart the service [message #273921 is a reply to message #273899] Fri, 12 October 2007 04:23 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
Hi Michel this following starting to alter database database completed

Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =46
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 = 384
sessions = 427
sga_max_size = 1073741824
__shared_pool_size = 134217728
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 4194304
sga_target = 1073741824
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL03.CTL
db_block_size = 16384
__db_cache_size = 918552576
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\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=PACCMINXDB)
job_queue_processes = 20
parallel_instance_group = 2
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\CDUMP
db_name = PACCMIN
open_cursors = 300
optimizer_mode = FIRST_ROWS
parallel_threads_per_cpu = 8
parallel_automatic_tuning= TRUE
pga_aggregate_target = 419430400
Deprecated system parameters with specified values:
parallel_automatic_tuning
End of deprecated system parameter listing
PMON started with pid=2, OS id=5800
PSP0 started with pid=3, OS id=4616
MMAN started with pid=4, OS id=5976
DBW0 started with pid=5, OS id=4716
LGWR started with pid=6, OS id=3436
CKPT started with pid=7, OS id=5944
SMON started with pid=8, OS id=4332
RECO started with pid=9, OS id=5140
CJQ0 started with pid=10, OS id=3296
MMON started with pid=11, OS id=2720
MMNL started with pid=12, OS id=3592
Wed Oct 10 17:05:30 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Oct 10 17:05:30 2007
alter database mount exclusive
Wed Oct 10 17:05:34 2007
Setting recovery target incarnation to 1
Wed Oct 10 17:05:34 2007
Successful mount of redo thread 1, with mount id 3470946394
Wed Oct 10 17:05:34 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Oct 10 17:05:34 2007
alter database open
Wed Oct 10 17:05:35 2007
Thread 1 opened at log sequence 1144
Current log# 1 seq# 1144 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Successful open of redo thread 1
Wed Oct 10 17:05:35 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Oct 10 17:05:35 2007
SMON: enabling cache recovery
Wed Oct 10 17:05:35 2007
Successfully onlined Undo Tablespace 1.
Wed Oct 10 17:05:35 2007
SMON: enabling tx recovery
Wed Oct 10 17:05:35 2007
Database Characterset is TH8TISASCII
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=6028
Wed Oct 10 17:05:38 2007
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.
Wed Oct 10 17:05:38 2007
Completed: alter database open
Wed Oct 10 17:05:42 2007
Thread 1 advanced to log sequence 1145
Current log# 2 seq# 1145 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:08:57 2007
Thread 1 advanced to log sequence 1146
Current log# 3 seq# 1146 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1147
Checkpoint not complete
Current log# 3 seq# 1146 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:09:07 2007
Thread 1 advanced to log sequence 1147
Current log# 1 seq# 1147 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:09:23 2007
Thread 1 advanced to log sequence 1148
Current log# 2 seq# 1148 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1149
Checkpoint not complete
Current log# 2 seq# 1148 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1149
Current log# 3 seq# 1149 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:09:46 2007
Thread 1 advanced to log sequence 1150
Current log# 1 seq# 1150 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1151
Checkpoint not complete
Current log# 1 seq# 1150 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:09:57 2007
Thread 1 advanced to log sequence 1151
Current log# 2 seq# 1151 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:10:12 2007
Thread 1 advanced to log sequence 1152
Current log# 3 seq# 1152 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1153
Checkpoint not complete
Current log# 3 seq# 1152 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:10:22 2007
Thread 1 advanced to log sequence 1153
Current log# 1 seq# 1153 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:10:39 2007
Thread 1 advanced to log sequence 1154
Current log# 2 seq# 1154 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1155
Checkpoint not complete
Current log# 2 seq# 1154 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1155
Current log# 3 seq# 1155 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:11:04 2007
Thread 1 advanced to log sequence 1156
Current log# 1 seq# 1156 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1157
Checkpoint not complete
Current log# 1 seq# 1156 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:11:14 2007
Thread 1 advanced to log sequence 1157
Current log# 2 seq# 1157 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:11:30 2007
Thread 1 advanced to log sequence 1158
Current log# 3 seq# 1158 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1159
Checkpoint not complete
Current log# 3 seq# 1158 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1159
Current log# 1 seq# 1159 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:11:53 2007
Thread 1 advanced to log sequence 1160
Current log# 2 seq# 1160 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1161
Checkpoint not complete
Current log# 2 seq# 1160 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1161
Current log# 3 seq# 1161 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:12:16 2007
Thread 1 advanced to log sequence 1162
Current log# 1 seq# 1162 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1163
Checkpoint not complete
Current log# 1 seq# 1162 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1163
Current log# 2 seq# 1163 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:12:37 2007
Thread 1 advanced to log sequence 1164
Current log# 3 seq# 1164 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1165
Checkpoint not complete
Current log# 3 seq# 1164 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1165
Current log# 1 seq# 1165 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:12:59 2007
Thread 1 advanced to log sequence 1166
Current log# 2 seq# 1166 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1167
Checkpoint not complete
Current log# 2 seq# 1166 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:13:10 2007
Thread 1 advanced to log sequence 1167
Current log# 3 seq# 1167 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:13:23 2007
Thread 1 advanced to log sequence 1168
Current log# 1 seq# 1168 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1169
Checkpoint not complete
Current log# 1 seq# 1168 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:13:33 2007
Thread 1 advanced to log sequence 1169
Current log# 2 seq# 1169 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:13:46 2007
Thread 1 advanced to log sequence 1170
Current log# 3 seq# 1170 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1171
Checkpoint not complete
Current log# 3 seq# 1170 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1171
Current log# 1 seq# 1171 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:14:10 2007
Thread 1 advanced to log sequence 1172
Current log# 2 seq# 1172 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1173
Checkpoint not complete
Current log# 2 seq# 1172 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:14:22 2007
Thread 1 advanced to log sequence 1173
Current log# 3 seq# 1173 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:14:36 2007
Thread 1 cannot allocate new log, sequence 1174
Checkpoint not complete
Current log# 3 seq# 1173 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1174
Current log# 1 seq# 1174 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:14:47 2007
Thread 1 advanced to log sequence 1175
Current log# 2 seq# 1175 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:14:58 2007
Thread 1 cannot allocate new log, sequence 1176
Checkpoint not complete
Current log# 2 seq# 1175 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1176
Current log# 3 seq# 1176 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:15:12 2007
Thread 1 advanced to log sequence 1177
Current log# 1 seq# 1177 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:15:24 2007
Thread 1 cannot allocate new log, sequence 1178
Checkpoint not complete
Current log# 1 seq# 1177 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1178
Current log# 2 seq# 1178 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:15:40 2007
Thread 1 advanced to log sequence 1179
Current log# 3 seq# 1179 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:15:52 2007
Thread 1 cannot allocate new log, sequence 1180
Checkpoint not complete
Current log# 3 seq# 1179 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1180
Current log# 1 seq# 1180 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:16:06 2007
Thread 1 advanced to log sequence 1181
Current log# 2 seq# 1181 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1182
Checkpoint not complete
Current log# 2 seq# 1181 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:16:17 2007
Thread 1 advanced to log sequence 1182
Current log# 3 seq# 1182 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:16:29 2007
Thread 1 advanced to log sequence 1183
Current log# 1 seq# 1183 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1184
Checkpoint not complete
Current log# 1 seq# 1183 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:16:41 2007
Thread 1 advanced to log sequence 1184
Current log# 2 seq# 1184 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:16:54 2007
Thread 1 advanced to log sequence 1185
Current log# 3 seq# 1185 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1186
Checkpoint not complete
Current log# 3 seq# 1185 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:17:04 2007
Thread 1 advanced to log sequence 1186
Current log# 1 seq# 1186 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:17:17 2007
Thread 1 advanced to log sequence 1187
Current log# 2 seq# 1187 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1188
Checkpoint not complete
Current log# 2 seq# 1187 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:17:27 2007
Thread 1 advanced to log sequence 1188
Current log# 3 seq# 1188 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:17:39 2007
Thread 1 advanced to log sequence 1189
Current log# 1 seq# 1189 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1190
Checkpoint not complete
Current log# 1 seq# 1189 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1190
Current log# 2 seq# 1190 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:17:59 2007
Thread 1 advanced to log sequence 1191
Current log# 3 seq# 1191 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1192
Checkpoint not complete
Current log# 3 seq# 1191 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1192
Current log# 1 seq# 1192 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:18:17 2007
Thread 1 advanced to log sequence 1193
Current log# 2 seq# 1193 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1194
Checkpoint not complete
Current log# 2 seq# 1193 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1194
Current log# 3 seq# 1194 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:18:36 2007
Thread 1 advanced to log sequence 1195
Current log# 1 seq# 1195 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1196
Checkpoint not complete
Current log# 1 seq# 1195 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1196
Current log# 2 seq# 1196 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:18:55 2007
Thread 1 advanced to log sequence 1197
Current log# 3 seq# 1197 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1198
Checkpoint not complete
Current log# 3 seq# 1197 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1198
Current log# 1 seq# 1198 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:19:14 2007
Thread 1 advanced to log sequence 1199
Current log# 2 seq# 1199 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1200
Checkpoint not complete
Current log# 2 seq# 1199 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:19:28 2007
Thread 1 advanced to log sequence 1200
Current log# 3 seq# 1200 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1201
Current log# 1 seq# 1201 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1202
Checkpoint not complete
Current log# 1 seq# 1201 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1202
Current log# 2 seq# 1202 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:19:47 2007
Thread 1 advanced to log sequence 1203
Current log# 3 seq# 1203 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1204
Checkpoint not complete
Current log# 3 seq# 1203 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Dump file d:\oracle\product\10.2.0\admin\paccmin\bdump\alert_paccmin.log
Wed Oct 10 17:30:22 2007
ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V5.2 Service Pack 2
CPU : 4 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:6624M/8190M, Ph+PgF:9403M/10820M
Wed Oct 10 17:30:22 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =46
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 = 384
sessions = 427
sga_max_size = 1073741824
__shared_pool_size = 121634816
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 4194304
sga_target = 1073741824
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL03.CTL
db_block_size = 16384
__db_cache_size = 931135488
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\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=PACCMINXDB)
job_queue_processes = 20
parallel_instance_group = 2
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\CDUMP
db_name = PACCMIN
open_cursors = 300
optimizer_mode = FIRST_ROWS
parallel_threads_per_cpu = 8
parallel_automatic_tuning= TRUE
pga_aggregate_target = 419430400
Deprecated system parameters with specified values:
parallel_automatic_tuning
End of deprecated system parameter listing
PSP0 started with pid=3, OS id=4496
PMON started with pid=2, OS id=4492
MMAN started with pid=4, OS id=4500
DBW0 started with pid=5, OS id=4504
LGWR started with pid=6, OS id=4508
CKPT started with pid=7, OS id=4512
SMON started with pid=8, OS id=4516
RECO started with pid=9, OS id=4520
CJQ0 started with pid=10, OS id=4524
MMON started with pid=11, OS id=4528
MMNL started with pid=12, OS id=4532
Wed Oct 10 17:30:23 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Oct 10 17:30:24 2007
alter database mount exclusive
Wed Oct 10 17:30:29 2007
Setting recovery target incarnation to 1
Wed Oct 10 17:30:29 2007
Successful mount of redo thread 1, with mount id 3470930992
Wed Oct 10 17:30:29 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Oct 10 17:30:29 2007
alter database open
Wed Oct 10 17:30:29 2007
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Wed Oct 10 17:30:29 2007
Started redo scan
Wed Oct 10 17:30:31 2007
Completed redo scan
237555 redo blocks read, 12841 data blocks need recovery
Wed Oct 10 17:30:38 2007
Started redo application at
Thread 1: logseq 1201, block 38239
Wed Oct 10 17:30:38 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1201 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:30:38 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1202 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:30:40 2007
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1203 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:30:46 2007
Completed redo application
Wed Oct 10 17:30:48 2007
Completed crash recovery at
Thread 1: logseq 1203, block 91922, scn 10811637
12841 data blocks read, 11442 data blocks written, 237555 redo blocks read
Wed Oct 10 17:30:49 2007
Thread 1 advanced to log sequence 1204
Thread 1 opened at log sequence 1204
Current log# 1 seq# 1204 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Successful open of redo thread 1
Wed Oct 10 17:30:49 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Oct 10 17:30:49 2007
SMON: enabling cache recovery
Wed Oct 10 17:30:51 2007
Successfully onlined Undo Tablespace 1.
Wed Oct 10 17:30:51 2007
SMON: enabling tx recovery
Wed Oct 10 17:30:51 2007
Database Characterset is TH8TISASCII
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=24, OS id=4616
Wed Oct 10 17:31:03 2007
Completed: alter database open
Wed Oct 10 17:31:03 2007
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.
Wed Oct 10 17:31:57 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 3597K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Wed Oct 10 17:32:00 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 3655K exceeds notification threshold (2048K)
Details in trace file d:\oracle\product\10.2.0\admin\paccmin\udump\paccmin_ora_4780.trc
KGL object name :XDB.XDGsQoAKuASp+S/RkOapfGzw==

Wed Oct 10 17:32:03 2007
Thread 1 advanced to log sequence 1205
Current log# 2 seq# 1205 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:32:45 2007
Thread 1 advanced to log sequence 1206
Current log# 3 seq# 1206 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:33:56 2007
Thread 1 advanced to log sequence 1207
Current log# 1 seq# 1207 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:34:26 2007
Thread 1 advanced to log sequence 1208
Current log# 2 seq# 1208 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:35:36 2007
Thread 1 cannot allocate new log, sequence 1209
Checkpoint not complete
Current log# 2 seq# 1208 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:35:56 2007
Thread 1 advanced to log sequence 1209
Current log# 3 seq# 1209 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:36:14 2007
Thread 1 advanced to log sequence 1210
Current log# 1 seq# 1210 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:37:05 2007
Thread 1 cannot allocate new log, sequence 1211
Checkpoint not complete
Current log# 1 seq# 1210 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:37:19 2007
Thread 1 advanced to log sequence 1211
Current log# 2 seq# 1211 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:37:57 2007
Thread 1 advanced to log sequence 1212
Current log# 3 seq# 1212 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:38:39 2007
Thread 1 cannot allocate new log, sequence 1213
Checkpoint not complete
Current log# 3 seq# 1212 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:38:55 2007
Thread 1 advanced to log sequence 1213
Current log# 1 seq# 1213 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:39:28 2007
Thread 1 advanced to log sequence 1214
Current log# 2 seq# 1214 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:39:56 2007
Thread 1 cannot allocate new log, sequence 1215
Checkpoint not complete
Current log# 2 seq# 1214 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:40:30 2007
Thread 1 advanced to log sequence 1215
Current log# 3 seq# 1215 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:41:12 2007
Thread 1 advanced to log sequence 1216
Current log# 1 seq# 1216 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:41:41 2007
Thread 1 cannot allocate new log, sequence 1217
Checkpoint not complete
Current log# 1 seq# 1216 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1217
Current log# 2 seq# 1217 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:42:42 2007
Thread 1 advanced to log sequence 1218
Current log# 3 seq# 1218 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:43:14 2007
Thread 1 cannot allocate new log, sequence 1219
Checkpoint not complete
Current log# 3 seq# 1218 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1219
Current log# 1 seq# 1219 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:43:29 2007
Thread 1 advanced to log sequence 1220
Current log# 2 seq# 1220 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1221
Checkpoint not complete
Current log# 2 seq# 1220 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:44:12 2007
Thread 1 advanced to log sequence 1221
Current log# 3 seq# 1221 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:44:40 2007
Thread 1 advanced to log sequence 1222
Current log# 1 seq# 1222 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1223
Checkpoint not complete
Current log# 1 seq# 1222 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:45:15 2007
Thread 1 advanced to log sequence 1223
Current log# 2 seq# 1223 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:45:48 2007
Thread 1 advanced to log sequence 1224
Current log# 3 seq# 1224 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:46:15 2007
Thread 1 advanced to log sequence 1225
Current log# 1 seq# 1225 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:46:49 2007
Thread 1 cannot allocate new log, sequence 1226
Checkpoint not complete
Current log# 1 seq# 1225 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:47:03 2007
Thread 1 advanced to log sequence 1226
Current log# 2 seq# 1226 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1227
Current log# 3 seq# 1227 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:47:35 2007
Thread 1 cannot allocate new log, sequence 1228
Checkpoint not complete
Current log# 3 seq# 1227 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:48:02 2007
Thread 1 advanced to log sequence 1228
Current log# 1 seq# 1228 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:48:46 2007
Thread 1 advanced to log sequence 1229
Current log# 2 seq# 1229 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:48:59 2007
Thread 1 cannot allocate new log, sequence 1230
Checkpoint not complete
Current log# 2 seq# 1229 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1230
Current log# 3 seq# 1230 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:49:37 2007
Thread 1 advanced to log sequence 1231
Current log# 1 seq# 1231 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:49:51 2007
Thread 1 cannot allocate new log, sequence 1232
Checkpoint not complete
Current log# 1 seq# 1231 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1232
Current log# 2 seq# 1232 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:50:13 2007
Thread 1 cannot allocate new log, sequence 1233
Checkpoint not complete
Current log# 2 seq# 1232 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1233
Current log# 3 seq# 1233 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:50:35 2007
Thread 1 advanced to log sequence 1234
Current log# 1 seq# 1234 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:50:37 2007
SMON: Parallel transaction recovery tried
Wed Oct 10 17:50:50 2007
Thread 1 cannot allocate new log, sequence 1235
Checkpoint not complete
Current log# 1 seq# 1234 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:51:01 2007
Thread 1 advanced to log sequence 1235
Current log# 2 seq# 1235 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1236
Current log# 3 seq# 1236 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:51:19 2007
Thread 1 cannot allocate new log, sequence 1237
Checkpoint not complete
Current log# 3 seq# 1236 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1237
Current log# 1 seq# 1237 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:51:36 2007
Thread 1 advanced to log sequence 1238
Current log# 2 seq# 1238 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:51:48 2007
Thread 1 cannot allocate new log, sequence 1239
Checkpoint not complete
Current log# 2 seq# 1238 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1239
Current log# 3 seq# 1239 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:52:04 2007
Thread 1 advanced to log sequence 1240
Current log# 1 seq# 1240 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1241
Checkpoint not complete
Current log# 1 seq# 1240 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:52:15 2007
Thread 1 advanced to log sequence 1241
Current log# 2 seq# 1241 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:52:30 2007
Thread 1 advanced to log sequence 1242
Current log# 3 seq# 1242 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1243
Checkpoint not complete
Current log# 3 seq# 1242 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1243
Current log# 1 seq# 1243 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:52:58 2007
Thread 1 advanced to log sequence 1244
Current log# 2 seq# 1244 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1245
Checkpoint not complete
Current log# 2 seq# 1244 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:53:08 2007
Thread 1 advanced to log sequence 1245
Current log# 3 seq# 1245 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:53:24 2007
Thread 1 advanced to log sequence 1246
Current log# 1 seq# 1246 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1247
Checkpoint not complete
Current log# 1 seq# 1246 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:53:34 2007
Thread 1 advanced to log sequence 1247
Current log# 2 seq# 1247 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:53:48 2007
Thread 1 advanced to log sequence 1248
Current log# 3 seq# 1248 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1249
Checkpoint not complete
Current log# 3 seq# 1248 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1249
Current log# 1 seq# 1249 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:54:11 2007
Thread 1 advanced to log sequence 1250
Current log# 2 seq# 1250 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1251
Checkpoint not complete
Current log# 2 seq# 1250 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1251
Current log# 3 seq# 1251 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:54:34 2007
Thread 1 advanced to log sequence 1252
Current log# 1 seq# 1252 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1253
Checkpoint not complete
Current log# 1 seq# 1252 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1253
Current log# 2 seq# 1253 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:54:57 2007
Thread 1 advanced to log sequence 1254
Current log# 3 seq# 1254 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1255
Checkpoint not complete
Current log# 3 seq# 1254 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1255
Current log# 1 seq# 1255 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:55:21 2007
Thread 1 advanced to log sequence 1256
Current log# 2 seq# 1256 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1257
Checkpoint not complete
Current log# 2 seq# 1256 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1257
Current log# 3 seq# 1257 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:55:47 2007
Thread 1 advanced to log sequence 1258
Current log# 1 seq# 1258 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:56:00 2007
Thread 1 cannot allocate new log, sequence 1259
Checkpoint not complete
Current log# 1 seq# 1258 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1259
Current log# 2 seq# 1259 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:56:21 2007
Thread 1 advanced to log sequence 1260
Current log# 3 seq# 1260 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1261
Checkpoint not complete
Current log# 3 seq# 1260 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:56:32 2007
Thread 1 advanced to log sequence 1261
Current log# 1 seq# 1261 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:56:50 2007
Thread 1 advanced to log sequence 1262
Current log# 2 seq# 1262 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:57:01 2007
Thread 1 cannot allocate new log, sequence 1263
Checkpoint not complete
Current log# 2 seq# 1262 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1263
Current log# 3 seq# 1263 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:57:21 2007
Thread 1 advanced to log sequence 1264
Current log# 1 seq# 1264 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:57:33 2007
Thread 1 cannot allocate new log, sequence 1265
Checkpoint not complete
Current log# 1 seq# 1264 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1265
Current log# 2 seq# 1265 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:57:52 2007
Thread 1 advanced to log sequence 1266
Current log# 3 seq# 1266 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1267
Checkpoint not complete
Current log# 3 seq# 1266 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:58:03 2007
Thread 1 advanced to log sequence 1267
Current log# 1 seq# 1267 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:58:21 2007
Thread 1 advanced to log sequence 1268
Current log# 2 seq# 1268 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1269
Checkpoint not complete
Current log# 2 seq# 1268 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:58:32 2007
Thread 1 advanced to log sequence 1269
Current log# 3 seq# 1269 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 17:58:44 2007
Thread 1 advanced to log sequence 1270
Current log# 1 seq# 1270 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1271
Checkpoint not complete
Current log# 1 seq# 1270 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:58:57 2007
Thread 1 advanced to log sequence 1271
Current log# 2 seq# 1271 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:59:09 2007
Thread 1 advanced to log sequence 1272
Current log# 3 seq# 1272 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1273
Checkpoint not complete
Current log# 3 seq# 1272 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1273
Current log# 1 seq# 1273 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 17:59:35 2007
Thread 1 advanced to log sequence 1274
Current log# 2 seq# 1274 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1275
Checkpoint not complete
Current log# 2 seq# 1274 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 17:59:46 2007
Thread 1 advanced to log sequence 1275
Current log# 3 seq# 1275 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:00:00 2007
Thread 1 advanced to log sequence 1276
Current log# 1 seq# 1276 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1277
Checkpoint not complete
Current log# 1 seq# 1276 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1277
Current log# 2 seq# 1277 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:00:24 2007
Thread 1 advanced to log sequence 1278
Current log# 3 seq# 1278 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:00:37 2007
Thread 1 advanced to log sequence 1279
Current log# 1 seq# 1279 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1280
Checkpoint not complete
Current log# 1 seq# 1279 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:00:49 2007
Thread 1 advanced to log sequence 1280
Current log# 2 seq# 1280 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1281
Current log# 3 seq# 1281 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:01:11 2007
Thread 1 cannot allocate new log, sequence 1282
Checkpoint not complete
Current log# 3 seq# 1281 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1282
Current log# 1 seq# 1282 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:01:22 2007
Thread 1 advanced to log sequence 1283
Current log# 2 seq# 1283 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:01:36 2007
Thread 1 cannot allocate new log, sequence 1284
Checkpoint not complete
Current log# 2 seq# 1283 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1284
Current log# 3 seq# 1284 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:01:47 2007
Thread 1 advanced to log sequence 1285
Current log# 1 seq# 1285 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:01:59 2007
Thread 1 cannot allocate new log, sequence 1286
Checkpoint not complete
Current log# 1 seq# 1285 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1286
Current log# 2 seq# 1286 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:02:10 2007
Thread 1 advanced to log sequence 1287
Current log# 3 seq# 1287 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1288
Checkpoint not complete
Current log# 3 seq# 1287 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:02:23 2007
Thread 1 advanced to log sequence 1288
Current log# 1 seq# 1288 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1289
Current log# 2 seq# 1289 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:02:34 2007
Thread 1 cannot allocate new log, sequence 1290
Checkpoint not complete
Current log# 2 seq# 1289 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1290
Current log# 3 seq# 1290 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:02:48 2007
Thread 1 advanced to log sequence 1291
Current log# 1 seq# 1291 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1292
Checkpoint not complete
Current log# 1 seq# 1291 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:03:01 2007
Thread 1 advanced to log sequence 1292
Current log# 2 seq# 1292 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:03:12 2007
Thread 1 advanced to log sequence 1293
Current log# 3 seq# 1293 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1294
Checkpoint not complete
Current log# 3 seq# 1293 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1294
Current log# 1 seq# 1294 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:03:33 2007
Thread 1 cannot allocate new log, sequence 1295
Checkpoint not complete
Current log# 1 seq# 1294 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1295
Current log# 2 seq# 1295 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1296
Current log# 3 seq# 1296 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:03:53 2007
Thread 1 cannot allocate new log, sequence 1297
Checkpoint not complete
Current log# 3 seq# 1296 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1297
Current log# 1 seq# 1297 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1298
Current log# 2 seq# 1298 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:04:15 2007
Thread 1 cannot allocate new log, sequence 1299
Checkpoint not complete
Current log# 2 seq# 1298 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1299
Current log# 3 seq# 1299 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:04:26 2007
Thread 1 cannot allocate new log, sequence 1300
Checkpoint not complete
Current log# 3 seq# 1299 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1300
Current log# 1 seq# 1300 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:04:39 2007
Thread 1 advanced to log sequence 1301
Current log# 2 seq# 1301 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1302
Checkpoint not complete
Current log# 2 seq# 1301 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1302
Current log# 3 seq# 1302 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:05:02 2007
Thread 1 advanced to log sequence 1303
Current log# 1 seq# 1303 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:05:13 2007
Thread 1 cannot allocate new log, sequence 1304
Checkpoint not complete
Current log# 1 seq# 1303 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1304
Current log# 2 seq# 1304 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:05:32 2007
Thread 1 advanced to log sequence 1305
Current log# 3 seq# 1305 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1306
Checkpoint not complete
Current log# 3 seq# 1305 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:05:44 2007
Thread 1 advanced to log sequence 1306
Current log# 1 seq# 1306 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:05:57 2007
Thread 1 cannot allocate new log, sequence 1307
Checkpoint not complete
Current log# 1 seq# 1306 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1307
Current log# 2 seq# 1307 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:06:11 2007
Thread 1 advanced to log sequence 1308
Current log# 3 seq# 1308 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:06:27 2007
Thread 1 cannot allocate new log, sequence 1309
Checkpoint not complete
Current log# 3 seq# 1308 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1309
Current log# 1 seq# 1309 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:06:41 2007
Thread 1 advanced to log sequence 1310
Current log# 2 seq# 1310 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1311
Checkpoint not complete
Current log# 2 seq# 1310 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:07:07 2007
Thread 1 advanced to log sequence 1311
Current log# 3 seq# 1311 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1312
Current log# 1 seq# 1312 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:07:18 2007
Thread 1 cannot allocate new log, sequence 1313
Checkpoint not complete
Current log# 1 seq# 1312 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:07:36 2007
Thread 1 advanced to log sequence 1313
Current log# 2 seq# 1313 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1314
Current log# 3 seq# 1314 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:07:47 2007
Thread 1 cannot allocate new log, sequence 1315
Checkpoint not complete
Current log# 3 seq# 1314 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1315
Current log# 1 seq# 1315 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:08:07 2007
Thread 1 advanced to log sequence 1316
Current log# 2 seq# 1316 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1317
Checkpoint not complete
Current log# 2 seq# 1316 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1317
Current log# 3 seq# 1317 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:08:32 2007
Thread 1 advanced to log sequence 1318
Current log# 1 seq# 1318 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1319
Checkpoint not complete
Current log# 1 seq# 1318 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:08:56 2007
Thread 1 advanced to log sequence 1319
Current log# 2 seq# 1319 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1320
Current log# 3 seq# 1320 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:09:07 2007
Thread 1 cannot allocate new log, sequence 1321
Checkpoint not complete
Current log# 3 seq# 1320 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1321
Current log# 1 seq# 1321 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:09:33 2007
Thread 1 advanced to log sequence 1322
Current log# 2 seq# 1322 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1323
Checkpoint not complete
Current log# 2 seq# 1322 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:09:44 2007
Thread 1 advanced to log sequence 1323
Current log# 3 seq# 1323 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:10:02 2007
Thread 1 advanced to log sequence 1324
Current log# 1 seq# 1324 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1325
Checkpoint not complete
Current log# 1 seq# 1324 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1325
Current log# 2 seq# 1325 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:10:29 2007
Thread 1 advanced to log sequence 1326
Current log# 3 seq# 1326 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1327
Checkpoint not complete
Current log# 3 seq# 1326 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1327
Current log# 1 seq# 1327 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:10:55 2007
Thread 1 advanced to log sequence 1328
Current log# 2 seq# 1328 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 cannot allocate new log, sequence 1329
Checkpoint not complete
Current log# 2 seq# 1328 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1329
Current log# 3 seq# 1329 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:11:29 2007
Thread 1 advanced to log sequence 1330
Current log# 1 seq# 1330 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 cannot allocate new log, sequence 1331
Checkpoint not complete
Current log# 1 seq# 1330 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1331
Current log# 2 seq# 1331 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:12:00 2007
Thread 1 advanced to log sequence 1332
Current log# 3 seq# 1332 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 cannot allocate new log, sequence 1333
Checkpoint not complete
Current log# 3 seq# 1332 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:12:11 2007
Thread 1 advanced to log sequence 1333
Current log# 1 seq# 1333 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:12:31 2007
Thread 1 advanced to log sequence 1334
Current log# 2 seq# 1334 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:12:44 2007
Thread 1 cannot allocate new log, sequence 1335
Checkpoint not complete
Current log# 2 seq# 1334 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1335
Current log# 3 seq# 1335 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:13:20 2007
Thread 1 advanced to log sequence 1336
Current log# 1 seq# 1336 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:13:48 2007
Thread 1 advanced to log sequence 1337
Current log# 2 seq# 1337 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:14:21 2007
Thread 1 advanced to log sequence 1338
Current log# 3 seq# 1338 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:14:43 2007
Thread 1 cannot allocate new log, sequence 1339
Checkpoint not complete
Current log# 3 seq# 1338 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:15:07 2007
Thread 1 advanced to log sequence 1339
Current log# 1 seq# 1339 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:15:17 2007
Thread 1 advanced to log sequence 1340
Current log# 2 seq# 1340 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:15:33 2007
Thread 1 cannot allocate new log, sequence 1341
Checkpoint not complete
Current log# 2 seq# 1340 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1341
Current log# 3 seq# 1341 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:16:11 2007
Thread 1 advanced to log sequence 1342
Current log# 1 seq# 1342 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:16:27 2007
Thread 1 cannot allocate new log, sequence 1343
Checkpoint not complete
Current log# 1 seq# 1342 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1343
Current log# 2 seq# 1343 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:17:09 2007
Thread 1 advanced to log sequence 1344
Current log# 3 seq# 1344 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:17:28 2007
Thread 1 cannot allocate new log, sequence 1345
Checkpoint not complete
Current log# 3 seq# 1344 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1345
Current log# 1 seq# 1345 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:18:05 2007
Thread 1 advanced to log sequence 1346
Current log# 2 seq# 1346 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:18:24 2007
Thread 1 cannot allocate new log, sequence 1347
Checkpoint not complete
Current log# 2 seq# 1346 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1347
Current log# 3 seq# 1347 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:19:03 2007
Thread 1 advanced to log sequence 1348
Current log# 1 seq# 1348 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:19:21 2007
Thread 1 cannot allocate new log, sequence 1349
Checkpoint not complete
Current log# 1 seq# 1348 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1349
Current log# 2 seq# 1349 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:20:03 2007
Thread 1 advanced to log sequence 1350
Current log# 3 seq# 1350 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:20:22 2007
Thread 1 cannot allocate new log, sequence 1351
Checkpoint not complete
Current log# 3 seq# 1350 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1351
Current log# 1 seq# 1351 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:21:11 2007
Thread 1 cannot allocate new log, sequence 1352
Checkpoint not complete
Current log# 1 seq# 1351 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Thread 1 advanced to log sequence 1352
Current log# 2 seq# 1352 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:21:37 2007
Thread 1 advanced to log sequence 1353
Current log# 3 seq# 1353 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:22:18 2007
Thread 1 advanced to log sequence 1354
Current log# 1 seq# 1354 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:22:34 2007
Thread 1 cannot allocate new log, sequence 1355
Checkpoint not complete
Current log# 1 seq# 1354 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:22:55 2007
Thread 1 advanced to log sequence 1355
Current log# 2 seq# 1355 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1356
Current log# 3 seq# 1356 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:23:10 2007
Starting background process EMN0
EMN0 started with pid=22, OS id=4224
Wed Oct 10 18:23:10 2007
Shutting down instance: further logons disabled
Wed Oct 10 18:23:33 2007
Stopping background process CJQ0
Wed Oct 10 18:23:33 2007
Stopping background process QMNC
Wed Oct 10 18:23:35 2007
Stopping background process MMNL
Wed Oct 10 18:23:36 2007
Stopping background process MMON
Wed Oct 10 18:23:37 2007
Shutting down instance (immediate)
License high water mark = 15
Wed Oct 10 18:23:37 2007
Stopping Job queue slave processes
Wed Oct 10 18:23:37 2007
Job queue slave processes stopped
Wed Oct 10 18:23:43 2007
Thread 1 advanced to log sequence 1357
Current log# 1 seq# 1357 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:23:53 2007
Thread 1 advanced to log sequence 1358
Current log# 2 seq# 1358 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:24:20 2007
Thread 1 cannot allocate new log, sequence 1359
Checkpoint not complete
Current log# 2 seq# 1358 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1359
Current log# 3 seq# 1359 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:24:35 2007
Thread 1 advanced to log sequence 1360
Current log# 1 seq# 1360 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Dump file d:\oracle\product\10.2.0\admin\paccmin\bdump\alert_paccmin.log
Wed Oct 10 18:24:36 2007
ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V5.2 Service Pack 2
CPU : 4 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:5501M/8190M, Ph+PgF:8211M/10820M
Wed Oct 10 18:24:36 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =46
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 = 384
sessions = 427
sga_max_size = 1073741824
__shared_pool_size = 121634816
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 4194304
sga_target = 1073741824
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL03.CTL
db_block_size = 16384
__db_cache_size = 931135488
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\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=PACCMINXDB)
job_queue_processes = 20
parallel_instance_group = 2
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\CDUMP
db_name = PACCMIN
open_cursors = 300
optimizer_mode = FIRST_ROWS
parallel_threads_per_cpu = 8
parallel_automatic_tuning= TRUE
pga_aggregate_target = 419430400
Deprecated system parameters with specified values:
parallel_automatic_tuning
End of deprecated system parameter listing
PMON started with pid=2, OS id=4820
PSP0 started with pid=3, OS id=3564
MMAN started with pid=4, OS id=4732
DBW0 started with pid=5, OS id=396
LGWR started with pid=6, OS id=3672
CKPT started with pid=7, OS id=4912
SMON started with pid=8, OS id=332
RECO started with pid=9, OS id=4644
CJQ0 started with pid=10, OS id=512
MMON started with pid=11, OS id=4548
MMNL started with pid=12, OS id=4824
Wed Oct 10 18:24:37 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Oct 10 18:24:37 2007
alter database mount exclusive
Wed Oct 10 18:24:41 2007
Setting recovery target incarnation to 1
Wed Oct 10 18:24:41 2007
Successful mount of redo thread 1, with mount id 3470976229
Wed Oct 10 18:24:41 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Oct 10 18:24:41 2007
alter database open
Wed Oct 10 18:24:41 2007
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Wed Oct 10 18:24:41 2007
Started redo scan
Wed Oct 10 18:24:42 2007
Completed redo scan
191936 redo blocks read, 16651 data blocks need recovery
Wed Oct 10 18:24:54 2007
Started redo application at
Thread 1: logseq 1358, block 28
Wed Oct 10 18:24:54 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1358 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:24:55 2007
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1359 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:25:00 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1360 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:25:08 2007
Completed redo application
Wed Oct 10 18:25:11 2007
Completed crash recovery at
Thread 1: logseq 1360, block 8092, scn 11239150
16651 data blocks read, 16651 data blocks written, 191936 redo blocks read
Wed Oct 10 18:25:11 2007
Thread 1 advanced to log sequence 1361
Thread 1 opened at log sequence 1361
Current log# 2 seq# 1361 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Successful open of redo thread 1
Wed Oct 10 18:25:11 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Oct 10 18:25:11 2007
SMON: enabling cache recovery
Wed Oct 10 18:25:12 2007
Successfully onlined Undo Tablespace 1.
Wed Oct 10 18:25:12 2007
SMON: enabling tx recovery
Wed Oct 10 18:25:12 2007
Database Characterset is TH8TISASCII
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=24, OS id=4792
Wed Oct 10 18:25:31 2007
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.
Wed Oct 10 18:25:33 2007
Completed: alter database open
Wed Oct 10 18:26:01 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 3623K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Wed Oct 10 18:26:05 2007
Memory Notification: Library Cache Object loaded into SGA
Heap size 3686K exceeds notification threshold (2048K)
Details in trace file d:\oracle\product\10.2.0\admin\paccmin\udump\paccmin_ora_4588.trc
KGL object name :XDB.XDGsQoAKuASp+S/RkOapfGzw==

Wed Oct 10 18:26:31 2007
Thread 1 advanced to log sequence 1362
Current log# 3 seq# 1362 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:27:26 2007
Thread 1 advanced to log sequence 1363
Current log# 1 seq# 1363 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:28:38 2007
Thread 1 advanced to log sequence 1364
Current log# 2 seq# 1364 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:29:05 2007
Thread 1 cannot allocate new log, sequence 1365
Checkpoint not complete
Current log# 2 seq# 1364 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:29:17 2007
Thread 1 advanced to log sequence 1365
Current log# 3 seq# 1365 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:30:29 2007
Thread 1 advanced to log sequence 1366
Current log# 1 seq# 1366 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:31:29 2007
Thread 1 advanced to log sequence 1367
Current log# 2 seq# 1367 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:32:24 2007
Thread 1 cannot allocate new log, sequence 1368
Checkpoint not complete
Current log# 2 seq# 1367 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Thread 1 advanced to log sequence 1368
Current log# 3 seq# 1368 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:32:55 2007
Thread 1 advanced to log sequence 1369
Current log# 1 seq# 1369 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:33:52 2007
Thread 1 cannot allocate new log, sequence 1370
Checkpoint not complete
Current log# 1 seq# 1369 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:34:09 2007
Thread 1 advanced to log sequence 1370
Current log# 2 seq# 1370 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:34:32 2007
ALTER SYSTEM SET parallel_server=TRUE SCOPE=SPFILE;
Wed Oct 10 18:34:49 2007
Thread 1 advanced to log sequence 1371
Current log# 3 seq# 1371 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:35:37 2007
Thread 1 cannot allocate new log, sequence 1372
Checkpoint not complete
Current log# 3 seq# 1371 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Thread 1 advanced to log sequence 1372
Current log# 1 seq# 1372 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:36:00 2007
Thread 1 advanced to log sequence 1373
Current log# 2 seq# 1373 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:36:12 2007
Starting background process EMN0
EMN0 started with pid=27, OS id=4688
Wed Oct 10 18:36:12 2007
Shutting down instance: further logons disabled
Wed Oct 10 18:37:15 2007
Stopping background process CJQ0
Wed Oct 10 18:37:16 2007
Stopping background process QMNC
Wed Oct 10 18:37:16 2007
Stopping background process MMNL
Wed Oct 10 18:37:17 2007
Stopping background process MMON
Wed Oct 10 18:37:18 2007
Shutting down instance (immediate)
License high water mark = 13
Wed Oct 10 18:37:18 2007
Stopping Job queue slave processes
Wed Oct 10 18:37:18 2007
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Oct 10 18:37:21 2007
alter database close normal
Wed Oct 10 18:37:26 2007
Thread 1 advanced to log sequence 1374
Current log# 3 seq# 1374 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG

[Updated on: Fri, 12 October 2007 11:00] by Moderator

Report message to a moderator

Re: ora-12514 after i restart the service [message #273931 is a reply to message #273921] Fri, 12 October 2007 04:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I give up. You are not able to provide what I asked and only that so I think you are not understanding what I'm saying and so you are not able to fix the problem (if there is still one which I don't understand).

Regards
Michel
Re: ora-12514 after i restart the service [message #273984 is a reply to message #273613] Fri, 12 October 2007 09:50 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
Hi Michel,
Thanks you very much for you help and effort. If there is some example you can provide on the statement you mentioned :"
Post the part containing the whole startup, from "startup" to "alter database open completed".", then it will be much helpful.

Arigato,
Thanach
Re: ora-12514 after i restart the service [message #273994 is a reply to message #273984] Fri, 12 October 2007 11:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See red lines in your previous message.

Regards
Michel
Re: ora-12514 after i restart the service [message #274000 is a reply to message #273613] Fri, 12 October 2007 11:15 Go to previous messageGo to next message
thanach
Messages: 14
Registered: October 2007
Location: Thailand
Junior Member
Ok. i got what you mean. sorry for misunderstood previously.
Now, i HOPE this is what you want, else i believe there is a major communication barrier happening here.
I hope i can get the solution in the next reply based on your experience and expertise. If you can't provide any solution, just forget it.

The error log requested by you as below:

Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =46
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 = 384
sessions = 427
sga_max_size = 1073741824
__shared_pool_size = 121634816
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 4194304
sga_target = 1073741824
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\CONTROL03.CTL
db_block_size = 16384
__db_cache_size = 931135488
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = D:\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=PACCMINXDB)
job_queue_processes = 20
parallel_instance_group = 2
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\PACCMIN\CDUMP
db_name = PACCMIN
open_cursors = 300
optimizer_mode = FIRST_ROWS
parallel_threads_per_cpu = 8
parallel_automatic_tuning= TRUE
pga_aggregate_target = 419430400
Deprecated system parameters with specified values:
parallel_automatic_tuning
End of deprecated system parameter listing
PMON started with pid=2, OS id=4820
PSP0 started with pid=3, OS id=3564
MMAN started with pid=4, OS id=4732
DBW0 started with pid=5, OS id=396
LGWR started with pid=6, OS id=3672
CKPT started with pid=7, OS id=4912
SMON started with pid=8, OS id=332
RECO started with pid=9, OS id=4644
CJQ0 started with pid=10, OS id=512
MMON started with pid=11, OS id=4548
MMNL started with pid=12, OS id=4824
Wed Oct 10 18:24:37 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Oct 10 18:24:37 2007
alter database mount exclusive
Wed Oct 10 18:24:41 2007
Setting recovery target incarnation to 1
Wed Oct 10 18:24:41 2007
Successful mount of redo thread 1, with mount id 3470976229
Wed Oct 10 18:24:41 2007
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Oct 10 18:24:41 2007
alter database open
Wed Oct 10 18:24:41 2007
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Wed Oct 10 18:24:41 2007
Started redo scan
Wed Oct 10 18:24:42 2007
Completed redo scan
191936 redo blocks read, 16651 data blocks need recovery
Wed Oct 10 18:24:54 2007
Started redo application at
Thread 1: logseq 1358, block 28
Wed Oct 10 18:24:54 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1358 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Wed Oct 10 18:24:55 2007
Recovery of Online Redo Log: Thread 1 Group 3 Seq 1359 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO03.LOG
Wed Oct 10 18:25:00 2007
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1360 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO01.LOG
Wed Oct 10 18:25:08 2007
Completed redo application
Wed Oct 10 18:25:11 2007
Completed crash recovery at
Thread 1: logseq 1360, block 8092, scn 11239150
16651 data blocks read, 16651 data blocks written, 191936 redo blocks read
Wed Oct 10 18:25:11 2007
Thread 1 advanced to log sequence 1361
Thread 1 opened at log sequence 1361
Current log# 2 seq# 1361 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\PACCMIN\REDO02.LOG
Successful open of redo thread 1
Wed Oct 10 18:25:11 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Oct 10 18:25:11 2007
SMON: enabling cache recovery
Wed Oct 10 18:25:12 2007
Successfully onlined Undo Tablespace 1.
Wed Oct 10 18:25:12 2007
SMON: enabling tx recovery
Wed Oct 10 18:25:12 2007
Database Characterset is TH8TISASCII
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=24, OS id=4792
Wed Oct 10 18:25:31 2007
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.
Wed Oct 10 18:25:33 2007
Completed: alter database open

Thanks very much
Thanach.
Re: ora-12514 after i restart the service [message #274001 is a reply to message #274000] Fri, 12 October 2007 11:17 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But is there still an error?

Regards
Michel
Previous Topic: ORA-12547: TNS:lost contact (merged)
Next Topic: ora -12547 TNS: lost contact
Goto Forum:
  


Current Time: Thu Dec 08 00:18:47 CST 2016

Total time taken to generate the page: 0.20613 seconds