【Troubleshooting】EXP-00091 Exporting questionable statistics

操作系统:soalris10 数据库版本:9i 日期:2013-2-19 问题: 使用exp导出时,出现EXP-00091 Exporting questionable statistics错误 分析: [cce] [oracle10g@ ~]$ oerr exp 00091 00091, 00000, "Exporting questionable statistics." // *Cause: Export was able export statistics, but the statistics may not be // usuable. The statistics are questionable because one or more of // the following happened during export: a row error occurred, client // character set or NCHARSET does not match with the server, a query // clause was specified on export, only certain partitions or // subpartitions were exported, or a fatal error occurred while // processing a table. // *Action: To export non-questionable statistics, change the client character // set or NCHARSET to match the server, export with no query clause, // export complete tables. If desired, import parameters can be // supplied so that only non-questionable statistics will be imported, // and all … [Read more...]

【Troubleshooting】ORA-27300:OS system dependent operationfork failed with status 12

【问题描述】 操作系统为AIX,在数据库的Alert日志中,出现如下报错: [cce] ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at: skgpspawn3 Fri Jul 13 13:33:08 2012 Process m000 died, see its trace file Fri Jul 13 13:33:08 2012 ksvcreate: Process(m000) creation failed Fri Jul 13 13:34:08 2012 Process startup failed, error stack: Fri Jul 13 13:34:08 2012 Errors in file /oracle/admin/nms115/bdump/nms115_psp0_7667948.trc: ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at: skgpspawn3 Fri Jul 13 13:34:09 2012 Process m000 died, see its trace file Fri Jul 13 13:34:09 2012 ksvcreate: Process(m000) creation failed Fri Jul 13 13:35:27 2012 Thread 1 advanced to log sequence 3275 (LGWR switch)   Current log# 3 seq# 3275 mem# 0: … [Read more...]

【Troubleshooting】ORA-12505 TNS:listener does not currently know of SID given in connect descriptor

【问题描述】 启动应用的过程中,出现如下提示,说明应用无法连接到数据库。 [cce][ERROR] 2013-05-08 10:47:21,993 org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Listen er refused the connection with the followin g error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: rac1:1521:racdb )[/cce] 【处理过程】 由于数据库是RAC环境,因此怀疑是应用jdbc的配置不适用于RAC环境。 [cce] #hibernate config hibernate.dialect=org.hibernate.dialect.OracleDialect iam.jdbc.database=oracle iam.jdbc.driverClassName:oracle.jdbc.driver.OracleDriver iam.jdbc.url:jdbc:oracle:thin:@192.168.1.111:1521:username iam.jdbc.username:username iam.jdbc.password:password [/cce] 上面的写法不适用于RAC环境,因此要修改为下面的写法: [cce] #hibernate … [Read more...]

【Troubleshooting】<0>Kernel panic-not syncing: Fatal exception

  现象: Vsphere的虚拟机从一台主机中迁移到新购买的HP主机中,所有windows系统的虚拟机均正常,Redhat linux系统的均无法启动。 报错如下:       处理方法: Vmware的解释如下:   1      CentOS and Red Hat 5.5 kernel panic on boot after install on AMD Opteron 6000-series based ESX/ESXi hosts 2       Symptoms After installing CentOS or Red Hat 5.5 on an AMD Opteron 6000-series based ESX/ESXi host, the guest OS may kernel panic with a crash signature similar to: RIP  [<ffffffff8008192f>] cpuid4_cache_lookup+0x256/0x356 RSP <ffff81010fc75d60> CR2: 0000000000000040 <0>Kernel panic - not syncing: Fatal exception 3       Resolution This is not a VMware issue. A fix is available in kernel-2.6.18-194.3.1.el5 (available from Red Hat) and later. For more information on this issue, see Red Hat article 37935. 4       Request a Product Feature To … [Read more...]