ITPub博客

ORA-00600: 内部错误代码, 参数: [4194], [34], [8], [], [], [], [], []报错信息：Thu Aug 27 18:49:17 2009Errors in file /opt/app/oracle/admin/odps/bdump/odps_pmon_8453.trc:ORA-00471: DBWR process terminated with errorThu Aug 27 18:50:12 2009Recovery of Online Redo Log: Thread 1 Group 3 Seq 975 Reading mem 0 Mem# 0 errs 0: /oradata/odps/redo03.logBlock recovery completed at rba 975.64.16, scn 0.59976334Doing block recovery for file 2 block 9Block recovery from logseq 975, block 62 to scn 59976373Th

出现ORA-00600：[keltnfy-ldmInit]，[46]错误,解决如下：原因：服务器hostname没有正确配置，通过hostname命令得到的主机名无法ping通，Oracle10g认为主机无法达到所以启动数据库报错。本次遇到问题状况如下：本地PING的通IP，ping不通主机名异地可ping通主机名=============由于半路接手，于是挨个情况查询，后发现是HOSTS里拼写错误导致。。。可笑[@more@]

执行alter database backup controlfile to trace;在%oracle_base%oradata%oracle_sid%udump下找到刚刚创建的trc文件，打开它。可以看到里面包含了如下两段sql脚本第一段sql是在所有online redolog没有丢失，以noresetlogs选项打开数据库的情况下使用的。第二段则是在丢失了online redolog需要resetlogs的情况下使用。[@more@]-- Below are two sets of SQL statements, each of which creates a new-- control file and uses it to open the database. The first set opens-- the database with the NORESETLOGS option and should be us

本文概述与实验环境概述：本文只讨论OS认证和口令文件认证方式的配置方法，如何配置以及使用OS认证和口令文件认证方式验证SYSDBA/SYSOPER权限。[@more@]实验环境：Oracle 10.1 + Windows 2003 和 Oracle 10.2 + RHEL 4特殊权限与Oracle登陆认证管理在开始学Oracle的时候有件事一直让我感觉很奇怪，就是为什么在数据没有起来的时候只要登录到安装Oracle的操作系统中直接用 sqlplus / as sysdba就能登陆到数据库中然后对数据库进行启动停止之类的操作。后来看到关于Oracle口令文件相关资料的时候才豁然开朗：数据库认证信息并不一 定存在数据

Select in the table below the areas you've visited and produce a map of China with those areas in red. You can even put the map on your website or blog by simply pasting the code you'll get![@more@]<img src="http://www.markwang.com/chinamap/image.php?&BJ=1&HeB=1&HLJ=1&HeN=1&HuN=1&JL=1&LN=1&SAX=1&SD=1&SX=1&SC=1"><br/><a href="create">http://www.markwang.com/chinamap/">create your own China map</a>

使用raw devices还是file system,看内容解释[@more@]Within the database community, there has been a long running debate surrounding the use of raw logical volumes (raw devices) versus file systems. Advocates of raw logical volumes stress the performance gains that can be realized through their use, whereas file system supporters emphasize the ease of use and manageability features of file systems. As with the other aspects of system design, a decision must be made as to which is more important: per

RMAN也可以进行联机备份，而且备份与恢复方法将比OS备份更简单可靠。[@more@]RMAN也可以进行联机备份，而且备份与恢复方法将比OS备份更简单可靠。1、连接数据库，创建测试表并插入记录SQL> connect internal/password as sysdba;Connected. SQL> create table test(a int) tablespace users;Table createdSQL> insert into test values(1);1 row insertedSQL> commit;Commit complete 2、 备份数据库表空间usersC:/>rmanRecovery Manager: Release 8.1.6.0.0 - ProductionRMAN> connect rcvcat rman/rman@backRMAN-0600

043，题型有变化了，有5道是通过操作DBconsole的题（通过在DBconsole的操作达到一些目的的图形操作题）还有一道是题库中没有的选择题，还好依然是100过去了现在把新遇到的尽量回忆下 供大家参考[@more@]043，题型有变化了，有5道是通过操作DBconsole的题（通过在DBconsole的操作达到一些目的的图形操作题）还有一道是题库中没有的选择题，还好依然是100过去了现在把新遇到的尽量回忆下 供大家参考1）DBconsole怎么把UNDO的不覆盖答案当然是操作DBconsole来使得undo表空间 retention grarantee2）DBconsole怎么参看SGA的各个部件大小答案利