Home » RDBMS Server » Enterprise Manager » emctl start dbconsole
| emctl start dbconsole [message #244010] |
Mon, 11 June 2007 05:08  |
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
|
Member |
|
|
After Database startup,we use the 'emclt start dbconsole' then we get
TZ set to Asia/Calcutta
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://linuxserver1:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ........................ started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/oracle/product/10.2.0/db_1/linuxserver1_oratest/sysman/log
after that we connect to database through sqlplus , then we get the error
ORA-01033: ORACLE initialization or shutdown in progress
the emoms.trc,emagent.trc also contains this message.
how this happend , what is the solution .
thanks in advance
|
|
|
|
| Re: emctl start dbconsole [message #244080 is a reply to message #244010] |
Mon, 11 June 2007 09:56  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | ORA-01033: ORACLE initialization or shutdown in progress
|
you getting this error when you connecting as simple user.
whats your last 100 entries in alertlog file.
|
|
|
|
| Re: emctl start dbconsole [message #245148 is a reply to message #244080] |
Fri, 15 June 2007 05:33 |
shiju_t_v
Messages: 56
Registered: May 2007
Location: kannur,kerala
|
Member |
|
|
Fri Jun 15 00:20:44 2007
Incremental checkpoint up to RBA [0x213.cc2a.0], current log tail at RBA [0x213.13823.0]
Fri Jun 15 00:50:46 2007
Incremental checkpoint up to RBA [0x213.154e0.0], current log tail at RBA [0x213.15590.0]
Fri Jun 15 01:20:47 2007
Incremental checkpoint up to RBA [0x213.159f7.0], current log tail at RBA [0x213.15a8d.0]
Fri Jun 15 01:50:48 2007
Incremental checkpoint up to RBA [0x213.162a9.0], current log tail at RBA [0x213.162ee.0]
Fri Jun 15 02:20:49 2007
Incremental checkpoint up to RBA [0x213.165fb.0], current log tail at RBA [0x213.166ca.0]
Fri Jun 15 02:30:47 2007
Beginning log switch checkpoint up to RBA [0x214.2.10], SCN: 12200098
Thread 1 advanced to log sequence 532
Current log# 3 seq# 532 mem# 0: /u01/app/oracle/oradata/oratest/redo03.log
Fri Jun 15 02:35:51 2007
Completed checkpoint up to RBA [0x214.2.10], SCN: 12200098
Fri Jun 15 02:50:51 2007
Incremental checkpoint up to RBA [0x214.29a.0], current log tail at RBA [0x214.33b.0]
Fri Jun 15 03:20:52 2007
Incremental checkpoint up to RBA [0x214.674.0], current log tail at RBA [0x214.6ca.0]
Fri Jun 15 03:50:53 2007
Incremental checkpoint up to RBA [0x214.e88.0], current log tail at RBA [0x214.ed5.0]
Fri Jun 15 04:20:54 2007
Incremental checkpoint up to RBA [0x214.120b.0], current log tail at RBA [0x214.1266.0]
Fri Jun 15 04:50:56 2007
Incremental checkpoint up to RBA [0x214.199d.0], current log tail at RBA [0x214.1a33.0]
Fri Jun 15 05:20:57 2007
Incremental checkpoint up to RBA [0x214.1d3d.0], current log tail at RBA [0x214.1dea.0]
Fri Jun 15 05:50:58 2007
Incremental checkpoint up to RBA [0x214.24e5.0], current log tail at RBA [0x214.251b.0]
Fri Jun 15 06:20:59 2007
Incremental checkpoint up to RBA [0x214.2878.0], current log tail at RBA [0x214.28c7.0]
Fri Jun 15 06:51:00 2007
Incremental checkpoint up to RBA [0x214.2f3d.0], current log tail at RBA [0x214.2fce.0]
Fri Jun 15 07:13:35 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
sga_max_size = 385875968
__shared_pool_size = 113246208
shared_pool_size = 113246208
__large_pool_size = 29360128
large_pool_size = 29360128
__java_pool_size = 75497472
java_pool_size = 75497472
__streams_pool_size = 0
streams_pool_size = 0
sga_target = 385875968
control_files = /u01/app/oracle/oradata/oratest/control01.ctl, /u01/app/oracle/oradata/oratest/control02.ctl, /u01/app/oracle/oradata/oratest/control03.ctl
db_block_size = 8192
__db_cache_size = 159383552
db_cache_size = 159383552
compatible = 10.2.0.1.0
log_archive_dest_1 = LOCATION=/u01/app/oracle/admin/oratest/arch
log_archive_max_processes= 1
log_archive_format = %t_%s_%r.dbf
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
log_checkpoints_to_alert = TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=oratestXDB)
plsql_compiler_flags = NATIVE, NON_DEBUG
plsql_native_library_dir = /u01/app/oracle/oracle/product/10.2.0/db_1/plsql/lib
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/oratest/bdump
user_dump_dest = /u01/app/oracle/admin/oratest/udump
core_dump_dest = /u01/app/oracle/admin/oratest/cdump
audit_file_dest = /u01/app/oracle/admin/oratest/adump
db_name = oratest
open_cursors = 1500
sql_trace = FALSE
pga_aggregate_target = 94371840
Deprecated system parameters with specified values:
plsql_compiler_flags
sql_trace
End of deprecated system parameter listing
PMON started with pid=2, OS id=3198
MMAN started with pid=4, OS id=3202
PSP0 started with pid=3, OS id=3200
DBW0 started with pid=5, OS id=3204
LGWR started with pid=6, OS id=3206
CKPT started with pid=7, OS id=3208
SMON started with pid=8, OS id=3210
RECO started with pid=9, OS id=3212
CJQ0 started with pid=10, OS id=3214
MMON started with pid=11, OS id=3216
Fri Jun 15 07:13:37 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3218
Fri Jun 15 07:13:37 2007
starting up 1 shared server(s) ...
Fri Jun 15 07:13:38 2007
ALTER DATABASE MOUNT
Fri Jun 15 07:13:42 2007
Setting recovery target incarnation to 1
Fri Jun 15 07:13:43 2007
Successful mount of redo thread 1, with mount id 3160709794
Fri Jun 15 07:13:43 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Jun 15 07:13:43 2007
ALTER DATABASE OPEN
Fri Jun 15 07:13:43 2007
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Fri Jun 15 07:13:43 2007
Started redo scan
Fri Jun 15 07:13:43 2007
Completed redo scan
150 redo blocks read, 52 data blocks need recovery
Fri Jun 15 07:13:44 2007
Started redo application at
Thread 1: logseq 532, block 12710
Fri Jun 15 07:13:44 2007
Recovery of Online Redo Log: Thread 1 Group 3 Seq 532 Reading mem 0
Mem# 0 errs 0: /u01/app/oracle/oradata/oratest/redo03.log
Fri Jun 15 07:13:44 2007
Completed redo application
Fri Jun 15 07:13:44 2007
Completed crash recovery at
Thread 1: logseq 532, block 12860, scn 12229700
52 data blocks read, 52 data blocks written, 150 redo blocks read
Fri Jun 15 07:13:44 2007
LGWR: STARTING ARCH PROCESSES
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0 started with pid=18, OS id=3230
Fri Jun 15 07:13:44 2007
Thread 1 advanced to log sequence 533
Thread 1 opened at log sequence 533
Current log# 1 seq# 533 mem# 0: /u01/app/oracle/oradata/oratest/redo01.log
Successful open of redo thread 1
Fri Jun 15 07:13:44 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jun 15 07:13:44 2007
ARC0: STARTING ARCH PROCESSES
ARC1: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC0: Becoming the heartbeat ARCH
ARC1 started with pid=19, OS id=3232
Fri Jun 15 07:13:45 2007
SMON: enabling cache recovery
Fri Jun 15 07:13:46 2007
Incremental checkpoint up to RBA [0x215.3.0], current log tail at RBA [0x215.3.0]
Fri Jun 15 07:13:47 2007
Successfully onlined Undo Tablespace 1.
Fri Jun 15 07:13:47 2007
SMON: enabling tx recovery
Fri Jun 15 07:13:47 2007
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=20, OS id=3234
Fri Jun 15 07:13:54 2007
db_recovery_file_dest_size of 2048 MB is 79.65% 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.
Fri Jun 15 07:13:54 2007
Completed: ALTER DATABASE OPEN
Fri Jun 15 07:19:44 2007
Shutting down archive processes
Fri Jun 15 07:19:49 2007
ARCH shutting down
ARC1: Archival stopped
Fri Jun 15 07:43:51 2007
Incremental checkpoint up to RBA [0x215.8f7.0], current log tail at RBA [0x215.9a2.0]
Fri Jun 15 08:13:52 2007
Incremental checkpoint up to RBA [0x215.ee4.0], current log tail at RBA [0x215.1007.0]
Fri Jun 15 08:43:53 2007
Incremental checkpoint up to RBA [0x215.1795.0], current log tail at RBA [0x215.17e2.0]
Fri Jun 15 09:13:55 2007
Incremental checkpoint up to RBA [0x215.1c2b.0], current log tail at RBA [0x215.1c72.0]
Fri Jun 15 09:43:56 2007
Incremental checkpoint up to RBA [0x215.23f5.0], current log tail at RBA [0x215.248f.0]
Fri Jun 15 10:13:57 2007
Incremental checkpoint up to RBA [0x215.28a3.0], current log tail at RBA [0x215.2931.0]
Fri Jun 15 10:43:58 2007
Incremental checkpoint up to RBA [0x215.30e6.0], current log tail at RBA [0x215.3130.0]
Fri Jun 15 11:13:59 2007
Incremental checkpoint up to RBA [0x215.3594.0], current log tail at RBA [0x215.35e4.0]
Fri Jun 15 11:44:00 2007
Incremental checkpoint up to RBA [0x215.3d3b.0], current log tail at RBA [0x215.3dd6.0]
Fri Jun 15 12:14:02 2007
Incremental checkpoint up to RBA [0x215.4365.0], current log tail at RBA [0x215.43fe.0]
Fri Jun 15 12:43:08 2007
alter tablespace DATABASETEST begin backup
Fri Jun 15 12:43:08 2007
Completed: alter tablespace DATABASETEST begin backup
Fri Jun 15 12:44:05 2007
Incremental checkpoint up to RBA [0x215.4c37.0], current log tail at RBA [0x215.4c74.0]
Fri Jun 15 12:44:18 2007
alter tablespace DATABASETEST end backup
Fri Jun 15 12:44:18 2007
Completed: alter tablespace DATABASETEST end backup
Fri Jun 15 12:44:19 2007
alter tablespace EXAMPLE begin backup
Completed: alter tablespace EXAMPLE begin backup
Fri Jun 15 12:44:25 2007
alter tablespace EXAMPLE end backup
Fri Jun 15 12:44:25 2007
Completed: alter tablespace EXAMPLE end backup
Fri Jun 15 12:44:26 2007
alter tablespace RCVCAT begin backup
Completed: alter tablespace RCVCAT begin backup
Fri Jun 15 12:44:47 2007
alter tablespace RCVCAT end backup
Completed: alter tablespace RCVCAT end backup
Fri Jun 15 12:44:48 2007
alter tablespace SYSAUX begin backup
Completed: alter tablespace SYSAUX begin backup
Fri Jun 15 12:45:07 2007
alter tablespace SYSAUX end backup
Completed: alter tablespace SYSAUX end backup
Fri Jun 15 12:45:07 2007
alter tablespace SYSTEM begin backup
Completed: alter tablespace SYSTEM begin backup
Fri Jun 15 12:45:32 2007
alter tablespace SYSTEM end backup
Completed: alter tablespace SYSTEM end backup
Fri Jun 15 12:45:33 2007
alter tablespace UNDOTBS1 begin backup
Completed: alter tablespace UNDOTBS1 begin backup
Fri Jun 15 12:45:38 2007
alter tablespace UNDOTBS1 end backup
Completed: alter tablespace UNDOTBS1 end backup
Fri Jun 15 12:45:39 2007
alter tablespace USERS begin backup
Completed: alter tablespace USERS begin backup
Fri Jun 15 12:45:40 2007
alter tablespace USERS end backup
Completed: alter tablespace USERS end backup
Fri Jun 15 12:45:40 2007
alter database backup controlfile to '/u01/app/oracle/admin/oratest/hot/controlfile_dir/backup_control.ctl'
Completed: alter database backup controlfile to '/u01/app/oracle/admin/oratest/hot/controlfile_dir/backup_control.ctl'
Fri Jun 15 12:45:41 2007
alter database backup controlfile to trace
Completed: alter database backup controlfile to trace
Fri Jun 15 12:45:42 2007
Beginning log switch checkpoint up to RBA [0x216.2.10], SCN: 12242838
Thread 1 advanced to log sequence 534
Current log# 2 seq# 534 mem# 0: /u01/app/oracle/oradata/oratest/redo02.log
Fri Jun 15 12:45:42 2007
ARCHIVE LOG STOP has been deprecated - see ALTER DATABASE ARCHIVELOG
ARCHIVE LOG START has been deprecated - see ALTER DATABASE ARCHIVELOG
Fri Jun 15 12:50:57 2007
Completed checkpoint up to RBA [0x216.2.10], SCN: 12242838
Fri Jun 15 13:14:09 2007
Incremental checkpoint up to RBA [0x216.354.0], current log tail at RBA [0x216.3a2.0]
Fri Jun 15 13:44:10 2007
Incremental checkpoint up to RBA [0x216.b51.0], current log tail at RBA [0x216.ba9.0]
Fri Jun 15 14:01:07 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
sga_max_size = 385875968
__shared_pool_size = 113246208
shared_pool_size = 113246208
__large_pool_size = 29360128
large_pool_size = 29360128
__java_pool_size = 75497472
java_pool_size = 75497472
__streams_pool_size = 0
streams_pool_size = 0
sga_target = 385875968
control_files = /u01/app/oracle/oradata/oratest/control01.ctl, /u01/app/oracle/oradata/oratest/control02.ctl, /u01/app/oracle/oradata/oratest/control03.ctl
db_block_size = 8192
__db_cache_size = 159383552
db_cache_size = 159383552
compatible = 10.2.0.1.0
log_archive_dest_1 = LOCATION=/u01/app/oracle/admin/oratest/arch
log_archive_max_processes= 1
log_archive_format = %t_%s_%r.dbf
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
log_checkpoints_to_alert = TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=oratestXDB)
plsql_compiler_flags = NATIVE, NON_DEBUG
plsql_native_library_dir = /u01/app/oracle/oracle/product/10.2.0/db_1/plsql/lib
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/oratest/bdump
user_dump_dest = /u01/app/oracle/admin/oratest/udump
core_dump_dest = /u01/app/oracle/admin/oratest/cdump
audit_file_dest = /u01/app/oracle/admin/oratest/adump
db_name = oratest
open_cursors = 1500
sql_trace = FALSE
pga_aggregate_target = 94371840
Deprecated system parameters with specified values:
plsql_compiler_flags
sql_trace
End of deprecated system parameter listing
PSP0 started with pid=3, OS id=3198
PMON started with pid=2, OS id=3196
MMAN started with pid=4, OS id=3200
DBW0 started with pid=5, OS id=3202
LGWR started with pid=6, OS id=3204
CKPT started with pid=7, OS id=3206
SMON started with pid=8, OS id=3208
RECO started with pid=9, OS id=3210
CJQ0 started with pid=10, OS id=3212
MMON started with pid=11, OS id=3214
Fri Jun 15 14:01:09 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3216
Fri Jun 15 14:01:09 2007
starting up 1 shared server(s) ...
Fri Jun 15 14:01:10 2007
ALTER DATABASE MOUNT
Fri Jun 15 14:01:14 2007
Setting recovery target incarnation to 1
Fri Jun 15 14:01:14 2007
Successful mount of redo thread 1, with mount id 3160712486
Fri Jun 15 14:01:14 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Jun 15 14:01:15 2007
ALTER DATABASE OPEN
Fri Jun 15 14:01:15 2007
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Fri Jun 15 14:01:15 2007
Started redo scan
Fri Jun 15 14:01:15 2007
Completed redo scan
297 redo blocks read, 68 data blocks need recovery
Fri Jun 15 14:01:16 2007
Started redo application at
Thread 1: logseq 534, block 2988
Fri Jun 15 14:01:16 2007
Recovery of Online Redo Log: Thread 1 Group 2 Seq 534 Reading mem 0
Mem# 0 errs 0: /u01/app/oracle/oradata/oratest/redo02.log
Fri Jun 15 14:01:16 2007
Completed redo application
Fri Jun 15 14:01:16 2007
Completed crash recovery at
Thread 1: logseq 534, block 3285, scn 12265211
68 data blocks read, 68 data blocks written, 297 redo blocks read
Fri Jun 15 14:01:16 2007
LGWR: STARTING ARCH PROCESSES
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0 started with pid=18, OS id=3228
Fri Jun 15 14:01:16 2007
Thread 1 advanced to log sequence 535
Thread 1 opened at log sequence 535
Current log# 3 seq# 535 mem# 0: /u01/app/oracle/oradata/oratest/redo03.log
Successful open of redo thread 1
Fri Jun 15 14:01:16 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jun 15 14:01:16 2007
ARC0: STARTING ARCH PROCESSES
ARC1: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC0: Becoming the heartbeat ARCH
ARC1 started with pid=19, OS id=3230
Fri Jun 15 14:01:17 2007
SMON: enabling cache recovery
Fri Jun 15 14:01:18 2007
Incremental checkpoint up to RBA [0x217.3.0], current log tail at RBA [0x217.3.0]
Fri Jun 15 14:01:19 2007
Successfully onlined Undo Tablespace 1.
Fri Jun 15 14:01:19 2007
SMON: enabling tx recovery
Fri Jun 15 14:01:19 2007
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=20, OS id=3232
Fri Jun 15 14:01:26 2007
db_recovery_file_dest_size of 2048 MB is 79.65% 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.
Fri Jun 15 14:01:26 2007
Completed: ALTER DATABASE OPEN
Fri Jun 15 14:07:16 2007
Shutting down archive processes
Fri Jun 15 14:07:21 2007
ARCH shutting down
ARC1: Archival stopped
Fri Jun 15 14:31:23 2007
Incremental checkpoint up to RBA [0x217.583.0], current log tail at RBA [0x217.aa3.0]
Fri Jun 15 15:01:24 2007
Incremental checkpoint up to RBA [0x217.f80.0], current log tail at RBA [0x217.101d.0]
Fri Jun 15 15:31:26 2007
Incremental checkpoint up to RBA [0x217.12ff.0], current log tail at RBA [0x217.1850.0]
Fri Jun 15 15:51:48 2007
Starting background process EMN0
EMN0 started with pid=33, OS id=8440
Fri Jun 15 15:51:48 2007
Shutting down instance: further logons disabled
Fri Jun 15 15:51:50 2007
Stopping background process QMNC
Fri Jun 15 15:51:50 2007
Stopping background process CJQ0
Fri Jun 15 15:51:52 2007
Stopping background process MMNL
Fri Jun 15 15:51:53 2007
Stopping background process MMON
Fri Jun 15 15:51:54 2007
Shutting down instance (immediate)
License high water mark = 14
Fri Jun 15 15:51:54 2007
Stopping Job queue slave processes
Fri Jun 15 15:51:54 2007
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Fri Jun 15 15:52:05 2007
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Fri Jun 15 15:52:18 2007
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Fri Jun 15 15:52:21 2007
ALTER DATABASE CLOSE NORMAL
Fri Jun 15 15:52:22 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jun 15 15:52:22 2007
Shutting down archive processes
Archiving is disabled
Fri Jun 15 15:52:27 2007
ARCH shutting down
ARC0: Archival stopped
Fri Jun 15 15:52:28 2007
Thread 1 closed at log sequence 535
Successful close of redo thread 1
Fri Jun 15 15:52:28 2007
Completed: ALTER DATABASE CLOSE NORMAL
Fri Jun 15 15:52:28 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Jun 15 15:52:30 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
sga_max_size = 385875968
__shared_pool_size = 113246208
shared_pool_size = 113246208
__large_pool_size = 29360128
large_pool_size = 29360128
__java_pool_size = 75497472
java_pool_size = 75497472
__streams_pool_size = 0
streams_pool_size = 0
sga_target = 385875968
control_files = /u01/app/oracle/oradata/oratest/control01.ctl, /u01/app/oracle/oradata/oratest/control02.ctl, /u01/app/oracle/oradata/oratest/control03.ctl
db_block_size = 8192
__db_cache_size = 159383552
db_cache_size = 159383552
compatible = 10.2.0.1.0
log_archive_dest_1 = LOCATION=/u01/app/oracle/admin/oratest/arch
log_archive_max_processes= 1
log_archive_format = %t_%s_%r.dbf
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
log_checkpoints_to_alert = TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=oratestXDB)
plsql_compiler_flags = NATIVE, NON_DEBUG
plsql_native_library_dir = /u01/app/oracle/oracle/product/10.2.0/db_1/plsql/lib
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/oratest/bdump
user_dump_dest = /u01/app/oracle/admin/oratest/udump
core_dump_dest = /u01/app/oracle/admin/oratest/cdump
audit_file_dest = /u01/app/oracle/admin/oratest/adump
db_name = oratest
open_cursors = 1500
sql_trace = FALSE
pga_aggregate_target = 94371840
Deprecated system parameters with specified values:
plsql_compiler_flags
sql_trace
End of deprecated system parameter listing
PMON started with pid=2, OS id=8490
PSP0 started with pid=3, OS id=8492
MMAN started with pid=4, OS id=8494
DBW0 started with pid=5, OS id=8496
LGWR started with pid=6, OS id=8498
CKPT started with pid=7, OS id=8500
SMON started with pid=8, OS id=8502
RECO started with pid=9, OS id=8504
CJQ0 started with pid=10, OS id=8506
MMON started with pid=11, OS id=8508
Fri Jun 15 15:52:31 2007
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=8510
Fri Jun 15 15:52:31 2007
starting up 1 shared server(s) ...
Fri Jun 15 15:52:31 2007
ALTER DATABASE MOUNT
Fri Jun 15 15:52:35 2007
Setting recovery target incarnation to 1
Fri Jun 15 15:52:35 2007
Successful mount of redo thread 1, with mount id 3160715583
Fri Jun 15 15:52:35 2007
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Jun 15 15:52:40 2007
db_recovery_file_dest_size of 2048 MB is 79.65% 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.
Fri Jun 15 15:53:11 2007
Errors in file /u01/app/oracle/admin/oratest/udump/oratest_ora_8529.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 86.98% used, and has 279658496 remaining bytes available.
Fri Jun 15 15:53:11 2007
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Jun 15 15:53:49 2007
Deleted Oracle managed file /u01/app/oracle/flash_recovery_area/ORATEST/backupset/2007_06_02/o1_mf_ncsn1_TAG20070602T140059_362br7fd_.bkp
Fri Jun 15 15:53:49 2007
Errors in file /u01/app/oracle/admin/oratest/udump/oratest_ora_8529.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.84% used, and has 24969216 remaining bytes available.
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Fri Jun 15 15:53:54 2007
Errors in file /u01/app/oracle/admin/oratest/udump/oratest_ora_8529.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.96% used, and has 22364160 remaining bytes available.
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Deleted Oracle managed file /u01/app/oracle/flash_recovery_area/ORATEST/backupset/2007_06_15/o1_mf_nnnd1_TAG20070615T155239_374t3jfm_.bkp
db_recovery_file_dest_size of 2048 MB is 79.65% 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.
Fri Jun 15 15:53:58 2007
Errors in file /u01/app/oracle/admin/oratest/udump/oratest_ora_8529.trc:
Fri Jun 15 15:53:58 2007
Errors in file /u01/app/oracle/admin/oratest/udump/oratest_ora_8529.trc:
Fri Jun 15 15:53:58 2007
Errors in file /u01/app/oracle/admin/oratest/udump/oratest_ora_8529.trc:
Fri Jun 15 15:54:00 2007
alter database open
Fri Jun 15 15:54:00 2007
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=8853
Fri Jun 15 15:54:00 2007
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 535
Current log# 3 seq# 535 mem# 0: /u01/app/oracle/oradata/oratest/redo03.log
Successful open of redo thread 1
Fri Jun 15 15:54:01 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jun 15 15:54:01 2007
ARC0: STARTING ARCH PROCESSES
ARC1: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC0: Becoming the heartbeat ARCH
ARC1 started with pid=17, OS id=8855
Fri Jun 15 15:54:01 2007
SMON: enabling cache recovery
Fri Jun 15 15:54:02 2007
Incremental checkpoint up to RBA [0x217.9ddb.0], current log tail at RBA [0x217.9ddb.0]
Fri Jun 15 15:54:04 2007
Successfully onlined Undo Tablespace 1.
Fri Jun 15 15:54:04 2007
SMON: enabling tx recovery
Fri Jun 15 15:54:04 2007
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=18, OS id=8862
Fri Jun 15 15:54:14 2007
Completed: alter database open
Fri Jun 15 16:00:00 2007
Shutting down archive processes
Fri Jun 15 16:00:05 2007
ARCH shutting down
ARC1: Archival stopped
|
|
|
|
| Re: emctl start dbconsole [message #245250 is a reply to message #245148] |
Fri, 15 June 2007 11:37 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | after that we connect to database through sqlplus , then we get the error
ORA-01033: ORACLE initialization or shutdown in progress
|
I guess you are connecting as normal user.
Try to connect as SYS
sqlplus '/as sysdba'
[Updated on: Fri, 15 June 2007 11:37] Report message to a moderator |
|
|
|
|
|
Goto Forum:
Current Time: Mon Nov 25 23:42:55 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
