<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[coxful1239的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/coxful1239</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; coxful1239]]></copyright><item><title><![CDATA[数据库无法关闭及启动(ora-24324,ora-01089)]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316612</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316612</guid><author>coxful1239</author><pubDate>Wed, 19 Aug 2009 10:52:55 +0800</pubDate><description><![CDATA[oracle@hostname $sqlplus / as sysdbaSQL*Plus: Release 10.2.0.2.0 - Production on Wed Aug 19 10:39:10 2009Copyright...]]></description><category></category></item><item><title><![CDATA[ORA-09925&ORA-01075错误处理]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316609</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316609</guid><author>coxful1239</author><pubDate>Mon, 13 Jul 2009 09:48:50 +0800</pubDate><description><![CDATA[一服务器出现无法使用sqlplusoracle@hostname&gt;sqlplus / as sysdbaSQL*Plus: Release 10.2.0.2.0 - Production on Mon Jul 13 08:...]]></description><category></category></item><item><title><![CDATA[5300-04安装补丁至5300-05]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316610</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316610</guid><author>coxful1239</author><pubDate>Tue, 23 Jun 2009 14:34:40 +0800</pubDate><description><![CDATA[# smitty installp choose option 'update install'# instfix -i|grep SP    All filesets for 5300-03-CSP_SP were found...]]></description><category></category></item><item><title><![CDATA[Unable to create a new central inventory at location.....]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316606</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316606</guid><author>coxful1239</author><pubDate>Sat, 20 Jun 2009 16:36:48 +0800</pubDate><description><![CDATA[when upgrade db from 10.2.0.1 to 10.2.0.4 on redhat es4 64bit get error "Unable to create a new central inventory ...]]></description><category></category></item><item><title><![CDATA[在redhat上使用rsh]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316604</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316604</guid><author>coxful1239</author><pubDate>Fri, 19 Jun 2009 08:45:26 +0800</pubDate><description><![CDATA[增加如下行到/etc/securettyrexecrshrloginpts/0pts/1打开服务Activate the services by issuingchkconfig rexec onchkconfig rlogin...]]></description><category></category></item><item><title><![CDATA[zt: windows2003管理（SP2-1503）]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316603</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316603</guid><author>coxful1239</author><pubDate>Thu, 18 Jun 2009 09:02:44 +0800</pubDate><description><![CDATA[windows2003服务器的一个普通用户不能正常启动sqlplus SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not b...]]></description><category></category></item><item><title><![CDATA[变更AIX下网卡的MAC地址]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316600</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316600</guid><author>coxful1239</author><pubDate>Mon, 15 Jun 2009 13:49:10 +0800</pubDate><description><![CDATA[# ifconfig en1 detach # chdev -l ent1 -a use_alt_addr=yes -a alt_addr=0x001125cc23dd # ifconfig en1 up [@more@]
  ...]]></description><category></category></item><item><title><![CDATA[TNS-12537, TNS-12560, TNS-00507的处理]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316601</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316601</guid><author>coxful1239</author><pubDate>Mon, 15 Jun 2009 11:24:46 +0800</pubDate><description><![CDATA[服务器在更新IP重启后发现listener无法启动,发生报错TNS-12537, TNS-12560, TNS-00507 ,检查配置正常,新建一个listener也一样.$ lsnrctl startLSNRCTL for H...]]></description><category></category></item><item><title><![CDATA[connect / as sysdba时发生ORA-12547]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316602</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316602</guid><author>coxful1239</author><pubDate>Mon, 15 Jun 2009 11:19:23 +0800</pubDate><description><![CDATA[一台P55A在重新开机后发生连接DB出错ORA-12547,检查后发现DB没有任何配置改变,listener也是以前所配的.检查到发现proc文件系统不存在,手工建立/proc,并重启服务器后正常. [@more@]
     ...]]></description><category></category></item><item><title><![CDATA[ora-27046处理]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316594</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316594</guid><author>coxful1239</author><pubDate>Fri, 24 Apr 2009 23:24:25 +0800</pubDate><description><![CDATA[今天晚上处理一个UAT CASE,数据库无法OPEN,报错某数据文件无法识别,报错ora-1157&amp;ora-01110检查文件,发现指定的文件存在,但时间与其它文件有差异.打开报警日志文件,再发现ora-27046报错,...]]></description><category></category></item><item><title><![CDATA[关于AWR的几个知识点]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316631</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316631</guid><author>coxful1239</author><pubDate>Tue, 21 Apr 2009 13:42:10 +0800</pubDate><description><![CDATA[从网上摘录关于AWR的一些知识点要使用AWR必须设置STATISTICS_LEVEL参数，共有三个：BASIC、TYPICAL、ALL。Oracle 10g后，默认值是TYPICAL。查看默认参数设置:select snap_i...]]></description><category></category></item><item><title><![CDATA[RAC数据库COPY到单实例的测试环境]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316598</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316598</guid><author>coxful1239</author><pubDate>Tue, 14 Apr 2009 16:51:31 +0800</pubDate><description><![CDATA[场景: RAC(10.2.0.2)生产数据库要复制一份到测试环境的单实例.并改变dbname(proddb-&gt;uatdb)步骤:1.热备RAC其中一个节点.2.将热备文件移到UAT对应的目录,以下步骤均在UAT上执行3.s...]]></description><category></category></item><item><title><![CDATA[遇到Bug 5928612]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316592</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316592</guid><author>coxful1239</author><pubDate>Fri, 10 Apr 2009 14:00:12 +0800</pubDate><description><![CDATA[上了QUEST监控数据库软件,遇到第二个database bug,即Bug 5928612,Performance Analysis无法在历史中看到dbms_job所发出的SQL语句,即发现了某时段SQL执行异常也无法获得具体的...]]></description><category></category></item><item><title><![CDATA[Aix下使用压缩命令压缩目录]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316591</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316591</guid><author>coxful1239</author><pubDate>Fri, 10 Apr 2009 13:54:28 +0800</pubDate><description><![CDATA[方法1: 安装gtar软件包,使用gtar cvzf,原有的tar不包含z选项方法2: 使用jar命令,如jar cvf db.jar /database_home方法3: 使用管道命令tar -cvf - 1* |compre...]]></description><category></category></item><item><title><![CDATA[遇到BUG:5103658]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316634</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316634</guid><author>coxful1239</author><pubDate>Tue, 31 Mar 2009 09:25:53 +0800</pubDate><description><![CDATA[背景说明: spotlight以RAC方式连接XDB数据库时产生连接成功后即中断,spotlight无法正常以RAC方式监控XDB;         但能以RAC方式监控同样平台,同样版本的另一个RAC数据库.分析:根据连接时产...]]></description><category></category></item><item><title><![CDATA[zt:AIX修改主机名z]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316632</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316632</guid><author>coxful1239</author><pubDate>Tue, 31 Mar 2009 09:09:18 +0800</pubDate><description><![CDATA[smit hostname改名后一个常见的问题是：hostname看到的是新名，uname -n看到的仍是旧名。没见IBM针对改名有官方的步骤，因此共享下我多年来的一直使用的方法。 1、smit hostname2、vi /et...]]></description><category></category></item><item><title><![CDATA[install db2v8 on linux]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316589</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316589</guid><author>coxful1239</author><pubDate>Fri, 06 Feb 2009 09:49:31 +0800</pubDate><description><![CDATA[[root@linuxb local]# groupadd db2grp1[root@linuxb local]# groupadd db2fgrp1[root@linuxb local]# groupadd dasadm1[r...]]></description><category></category></item><item><title><![CDATA[db2表空间状态为0x4080]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316587</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316587</guid><author>coxful1239</author><pubDate>Thu, 22 Jan 2009 21:08:30 +0800</pubDate><description><![CDATA[问题描述:用户报应用无法访问,开发发现连接数据库异常进入OS,发现DB2已经crash,发出命令db2start,数据库启动,用户连接测试成功,但无法查询表,检查表空间发现数据/索引表空间状态为0x4080,rollforwar...]]></description><category></category></item><item><title><![CDATA[AIXv5.3安装smb]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316588</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316588</guid><author>coxful1239</author><pubDate>Thu, 11 Sep 2008 16:01:36 +0800</pubDate><description><![CDATA[下载并安装软件：opt-samba-base.tar.gzopt-samba-3.0.28-AIX5.tar.gz增加访问用户，并输入密码：[root@615 /]#./smbpasswd -a dslog修改配置文件smb.c...]]></description><category></category></item><item><title><![CDATA[db2更新大表]]></title><link>https://blog.youkuaiyun.com/coxful1239/article/details/100316582</link><guid>https://blog.youkuaiyun.com/coxful1239/article/details/100316582</guid><author>coxful1239</author><pubDate>Wed, 23 Jul 2008 14:49:39 +0800</pubDate><description><![CDATA[当更新一个大表，可能导致错误：DB21034E The command was processed as an SQL statement because it was not avalid Command Line Proce...]]></description><category></category></item></channel></rss>