ITPub博客

99. Which two statements are true regarding Oracle Data Pump? (Choose two.)A.EXPDP and IMPDP are the client components of Oracle Data Pump.B.DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.C.Oracle Data Pump export and import operations can be performe...

到北京一段时间了，基本适应了北京的生活。记得刚到北京时的惶恐，找工作的辛苦。感谢朋友和同学的相伴。。。。才慢慢的适应了北京的生活。新的一年努力。。。。

sys@TESTDB>create tablespace test datafile '/u01/app/oracle/oradata/testdb/test01a.dbf' size 20m;Tablespace created.sys@TESTDB>create user test identified by test default tablespace test;User created.sys@TESTDB>conn test/testERROR:ORA-01045: user TEST lacks CREATE SESSION privilege; logon den...

1. Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0Which two will be the implications of these values in&nb...

linux 逻辑卷的使用给磁盘分区并添加lvm标示[root@node1 /]# fdisk /dev/sdbThe number of cylinders for this disk is set to 2610.There is nothing wrong with that, but this is larger than 1024,and could in certain setups cause problems with:1) software that runs at boot time (e.g., old versions of ...

最近对增量检查点和全局检查点有些疑惑，查看了很多的资料感觉都写得非常复杂不容易理解。下面贴出一些自己的心得，如果有错误的地方希望得到指正。                           ...

1，通常情况如果日志文件多元化，日志组好的成员拷贝到损坏的日志成员就可以了。一下只考虑一些极端的日志文件损坏的情况。2，通常联机日志有四种状态 active 、  不是正在使用的日志文件，但是日志条目对应的脏数据并没有写到数据文件里，如果实例异常崩溃，而日志文件损坏的话是要丢数据的。   &nb...

1，scan ip的功能 2，10g和11g  rac的区别3，undo 表空间的作用undo 表空间是存放未提交的数据块，从这点看undo有两个功能 一，读一致性，是在数据未提交之前，其它会话又要访问这些数据的时候，必须从undo段里读取。             &nb...

英文太烂    Data segment  Each nonclustered table has a data segment. All table data is stored in the extents of the data segment.每个普通表都有一个数据段，所有表的数据存储在数据段的区里。              ...

一，   实施目的了解密码文件的相关信息二，   实施环境ItemSystemPlatformOEL5.4HostnameNode1...

今天搭建ogg的时候遇到一个奇葩的问题，现将问题贴出来供大家一起思考                                       &...

[oracle@node1 ~]$ ggsciGGSCI (node1) 1> start mgrCannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directoryCannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directoryAborted[oracle@node1 ~]$ cd /u01/app/ogg[oracle@node1 ogg]$ ./ggsci启动管...

修改hostname后SQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=node3)(PORT=1521))'SQ> create pfile='/home/oracle/init.ora' from spfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileprod.ora';...

11g的监听配置[oracle@node3 admin]$ more listener.ora LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.11)(PORT = 1521))    )  )ADR_BASE_LISTENER = /u01/app/oracle11g的tns配置[oracl...

SQL> set autotrace trace SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS reportSQL> conn / as sysdbaSQL> grant PLUSTRACE to hr;grant PLUSTRACE to hr      *ERROR at line 1:ORA-01919: role 'PLUSTRACE' do...

SQL> show parameter undoNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------undo_management       ...

[oracle@node1 ~]$ imp scott/oracle ignore=y tables=emp4 full=n file=/home/oracle/emp5.dbfImport: Release 11.2.0.1.0 - Production on Sun Nov 17 17:36:40 2013Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Rele...

到处一张表的时候报错        [oracle@node1 ~]$ exp scott/oracle tables=emp5 file=/home/oracle/emp5.dbfExport: Release 11.2.0.1.0 - Production on Sun Nov 17 16:59:32 2013Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.Conn...

开库报错SQL> startup;ORA-03113: end-of-file on communication channel修改了spfile的 *.processes[oracle@node1 dbs]$ vi spfileprod.ora *.processes=150修改为*.processes=15从新开库正常                &nbs...

环境redhat5.5oracle 11g开库报错      SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01194: file 1 needs more recovery to be consistentORA-01110: data file 1: '/oradata/prod/system01.dbf'SQL>  recover database until c...