oracle启动卡住了,oracle总是死机

最新推荐文章于 2024-07-22 11:22:30 发布
最新推荐文章于 2024-07-22 11:22:30 发布
阅读量1.1k 收藏
点赞数
文章标签： oracle启动卡住了

客户端在使用过程中总是莫名的死机，

ORACLE所在服务器也挂了，下面是

ALTERLOG日志，大虾们帮分析一下，

急，谢了

Sun Jul 30 09:13:54 2006

ORACLE V9.2.0.4.0 - Production vsnsta=0

vsnsql=12 vsnxtr=3

Windows 2000 Version 5.2 , CPU type 586

Sun Jul 30 09:13:54 2006

Starting ORACLE instance (normal)

Sun Jul 30 09:13:54 2006

Running with 1 strand for Non-Enterprise Edition

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 2

Using log_archive_dest parameter default value

Running with 1 strand for Non-Enterprise Edition

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.4.0.

System parameters with non-default values:

processes                = 150

timed_statistics         = TRUE

shared_pool_size         = 50331648

large_pool_size          = 8388608

java_pool_size           = 33554432

control_files            = D:\oracle\oradata\GDESIGN\CONTROL01.CTL, D:\oracle\oradata\GDESIGN\CONTROL02.CTL, D:\oracle\oradata\GDESIGN\CONTROL03.CTL

db_block_size            = 8192

db_cache_size            = 25165824

compatible               = 9.2.0.0.0

db_file_multiblock_read_count= 16

fast_start_mttr_target   = 0

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

undo_retention           = 10800

remote_login_passwordfile= EXCLUSIVE

db_domain                =

instance_name            = GDES

dispatchers              = (PROTOCOL=TCP) (SERVICE=GDESXDB)

job_queue_processes      = 10

hash_join_enabled        = TRUE

background_dump_dest     = C:\oracle\admin\GDESIGN\bdump

user_dump_dest           = C:\oracle\admin\GDESIGN\udump

core_dump_dest           = C:\oracle\admin\GDESIGN\cdump

sort_area_size           = 524288

db_name                  = GDESIGN

open_cursors             = 300

star_transformation_enabled= FALSE

query_rewrite_enabled    = FALSE

pga_aggregate_target     = 25165824

aq_tm_processes          = 1

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

CJQ0 started with pid=8

QMN0 started with pid=9

Sun Jul 30 09:13:57 2006

starting up 1 shared server(s) ...

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Oracle Data Guard is not available in this edition of Oracle.

Sun Jul 30 09:13:58 2006

alter database mount exclusive

Sun Jul 30 09:14:02 2006

Successful mount of redo thread 1, with mount id 3828910678.

Sun Jul 30 09:14:02 2006

Database mounted in Exclusive Mode.

Completed: alter database mount exclusive

Sun Jul 30 09:14:02 2006

alter database open

Sun Jul 30 09:14:02 2006

Beginning crash recovery of 1 threads

Sun Jul 30 09:14:02 2006

Started recovery at

Thread 1: logseq 1601, block 111268, scn 0.0

Recovery of Online Redo Log: Thread 1 Group 1 Seq 1601 Reading mem 0

Mem# 0 errs 0: D:\ORACLE\ORADATA\GDESIGN\REDO01.LOG

Sun Jul 30 09:14:02 2006

Completed redo application

Sun Jul 30 09:14:02 2006

Ended recovery at

Thread 1: logseq 1601, block 115491, scn 0.195064985

74 data blocks read, 64 data blocks written, 4223 redo blocks read

Crash recovery completed successfully

Sun Jul 30 09:14:02 2006

Thread 1 advanced to log sequence 1602

Thread 1 opened at log sequence 1602

Current log# 2 seq# 1602 mem# 0: D:\ORACLE\ORADATA\GDESIGN\REDO02.LOG

Successful open of redo thread 1.

Sun Jul 30 09:14:02 2006

SMON: enabling cache recovery

Sun Jul 30 09:14:03 2006

Undo Segment 1 Onlined

Undo Segment 2 Onlined

Undo Segment 3 Onlined

Undo Segment 4 Onlined

Undo Segment 5 Onlined

Undo Segment 6 Onlined

Undo Segment 7 Onlined

Undo Segment 8 Onlined

Undo Segment 9 Onlined

Undo Segment 10 Onlined

Successfully onlined Undo Tablespace 1.

Sun Jul 30 09:14:03 2006

SMON: enabling tx recovery

Sun Jul 30 09:14:03 2006

Database Characterset is AL32UTF8

replication_dependency_tracking turned off (no async multimaster replication found)

Completed: alter database open

Dump file c:\oracle\admin\gdesign\bdump\alert_gdes.log

Sun Jul 30 09:45:25 2006

ORACLE V9.2.0.4.0 - Production vsnsta=0

vsnsql=12 vsnxtr=3

Windows 2000 Version 5.2 , CPU type 586

Sun Jul 30 09:45:25 2006

Starting ORACLE instance (normal)

Sun Jul 30 09:45:25 2006

Running with 1 strand for Non-Enterprise Edition

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 2

Using log_archive_dest parameter default value

Running with 1 strand for Non-Enterprise Edition

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.4.0.

System parameters with non-default values:

processes                = 150

timed_statistics         = TRUE

shared_pool_size         = 50331648

large_pool_size          = 8388608

java_pool_size           = 33554432

control_files            = D:\oracle\oradata\GDESIGN\CONTROL01.CTL, D:\oracle\oradata\GDESIGN\CONTROL02.CTL, D:\oracle\oradata\GDESIGN\CONTROL03.CTL

db_block_size            = 8192

db_cache_size            = 25165824

compatible               = 9.2.0.0.0

db_file_multiblock_read_count= 16

fast_start_mttr_target   = 0

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

undo_retention           = 10800

remote_login_passwordfile= EXCLUSIVE

db_domain                =

instance_name            = GDES

dispatchers              = (PROTOCOL=TCP) (SERVICE=GDESXDB)

job_queue_processes      = 10

hash_join_enabled        = TRUE

background_dump_dest     = C:\oracle\admin\GDESIGN\bdump

user_dump_dest           = C:\oracle\admin\GDESIGN\udump

core_dump_dest           = C:\oracle\admin\GDESIGN\cdump

sort_area_size           = 524288

db_name                  = GDESIGN

open_cursors             = 300

star_transformation_enabled= FALSE

query_rewrite_enabled    = FALSE

pga_aggregate_target     = 25165824

aq_tm_processes          = 1

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

CJQ0 started with pid=8

QMN0 started with pid=9

Sun Jul 30 09:45:28 2006

starting up 1 shared server(s) ...

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Oracle Data Guard is not available in this edition of Oracle.

Sun Jul 30 09:45:28 2006

alter database mount exclusive

Sun Jul 30 09:45:32 2006

Successful mount of redo thread 1, with mount id 3828905400.

Sun Jul 30 09:45:32 2006

Database mounted in Exclusive Mode.

Completed: alter database mount exclusive

Sun Jul 30 09:45:32 2006

alter database open

Sun Jul 30 09:45:32 2006

Beginning crash recovery of 1 threads

Sun Jul 30 09:45:33 2006

Started recovery at

Thread 1: logseq 1602, block 3, scn 0.0

Recovery of Online Redo Log: Thread 1 Group 2 Seq 1602 Reading mem 0

Mem# 0 errs 0: D:\ORACLE\ORADATA\GDESIGN\REDO02.LOG

Sun Jul 30 09:45:33 2006

Completed redo application

Sun Jul 30 09:45:33 2006

Ended recovery at

Thread 1: logseq 1602, block 1615, scn 0.195087106

108 data blocks read, 51 data blocks written, 1612 redo blocks read

Crash recovery completed successfully

Sun Jul 30 09:45:33 2006

Thread 1 advanced to log sequence 1603

Thread 1 opened at log sequence 1603

Current log# 3 seq# 1603 mem# 0: D:\ORACLE\ORADATA\GDESIGN\REDO03.LOG

Successful open of redo thread 1.

Sun Jul 30 09:45:33 2006

SMON: enabling cache recovery

Sun Jul 30 09:45:33 2006

Undo Segment 1 Onlined

Undo Segment 2 Onlined

Undo Segment 3 Onlined

Undo Segment 4 Onlined

Undo Segment 5 Onlined

Undo Segment 6 Onlined

Undo Segment 7 Onlined

Undo Segment 8 Onlined

Undo Segment 9 Onlined

Undo Segment 10 Onlined

Successfully onlined Undo Tablespace 1.

Sun Jul 30 09:45:33 2006

SMON: enabling tx recovery

Sun Jul 30 09:45:33 2006

Database Characterset is AL32UTF8

replication_dependency_tracking turned off (no async multimaster replication found)

Completed: alter database open

Dump file c:\oracle\admin\gdesign\bdump\alert_gdes.log

Sun Jul 30 10:14:03 2006

ORACLE V9.2.0.4.0 - Production vsnsta=0

vsnsql=12 vsnxtr=3

Windows 2000 Version 5.2 , CPU type 586

Sun Jul 30 10:14:03 2006

Starting ORACLE instance (normal)

Sun Jul 30 10:14:03 2006

Running with 1 strand for Non-Enterprise Edition

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 2

Using log_archive_dest parameter default value

Running with 1 strand for Non-Enterprise Edition

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.4.0.

System parameters with non-default values:

processes                = 150

timed_statistics         = TRUE

shared_pool_size         = 50331648

large_pool_size          = 8388608

java_pool_size           = 33554432

control_files            = D:\oracle\oradata\GDESIGN\CONTROL01.CTL, D:\oracle\oradata\GDESIGN\CONTROL02.CTL, D:\oracle\oradata\GDESIGN\CONTROL03.CTL

db_block_size            = 8192

db_cache_size            = 25165824

compatible               = 9.2.0.0.0

db_file_multiblock_read_count= 16

fast_start_mttr_target   = 0

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

undo_retention           = 10800

remote_login_passwordfile= EXCLUSIVE

db_domain                =

instance_name            = GDES

dispatchers              = (PROTOCOL=TCP) (SERVICE=GDESXDB)

job_queue_processes      = 10

hash_join_enabled        = TRUE

background_dump_dest     = C:\oracle\admin\GDESIGN\bdump

user_dump_dest           = C:\oracle\admin\GDESIGN\udump

core_dump_dest           = C:\oracle\admin\GDESIGN\cdump

sort_area_size           = 524288

db_name                  = GDESIGN

open_cursors             = 300

star_transformation_enabled= FALSE

query_rewrite_enabled    = FALSE

pga_aggregate_target     = 25165824

aq_tm_processes          = 1

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

CJQ0 started with pid=8

QMN0 started with pid=9

Sun Jul 30 10:14:06 2006

starting up 1 shared server(s) ...

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Oracle Data Guard is not available in this edition of Oracle.

Sun Jul 30 10:14:07 2006

alter database mount exclusive

Sun Jul 30 10:14:11 2006

Successful mount of redo thread 1, with mount id 3828938607.

Sun Jul 30 10:14:11 2006

Database mounted in Exclusive Mode.

Completed: alter database mount exclusive

Sun Jul 30 10:14:11 2006

alter database open

Sun Jul 30 10:14:11 2006

Beginning crash recovery of 1 threads

Sun Jul 30 10:14:11 2006

Started recovery at

Thread 1: logseq 1603, block 549, scn 0.0

Recovery of Online Redo Log: Thread 1 Group 3 Seq 1603 Reading mem 0

Mem# 0 errs 0: D:\ORACLE\ORADATA\GDESIGN\REDO03.LOG

Sun Jul 30 10:14:11 2006

Completed redo application

Sun Jul 30 10:14:11 2006

Ended recovery at

Thread 1: logseq 1603, block 3458, scn 0.195112067

72 data blocks read, 59 data blocks written, 2909 redo blocks read

Crash recovery completed successfully

Sun Jul 30 10:14:11 2006

Thread 1 advanced to log sequence 1604

Thread 1 opened at log sequence 1604

Current log# 1 seq# 1604 mem# 0: D:\ORACLE\ORADATA\GDESIGN\REDO01.LOG

Successful open of redo thread 1.

Sun Jul 30 10:14:11 2006

SMON: enabling cache recovery

Sun Jul 30 10:14:11 2006

Undo Segment 1 Onlined

Undo Segment 2 Onlined

Undo Segment 3 Onlined

Undo Segment 4 Onlined

Undo Segment 5 Onlined

Undo Segment 6 Onlined

Undo Segment 7 Onlined

Undo Segment 8 Onlined

Undo Segment 9 Onlined

Undo Segment 10 Onlined

Successfully onlined Undo Tablespace 1.

Sun Jul 30 10:14:11 2006

SMON: enabling tx recovery

Sun Jul 30 10:14:11 2006

Database Characterset is AL32UTF8

replication_dependency_tracking turned off (no async multimaster replication found)

Completed: alter database open

Dump file c:\oracle\admin\gdesign\bdump\alert_gdes.log

Sun Jul 30 10:36:53 2006

ORACLE V9.2.0.4.0 - Production vsnsta=0

vsnsql=12 vsnxtr=3

Windows 2000 Version 5.2 , CPU type 586

Sun Jul 30 10:36:53 2006

Starting ORACLE instance (normal)

Sun Jul 30 10:36:53 2006

Running with 1 strand for Non-Enterprise Edition

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 2

Using log_archive_dest parameter default value

Running with 1 strand for Non-Enterprise Edition

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.4.0.

System parameters with non-default values:

processes                = 150

timed_statistics         = TRUE

shared_pool_size         = 50331648

large_pool_size          = 8388608

java_pool_size           = 33554432

control_files            = D:\oracle\oradata\GDESIGN\CONTROL01.CTL, D:\oracle\oradata\GDESIGN\CONTROL02.CTL, D:\oracle\oradata\GDESIGN\CONTROL03.CTL

db_block_size            = 8192

db_cache_size            = 25165824

compatible               = 9.2.0.0.0

db_file_multiblock_read_count= 16

fast_start_mttr_target   = 0

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

undo_retention           = 10800

remote_login_passwordfile= EXCLUSIVE

db_domain                =

instance_name            = GDES

dispatchers              = (PROTOCOL=TCP) (SERVICE=GDESXDB)

job_queue_processes      = 10

hash_join_enabled        = TRUE

background_dump_dest     = C:\oracle\admin\GDESIGN\bdump

user_dump_dest           = C:\oracle\admin\GDESIGN\udump

core_dump_dest           = C:\oracle\admin\GDESIGN\cdump

sort_area_size           = 524288

db_name                  = GDESIGN

open_cursors             = 300

star_transformation_enabled= FALSE

query_rewrite_enabled    = FALSE

pga_aggregate_target     = 25165824

aq_tm_processes          = 1

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

CJQ0 started with pid=8

QMN0 started with pid=9

Sun Jul 30 10:36:56 2006

starting up 1 shared server(s) ...

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Oracle Data Guard is not available in this edition of Oracle.

Sun Jul 30 10:36:57 2006

alter database mount exclusive

Sun Jul 30 10:37:01 2006

Successful mount of redo thread 1, with mount id 3828904905.

Sun Jul 30 10:37:01 2006

Database mounted in Exclusive Mode.

Completed: alter database mount exclusive

Sun Jul 30 10:37:01 2006

alter database open

Sun Jul 30 10:37:01 2006

Beginning crash recovery of 1 threads

Sun Jul 30 10:37:01 2006

Started recovery at

Thread 1: logseq 1604, block 3, scn 0.0

Recovery of Online Redo Log: Thread 1 Group 1 Seq 1604 Reading mem 0

Mem# 0 errs 0: D:\ORACLE\ORADATA\GDESIGN\REDO01.LOG

Sun Jul 30 10:37:01 2006

Completed redo application

Sun Jul 30 10:37:01 2006

Ended recovery at

Thread 1: logseq 1604, block 267, scn 0.195132280

83 data blocks read, 83 data blocks written, 264 redo blocks read

Crash recovery completed successfully

Sun Jul 30 10:37:01 2006

Thread 1 advanced to log sequence 1605

Thread 1 opened at log sequence 1605

Current log# 2 seq# 1605 mem# 0: D:\ORACLE\ORADATA\GDESIGN\REDO02.LOG

Successful open of redo thread 1.

Sun Jul 30 10:37:01 2006

SMON: enabling cache recovery

Sun Jul 30 10:37:02 2006

Undo Segment 1 Onlined

Undo Segment 2 Onlined

Undo Segment 3 Onlined

Undo Segment 4 Onlined

Undo Segment 5 Onlined

Undo Segment 6 Onlined

Undo Segment 7 Onlined

Undo Segment 8 Onlined

Undo Segment 9 Onlined

Undo Segment 10 Onlined

Successfully onlined Undo Tablespace 1.

Sun Jul 30 10:37:02 2006

SMON: enabling tx recovery

Sun Jul 30 10:37:02 2006

Database Characterset is AL32UTF8

replication_dependency_tracking turned off (no async multimaster replication found)

Completed: alter database open

Dump file c:\oracle\admin\gdesign\bdump\alert_gdes.log

Sun Jul 30 11:02:46 2006

ORACLE V9.2.0.4.0 - Production vsnsta=0

vsnsql=12 vsnxtr=3

Windows 2000 Version 5.2 , CPU type 586

Sun Jul 30 11:02:46 2006

Starting ORACLE instance (normal)

Sun Jul 30 11:02:46 2006

Running with 1 strand for Non-Enterprise Edition

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 2

Using log_archive_dest parameter default value

Running with 1 strand for Non-Enterprise Edition

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.4.0.

System parameters with non-default values:

processes                = 150

timed_statistics         = TRUE

shared_pool_size         = 50331648

large_pool_size          = 8388608

java_pool_size           = 33554432

control_files            = D:\oracle\oradata\GDESIGN\CONTROL01.CTL, D:\oracle\oradata\GDESIGN\CONTROL02.CTL, D:\oracle\oradata\GDESIGN\CONTROL03.CTL

db_block_size            = 8192

db_cache_size            = 25165824

compatible               = 9.2.0.0.0

db_file_multiblock_read_count= 16

fast_start_mttr_target   = 0

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

undo_retention           = 10800

remote_login_passwordfile= EXCLUSIVE

db_domain                =

instance_name            = GDES

dispatchers              = (PROTOCOL=TCP) (SERVICE=GDESXDB)

job_queue_processes      = 10

hash_join_enabled        = TRUE

background_dump_dest     = C:\oracle\admin\GDESIGN\bdump

user_dump_dest           = C:\oracle\admin\GDESIGN\udump

core_dump_dest           = C:\oracle\admin\GDESIGN\cdump

sort_area_size           = 524288

db_name                  = GDESIGN

open_cursors             = 300

star_transformation_enabled= FALSE

query_rewrite_enabled    = FALSE

pga_aggregate_target     = 25165824

aq_tm_processes          = 1

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

CJQ0 started with pid=8

QMN0 started with pid=9

Sun Jul 30 11:02:49 2006

starting up 1 shared server(s) ...

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Oracle Data Guard is not available in this edition of Oracle.

Sun Jul 30 11:02:49 2006

alter database mount exclusive

Sun Jul 30 11:02:53 2006

Successful mount of redo thread 1, with mount id 3828931033.

Sun Jul 30 11:02:53 2006

Database mounted in Exclusive Mode.

Completed: alter database mount exclusive

Sun Jul 30 11:02:53 2006

alter database open

Sun Jul 30 11:02:54 2006

Beginning crash recovery of 1 threads

Sun Jul 30 11:02:54 2006

Started recovery at

Thread 1: logseq 1605, block 23, scn 0.0

Recovery of Online Redo Log: Thread 1 Group 2 Seq 1605 Reading mem 0

Mem# 0 errs 0: D:\ORACLE\ORADATA\GDESIGN\REDO02.LOG

Sun Jul 30 11:02:55 2006

Completed redo application

Sun Jul 30 11:02:55 2006

Ended recovery at

Thread 1: logseq 1605, block 31067, scn 0.195161479

1731 data blocks read, 636 data blocks written, 31044 redo blocks read

Crash recovery completed successfully

Sun Jul 30 11:02:55 2006

Thread 1 advanced to log sequence 1606

Thread 1 opened at log sequence 1606

Current log# 3 seq# 1606 mem# 0: D:\ORACLE\ORADATA\GDESIGN\REDO03.LOG

Successful open of redo thread 1.

Sun Jul 30 11:02:55 2006

SMON: enabling cache recovery

Sun Jul 30 11:02:55 2006

Undo Segment 1 Onlined

Undo Segment 2 Onlined

Undo Segment 3 Onlined

Undo Segment 4 Onlined

Undo Segment 5 Onlined

Undo Segment 6 Onlined

Undo Segment 7 Onlined

Undo Segment 8 Onlined

Undo Segment 9 Onlined

Undo Segment 10 Onlined

Successfully onlined Undo Tablespace 1.

Sun Jul 30 11:02:55 2006

SMON: enabling tx recovery

Moriarty K
关注
oracle卡在started状态,Lsnrctl status/start 卡住问题及解决办法
weixin_31176789的博客
04-16 1804
Lsnrctl status/start hangs转载请注明出处：http://blog.csdn.net/xiaofan23zEnvironment：HPUX B11.31 + oracle 10.2.0.4 three nodes racSymptom：The listener on the first node was stoped and can’t be start use crs_s...
oracle数据库expdp导出卡住,AIX环境下EXPDP卡住问题处理
weixin_32307599的博客
04-16 1863
问题现象： 最近一用户准备搭建测试环境，由于该用户正式库是AIX小机，测试环境是X86平台，因此只能通过expdp进行数据导出，但是在导出的时候，发现EXPDP一直卡在如下位置,几个小时都不动弹： Export: Release 11.2.0.3.0 - Production on Fri Dec 5 13:06:2问题现象：最近一用户准备搭建测试环境，由于该用户正式库是AIX小机，测试环境是X8...
oracle startup没有任何反应
12-14
现象 　　[oracle@focorcl-ogg01 database]$ sqlplus / as sysdba 　　SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 7 23:51:15 2016 　　Copyright (c) 1982， 2013， Oracle.  All rights reserved. 　　Connected to an idle instance. 　　SQL> startup; 　　语句运行几分钟没有任何反应，alert_orcl.log中没有任何信息。 　　原因 　　*.log_archiv
Oracle启用startup不成功
weixin_43726316的博客
05-21 4366
Linux重启之后，startup命令后显示 SQL> startup LRM-00109: could not openparameterfile '/opt/oracle10g/product/10.2/db_1/dbs/initVDEDU.ora' 查找文件，果然不存在。估计是非法关机造成的。 这是因为在oracle9i和oracle10g中，oracle默认将使用spfile启动数...
Oracle数据库启动问题排查的一般流程-解决ORA-03113和ORA-16038错误
最新发布
weixin_60783132的博客
07-22 247
通过检查告警日志、trace文件、动态性能视图和操作系统日志，迅速定位问题的根本原因。采取相应的措施，如调整数据库参数、清理磁盘空间、检查网络连接和权限设置等。
让windows下的oracle startup hang住的一个设置
msdnchina的专栏@JiNan,ShanDong
10-07 668
让windows下的oracle startup hang住的一个设置
oracle连接卡住，导致程序不运行
weixin_36647532的博客
09-19 2297
一 、概况 采用springboot的jpa读取oracle的数据，大概300万数据，运行一天左右之后，程序卡死，导致数据接入接不完。 二、排查思路 java生产级别的接入程序卡死是正常的，基本重启就可以解决问题，但是重启之后还是会卡死，所以要排查原因，找到源头。 基本的思路就是查看代码堆栈，是否是线程死锁、遇到阻塞队列、或者线程池线程因为内存不足退出等。 基本使用的工具包括jstack...
oracle11g redhat7卡死,Centos7解决图形界面卡死问题
weixin_39902345的博客
04-16 2385
经常会遇到图形界面卡死,搜了一搜,解决办法如下: killall -9 gnome-shell…工作中的项目,CS客户端会通过MQ接收前端设备发送的信息,之前测试的时候,由于测试的数据不大,没有进行压力测试,软件可以正常工作,随着项目现场设备数量的增加,CS客户端从MQ中订阅的数据量不断增加,最终导致,客户端界面卡死.原来的数据流程图如下: 这个数据流程,在数据不大的情况下,是没有什么问题,数据太...
Oracle 数据库服务启动进程停止响应
diborve的专栏
06-15 1382
症状loadTOCNode(1, symptoms);在 Oracle 数据库 8i, 运行计算机上安装 MS 04 -011 安全更新用于 MicrosoftWindows 计算机可能停止响应在启动过程。 详见以下 Microsoft 安全公告 MS 04 0ll 安全更新：http://www.microsoft.com/technet/security/bulletin/ms
Oracle实例无法启动的问题如何解决
qq_50730941的博客
07-28 3627
出现这个问题可能由于断电数据库被强制异常关闭，导致文件状态可能不一致，因为正常关闭数据库会同步校验各文件，使得重新启动的时候文件时间点一致。SQL>recoverdatabaseuntiltime'2022-07-20'（恢复到故障时间点）1.启动数据库到mount状态。2.查看v$log再重置日志。在启动数据库时出现以上的问题。...
oracle账号权限导致拒绝访问和启动（startup）无反应问题
左直拳的马桶_日用桶
04-21 2198
合作伙伴的oracle又连不上了。 我又远程上去望闻问切。 oracle服务、监听服务都显示正在运行。但本机同样连不上。一阵装模作样，无聊的点击之后，我决定重启oracle服务。不料，重启失败，黄色的惊叹号，提示：拒绝访问！ 怎么回事？看上去，是权限问题？oracle服务没启动，一切都是白搭。什么startup，什么shutdown，都是扯。没办法了，将oracle所在目录，全部设为everyon...
oracle startup 之后 如果执行SQL 那么立马shutdown 原因分析
weixin_30650039的博客
07-04 190
事故场景 当我数据库使用的时候，突然断电了。然后就出现了下边的症状。 oracle startup 之后 如果执行SQL 那么立马shutdown 原因分析 排查步骤 ： 1 根据 alter_orcl.log 查找错误。然后在trc里面找明细的错误。 如图： 2 发现时 ora-00600错误。 然后引用了一遍其...
Oracle startup open 没响应 原因1
03-28 381
SQL>startup open .......... SQL> SHOW PARAMETER SGA; NAME TYPE VA...
startup nomount卡死不动
csdn20142014的博客
10-08 1076
如果startup nomount卡死不动，而且没有看到警告信息，如果是32位操作系统，就要考虑去查一下alert_xxx.log文件的大小是否超过了4G。因为启动是读取pfile，spfile后分配内存的速度是很快的，后台还做...
Oracle无缘无故卡死解决,oracle的后台进程隔三差五的突然死掉，谁遇到过？
weixin_28687331的博客
04-07 941
下面3个是alert中的信息------------------------------------------------------Wed Nov 22 22:18:01 2006MMNL: terminating instance due to error 472Instance terminated by MMNL, pid = 984Wed Nov 22 23:55:04 2006---...
linux oracle服务器重启中遇到的问题和解决方法
yanyichi0的博客
10-17 1396
由于 liunx服务器要关机迁移，导致这台服务器部署的oracle需要重启。 但由于部署oracle数据库的时候有些配置不到位。导致重启oracle服务器出现了一些故障。记录下来。 1 、查看ORACLE状态     ps -ef|grep oracle  2、（1） 以oracle身份登录数据库，命令：su - oracle （2） 进入Sqlplus控制台，命令：sqlplus /no...
oracle存储过程包损坏,关于存储过程包失效的问题！急！
weixin_32737183的博客
04-03 550
包没问题啊，我看有人是这样解释的，但是还是解决不了问题啊，杀session也会影响其他业务啊，而且我试了好像没效果，不知道是不是没杀正确一、1. 楼主新打开一个session去执行就没有该问题了2. 因为在A会话修改包并重复编译的时候之前，B会话已经执行过一次A会话的包中的函数，而A会话修改和编译完毕后，B会话再次调用A会话中的包中的函数，oracle发现缓存区中的包的函数已经是旧的了，所...
Oracle Linux 6.6系统卡在进度条界面
大动脉的博客
12-29 2436
最近在虚拟机里面安装redmine。系统开机卡在进度条界面
Oracle联网安装监听器启动问题及虚拟网卡解决方案
"联网安装Oracle数据库时，监听器无法启动的问题通常与网络配置有关。Oracle数据库在安装过程中，如果联网，其配置的主机名会基于当前的网络IP，而当IP改变时，数据库可能无法正确识别。本文提供了一种解决方案，即...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值