oracle
关注
分享
扫一扫
rgb_rgb
dba
展开
-
./runcluvfy.sh stage -pre crsinst -n `hostname` -verbose -method root
grid:Cluvfy Fail with PRVG-11250 The Check “RPM Package Manager Database” Was Not Performed (Doc ID 2548970.1)./runcluvfy.sh stage -pre crsinst -n hostname -verbose -method root Node Name Running? Status -------原创 2021-12-11 14:47:47 · 772 阅读 · 0 评论 -
ORA-28040: No matching authentication protocol exception
参考：https://stackoverflow.com/questions/24100117/ora-28040-no-matching-authentication-protocol-exception/33675384SQLNET.ALLOWED_LOGON_VERSION=10SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10SQLNET....原创 2019-12-02 10:36:48 · 250 阅读 · 0 评论 -
oracle 19c ADG 配置删除归档策略
RMAN> show all;using target database control file instead of recovery catalogRMAN configuration parameters for database with db_unique_name TCYANG are:CONFIGURE RETENTION POLICY TO REDUNDAN...原创 2019-10-18 17:39:43 · 1057 阅读 · 0 评论 -
Oracle 19c dgmgrl 配置
DGMGRL> show database verbose tcyang_stbDatabase - tcyang_stb Role: PRIMARY Intended State: TRANSPORT-ON Instance(s): tcyang Properties: DGConnectIdentifier ...原创 2019-10-18 17:29:05 · 901 阅读 · 0 评论 -
sysaux表空间文件从asm迁移到文件系统
1.修改表空间为离线状态ALTER TABLESPACE sysaux OFFLINE;2.复制表空间对应文件到新的位置RMAN> convert datafile "+DATA/awr/datafile/sysaux.325.915646129" format "/u01/app/awr/sysaux11.dbf";RMAN> convert datafile "+DATA/aw原创 2016-09-08 15:11:13 · 583 阅读 · 0 评论 -
在线重定义/*+ BYPASS_RECURSIVE_CHECK APPEND SKIP_UNQ_UNUSABLE_IDX */
在线重定义/*+ BYPASS_RECURSIVE_CHECK APPEND SKIP_UNQ_UNUSABLE_IDX */原来是通过insert /*+ BYPASS_RECURSIVE_CHECK APPEND SKIP_UNQ_UNUSABLE_IDX */ 这种不会产生undo(如果有对数据导入用这个hit会方便很多)。在重定义之前需要准备充足重定义需要的原创 2017-03-24 11:29:56 · 1556 阅读 · 0 评论 -
ORA-19566: exceeded limit of 0 corrupt blocks for file +DATA/datafile/undotbs2.260.842548839
问题：RMAN-03009: failure of backup command on dev_1 channel at 03/06/2017 19:35:10ORA-27192: skgfcls: sbtclose2 returned error - failed to close fileORA-19511: Error received from media manager la原创 2017-03-15 13:24:36 · 3267 阅读 · 0 评论 -
EM 12cR5 Cloud Control
Navigate: Targets > Databases > [select target instance] > [Performance pull down menu] > Ash AnalyticsDeploying the ASH Analytic package in EM 12c Cloud Control fails with this error:Erro原创 2017-04-18 22:48:18 · 768 阅读 · 0 评论 -
_use_adaptive_log_file_sync 参数
从10.2.0.5升级到11.2出现LOG FILE SYNCS等待事件可能会有显著增长的性能问题。在11.2.0.3版本中，Oracle 默认启用 _use_adaptive_log_file_sync 参数，使得 LGWR 进程写日志的方式能自动在 post/wait 和 polling 两种方式之间进行取舍，可能会导致比较严重的写日志等待（log file sync的平均单次等待原创 2017-05-29 21:50:42 · 2888 阅读 · 0 评论 -
metric和Alerts
now: v$sysmetric1 hour: v$sysmetric_history7 Days: DBA_HIST_SYSMETRIC_summary15 Ses: v$sessmetricDBA_HIST_SYSMETRIC_HISTORY与Alerts 相关的数据字典如下表： ViewDes原创 2017-06-13 16:45:50 · 453 阅读 · 0 评论 -
Oracle 如何关闭监听日志
监听日志受log_status参数控制，ON为开打，这也是默认值，OFF为关闭。可以通过LSNRCTL工具的show命令来查看参数的状态。LSNRCTL> show log_statusLSNRCTL> set log_status offstatus原创 2017-07-29 21:20:00 · 3262 阅读 · 0 评论 -
dbms_stats.set_system_stats 使用
http://www.searu.org/19178.htmlalter session set "_optimizer_cost_model" = cpu;ALTER SESSION SET optimizer_features_enable = '10.2.0.4';ALTER SESSION SET optimizer_dynamic_sampling = 2;ALT转载 2017-08-28 21:21:09 · 471 阅读 · 0 评论 -
等待事件：enq: HW - contention
Top 10 Foreground Events by Total Wait TimeEventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Classenq: HW - contention54177.5K143220原创 2017-09-22 23:16:35 · 887 阅读 · 0 评论 -
SunOS 5.10 11.2.0.4--->11.2.0.4.160718
$ $ORACLE_HOME/OPatch/opatch lsinventoryOracle 中间补丁程序安装程序版本 11.2.0.3.15版权所有 (c) 2017, Oracle Corporation。保留所有权利。Oracle Home : /oracle/app/oracle/product/11.2.0/dbhome_1Centra原创 2017-03-02 14:01:18 · 1183 阅读 · 0 评论 -
ORA-00600: 内部错误代码
问题：aix 7.1 oracle 11.2.0.4ORA-00600: 内部错误代码, 参数: [4552], [2], [53], [], [], [], [], [], [], [], [], []Corrupt Block Found TSN = 3, TSNAME = TEMP RFN = 1, BLK = 854017, RDBA原创 2016-09-08 23:15:49 · 1518 阅读 · 0 评论 -
模拟坏块及rman恢复坏块测试（一）
准备：create table t_block(id integer primary key,name varchar2(10)); insert into t_block values(1,'tcaaaa a'); insert into t_block values(2,'ad阿@奥迪'); insert into t_block values(3,'ABa$23省道')原创 2016-09-20 18:08:38 · 800 阅读 · 1 评论 -
模拟坏块及rman恢复坏块测试（二）
损坏发生在只有归档，没有备份的数据库中该如何操作：DBV只报告物理损坏，validate check logical database可以验证物理损坏和逻辑损坏，执行VALIDATE命令后通过查询V$DATABASE_BLOCK_CORRUPTION视图可以获得坏块的详细信息，块被修复后V$DATABASE_BLOCK_CORRUPTION中相应的记录会被删除。该命令只能运行在归档原创 2016-09-21 10:30:13 · 589 阅读 · 0 评论 -
模拟数据丢失(truncate table)
参考：http://www.hellodba.com/reader.php?ID=217好好学习，以备不时之需。模拟数据：create table scott.truncate_test tablespace usersasselect * from Hr.EMPLOYEES;insert into scott.truncate_testselect * fr原创 2016-09-08 16:38:38 · 858 阅读 · 0 评论 -
11g新特性：Health Monitor Checks
11g新特性：Health Monitor Checks 这个功能挺好。select name,name_nls from V$HM_CHECK order by 1;ASM Allocation CheckASM 分配检查ASM Disk Visibility CheckASM 磁盘可见性检查ASM File Busy Ch原创 2016-09-22 11:47:10 · 631 阅读 · 0 评论 -
oracle 11.2.0.4(CentOS release 6.8) 打24006111补丁
[oracle@upg-db1 24006111]$ lltotal 108drwxr-xr-x 4 oracle oinstall 4096 Aug 26 20:55 17478514drwxr-xr-x 4 oracle oinstall 4096 Aug 26 20:55 18031668drwxr-xr-x 4 oracle oinstall 4096 Aug 26原创 2016-11-22 16:51:33 · 979 阅读 · 0 评论 -
hf_HP-UX .11.23 U ia64 0038610181 unlimited-user license 10.2.0.4
[testhf01:/oracle] df -k/testhf01_arc (/dev/vg_testhf01_arc/lvol1) : 197323918 total allocated Kb 184928651 free allocated Kb原创 2016-12-26 15:07:59 · 509 阅读 · 0 评论 -
谁能明白这里面的痛（透明网关）
谁能明白这里面的痛（透明网关），折腾了好几天，试了很多方法，环境有限只能在现有的环境上做测试。源端数据库：sql anywhere 10目标端数据库：oracle 10.2.0.4透明网关：oracle 11.2.0.111g报错：SQL> select * from dual@dg4sybs;select * from dual@dg4sybs原创 2017-01-05 16:48:42 · 2275 阅读 · 0 评论 -
oracle dbfusrpt
你想知道你已经使用了数据库多少功能(模块)吗?$ORACLE_HOME/rdbms/adim/dbfusrpt.sql可以帮你完成这个问题.原创 2016-12-28 23:23:10 · 350 阅读 · 0 评论 -
等待事件：enq: SQ - contention
Top 10 Foreground Events by Total Wait TimeEventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Classenq: SQ - contention25987.7K338548原创 2017-08-31 16:22:59 · 822 阅读 · 0 评论 -
关闭 oracle dblink 功能
alter system set open_links=0 sid ='*' scope=spfile;System altered.alter system set open_links_per_instance=0 sid ='*' scope=spfile;System altered.重启数据库SELECT id FROM tb@db_lin原创 2017-09-15 17:15:32 · 2821 阅读 · 1 评论 -
centos 6.9 DB PSU
root@swbilling1:/root#/oracle/product/11.2.0/dbhome_1/OPatch/opatch auto /oracle/soft/27967757/ -oh /oracle/product/11.2.0/dbhome_1 -ocmrf /home/oracle/oracle_ocm.rsp Executing /oracle/11.2.0/grid/pe...原创 2018-07-22 09:39:12 · 383 阅读 · 0 评论 -
solaris 11.2.0.4 DB PSU 180717
[oracle@swboss-rpt1 28317183]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./Oracle 中间补丁程序安装程序版本 11.2.0.3.19版权所有 (c) 2018, Oracle Corporation。保留所有权利。PREREQ sessionOra...原创 2018-07-26 23:37:17 · 472 阅读 · 0 评论 -
centos 6.9 11.2.0.4.180717 OJVM PATCH SET UPDATE
swbilling2:/home/oracle$$ORACLE_HOME/OPatch/opatch lspatches27441052;OCW PATCH SET UPDATE: 11.2.0.4.180417 (27441052)27734982;Database Patch Set Update : 11.2.0.4.180717 (27734982)OPatch succee...原创 2018-07-22 11:52:55 · 1283 阅读 · 0 评论 -
ing lsdg
ASMCMD> lsdgState Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED EXTERN N 512 4096 1048576 ...原创 2018-07-22 13:19:52 · 265 阅读 · 0 评论 -
solaris 5.10 root.sh
root@swcrm1 # /oracle/oraInventory/orainstRoot.shChanging permissions of /oracle/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing gr...原创 2018-08-24 13:15:59 · 563 阅读 · 1 评论 -
11.2.0.4.170717 ojvm 28317183
[oracle@swcrm1 28317183]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./Oracle Interim Patch Installer version 11.2.0.3.19Copyright (c) 2018, Oracle Corporation. All righ...原创 2018-08-25 20:34:29 · 543 阅读 · 0 评论 -
单实例打PSU 27734982 （180717）
oradb19:/tools/PSU/27734982$$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./Oracle Interim Patch Installer version 11.2.0.3.15Copyright (c) 2018, Oracle Corporation. All ri...原创 2018-10-31 10:23:22 · 673 阅读 · 0 评论 -
CLSRSC-507: The root script cannot proceed on this node
问题描述：[root@testdb02 dev]# /oracle/app/12.1.0/grid/root.shPerforming root user operation.The following environment variables are set as: ORACLE_OWNER= grid ORACLE_HOME= /oracle/app/...原创 2019-04-05 18:50:11 · 2440 阅读 · 5 评论 -
centos 6.9 11.2.0.4 PSU GI 27967757
#/oracle/11.2.0/grid/OPatch/opatch auto /oracle/soft/27967757 -ocmrf /home/grid/grid_ocm.rspExecuting /oracle/11.2.0/grid/perl/bin/perl /oracle/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /oracle/...原创 2018-07-22 00:24:18 · 659 阅读 · 0 评论 -
centos 6.8 11.2.0.4 DB PSU 180717
$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /oracle/soft/11g/27726500Oracle Interim Patch Installer version 11.2.0.3.19Copyright (c) 2018, Oracle Corporation. All rights reserved.O...原创 2018-06-29 15:47:15 · 333 阅读 · 0 评论 -
expdp 问题和 ORA-00600: internal error code, arguments: [25027], [6], [0], [], [], [], [], [], [], [],
Export: Release 11.2.0.4.0 - Production on Thu Nov 30 17:12:48 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition原创 2017-11-30 18:28:04 · 1933 阅读 · 0 评论 -
ASH ORA-01843: 无效的月份
select output from table(dbms_workload_repository.ash_report_html( :dbid, *第 1 行出现错误:ORA-01843: 无效的月份ORA-06512: 在 "SYS.DBMS_SWRF_REPORT_INTERNAL", line 11980ORA-06512原创 2017-08-31 10:29:26 · 2679 阅读 · 0 评论 -
How to disable DRM
How to disable DRM？10gR2以及以下版本 静态： _gc_affinity_time=0 _gc_undo_affinity=FALSE 或 动态： _gc_affinity_limit=250 _gc_affinity_minimum=10485760 11gR1以及以上版本 _gc_policy_time=原创 2017-10-17 14:52:03 · 452 阅读 · 0 评论 -
rac后台进程说明及一些概念
参考：http://blog.itpub.net/670493/viewspace-1024937/rac后台进程说明及一些概念1.GSD global services daemonGSD与rac的管理工具dbca srvctl oem进行交互，用来完成实例的启动关闭等管理任务。为了保证这些管理工具运行正常必须在所有的节点上先start gsd,并且一个G转载 2017-10-08 17:20:12 · 1686 阅读 · 0 评论 -
dba_hist_active_sess_history中sample_time的采样时间
set lines 200 pages 55col KSPPINM format a25col KSPPSTVL format a22select a.ksppinm, b.ksppstvl from sys.x$ksppi a, sys.x$ksppcv b where a.indx = b.indx and a.ksppinm like '_ash%';KSPPINM原创 2017-10-08 20:42:55 · 1571 阅读 · 1 评论