ITPub博客

20c 不支持non-cdb架构

当删除oracle数据库user时发生row cache lock 等待事件

通过oci考试 1z0-932云认证考试

在增加节点完后，用dbca 添加数据库实例时  报ORA-32021: parameter value longer than 255 characters 错误oraagent log2011-10-24 09:18:32.724: [ USRTHRD][3389032768] {1:47226:28141} Value ofLOCAL_LISTENER is2011-10-24 09:18:32.724: [ USRTHRD][3389032768] {1:47226:28141} sqlStmt =...

参考metalink id How to Rotate or Purge Listener Log Data to Avoid Large listener.log File? (文档 ID 1457196.1)LSNRCTL>LSNRCTL> set current_listener <listenername>LSNRCTL> set log_status offIn another window rename the log file. Then return to previous windowLSNRCTL> set log_statu...

参考metalink:  SCRIPT - Select to show Optimizer Statistics for CBO (文档 ID 31412.1) set echo offset scan onset lines 150set pages 66set verify offset feedback offset termout offcolumn uservar new_value Table_Owner noprintselect user uservar from dual;set termout oncolumn TABLE_NA...

  impdp命令在导入数据时,如果用户存在,则会自动创建该用户,这是因为expdp导出的dmp文件中包含了创建用户的脚本信息(包括密码,缺省表空间,临时表空间等)  而impdp自动创建用户有一个前提条件，就是需要首先创建用户的缺省表空间和临时表空间，如果缺省表空间或者临时表空间不存在，则自动创建用户会失败...

参考以下步骤:1) Identify the data file to be moved.2) Identify the diskgroup on to which the file has to be moved.3) Take the file offline.4) Copy the file to new diskgroup using Either RMAN or DBMS_FILE_TRANSFER.5) Rename the file to point to new location.6) Recover the file.7) Bring the f...

环境 oracle 9.2.0.7  rac + aix 安装完oracle 9i rac 在aix平台上后，用dbca建库或者手工建库都报以下错误:*** 2016-08-03 04:37:05.900ksedmp: internal or fatal errorORA-00603: ORACLE server session terminated by fatal errorORA-27504: IPC error creating OSD contextORA-27300: OS system dependen...

     环境:  oracle 9.2.0.7+aix 5.3     好久没有安装oracle 9i for aix 版本了，今天安装好软件后，用dbca建库，      报以下错误:    ORA-00603: ORACLE server session terminated by fatal errorORA-27504: IPC error creati...

What do the reasons given in v$SQL_SHARED_CURSOR meanIf you are unable to use that script then you can select the same information from the base views as illustrated in the examples below. Lets use the example above and take a look at what SQL we can use to see this in the shared pool. SCOT...

oracle 12cR2 版本推迟发布，发布时间 在 2HCY2016，要今年下半年了。

环境:主库和备库形成oracle dataguard环境实施目标:利用scn增量备份来实现同步dataguard主要解决以下问题：The steps in this section can used to resolve problems of missing or corrupted archive log file, an unresolveable archive gap, or need to roll standby forward in time without applying a large n...

在10gR1 版本以上，查询DBA_FREE_SPACE视图会非常慢，导致不能及时查到表空间使用率分析:查看DBA_FREE_SPACE的视图定义:SQL> select text from dba_views where view_name='DBA_FREE_SPACE';TEXT--------------------------------------------------------------------------------select ts.name, fi.file#, f.blo...

ORA-00600 3020 分析处理过程如下: ERROR:   Format: ORA-600 [3020] [a] [b] [c] [d] [e] VERSIONS: version 6.0 and aboveDESCRIPTION: This is called a 'STUCK RECOVERY'. There is an inconsistency between the information stored in the redo and the information stored...

环境: oracle 11.2.0.4  rac +aix 6.1问题描述:  在安装oracle 11.2.0.4 grid 时，在进入到ssh 安装界面，点test 按钮时，提示以下错误:[INS-06006] Passwordless SSH connectivity not set up between the following nodes(s)而在二个节点手工去测试ssh成功，ssh互信关系通过问题分析: 查看installActio...

1：脚本下载 可以在metalink id 438755.1 中下载2：运行方法:     sqlplus / as sysdba     @version_rpt3_24.sql     会创建4个视图3: 查找大于多版本大于100个根据sql_idset pages 2000 lines 100SELECT b.*FROM v$sqlarea a , TABLE(version...

PLATFORM_IDPLATFORM_NAMERelease namePLATFORM_IDs supported within the same Data Guard configuration when using Data Guard Redo Apply (Physical Standby)2Solaris[tm] OE (64-bit)S...

在oracle 12c 通过Using In-Database Archiving feature 特性，来启到分离在线数据和历史数据的作用，即数据归档，应用可以有选择性的访问在线数据或者历史数据，要启用这个特性，在建表的时候启用ROW ARCHIVAL，并操作ORA_ARCHIVE_STATE 这个隐藏字段，此外用户还可以指定会话级别的 ROW ARCHIVAL VISIBILITY为ACTI...

The following procedure describe the steps to recreate the diskgroup where OCR and Voting disks are stored and restore the OCR data from a backup.1. List the backups of the OCR# $GI/bin/ocrconfig -showbackup2. Validate the integrity of the backup# $GI/bin/ocrdump -backupfile back...