<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[orabing的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/orabing</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; orabing]]></copyright><item><title><![CDATA[Oracle GoldenGate Director 12.1.2安装及配置]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/82999772</link><guid>https://blog.youkuaiyun.com/orabing/article/details/82999772</guid><author>orabing</author><pubDate>Wed, 10 Oct 2018 16:56:50 +0800</pubDate><description><![CDATA[一、安装前工作：
1、根据官网建议修改游标数大到2000：
SQL&amp;gt; show parameter cursor

NAME                     TYPE
------------------------------------ ----------------------
VALUE
------------------------------
cursor_bind_...]]></description><category></category></item><item><title><![CDATA[p26519424_1036_Generic补丁升级]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/79932176</link><guid>https://blog.youkuaiyun.com/orabing/article/details/79932176</guid><author>orabing</author><pubDate>Fri, 13 Apr 2018 17:30:12 +0800</pubDate><description><![CDATA[补丁更新方法：
 - unzip p26519424_1036_Generic.zip to {MW_HOME}/utils/bsu/cache_dir or any local directory
   
   Note: You must make sure that the target directory for unzip has required write and execut]]></description><category></category></item><item><title><![CDATA[ogg12.2安装及初始配置]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/79932093</link><guid>https://blog.youkuaiyun.com/orabing/article/details/79932093</guid><author>orabing</author><pubDate>Fri, 13 Apr 2018 17:25:59 +0800</pubDate><description><![CDATA[一、配置环境
            source                                 target
IP地址 192.168.184.220 
   192.168.184.221 
操作系统    oracle linux 6.8                       oracle linux 6.8
数据库软件  ORACLE 11.2.0.4  ]]></description><category></category></item><item><title><![CDATA[oracle 12.2DBRU]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/79932018</link><guid>https://blog.youkuaiyun.com/orabing/article/details/79932018</guid><author>orabing</author><pubDate>Fri, 13 Apr 2018 17:22:28 +0800</pubDate><description><![CDATA[一、使用opatch工具分析补丁冲突
[oracle@ogg2 ~]$ export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
[oracle@ogg2 ~]$ opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.6
Copyright (c) 2]]></description><category></category></item><item><title><![CDATA[oracle 11.2.0.4 PSU补丁升级]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/79763778</link><guid>https://blog.youkuaiyun.com/orabing/article/details/79763778</guid><author>orabing</author><pubDate>Fri, 30 Mar 2018 21:50:51 +0800</pubDate><description><![CDATA[一、准备工作
1、下载补丁程序
oracle patch是oracle的更新工具，由于本次更新补丁要求使用OPatch 11.2.0.3.6以上，而默认安装的oracle 11.2.0.4的OPatch为11.2.0.3.5。
为此需要下载一个新的OPatch工具。下载地址：https://updates.oracle.com/download/6880880.html
p6880880_]]></description><category></category></item><item><title><![CDATA[迁移中修改oracle数据库名及实例名]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/72581714</link><guid>https://blog.youkuaiyun.com/orabing/article/details/72581714</guid><author>orabing</author><pubDate>Sat, 20 May 2017 17:30:44 +0800</pubDate><description><![CDATA[因工作需要，需要将部署在两台虚拟机且数据库名相同的oracle数据库迁移到一台物理机上。一个数据库500G，一个100G，若不考虑数据库名相同的情况下，最简便的办法是停数据库，然后将数据文件、联机日志文件、控制文件、口令文件、spfile、tnsname等文件一并拷贝到新服务器上即可直接使用，但是数据库名、实例名相同则无法这样实现。
本计划通过冷备份的方式将500G的数据库拷贝到新服务器上，然后]]></description><category></category></item><item><title><![CDATA[nginx的https代理配置]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/64437673</link><guid>https://blog.youkuaiyun.com/orabing/article/details/64437673</guid><author>orabing</author><pubDate>Tue, 21 Mar 2017 09:36:49 +0800</pubDate><description><![CDATA[使用nginx配置https代理分为两种，一种是后端为http应用时前端代理使用ssl证书配置https的反向代理，另一种是后端为https应用，前端仅做反向代理，本文阐述第一种方案的配置方法。]]></description><category></category></item><item><title><![CDATA[由impdp导入引起的oracle用户权限的问题]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/55194330</link><guid>https://blog.youkuaiyun.com/orabing/article/details/55194330</guid><author>orabing</author><pubDate>Wed, 15 Feb 2017 14:00:34 +0800</pubDate><description><![CDATA[根据业务要求需要将数据库上的TEST用户下的所有对象复制到一个新建的用户TEST2上，但不需要表数据。想到的办法是先用expdp的CONTENT=METADATA_ONLY参数导出元数据，然后使用impdp的remap_schema=TEST:TEST2来转换，完成业务要求。
      提交给业务部门后，又提出要求需要将TEST2业务表使用的表空间与索引表空间分配到指定表空间并分开。
使用如]]></description><category></category></item><item><title><![CDATA[ORACLE 11G双节点RAC配置单实例DG]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/55100794</link><guid>https://blog.youkuaiyun.com/orabing/article/details/55100794</guid><author>orabing</author><pubDate>Tue, 14 Feb 2017 17:10:24 +0800</pubDate><description><![CDATA[一、环境




database

db_unique_name

net service name

SID

os version

DB version


primary

jgsb

jg_pd

jgsb

oracle linux 6.7 x64

11.2.0.4


physical standby

jgsbd]]></description><category></category></item><item><title><![CDATA[linux 下oracle自动启动]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53944432</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53944432</guid><author>orabing</author><pubDate>Fri, 30 Dec 2016 16:24:42 +0800</pubDate><description><![CDATA[1、修改/etc/oratab
[root@db ~]# cat /etc/oratab
#
# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a datab]]></description><category></category></item><item><title><![CDATA[oracle 12c pdb与cdb]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53726843</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53726843</guid><author>orabing</author><pubDate>Sun, 18 Dec 2016 13:20:45 +0800</pubDate><description><![CDATA[一、概念
CDB的组件：
  Root：即CDB$ROOT，保存了元数据及通用用户。如PL/SQL包的源码就是元数据。通用用户是指每一个容器都知道的数据库用户。
  The root,namedCDB$ROOT, stores Oracle-supplied metadata andcommon users. An example ofmetadata is the source code ]]></description><category></category></item><item><title><![CDATA[CRS-1714 Unable to discover any voting files]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53575695</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53575695</guid><author>orabing</author><pubDate>Sun, 11 Dec 2016 21:29:21 +0800</pubDate><description><![CDATA[RHEL6.7+ORACLE 11.2.0.4rac环境，重启一个节点，发现crs起不来，ASM起不来

故障情况：
[root@rac2 ~]# /oracle/app/grid/product/11.2.0/bin/crsctl start crs
CRS-4640: Oracle High Availability Services is already active
CRS-40]]></description><category></category></item><item><title><![CDATA[oracle11gRAC votingdisk全部丢失处理]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53575558</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53575558</guid><author>orabing</author><pubDate>Sun, 11 Dec 2016 21:12:53 +0800</pubDate><description><![CDATA[环境：oracle linux 6.7+oracle11.2.0.4 RAC
因在存储上误操作仲裁盘全部丢失，从而导致rac数据库崩溃无法再启动。
1、现象
fdisk以及multipath中无法找到ocr所在磁盘

tail -100 alertdgdb1.log
集群日志出现：
[cssd(18729)]CRS-1714:Unable to discover any voting]]></description><category></category></item><item><title><![CDATA[手动注册database至crs中]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53415223</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53415223</guid><author>orabing</author><pubDate>Wed, 30 Nov 2016 23:05:42 +0800</pubDate><description><![CDATA[项目现场备用库为rac平台，通过duplicate方式配置备用库后，需要手动将database信息注册到crs中，方便进行集群资源管理。
  添加database信息至crs中，需要在oracle用户下执行，在grid用户下执行将报错。
[oracle@dgdb1 ~]$ srvctl add database -d rlzydg -o /u01/app/oracle/product/11.2]]></description><category></category></item><item><title><![CDATA[Oracle 11g RAC CRS-4535/ORA-15077]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53401548</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53401548</guid><author>orabing</author><pubDate>Tue, 29 Nov 2016 22:39:27 +0800</pubDate><description><![CDATA[oracle 11.2.0.4的rac集群，其中一个节点出现故障，集群无法启动，
使用crsctl check crs查看集群状况如下：
[grid@db2 client]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Clu]]></description><category></category></item><item><title><![CDATA[weblogic部署应用出现cannot be cast to java.util.Even]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53401405</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53401405</guid><author>orabing</author><pubDate>Tue, 29 Nov 2016 22:34:10 +0800</pubDate><description><![CDATA[在部署weblogic12.1.3的版本中部署生产应用，部署完成后却无法启动，提示“cannot be cast to java.util.Even”，查看weblogic日志出现如下错误信息：
    
p_ggfw".> 
     
    
weblogic.application.ModuleException: java.lang.ClassCastException: co]]></description><category></category></item><item><title><![CDATA[客户端访问scan IP出现ora12545错误]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53385082</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53385082</guid><author>orabing</author><pubDate>Mon, 28 Nov 2016 21:27:51 +0800</pubDate><description><![CDATA[现场环境是oracle linux 5.7下一个双节点版本为11.2.0.4的rac集群，运行着3个数据库，有3个scan ip。
在使用过程中发现使用scan ip连接其中一个数据库服务名时经常出现oracle TNS-12545:因目标主机或对象不存在的错误，有时又能访问。使用该scan ip访问其他两个数据库服务名完全正常，未出现12545错误。随即通过vip地址尝试访问有问题的数据库，测]]></description><category></category></item><item><title><![CDATA[weblogic去项目名访问]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53384726</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53384726</guid><author>orabing</author><pubDate>Mon, 28 Nov 2016 20:56:04 +0800</pubDate><description><![CDATA[因现场应用需要，使访问weblogic的项目能够以ip加端口的方式访问。通过查资料设置方法很简单，只需要将应用包下的WEB-INFO文件夹中的weblogic.xml文件添加“/”即可，见下：
[root@app WEB-INF]# cat weblogic.xml


-----中间省略----
/

   设置完成后需要重启weblogic服务才能生效，在控制台--部署中重启应用]]></description><category></category></item><item><title><![CDATA[oracle rac 添加SCAN IP]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53371010</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53371010</guid><author>orabing</author><pubDate>Mon, 28 Nov 2016 00:02:34 +0800</pubDate><description><![CDATA[因现场应用需要，需要对新配置的oracle RAC环境增配2个scanIP地址，10.138.129.106以及10.138.129.107。
       配置前情况：
      [grid@db1 ~]$ srvctl config scan                    ----查看scan的配置信息
      SCAN name: scan-ip, Network: 1/]]></description><category></category></item><item><title><![CDATA[oracle ASM实例ORA-04031故障处理]]></title><link>https://blog.youkuaiyun.com/orabing/article/details/53370484</link><guid>https://blog.youkuaiyun.com/orabing/article/details/53370484</guid><author>orabing</author><pubDate>Sun, 27 Nov 2016 23:43:37 +0800</pubDate><description><![CDATA[数据库服务器为两台AIX小型机配置的2点11gR2
 RAC数据库。故障发生后，业务应用无法连接数据库故障，数据库整体故障，而非某一节点故障导致。
         首先，通过cts_stat -t查看集群资源，发现两个节点的实例状态是offline，其他集群资源正常。随即登陆node2数据库，发现数据库实例的状态为“start”即no
 mount状态，尝试open数据库，无法open。]]></description><category></category></item></channel></rss>