ITPub博客

oracle@hostname $sqlplus / as sysdbaSQL*Plus: Release 10.2.0.2.0 - Production on Wed Aug 19 10:39:10 2009Copyright (c) 1982, 2005, Oracle. All Rights Reserved.Connected.SQL> startup nomount;ORA-01081: cannot start already-running ORACLE - shut it down firstSQL> shutdown immediate;ORA-24324: service handle not initializedORA-24323: value not allowedORA-01089: immediate shutdown in progress - no operations are permittedSQL> shutdown abort;ORA-01031: insufficient privilegesSQL> exitDis

一服务器出现无法使用sqlplusoracle@hostname>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.2.0 - Production on Mon Jul 13 08:52:45 2009Copyright (c) 1982, 2005, Oracle. All Rights Reserved.ERROR:ORA-09925: Unable to create audit trail fileIBM AIX RISC System/6000 Error: 89: Invalid file system control data detectedAdditional information: 9925ORA-01075: you are currently logged on检查对应的错误说明:oracle@hostname $oerr ora 992509925, 00000, "Unable to create audit trail file"// *Cause:

# smitty installp choose option 'update install'# instfix -i|grep SP All filesets for 5300-03-CSP_SP were found. All filesets for 5300-04-01_SP were found. All filesets for 5300-04-02_SP were found. All filesets for 5300-04-03_SP were found. All filesets for 5300-04-CSP_SP were found. All filesets for 5300-05-01_SP were found. All filesets for 5300-05-02_SP were found. All filesets for 5300-05-03_SP were found. All filesets for 5300-05-04_SP were found. All filesets

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 at location....."no found /etc/oraInst.loc in /etc,but found it in /oracle/oraInventory then:#cd /etc #ln -s /oracle/oraInventory/oraInst.loc oraInst.loc re-install the patchset ok.[@more@]

增加如下行到/etc/securettyrexecrshrloginpts/0pts/1打开服务Activate the services by issuingchkconfig rexec onchkconfig rlogin onchkconfig rsh on增加信任的主机名到/root/.rhosts改变文件属性为600chmod 600 /root/.rhosts增加主机名与/IP到/etc/hosts重启inetd服务service inetd restart[@more@]

windows2003服务器的一个普通用户不能正常启动sqlplus SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properl 下面的操作可以解决上面的问题。 Assign the "Create global objects" user right to the non-Administrator account. 1. Click Start, point to Programs, point to Administrative Tools, and then click Local Security Policy. 2. Expand Local Policies, and then click User Rights Assignment. 3. In the right pane, double-click Create global objects.

# ifconfig en1 detach # chdev -l ent1 -a use_alt_addr=yes -a alt_addr=0x001125cc23dd # ifconfig en1 up [@more@]

服务器在更新IP重启后发现listener无法启动,发生报错TNS-12537, TNS-12560, TNS-00507 ,检查配置正常,新建一个listener也一样.$ lsnrctl startLSNRCTL for HPUX: Version 10.2.0.4.0 - Production on 11-JUL-2009 10:16:59Copyright (c) 1991, 2004, Oracle. All rights reserved.Starting /db02/product/10.1/bin/tnslsnr: please wait...TNS-12537: TNS:connection closedTNS-12560: TNS:proto adapter errorTNS-00507: Connection closed检查/etc/hosts发现127.0.0.1 localhost.domain localhost这行已不存在.在system administrator修

一台P55A在重新开机后发生连接DB出错ORA-12547,检查后发现DB没有任何配置改变,listener也是以前所配的.检查到发现proc文件系统不存在,手工建立/proc,并重启服务器后正常. [@more@]

从网上摘录关于AWR的一些知识点要使用AWR必须设置STATISTICS_LEVEL参数，共有三个：BASIC、TYPICAL、ALL。Oracle 10g后，默认值是TYPICAL。查看默认参数设置:select snap_interval, retention from dba_hist_wr_control;默认情况为AWR的统计数据保留7天，并且每小时获取一次快照。Oracle 10g提供以下命令可以修改快照收集时间间隔和保存时间：execute dbms_workload_repository.modify_snapshot_settings(interval => 20, retention => 10080);以上命令修改为每20分钟收集一次并保留七天。可以为AWR数据创建baseline，保存这些数据

场景: RAC(10.2.0.2)生产数据库要复制一份到测试环境的单实例.并改变dbname(proddb->uatdb)步骤:1.热备RAC其中一个节点.2.将热备文件移到UAT对应的目录,以下步骤均在UAT上执行3.sqlplus / as sysdba alter system set db_name='proddb' scope=spfile; shutdown immediate startup mount;4.用命令alter database rename file将数据文件/在线重做日志文件目录改为UAT下对应的目录5.检查文件路径是否正确select name from v$datafile ; select name from v$tempfile; select member from v$logfile ;6.在sqlplus中执行 recover da

上了QUEST监控数据库软件,遇到第二个database bug,即Bug 5928612,Performance Analysis无法在历史中看到dbms_job所发出的SQL语句,即发现了某时段SQL执行异常也无法获得具体的SQL语句,反而只能用AWR/ADDM来取得当时的Top语句.目前数据库版本为10.2.0.2,需要升级到10.2.0.4以上.DescriptionIf a job is run through DBMS_JOB then the columnsSQL_ADDRESS and SQL_HASH_VALUE are not populated in V$SESSION which can hinder performance monitoring.(the columns show as 0). A similar issue exists for DBMS_SCHEDULER under <Bug:5

方法1: 安装gtar软件包,使用gtar cvzf,原有的tar不包含z选项方法2: 使用jar命令,如jar cvf db.jar /database_home方法3: 使用管道命令tar -cvf - 1* |compress > /tmp/1.Z[@more@]

背景说明: spotlight以RAC方式连接XDB数据库时产生连接成功后即中断,spotlight无法正常以RAC方式监控XDB; 但能以RAC方式监控同样平台,同样版本的另一个RAC数据库.分析:根据连接时产生的错误提示ORA-03113: end-of-file on communication channel, 并在alert数据库报警日志文件中产生trc文件及ORA-07445: exception encountered: core dump [] [] [] [] [] []错误提示. Trc文件中发现:*** 2009-03-03 15:44:47.458ksedmp: internal or fatal errorORA-07445: 鍑虹幇寮傚父閿欒?: 鏍稿績杞?偍 [] [] [] [] [] []Current SQL state

smit hostname改名后一个常见的问题是：hostname看到的是新名，uname -n看到的仍是旧名。没见IBM针对改名有官方的步骤，因此共享下我多年来的一直使用的方法。 1、smit hostname2、vi /etc/hosts3、uname -S`hostname|sed 's/..*$//'` 第三步为什么写得这么麻烦？因为是直接照搬/etc/rc.net。显然IBM这么做，是特意针对hostname.XXX.com这样类型的hostname的。 另外，补充个另类的方法——用smit tcpip也可以改名，印象中这样是可以省去uname -S的，不过不是很确定。来源:http://www.aixchina.net/?1865/viewspace-12675.html[@m

[root@linuxb local]# groupadd db2grp1[root@linuxb local]# groupadd db2fgrp1[root@linuxb local]# groupadd dasadm1[root@linuxb local]# useradd db2inst1 -g db2grp1[root@linuxb local]# useradd db2fenc1 -g db2fgrp1[root@linuxb local]# useradd dasusr1 -g dasadm1[root@linuxb local]# passwd db2inst1[root@linuxb local]# passwd db2fenc1[root@linuxb local]# passwd dasusr1http://he.fi/bchunk/[root@linuxb db2inst1]# rpm -ivh bchunk-1.2.0-0.i386.rpm[root@linuxb db2]# bchunk IBM.DB2.Enterprise.Edition.v8.2.Lin

问题描述:用户报应用无法访问,开发发现连接数据库异常进入OS,发现DB2已经crash,发出命令db2start,数据库启动,用户连接测试成功,但无法查询表,检查表空间发现数据/索引表空间状态为0x4080,rollforward pending.而用户临时表空间状态为0x4000db2 list tablespaces show detail|grep State执行:db2 "rollforward database ips3 to end of logs and stop tablespace (dataspace,idxspace,datasystmp) online"这几个表空间状态恢复正常,再检查用户临时表空间:db2 list tablespace containers for 6ls -rlt /dev/rlvdatautmp发现文件

下载并安装软件：opt-samba-base.tar.gzopt-samba-3.0.28-AIX5.tar.gz增加访问用户，并输入密码：[root@615 /]#./smbpasswd -a dslog修改配置文件smb.conf，增加访问内容：[dslog] comment = Datastage log directory browseable = yes writable = no path = /dswork/etlhome/etllog增加开机自动启动smb服务：[root@615 /]#cat /etc/inittab...smb:2:respawn:/usr/bin/sh /script/startsmb.sh #start samba[root@615 /]#cat /script/startsmb.sh/opt/pware/samba/3.0.28/sbin/nmbd -D/opt/pware/samba/3.0.28/sbin/smbd -D[@more

当更新一个大表，可能导致错误：DB21034E The command was processed as an SQL statement because it was not avalid Command Line Processor command. During SQL processing it returned:SQL0964C The transaction log for the database is full. SQLSTATE=57011可能的原因：1、事务过大，导致所有的日志文件都满，此时解决方法有：1）加大日志文件数量或容量2）在事务中对大表执行关闭日志操作db2 +c "alter table ods.table1 activate not logged initially"db2 +c "update ods.table1 set col1=''"两条命令要在

背景：UAT环境在开发阶段，更新比较频繁，开发人员要求能重启websphere进程；unix平台下容易做到，但windows平台通常情况下需要管理员或power users权限，此权限过大。多次测试后得到如下方法来控制：以windows平台下default profile为例1、新建本地用户admin_dev，权限组users,remote desktop users2、建立相关的发布目录，共享/授所有权给admin_dev，如d:citicups3、将目录E:IBMWebSphereAppServerlogs 以及目录E:IBMWebSphereAppServerprofilesdefault 授所有权给admin_dev4、这时对‘服务’中相关的websphere服务设置‘手动’启动5、本