免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 2570 | 回复: 6

[求助] 求大神看下日志oracle启动时有报错吗。 [复制链接]

论坛徽章:
0
发表于 2012-09-08 00:35 |显示全部楼层
Fri Sep 07 22:47:11 2012
Starting background process SMCO
Fri Sep 07 22:47:11 2012
SMCO started with pid=24, OS id=5681
Fri Sep 07 22:52:00 2012
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Fri Sep 07 22:52:00 2012
Stopping background process CJQ0
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 10
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Fri Sep 07 22:52:01 2012
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Sep 07 22:52:01 2012
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 67
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
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
Fri Sep 07 22:52:01 2012
Stopping background process VKTM:
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Sep 07 22:52:04 2012
Instance shutdown complete
Fri Sep 07 22:57:48 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora
System parameters with non-default values:
  processes                = 150
  nls_language             = "SIMPLIFIED CHINESE"
  nls_territory            = "CHINA"
  memory_target            = 404M
  control_files            = "/oracdata/orcl/control01.ctl"
  control_files            = "/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "/oracle/app/oracle/flash_recovery_area"
  db_recovery_file_dest_size= 4977M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  audit_file_dest          = "/oracle/app/oracle/admin/orcl/adump"
  audit_trail              = "DB"
  db_name                  = "orcl"
  open_cursors             = 300
  diagnostic_dest          = "/oracle/app/oracle"
Fri Sep 07 22:57:49 2012
PMON started with pid=2, OS id=5857
Fri Sep 07 22:57:49 2012
VKTM started with pid=3, OS id=5859
VKTM running at (100ms) precision
Fri Sep 07 22:57:49 2012
GEN0 started with pid=4, OS id=5863
Fri Sep 07 22:57:49 2012
DIAG started with pid=5, OS id=5865
Fri Sep 07 22:57:49 2012
DBRM started with pid=6, OS id=5867
Fri Sep 07 22:57:49 2012
PSP0 started with pid=7, OS id=5869
Fri Sep 07 22:57:49 2012
DIA0 started with pid=8, OS id=5871
Fri Sep 07 22:57:49 2012
MMAN started with pid=9, OS id=5873
Fri Sep 07 22:57:49 2012
DBW0 started with pid=10, OS id=5875
Fri Sep 07 22:57:49 2012
LGWR started with pid=11, OS id=5877
Fri Sep 07 22:57:49 2012
CKPT started with pid=12, OS id=5879
Fri Sep 07 22:57:49 2012
SMON started with pid=13, OS id=5881
Fri Sep 07 22:57:50 2012
RECO started with pid=14, OS id=5883
Fri Sep 07 22:57:50 2012
MMON started with pid=15, OS id=5885
Fri Sep 07 22:57:50 2012
MMNL started with pid=16, OS id=5887
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /oracle/app/oracle
Fri Sep 07 22:58:16 2012
alter database mount
Fri Sep 07 22:58:21 2012
Successful mount of redo thread 1, with mount id 1321174664
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Fri Sep 07 22:58:36 2012
alter database open
Fri Sep 07 22:58:36 2012
Thread 1 opened at log sequence 67
  Current log# 1 seq# 67 mem# 0: /oracdata/orcl/redo01.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
Fri Sep 07 22:58:36 2012
SMON: enabling cache recovery
SMON: enabling tx recovery
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Fri Sep 07 22:58:36 2012
QMNC started with pid=20, OS id=5935
Completed: alter database open
Fri Sep 07 22:58:37 2012
db_recovery_file_dest_size of 4977 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.
Starting background process SMCO
Fri Sep 07 22:58:37 2012
SMCO started with pid=21, OS id=5941
Fri Sep 07 22:58:38 2012
Starting background process CJQ0
Fri Sep 07 22:58:38 2012
CJQ0 started with pid=27, OS id=5955
Setting Resource Manager plan SCHEDULER[0x3007]EFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Fri Sep 07 22:58:41 2012
Starting background process VKRM
Fri Sep 07 22:58:41 2012
VKRM started with pid=25, OS id=5959

论坛徽章:
8
CU大牛徽章
日期:2013-09-18 15:20:48CU大牛徽章
日期:2013-09-18 15:20:58CU大牛徽章
日期:2013-09-18 15:21:06CU大牛徽章
日期:2013-09-18 15:21:12CU大牛徽章
日期:2013-09-18 15:21:17天秤座
日期:2013-10-30 14:01:03摩羯座
日期:2013-11-29 18:02:31luobin
日期:2016-06-17 17:46:36
发表于 2012-09-12 17:13 |显示全部楼层
回复 1# yzs1059252977
看上去一切正常,木有报错。

   

论坛徽章:
2
酉鸡
日期:2014-02-19 09:11:08摩羯座
日期:2014-05-23 10:16:16
发表于 2012-09-28 15:13 |显示全部楼层
木有明显错误,正常的啊

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
发表于 2012-10-08 16:38 |显示全部楼层
   简单来说,没有ORA,没有DUMP,没有TRC,一切大大的正常

论坛徽章:
0
发表于 2012-10-11 14:53 |显示全部楼层
Congratulations...

论坛徽章:
0
发表于 2012-10-11 22:23 |显示全部楼层
可以用ps -ef来看ora相关进程起来没有噻,用sqlplus连一下不就什么都知道了蛮?

论坛徽章:
0
发表于 2012-10-26 16:58 |显示全部楼层
应该没有问题吧
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP