<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/chenyao1897</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; chenyao1897]]></copyright><item><title><![CDATA[连接Oracle出错：sqlplus "/as sysdba"]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717576</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717576</guid><author>chenyao1897</author><pubDate>Fri, 06 Sep 2019 14:50:00 +0800</pubDate><description><![CDATA[执行sqlplus "/as sysdba" 出现错误：sqlplus: error while loading shared libraries: /u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.11.1: cannot restor...]]></description><category></category></item><item><title><![CDATA[or each row触发器]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717578</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717578</guid><author>chenyao1897</author><pubDate>Thu, 05 Sep 2019 16:34:00 +0800</pubDate><description><![CDATA[create table test(id number); 
 create table audit_table(table_name varchar2(20),ins int,upd int,del int); 
 create or replace trigger test_tri ...]]></description><category></category></item><item><title><![CDATA[如何快速把一个11g数据库插入到12c cdb中去？]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717573</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717573</guid><author>chenyao1897</author><pubDate>Wed, 04 Sep 2019 15:43:00 +0800</pubDate><description><![CDATA[使用DBMS_PDB把一个11g数据库插入到12c cdb中去 
环境: 
windows 7 
源库:orcl oracle 11.2.0.4 
目标库:cdbdb 12.2.0.1 ,pdb:sztech 
1.源库先升级到12c 
这个步骤略,可以通过dbua完成 
2.原库以只读方式打...]]></description><category></category></item><item><title><![CDATA[Oracle Listener 静态注册]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717575</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717575</guid><author>chenyao1897</author><pubDate>Tue, 03 Sep 2019 15:01:00 +0800</pubDate><description><![CDATA[静态注册 
静态注册就是实例启动时读取listener.ora文件的配置，将实例和服务注册到监听程序。无论何时启动一个数据库， 
默认地都有两条信息注册到监听器中：数据库服务器对应的实例和服务。 
静态注册时，listener.ora中的GLOBAL_DBNAME向外提供服务名，listene...]]></description><category></category></item><item><title><![CDATA[Oracle Listener 动态注册]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717571</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717571</guid><author>chenyao1897</author><pubDate>Mon, 02 Sep 2019 16:36:00 +0800</pubDate><description><![CDATA[动态注册是在instance启动的时候PMON进程根据init.ora中的instance_name,service_names两个参数将实例和服务动态注册到listener中。 
 首先要在init.ora中指定instance_name,service_names两个参数的值。在sq...]]></description><category></category></item><item><title><![CDATA[使用data pump驱动的外部表移动数据]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717570</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717570</guid><author>chenyao1897</author><pubDate>Sat, 31 Aug 2019 15:47:00 +0800</pubDate><description><![CDATA[使用data pump驱动的外部表移动数据 
  比如我们有一个报表的数据,准备从一个数据库A中移动到另一个数据库B中,如何实现? 
  这个问题,我们使用带data pump驱动的外部表方式,很容易实现,具体方法如下: 
  1.在A库中,使用data pump驱动创建一个外部...]]></description><category></category></item><item><title><![CDATA[在解决了ORA-600 [2662]后，库启动的时候出现ORA-600[4193]错误]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717567</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717567</guid><author>chenyao1897</author><pubDate>Fri, 30 Aug 2019 16:42:00 +0800</pubDate><description><![CDATA[ORA-600[4193]解决 
在解决了ORA-600 [2662]后，库启动的时候出现ORA-600[4193]错误 
 Tue Feb 14 09:34:11 2012 Errors in file d:\oracle\product\10.2.0\admin\interlib\bdum...]]></description><category></category></item><item><title><![CDATA[普通用户 要导整个数据库需要 什么权限？]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717566</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717566</guid><author>chenyao1897</author><pubDate>Wed, 28 Aug 2019 16:17:00 +0800</pubDate><description><![CDATA[普通用户 hr进行expdp数据导出，报权限不够的错误 
 [oracle@dbserver ~]$ expdp hr/hr directory=exp_dir dumpfile=full.dmp full=y 
 Export: Release 11.2.0.4.0 - Product...]]></description><category></category></item><item><title><![CDATA[asm磁盘路径 包含混合路径时 的设置]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717565</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717565</guid><author>chenyao1897</author><pubDate>Tue, 27 Aug 2019 17:08:00 +0800</pubDate><description><![CDATA[如果asm磁盘发现路径中，既有udev方式创建的磁盘，又有asmlib创建的磁盘，那么，在asm_diskstring中，需要把两种情况都设置： 
   
  
    asm_diskstring string /dev/*, ORCL:* 
   
  
    否...]]></description><category></category></item><item><title><![CDATA[关于varchar 与 varchar2的讨论]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717563</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717563</guid><author>chenyao1897</author><pubDate>Fri, 23 Aug 2019 14:52:00 +0800</pubDate><description><![CDATA[我们习惯了使用varchar2.但原因知之甚少： 
  
   
  
     
   
  
   图示为新建表为varchar 类型、 查看表定于 却显示为varchar2  我们来看下官网的定义： 
  
   
  
     
   
  
 网上资料说： varchar...]]></description><category></category></item><item><title><![CDATA[oracle 采用操作系统 认证登陆数据库]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717562</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717562</guid><author>chenyao1897</author><pubDate>Wed, 21 Aug 2019 14:45:00 +0800</pubDate><description><![CDATA[以oracle用户登陆操作系统，用sys用户任意密码登陆。 [oracle@dbsrv ~]$ sqlplus sys/akdosfw as sysdba  SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 24 06:39:31 2015 ...]]></description><category></category></item><item><title><![CDATA[OGG启动报错：不能创建 共享内存段]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717560</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717560</guid><author>chenyao1897</author><pubDate>Tue, 20 Aug 2019 15:22:00 +0800</pubDate><description><![CDATA[错误日志信息： mgr.prm: Datastore in 'dirbdb':BDB1546 unable to join the environment: unable to create shared system memory region:No space left on Device...]]></description><category></category></item><item><title><![CDATA[使用recovery catalog查看数据库过去的定义]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717559</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717559</guid><author>chenyao1897</author><pubDate>Mon, 19 Aug 2019 18:02:00 +0800</pubDate><description><![CDATA[recovery catalog 应用之一:使用recovery catalog查看数据库过去的定义 
  我们平时通过report schema看到的是当前数据库的定义信息， 
  如果使用 recovery catalog的情况下，我们可以看到数据库以前的数据结构的信息 
 ...]]></description><category></category></item><item><title><![CDATA[关于SYSTEM表空间的表删除后不会进入回收站的疑惑]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717558</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717558</guid><author>chenyao1897</author><pubDate>Sat, 17 Aug 2019 16:59:00 +0800</pubDate><description><![CDATA[我们知道Oracle有一个回收站的功能，如果删除表的时候不使用purge选项，则会进入到回收站，可以使用Flashback闪回删除。具体如下： 
  SQL&gt; select * from v$version; 
  
  BANNER 
  
  Oracle Database 1...]]></description><category></category></item><item><title><![CDATA[linux下取消挂载时报xxxx device is bus]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717557</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717557</guid><author>chenyao1897</author><pubDate>Fri, 16 Aug 2019 15:52:00 +0800</pubDate><description><![CDATA[报错现象; 
  取消使用umount /u01/mount/会出现 
  umount2: Device or resource busy 
  umount: /u01/mount: device is busy. 
  (In some cases useful info ...]]></description><category></category></item><item><title><![CDATA[ORA-04031 large pool PX msg pool 不足错误解决]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717555</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717555</guid><author>chenyao1897</author><pubDate>Thu, 15 Aug 2019 15:39:00 +0800</pubDate><description><![CDATA[今天接到用户反映,执行一个查询select * from xxx,就会挂起,后端报警文件在报大池无法分配的问题,具体如下: 
   
  
    Tue Oct 11 15:26:06 2016 
   
  
    Errors in file c:\app\ad...]]></description><category></category></item><item><title><![CDATA[insert中启用 错误日志的 问题及分析]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717554</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717554</guid><author>chenyao1897</author><pubDate>Wed, 14 Aug 2019 17:29:00 +0800</pubDate><description><![CDATA[在平时的工作中，有时候需要insert一批数据，这些数据可能是临时表，外部表，普通表，子查询等形式，类似下面的格式 insert into xxxx (select xxxxx from xxx where xxxxx); 如果其中有冗余数据的时候，整个Insert会自动rollback,一条...]]></description><category></category></item><item><title><![CDATA[成ORA-12560：TNS：协议适配器错误的问题的原因]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717553</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717553</guid><author>chenyao1897</author><pubDate>Mon, 12 Aug 2019 16:45:00 +0800</pubDate><description><![CDATA[造成ORA-12560: TNS: 协议适配器错误的问题的原因有三个： 
1.监听服务没有起起来。windows平台个一如下操作：开始---程序---管理工具---服务，打开服务面板， 
启动oraclehome92TNSlistener服务。 
2.database instance没有起起...]]></description><category></category></item><item><title><![CDATA[使用recovery catalog查看数据库过去的定义]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717552</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717552</guid><author>chenyao1897</author><pubDate>Sat, 10 Aug 2019 16:48:00 +0800</pubDate><description><![CDATA[我们平时通过report schema看到的是当前数据库的定义信息， 
如果使用 recovery catalog的情况下，我们可以看到数据库以前的数据结构的信息 
比如： 
1.增加表空间前的情况： 
[oracle@dbserver ~]$ rman target / catalog rm...]]></description><category></category></item><item><title><![CDATA[使用 gather_plan_statistics hint 产生执行计划]]></title><link>https://blog.youkuaiyun.com/chenyao1897/article/details/100717550</link><guid>https://blog.youkuaiyun.com/chenyao1897/article/details/100717550</guid><author>chenyao1897</author><pubDate>Fri, 09 Aug 2019 17:28:00 +0800</pubDate><description><![CDATA[首先sqlplus登陆当前用户 2、执行 运行 sql语句 ，在语句中加入 /*+ gather_plan_statistics */ 例子： 执行 sql 语句 select /*+ gather_plan_statistics */ count(employee_id) from hr.e...]]></description><category></category></item></channel></rss>