STEPHEN_ORACLE 'S LIFE

今天有个数据库很繁忙，开发反应调度跑的很慢， 去os上观察，发现os的IO非常高，停掉调度任务后，仍然很高， 关掉所有应用，关掉监听，io依然很高，于是乎 决定关闭数据库重启，结果遇到如下报错:SHUTDOWN: waiting for active calls to complete.Active call for process 26348 user 'oracle' program 'o

今天想把一张190G的大表，转成分区表。且按月自动分区再导入过程中报错了:ORA-02354: error in exporting/importing dataORA-14400: inserted partition key does not map to any partitionProcessing object type TABLE_EXPORT/TABLE/COMMENT怀疑是有非法

需要sql语句： SELECT * FROM cux.CUX_SETT_XLA_LINES V WHERE V.SOURCE_CODE = 'STR' AND v.created_by = 0 AND v.accounting_date =DATE '2017-10-25' ORDER BY V.CREATION_DATE DESC;Plan hash

今天处理数据，遇到两个报错，记录于下 数据库版本：SQL> select * from v$version 2 /BANNER-------------------------------------------------------------------------------- CON_ID----------Oracle Database 12c Enterpris

今天在恢复一个测试库时遇到一下问题RMAN-06025，现在记录如下：恢复数据库后报错SQL> alter database open 2 /alter database open*ERROR at line 1:ORA-01113: file 1 needs media recoveryORA-01110: data file 1:'/u01/app/oracle/oradata

首先 监听的信息Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.100.21.205)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=t