ITPub博客

实例能正常启动，查看　alert.log出现WARNING如下：（重复出现很多次）WARNING: -------------------------------WARNING: oradism did not start up correctly.Dynamic ISM can not be locked.----------------------------------------oradism creation failed for unknown reasons 0 8 105WARNING: -------------------------------WARNING: oradism did not start up correctly.Dynamic ISM can not be locked.----------------------------------------oradism creation failed for unknown reasons 0 8 105Metalink note 374367.1 d

set pages 1000set lines 120set heading offcolumn w_proc format a50 trucolumn instance format a20 trucolumn inst format a28 trucolumn wait_event format a50 truset pages 1000set lines 120set heading offcolumn w_proc format a50 trucolumn instance format a20...

一. ORA-600 概述ORA-600 是一个非常头疼的一个错误。比如：       ORA-00600:internal error code, arguments: [4194], [43], [46], [], [], [], [], []       这个就是undo 损坏出现故障的一个提示信息。关于这种情况的解决方法，参考blo...

这几天开发同学反映了一个问题，有一个Java写的夜维程序，用于每天定时删除历史过期数据，3月10日之前经过了内测，但这两天再次执行的时候，有一条SQL语句一直报ORA-01752的错误，由于近期做过一次开发库的迁移，从一个机房搬迁至另一个机房，而且开发同学确认这期间未变代码逻辑，所以怀疑是否和数据迁移有关，这个错...

系统日志、告警日志、Clusterware日志都正常，唯一不正常的就是监听日志，监听器访问非常的频繁每1秒都有3到4个连接，一直持续不断，最后有如下报错：TNS-12518: TNS:listener could not hand off client connection...

[oracle@rman1 ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.4.0 Production on Mon May 22 14:31:03 2017Copyright (c) 1982, 2013, Oracle.  All rights reserved.SQL> conn scott/tigerConnected.SQL> set autot traceSP2-0618: Cannot find the Session Identifier.  ...

1、调整强制归档：SQL> select force_logging from v$database;FOR---NO2 RAC开启归档SQL> alter system set log_archive_dest_1='LOCATION=+DATA' scope=spfile sid='RACDB1';System altered.SQL> alter system set log_archive_dest_1='LOCATION=+DATA' scope=spf...

        在一次性能调优交流中，听到某专家介绍，在缺省db_block_size=8K的环境下，增加额外db block size=32K的表空间，然后把需要进行全表扫描的表(FTS)或索引(FI...

1.Goldengate的起停启动goldengate  a> 启动goldengate时最好先从target节点开始，然后是source节点.否则data pump进程可能会由于没有收到target端的响应而异常退出。  b> manager进程是其他进程的管...

_use_adaptive_log_file_sync该参数在commit次数较多的系统中,post/wait and polling特性对性能影响明显,主要是在写日志上的等待上影响了事务的提交速度.建议在11g中关闭(设置为false)._use_adaptive_log_file_sync造成性能下降的原因可能是其导致LGWR使用了polling 方式来取代 post/wait，并且polling的...

SELECT 'grant ' || tt.granted_role || ' to ' || tt.grantee || ';' AS SQL_text FROM dba_role_privs tt WHERE tt.grantee = (UPPER('scott'))UNION ALLSELECT 'grant ' || tt. PRIVILEGE || ' to ' || tt.grantee || ';' FROM dba_sys_privs tt WHERE tt.grantee = (UPPER('scott'))UNION ALLSELECT ...

select wait_class_id, wait_class, count(*) cnt  from dba_hist_active_sess_history where snap_id between 5508 and 5518 group by wait_class_id, wait_class order by 3;select event_id, event, count(*) cnt from dba_hist_active_sess_history  where snap_id between 5508 and 5518 and wait_cla...

SQL> conn / as sysdbaConnected.SQL> select name from v$datafile;NAME--------------------------------------------------------------------------------/u01/oracle/oradata/orcl/system01.dbf/u01/oracle/oradata/orcl/sysaux01.dbf/u01/oracle/oradata/orcl/undotbs01.dbf/u...

1 告警日志内容：[oracle@CnXzBus01POraclL01 ~]$ tail -1000f /opt/app/oracle/diag/rdbms/kcpt/kcpt/trace/alert_kcpt.log | grep -A 2 -B 2 "07445"Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x21607D1, apaneg()+227] [flags: 0x0, ...

[oracle@kcpttest ~]$  sqlplus scott/tiger@192.168.2.227:1521/kcptdg1SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 6 15:52:48 2016Copyright (c) 1982, 2013, Oracle.  All rights reserved.ERROR:ORA-12514: TNS:listener does not currently know of service reques...

SQL> conn scott/tigerConnected.SQL> SQL> SQL> SQL> select * from tab;TNAME                          TABTYPE  CLUSTERID------------------------------ ------- ----------BONUS&nbsp...

10G--10g及以后版本select distinct b.SID,b.SERIAL#,p.SPID,b.LAST_CALL_ET,a.sql_id, a.sql_text,b.status,b.event,b.MODULE, b.OSUSER,b.MACHINE from v$sql a,v$session b,v$process p where a.SQL_ID=b.SQL_ID and b.PADDR=p.ADDR and b.STATUS='ACTIVE' order by B.LAST_CALL_ET desc;--9i及以后版本s...

set linesize 300set pagesize 10000col TABLESPACE_NAME for a30;col PCT_FREE for a20;col PCT_USED for a20;col USED_MAX% for a20select  a.tablespace_name,       round(a.bytes_alloc / 1024 / 1024, 2) megs_alloc,   ...

LSNRCTL> change_password  Old password: New password: Reenter new password: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521)))Password changed for LISTENERThe command completed successfullyLSNRCTL> set passwordPassword:&nb...

注意：log_file_name_convert如果不配置,将导致备库redo 文件不能被删除检查主备库状态主库：select SEQUENCE#,first_time,next_time,APPLIED, THREAD# from v$archived_log order by  SEQUENCE#,THREAD#;        49 31-MAR-16  &n...