<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>易陆发现论坛 - Oracle/DB2数据库</title>
    <link>https://www.bbs168x.cn/forum.php?mod=forumdisplay&amp;fid=52</link>
    <description>Latest 20 threads of Oracle/DB2数据库</description>
    <copyright>Copyright(C) 易陆发现论坛</copyright>
    <generator>Discuz! Board by Discuz! Team</generator>
    <lastBuildDate>Thu, 11 Jun 2026 15:52:00 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>https://www.bbs168x.cn/static/image/common/logo_88_31.gif</url>
      <title>易陆发现论坛</title>
      <link>https://www.bbs168x.cn/</link>
    </image>
    <item>
      <title>oracle rac使用iscsi设备</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=1794</link>
      <description><![CDATA[12.在 Oracle RAC 节点上配置 iSCSI 卷
在集群中的两个 Oracle RAC 节点上配置 iSCSI 启动器。但是，应当仅在 RAC 集群中的节点之一上执行创建分区的操作。iSCSI 客户端可以是任何提供 iSCSI 支持（驱动程序）的系统（Linux、Unix、MS Windows、Apple Mac 等）。在本例 ...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Fri, 09 Jul 2021 09:25:34 +0000</pubDate>
    </item>
    <item>
      <title>DB2 - 在LINUX上删除DB2v9.5(RHEL55)</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=1071</link>
      <description><![CDATA[Following are the steps to remove DB2 from Unix/Linux:1.Remove DB[首先删除数据库](1)su - db2inst1(2)db2 list db directory(3)db2 drop db2.Remove Instance【删除实例】(1)su - root(2)cd /instance(3)./db2ilist(4)./db2idrop -f3.Remove das【删除das】(1)su - ...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Tue, 27 Nov 2018 02:38:05 +0000</pubDate>
    </item>
    <item>
      <title>Oracle12C用户创建、授权、登录</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=1037</link>
      <description><![CDATA[Oracle12C用户创建、授权、登录　　1.以系统用户登录　　　　命令sqlplus sys/dwh as sysdba;


　　　　　　　　　2. 确认选择CDB


select name,cdb from v$database;







col pdb_name for a30



select pdb_id,pdb_name,dbid,status,creation_scn from dba_pdbs ...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sun, 11 Nov 2018 03:28:43 +0000</pubDate>
    </item>
    <item>
      <title>Oracle12c创建新用户提示公共用户名或角色无效</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=1036</link>
      <description><![CDATA[　今天将备份的数据库还原到一台新的电脑上，首先要创建用户，执行如下语句：create user fxhyidentified by \&quot;123456\&quot;default tablespace USERStemporary tablespace TEMP;
　　结果出现了一个错误：　　　　我们可以看出提示的是：公共用户名或角色无效。这时候我就郁 ...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sat, 10 Nov 2018 13:51:32 +0000</pubDate>
    </item>
    <item>
      <title>oracle增加表空间</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=991</link>
      <description><![CDATA[SQL&gt; conn v3er/Seeyo3
已连接。
SQL&gt; alter database datafile \'/u01/app/oracle/oradata/clouddb/V3XSPACE.DBF\' resize 29696M;
重新增加表空间]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sat, 13 Oct 2018 17:56:09 +0000</pubDate>
    </item>
    <item>
      <title>oracle数据查询用户和给数据库权限命令</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=990</link>
      <description><![CDATA[]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sat, 13 Oct 2018 07:57:23 +0000</pubDate>
    </item>
    <item>
      <title>linux 下创建oracle监听配置过程</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=989</link>
      <description><![CDATA[]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sat, 13 Oct 2018 07:37:46 +0000</pubDate>
    </item>
    <item>
      <title>The listener supports no services解决</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=988</link>
      <description><![CDATA[[oracle@adrep ~]$ lsnrctl start


LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:11:38


Copyright (c) 1991, 2011, Oracle.  All rights reserved.


Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sat, 13 Oct 2018 05:26:58 +0000</pubDate>
    </item>
    <item>
      <title>The listener supports no services解决</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=987</link>
      <description><![CDATA[[oracle@adrep ~]$ lsnrctl start


LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 14-SEP-2013 10:11:38


Copyright (c) 1991, 2011, Oracle.  All rights reserved.


Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sat, 13 Oct 2018 05:26:56 +0000</pubDate>
    </item>
    <item>
      <title>ORA-01031:insufficient privileges</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=986</link>
      <description><![CDATA[ORA-01031:insufficient privileges]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sat, 13 Oct 2018 04:27:53 +0000</pubDate>
    </item>
    <item>
      <title>oracle Listener failed to start. See the error message(s) above</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=985</link>
      <description><![CDATA[Listener failed to start. See the error message(s) above

检查监听程序的配置文件内容
cat /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/ad ...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sat, 13 Oct 2018 03:52:29 +0000</pubDate>
    </item>
    <item>
      <title>彻底删除Oracle数据库，创建相同实例名称的库</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=983</link>
      <description><![CDATA[]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sat, 13 Oct 2018 02:53:54 +0000</pubDate>
    </item>
    <item>
      <title>Linux下启动Oracle服务和监听程序</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=982</link>
      <description><![CDATA[]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Sat, 13 Oct 2018 02:51:44 +0000</pubDate>
    </item>
    <item>
      <title>rman 备份</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=967</link>
      <description><![CDATA[[oracle@oracle ~]$ rman target /
RMAN&gt; backup current controlfile;
/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_01_13/o1_mf_ncnnf_TAG20140113T112837_9f6qcg2z_.bkp   这是位置

RMAN&gt; backup database include current controlfile;  也可以这种方 ...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Wed, 10 Oct 2018 13:03:16 +0000</pubDate>
    </item>
    <item>
      <title>查看Oracle是否归档和修改归档模式</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=966</link>
      <description><![CDATA[查看oracle日志模式：archive log list



修改oracle日志模式：
1，关闭数据库：shutdown immediate;
2，启动数据库实例到mount状态：startup mount;
3，切换数据库日志模式：
      alter database archivelog;（设置数据库为归档日志模式）
      alter databa ...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Wed, 10 Oct 2018 12:50:12 +0000</pubDate>
    </item>
    <item>
      <title>数据库故障，空间无法扩展</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=962</link>
      <description><![CDATA[Detailed Task:
   检查空间为自动扩展，但是后台报错。
OER 7451 in Load Indicator : Error Code = OSD-04500: 指定了非法选项
O/S-Error: (OS 1) 函数不正确。 !
Wed Jan 08 10:47:49 2014
OER 7451 in Load Indicator : Error Code = OSD-04500: 指定了非法选项
O ...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Wed, 10 Oct 2018 04:52:25 +0000</pubDate>
    </item>
    <item>
      <title>OER 7451 in load Indicator:Error Code=OSD-04500:指定了非法选项</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=878</link>
      <description><![CDATA[OER 7451 in load Indicator:Error Code=OSD-04500:指定了非法选项

O/S-Erroros 1)函数不正确

诊断：64位操作系统安装了32位的oracle

卸载，重新安装吧。]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Tue, 18 Sep 2018 02:16:46 +0000</pubDate>
    </item>
    <item>
      <title>oracle-REDO日志文件分析（insert）</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=877</link>
      <description><![CDATA[1:记录当前scn
select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
                 1159572
2:创建表
CREATE TABLE team
(
  team_code    VARCHAR2(3),
  team_name    VARCHAR2(30),
  country_code VA .]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Tue, 18 Sep 2018 02:12:44 +0000</pubDate>
    </item>
    <item>
      <title>redo日志文件学习笔记</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=876</link>
      <description><![CDATA[于redo日志文件，今天因为要做redo日志的在线迁移，所以特意做了个简单的总结。

1. 如果要把redo的切换信息显示到alert日志中，需要设置个参数。
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mi ...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Tue, 18 Sep 2018 02:07:17 +0000</pubDate>
    </item>
    <item>
      <title>oracle安装报错</title>
      <link>https://www.bbs168x.cn/forum.php?mod=viewthread&amp;tid=466</link>
      <description><![CDATA[Exception in thread \&quot;main\&quot; java.lang.UnsatisfiedLinkError: /tmp/OraInstall2017-09-23_12-29-47AM/jdk/jre/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory
安装时报错，解决办法：

# yum install -y libXex ...]]></description>
      <category>Oracle/DB2数据库</category>
      <author>admin</author>
      <pubDate>Fri, 22 Sep 2017 08:29:58 +0000</pubDate>
    </item>
  </channel>
</rss>