Oracle Basic
DBDoctor
红豆生南国!
展开
-
OORA-38760: This database instance failed to turn on flashback database
问题ORA-38760: Thisdatabase instance failed to turn on flashback database背景数据库的Flashback是打开的,测试冷备和恢复。SQL> select * from v$version;BANNER-------------------------------------------------------Oracle原创 2016-02-17 11:24:55 · 1713 阅读 · 0 评论 -
expdp之ORA-39006: internal error
数据库版本SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL原创 2016-07-15 20:53:37 · 2045 阅读 · 0 评论 -
oracle startup没有任何反应
现象[oracle@focorcl-ogg01 database]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 7 23:51:15 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle insta原创 2016-07-07 16:04:17 · 2919 阅读 · 1 评论 -
oracle审计
oracle audit原创 2016-06-22 12:30:36 · 8413 阅读 · 1 评论 -
kewastUnPackStats(): bad magic 1
11.2.0.1数据库alert中存在如下错误信息Wed Aug 17 12:19:09 2016kewastUnPackStats(): bad magic 1 (0x7f5b783f4dc7, 0)kewastUnPackStats(): bad magic 1 (0x7f5b783f4dc7, 0)kewastUnPackStats(): bad magic 1 (0x7f5b783f4原创 2016-08-17 13:56:11 · 735 阅读 · 0 评论 -
oracle版本升级路线
oracle版本升级路线,记录备用!原创 2016-08-31 10:07:04 · 566 阅读 · 0 评论 -
ORA-03137: TTC protocol internal error : [12333] [7] [120] [116] [] [] [] []
数据库版本:SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionP原创 2016-09-01 13:47:05 · 1154 阅读 · 0 评论 -
oracle隐含参数查询 $ksppi 和x$ksppcv
oracle数据库的初始化参数,主要来源于两个Oracle内部数据字典表X$KSPI和X$KSPPCV; 通常我们查询的V$Parameter视图或使用show parameter命令都是就来源于这两个系统表的,但通过这两种方式不能查询隐含参数。X$KSPPCV用以记录当前的设置的值,及是否使用了缺省值等信息,X$KSPPI则是一个基础表,用于记录参数名、参数说明等简单的信息。X$KSPPIADD原创 2016-09-01 13:53:21 · 2031 阅读 · 0 评论 -
ORA-20011 ORA-29913 KUP-11024问题处理
问题发现数据库版本SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Productio原创 2016-08-11 13:18:26 · 4754 阅读 · 0 评论 -
oracle内存管理手动到自动
数据库版本SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL原创 2016-07-14 14:41:23 · 2716 阅读 · 0 评论 -
oracle修改字符集(WE8MSWIN1252 -->ZHS16GBK)
查看数据库当前字符集SQL> select userenv('language') from dual;USERENV('LANGUAGE')----------------------------------------------------AMERICAN_AMERICA.WE8MSWIN1252将数据库置于restricted mode下SQL> alter system enable原创 2016-07-14 14:26:26 · 9733 阅读 · 0 评论 -
oracle的restricted mode(受限模式)
概述在查看oracle的v$instance视图中发现有logins列,我们可以看下contents中对此列的定义。![这里写图片描述](http://img.blog.csdn.net/20160714104516544)实例启动有两种模式,一种为allowed,一种为restricted模式。Restricted Mode of Instance StartupYou can start an原创 2016-07-14 11:13:29 · 4930 阅读 · 0 评论 -
Oracle In-Memory database cache --TimesTen
官方中文介绍:http://www.oracle.com/technetwork/database/timesten/timesten-imdb-cache-083828-zhs.html原创 2016-03-04 11:19:57 · 657 阅读 · 0 评论 -
UDEV SCSI Rules Configuration for ASM in Oracle Linux 5, 6 and 7
从oracle-base中看到这篇文章,写的比较详细,分享一下For Oracle Automatic Storage Manager (ASM) to use disks, it needs to be able to identify the devices consistently and for them to have the correct ownership and permissio原创 2016-03-19 15:09:51 · 861 阅读 · 0 评论 -
oracle11R2 log_archive_format
log_archive_format定义了归档文件名称的格式。SQL> select * from v$version;BANNEROracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0原创 2016-03-21 08:54:01 · 2528 阅读 · 0 评论 -
Oracle CPU/PSU补丁安装详细教程
请参考如下blog,感谢作者的分享。 [http://www.jb51.net/article/39717.htm]原创 2016-02-18 11:03:00 · 1404 阅读 · 0 评论 -
INS-35172 Target database memory(945MB) excessds the systems available shared memory({0}MB)
Centos6.5安装oracle11.2.0.1的时候报错如下:解决方法:增加/dev/shm, /dev/shm通常用做共享内存。将/dev/shm增大到大于你期望设置的memory_target值。修改/dev/shm方式如下:[root@orcl ~]# umount tmpfs[root@orcl ~]# mount -t tmpfs shmfs -o size=2G /dev/shm/让原创 2016-06-16 10:32:56 · 1161 阅读 · 0 评论 -
ora-19624 ora-19502 ora-27040
数据库环境: oracle 11.2.0.1 rac(两个节点) centos 6.5 netapp存储 alert.log Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_m000_19756.trc: ORA-19624: operation failed, retry possible ORA-19原创 2016-06-15 23:17:34 · 3476 阅读 · 0 评论 -
INS-06101 IP adress of localhost could not be determined
Centos6.5安装oracle 11.2.0.1,执行[oracle@orcl database]$ ./runInstaller 提示如下:解决办法:修改host,将ip与主机名做绑定[root@orcl ~]# vi /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4原创 2016-06-16 10:07:30 · 1081 阅读 · 0 评论 -
oracle trigger中的before和after
before:(insert、update)可以对new进行修改;after不能对new进行修改,两者都不能修改old数据。对于INSERT语句, 只有NEW是合法的;对于DELETE语句,只有OLD才合法;对于UPDATE语句,NEW、OLD可以同时使用。修改为before,可以顺利执行create or replace trigger trg_t6103_insert before inse原创 2016-11-15 08:53:15 · 1530 阅读 · 0 评论