oracle 11g不能启动,[求助]oracle 11g无法启动

系统是redhat 6.5,之前没有过任何预兆即出现了以下问题。

今日发现整个数据库非常缓慢,遂准备重启服务器解决问题。

但是执行shutdown immediate没有任何效果。同时sql语句执行缓慢,小弟并非专业oracle数据库运维,只是接了个活,所以想着速战速决,于是执行了shutdown abort。成功。

之后再启动时就出现了无法启动的问题。下面是错误日志。希望各位能够帮助我

Tue Apr 21 14:16:54 2015

Starting ORACLE instance (normal)

Tue Apr 21 14:17:27 2015

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

IMODE=BR

ILAT =134

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Tue Apr 21 14:17:43 2015

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/db_1/dbs/spfileorc11g.ora

System parameters with non-default values:

processes                = 800

sessions                 = 1224

memory_target            = 3200M

control_files            = "/u01/app/oracle/oradata/orc11g/control01.ctl"

control_files            = "/u01/app/oracle/flash_recovery_area/orc11g/control02.ctl"

db_block_size            = 8192

compatible               = "11.2.0.0.0"

log_archive_dest_1       = "LOCATION=/u01/arch"

db_recovery_file_dest    = "/u01/app/oracle/flash_recovery_area"

db_recovery_file_dest_size= 2G

undo_tablespace          = "UNDOTBS1"

remote_login_passwordfile= "EXCLUSIVE"

db_domain                = ""

dispatchers              = "(PROTOCOL=TCP) (SERVICE=orc11gXDB)"

audit_file_dest          = "/u01/app/oracle/admin/orc11g/adump"

audit_trail              = "DB"

db_name                  = "orc11g"

open_cursors             = 1000

diagnostic_dest          = "/u01/app/oracle"

Tue Apr 21 14:17:47 2015

PMON started with pid=2, OS id=3335

Tue Apr 21 14:17:47 2015

VKTM started with pid=3, OS id=3337

VKTM running at (100ms) precision

Tue Apr 21 14:17:47 2015

GEN0 started with pid=4, OS id=3341

Tue Apr 21 14:17:47 2015

DIAG started with pid=5, OS id=3343

Tue Apr 21 14:17:47 2015

DBRM started with pid=6, OS id=3345

Tue Apr 21 14:17:47 2015

PSP0 started with pid=7, OS id=3347

Tue Apr 21 14:17:47 2015

DIA0 started with pid=8, OS id=3349

Tue Apr 21 14:17:47 2015

MMAN started with pid=9, OS id=3351

Tue Apr 21 14:17:47 2015

DBW0 started with pid=10, OS id=3353

Tue Apr 21 14:17:47 2015

LGWR started with pid=11, OS id=3355

Tue Apr 21 14:17:47 2015

CKPT started with pid=12, OS id=3357

Tue Apr 21 14:17:47 2015

SMON started with pid=13, OS id=3359

Tue Apr 21 14:17:47 2015

RECO started with pid=14, OS id=3361

Tue Apr 21 14:17:47 2015

MMON started with pid=15, OS id=3363

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

Tue Apr 21 14:17:47 2015

MMNL started with pid=16, OS id=3365

starting up 1 shared server(s) ...

ORACLE_BASE from environment = /u01/app/oracle

Tue Apr 21 14:18:02 2015

ALTER DATABASE   MOUNT

Tue Apr 21 14:18:11 2015

Successful mount of redo thread 1, with mount id 598884954

Database mounted in Exclusive Mode

Lost write protection disabled

Tue Apr 21 14:18:22 2015

Completed: ALTER DATABASE   MOUNT

Tue Apr 21 14:18:25 2015

ALTER DATABASE OPEN

Tue Apr 21 14:18:44 2015

Beginning crash recovery of 1 threads

parallel recovery started with 7 processes

Started redo scan

Tue Apr 21 14:26:02 2015

Completed redo scan

read 1587084 KB redo, 46815 data blocks need recovery

Tue Apr 21 14:33:21 2015

Errors in file /u01/app/oracle/diag/rdbms/orc11g/orc11g/trace/orc11g_m000_26444.trc:

ORA-01155: the database is being opened, closed, mounted or dismounted

orc11g_m000_12676.trc文件内容如下。

Trace file /u01/app/oracle/diag/rdbms/orc11g/orc11g/trace/orc11g_m000_12676.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1

System name:        Linux

Node name:        localhost.localdomain

Release:        2.6.18-128.el5

Version:        #1 SMP Wed Dec 17 11:41:38 EST 2008

Machine:        x86_64

Instance name: orc11g

Redo thread mounted by this instance: 1

Oracle process number: 32

Unix process pid: 12676, image: oracle@localhost.localdomain (M000)

*** 2015-04-21 14:47:52.744

*** SESSION ID

c58e339c7046a1ffce9c5508745874fa.gif5.9727) 2015-04-21 14:47:52.745

*** CLIENT ID

c58e339c7046a1ffce9c5508745874fa.gif) 2015-04-21 14:47:52.745

*** SERVICE NAME

c58e339c7046a1ffce9c5508745874fa.gif) 2015-04-21 14:47:52.745

*** MODULE NAME

c58e339c7046a1ffce9c5508745874fa.gifMMON_SLAVE) 2015-04-21 14:47:52.745

*** ACTION NAME

c58e339c7046a1ffce9c5508745874fa.gifMonitor FRA Space) 2015-04-21 14:47:52.745

ORA-01155: the database is being opened, closed, mounted or dismounted

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值