ITPub博客

<strong>数据库processes是2000&nbsp;<br />select count(*) from v$session;<br />--1997</strong><br />起初os层面 kill -9&nbsp;select spid from $process where paddr in(select addr from v$session where username ='BI_SJJS' and status = 'INACTIVE');<br /><br /><strong>什么是inactive的会话呢？</strong...

查看db alter日志，有大量的Fatal NI connect error 12170报错*********************************************************************** Fatal NI connect error 12170.   VERSION INFORMATION:        TNS for Linux: Version 11.2.0.2.0 - Production      ...

SQL> alter database mount;alter database mount*ERROR at line 1:ORA-32700: error occurred in DIAG Group ServiceSQL> exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining optionsJSer...

LOCAL=NO是非本地连接首先通过远程登陆(监听)sqlplus scott/tiger@192.168.6.11:1521/test 执行下面会看到点击(此处)折叠或打开[root@Test11g ~]# ps -ef | grep LOCAL=NO | grep -v greporacle 24319 1 0 01:35 ? 00:00:00 oracletest (LOCAL=NO)干掉这...

在数据库中创建视图create or replace view dba_tablespace_free as select a.tablespace_name,        a.total_space_mb allocated_space_mb, &n

日立存储灾备，据说同步性可达5分钟以内其中红色的部分是给演练使用的数据，这时候，红色区域内的数据是和同步的数据分离开的。之前的系统是10g RAC，更改成单节点。init+ASM.ora点击(此处)折叠或打开##############################################################################...

主库：点击(此处)折叠或打开[oracle@primary ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 12 10:04:03 2015Copyright (c) 1982, 2011, Oracle. All rights reserved....

standby database点击(此处)折叠或打开SQL> select * from v$managed_standby;PROCESS   PID STATUS     CLIENT_P CLIENT_P CLIENT_DBID GROUP# RESETLOG_ID THREAD# SEQUENCE# BLOCK#    BLOCKS ...

alter database recover managed standby database cancel;点击(此处)折叠或打开SQL> alter database drop logfile group 4;alter database drop logfile group 4*ERROR at line 1:ORA-00261: log 4 of thread 1 is being ar...

一、环境（主备库环境相同）   操作系统：Red Hat Enterprise Linux Server release 5.5    oracle：11.2.0.1.0主库/etc/hosts如下点击(此处)折叠或打开[root@wbg1 ~]# cat /etc/hosts# Do not remove the following line, or va

前面pfile参数等配置 参考如下：http://blog.itpub.net/29990276/viewspace-1683772/点击(此处)折叠或打开run{allocate channel c1 type disk;allocate channel c2 type disk;sql'alter system archive log current';backup format '/...

1.主库设置强制归档点击(此处)折叠或打开SQL> alter database force logging;SQL> select force_logging from v$database;FOR---YES2.创建口令文件并拷贝到备库点击(此处)折叠或打开...

ORA-01678: parameter db_file_name_convert must be pairs of pattern and replacement strings错误的原因就是这个配置DG时候，参数文件中居然加了“;”。 点击(此处)折叠或打开*.db_file_name_convert='/u01/app/oracle/oradata/shanghai','/u01/app/oracle/oradata/beijing';...

搭建物理standby时启动备库报错如下：点击(此处)折叠或打开SQL> startup pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initshanghai.ora';ORACLE instance started.Total System Global Area 839282688 bytesFixed Size &nbs...

grid用户sqlplus / as sysasm报如标题错查看都起来了啊保点击(此处)折叠或打开[grid@rac2 ohasd]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER S...

班级表点击(此处)折叠或打开select * from class;求各个班级的第一名分数。点击(此处)折叠或打开select *  from (select name,            &n...

alter system set session_cached_cursors = 0 scope=spfile; System altered.重启22:23:42 SQL> show parameter session_cached_cursor; NAME &

通過active_session_history我們能得到什麼

SQL>select * from dba_directories OWNER       DIRECTORY_NAME          DIRECTORY_PATH --------

点击(此处)折叠或打开create table base_tab (name varchar2(20),age number, address varchar2(100)); insert into base_tab values('任我行',56,'山东');insert into base_tab values('风清扬',107,'湖南');insert into base_tab values('孙悟空',5...