今天开始一登录oracle就会停在那里,PLSQLDEVOLE就会崩溃。
以下是alert.log信息
Wed Sep 07 15:35:24 2011
Starting background process EMN0
EMN0 started with pid=18, OS id=784
Wed Sep 07 15:35:24 2011
Shutting down instance: further logons disabled
Wed Sep 07 15:35:24 2011
Stopping background process QMNC
Wed Sep 07 15:35:24 2011
Stopping background process CJQ0
Wed Sep 07 15:35:26 2011
Stopping background process MMNL
Wed Sep 07 15:35:27 2011
Stopping background process MMON
Wed Sep 07 15:35:29 2011
Shutting down instance (immediate)
License high water = 6
Wed Sep 07 15:35:29 2011
Stopping Job queue slave processes
Wed Sep 07 15:35:29 2011
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Sep 07 15:35:36 2011
alter database close normal
Wed Sep 07 15:35:36 2011
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Sep 07 15:35:36 2011
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 304
Successful close of redo thread 1
Wed Sep 07 15:35:36 2011
Completed: alter database close normal
Wed Sep 07 15:35:36 2011
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
Dump file f:\database\oracle/admin/orcl10/bdump\alert_orcl10.log
Wed Sep 07 15:36:37 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:910M/2042M, Ph+PgF:2852M/3930M, VA:1940M/2047M
Wed Sep 07 15:36:37 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 92274688
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = F:\DATABASE\ORACLE\ORACLEAPP\DBS\SPFILEORCL10.ORA
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 314572800
control_files = F:\DATABASE\ORACLE\ORADATA\ORCL10\CONTROL01.CTL, F:\DATABASE\ORACLE\ORADATA\ORCL10\CONTROL02.CTL, F:\DATABASE\ORACLE\ORADATA\ORCL10\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 205520896
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\database\oracle/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=orcl10XDB)
job_queue_processes = 10
audit_file_dest = F:\DATABASE\ORACLE\ADMIN\ORCL10\ADUMP
background_dump_dest = F:\DATABASE\ORACLE\ADMIN\ORCL10\BDUMP
user_dump_dest = F:\DATABASE\ORACLE\ADMIN\ORCL10\UDUMP
core_dump_dest = F:\DATABASE\ORACLE\ADMIN\ORCL10\CDUMP
db_name = orcl10
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2484
PSP0 started with pid=3, OS id=3632
MMAN started with pid=4, OS id=1544
DBW0 started with pid=5, OS id=3512
LGWR started with pid=6, OS id=2268
CKPT started with pid=7, OS id=1396
SMON started with pid=8, OS id=1376
RECO started with pid=9, OS id=3844
CJQ0 started with pid=10, OS id=1976
MMON started with pid=11, OS id=3052
Wed Sep 07 15:36:38 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Sep 07 15:36:39 2011
alter database mount exclusive
MMNL started with pid=12, OS id=2288
Wed Sep 07 15:36:43 2011
Setting recovery target incarnation to 2
Wed Sep 07 15:36:43 2011
Successful mount of redo thread 1, with mount id 3969202439
Wed Sep 07 15:36:43 2011
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Sep 07 15:36:43 2011
alter database open
Wed Sep 07 15:36:43 2011
Thread 1 opened at log sequence 304
Current log# 3 seq# 304 mem# 0: F:\DATABASE\ORACLE\ORADATA\ORCL10\REDO03.LOG
Successful open of redo thread 1
Wed Sep 07 15:36:43 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Sep 07 15:36:43 2011
SMON: enabling cache recovery
Wed Sep 07 15:36:45 2011
Successfully onlined Undo Tablespace 1.
Wed Sep 07 15:36:45 2011
SMON: enabling tx recovery
Wed Sep 07 15:36:45 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=3584
Wed Sep 07 15:36:50 2011
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 Sep 07 15:36:50 2011
Completed: alter database open
过了一会就报错了:
Wed Sep 07 16:10:00 2011
Errors in file f:\database\oracle\admin\orcl10\bdump\orcl10_j001_2408.trc:
ORA-12012: 自动执行作业 52554 出错
ORA-06576: 不是有效的函数或过程名Wed Sep 07 16:10:00 2011
Errors in file f:\database\oracle\admin\orcl10\bdump\orcl10_j001_2408.trc:
ORA-12012: 自动执行作业 54724 出错
ORA-06575: 程序包或函数 ORA-06575: 程序包或函数 PROSTATXVIEWTEMPDATAALL 处于无效状态
处于无效状态Wed Sep 07 16:10:00 2011
Errors in file f:\database\oracle\admin\orcl10\bdump\orcl10_j000_4000.trc:
ORA-12012: 自动执行作业 55699 出错
ORA-06575: 程序包或函数 ORA-06575: 程序包或函数 PROSTATXVIEWTEMPDATAALL 处于无效状态
处于无效状态
以下是alert.log信息
Wed Sep 07 15:35:24 2011
Starting background process EMN0
EMN0 started with pid=18, OS id=784
Wed Sep 07 15:35:24 2011
Shutting down instance: further logons disabled
Wed Sep 07 15:35:24 2011
Stopping background process QMNC
Wed Sep 07 15:35:24 2011
Stopping background process CJQ0
Wed Sep 07 15:35:26 2011
Stopping background process MMNL
Wed Sep 07 15:35:27 2011
Stopping background process MMON
Wed Sep 07 15:35:29 2011
Shutting down instance (immediate)
License high water = 6
Wed Sep 07 15:35:29 2011
Stopping Job queue slave processes
Wed Sep 07 15:35:29 2011
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Wed Sep 07 15:35:36 2011
alter database close normal
Wed Sep 07 15:35:36 2011
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Sep 07 15:35:36 2011
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 304
Successful close of redo thread 1
Wed Sep 07 15:35:36 2011
Completed: alter database close normal
Wed Sep 07 15:35:36 2011
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
Dump file f:\database\oracle/admin/orcl10/bdump\alert_orcl10.log
Wed Sep 07 15:36:37 2011
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows XP Version V5.1 Service Pack 3
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:910M/2042M, Ph+PgF:2852M/3930M, VA:1940M/2047M
Wed Sep 07 15:36:37 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 92274688
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = F:\DATABASE\ORACLE\ORACLEAPP\DBS\SPFILEORCL10.ORA
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 314572800
control_files = F:\DATABASE\ORACLE\ORADATA\ORCL10\CONTROL01.CTL, F:\DATABASE\ORACLE\ORADATA\ORCL10\CONTROL02.CTL, F:\DATABASE\ORACLE\ORADATA\ORCL10\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 205520896
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = F:\database\oracle/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=orcl10XDB)
job_queue_processes = 10
audit_file_dest = F:\DATABASE\ORACLE\ADMIN\ORCL10\ADUMP
background_dump_dest = F:\DATABASE\ORACLE\ADMIN\ORCL10\BDUMP
user_dump_dest = F:\DATABASE\ORACLE\ADMIN\ORCL10\UDUMP
core_dump_dest = F:\DATABASE\ORACLE\ADMIN\ORCL10\CDUMP
db_name = orcl10
open_cursors = 300
pga_aggregate_target = 203423744
PMON started with pid=2, OS id=2484
PSP0 started with pid=3, OS id=3632
MMAN started with pid=4, OS id=1544
DBW0 started with pid=5, OS id=3512
LGWR started with pid=6, OS id=2268
CKPT started with pid=7, OS id=1396
SMON started with pid=8, OS id=1376
RECO started with pid=9, OS id=3844
CJQ0 started with pid=10, OS id=1976
MMON started with pid=11, OS id=3052
Wed Sep 07 15:36:38 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Sep 07 15:36:39 2011
alter database mount exclusive
MMNL started with pid=12, OS id=2288
Wed Sep 07 15:36:43 2011
Setting recovery target incarnation to 2
Wed Sep 07 15:36:43 2011
Successful mount of redo thread 1, with mount id 3969202439
Wed Sep 07 15:36:43 2011
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Sep 07 15:36:43 2011
alter database open
Wed Sep 07 15:36:43 2011
Thread 1 opened at log sequence 304
Current log# 3 seq# 304 mem# 0: F:\DATABASE\ORACLE\ORADATA\ORCL10\REDO03.LOG
Successful open of redo thread 1
Wed Sep 07 15:36:43 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Sep 07 15:36:43 2011
SMON: enabling cache recovery
Wed Sep 07 15:36:45 2011
Successfully onlined Undo Tablespace 1.
Wed Sep 07 15:36:45 2011
SMON: enabling tx recovery
Wed Sep 07 15:36:45 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=3584
Wed Sep 07 15:36:50 2011
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 Sep 07 15:36:50 2011
Completed: alter database open
过了一会就报错了:
Wed Sep 07 16:10:00 2011
Errors in file f:\database\oracle\admin\orcl10\bdump\orcl10_j001_2408.trc:
ORA-12012: 自动执行作业 52554 出错
ORA-06576: 不是有效的函数或过程名Wed Sep 07 16:10:00 2011
Errors in file f:\database\oracle\admin\orcl10\bdump\orcl10_j001_2408.trc:
ORA-12012: 自动执行作业 54724 出错
ORA-06575: 程序包或函数 ORA-06575: 程序包或函数 PROSTATXVIEWTEMPDATAALL 处于无效状态
处于无效状态Wed Sep 07 16:10:00 2011
Errors in file f:\database\oracle\admin\orcl10\bdump\orcl10_j000_4000.trc:
ORA-12012: 自动执行作业 55699 出错
ORA-06575: 程序包或函数 ORA-06575: 程序包或函数 PROSTATXVIEWTEMPDATAALL 处于无效状态
处于无效状态
解决方案 »
- PL/SQL Developer 7.0.3 大家过来帮帮忙
- 关于DBLINK的查询问题
- oracle 9i 监听器启动不了(改了机器名就这样子了)
- 一存储过程调试编译无反应,而其他的则一切正常,盼解决之
- plsql能正常连接,toad报ORA-12154: TNS: 无法解析指定的连接标识符 错误
- 哪里有学习pl/sql的好教程,高分相赠
- 请教高手:在delphi6中, sys或system 等DBA用户如何连接到oracle9i ?
- 在oracle中如何才可以看到数据库的表的记录?
- 客户机连接到服务器的数据库,在profile如何配置
- 不用客户端连接oralce数据库PLSQL10绿色版
- oracle中得函数索引怎么建立,在arcsde中能否建立函数索引
- 连接多个DB的问题
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.db_recovery_file_dest_size或者db_recovery_file_dest错了?
不是成功alter database open 了么
后面报错只是你的3个job执行的时候报package错误
Errors in file f:\database\oracle\admin\orcl10\bdump\orcl10_j001_2408.trc:
ORA-12012: 自动执行作业 52554 出错
ORA-06576: 不是有效的函数或过程名看看52554这个job的what是不是写错了Wed Sep 07 16:10:00 2011
Errors in file f:\database\oracle\admin\orcl10\bdump\orcl10_j001_2408.trc:
ORA-12012: 自动执行作业 54724 出错
ORA-06575: 程序包或函数 ORA-06575: 程序包或函数 PROSTATXVIEWTEMPDATAALL 处于无效状态
处于无效状态Wed Sep 07 16:10:00 2011
Errors in file f:\database\oracle\admin\orcl10\bdump\orcl10_j000_4000.trc:
ORA-12012: 自动执行作业 55699 出错
ORA-06575: 程序包或函数 ORA-06575: 程序包或函数 PROSTATXVIEWTEMPDATAALL 处于无效状态
处于无效状态
手动编译下PROSTATXVIEWTEMPDATAALL 这个