ITPub博客

一、测试环境OS：Windows XPDB：ORACLE10GTOOL：orabf-v0.7.6二、破解原理 orabf-v0.7.6是一款基于数据字典，破解ORACLE密码的工具，也是ORACLE密码破解目前最快的工具。它甚至能破解SYS的密码。功能非常强大...

<a href="http://down.51cto.com/data/238560">http://down.51cto.com/data/238560</a>&nbsp;

set pagesize 100set timing onselect x.tablespace_name,y.bytes/1024/1024 total_size_mb,x.bytes/1024/1024 free_size_mb,(y.bytes-x.bytes)/1024/1024 use_size_mb,round((y.bytes-x.bytes)/y.bytes,4)*100 usagefrom (select tablespace_name,sum(bytes) bytes from dba_free_space group...

SQL> select dbid from v$database;      DBID----------2936527823[oracle@primary ~]$ rman target /Recovery Manager: Release 11.2.0.1.0 - Production on Mon Apr 21 19:12:14 2014Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.connec...

[oracle@primary ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sat Feb 8 14:14:46 2014Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, ...

SQL> drop procedure "test123";Procedure droppedSQL> drop procedure "test";Procedure dropped如上我已经删除了procedure  test123,test现在我想找回已经删除的procedure,可以通过如下语句获得:其查询方式和查询表里面删除的记录的方式一样。select * from dba_source as of timesta...

今天删除procedure 的时候出现ORA-04043: 对象 TEST123 不存在baidu了一下,因为自己创建test123的时候加了双引号。所以删除的时候也需要加双引号。SQL> drop procedure "test123";Procedure droppedSQL> drop procedure "test";Procedure dropped...

select * from v$controlfileselect * from v$parameter where name like '%control%'查看controlfile文件所在位置 select * from v$controlfile_record_section 查看controlfile中包含的大概信息 [oracle@primary ~]$ strings /u01/oradata/wlcsp/control01.ctl | more}|{zWLCSPP\91...

C:\Users\wlcsp>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期日 12月 22 09:52:41 2013Copyright (c) 1982, 2010, Oracle.  All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data M...

create index ...select .... order by ..select distinct ...select .... group byselect ...unionselect ...intersectselect ...minusunindex join,subquery以上操作都有可能会使用temp segmentorder by ,group by ,distinct 有可能会使用两个temp segment....

expdp/impdp transport_tablespace[@more@][oracle@primary ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 18 13:07:45 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> alter tablespace wlcsp read only;Tablespace altered.[oracle@primary ~]$ expdp system/wlcsp123 directory=temp_dir dumpfile=wlcs

impdp network_link[@more@]C:Userswlcsp>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期一 11月 18 11:49:50 2013Copyright (c) 1982, 2010, Oracle. All rights reserved.连接到:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> grant create database link to wlcsp;授权成功。SQL> conn wlcsp/wlcsp123已连接。SQL> create database link primary connect to wlcsp identified

[root@rac1 ~]# /etc/init.d/oracleasm createdisk data01 /dev/sdb1Marking disk "data01" as an ASM disk: [FAILED][@more@][root@rac1 ~]# more /var/log/oracleasmInstantiating disk: oracleasm-instantiate-disk: Unable to create ASM disk "DATA01": Permission deniedfailed 出现这个需要将selinux disable掉[root@rac1 ~]# more /etc/selinux/config# This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:# enforcing - SE

ORA-0131:Insufficient privileges.Note:Debugging requires the DEBUG CONNECT SESSION system privileges[@more@]后经查找，是缺失 DEBUG CONNECT SESSION 系统权限所致。解决办法：以SYS用户登录数据库，执行赋权操作： SQL> grant DEBUG CONNECT SESSION to user_name; 不需要赋予DEBUG ANY PROCEDURE 也可以的。 SQL> conn / as sysdba; Connected. SQL> select * from role_sys_privs where privilege like 'DEBUG%' order by 2; ROLE PRIVILEGE ADM ---------------- -------------------

已确保安装的ORACLE_BASE目录是属于grid:oinstall但安装时总是报：OUI-10182 The effective user ID does not match the owner of the file ..........--------------------------------------------------- 解决方法：用root帐户在/etc下建立文件oraInst.loc,并写入以下内容:inventory_loc=/home/app/oraInventoryinst_group=oinstall重新执行安装程序即可。==这个问题自己遇到了，然后在网上百度到的解决方法.[@more@]

linux下删除oracle11g[@more@] 1: 停数据库 SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 9 15:22:13 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter user-name: /as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> 2: 停监听和

http://tech.it168.com/a2013/0802/1516/000001516310.shtml (转)[@more@]

[root@XY-EMPIDB ~]# su - oracle[@more@][oracle@XY-EMPIDB ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Mon May 27 15:09:48 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>SQL> show parameter memoryNAME TYPE VALUE------------------------------------ -----

今天使用impdp导入数据的时候出现如下错误： ORA-31655: 尚未为作业选择数据或元数据对象 ORA-39154: 外部方案中的对象已从导入中删除 原因是impdp两边的用户不一样需要加上参数remap_schema[@more@]

[root@asmdb1 crs_1]# srvctl enable database -d asmdbPRKR-1005 : adding of cluster database asmdb configuration failed, {1}出现这个错误，需要切换到oracle用户下执行[root@asmdb1 crs_1]# su - oracle [oracle@asmdb1 ~]$ cd /u01/oracle/product/10.2.0/crs_1/bin/ [oracle@asmdb1 bin]$ ./srvctl disable database -d asmdb PRKP-1019 : Database asmdb already disabled. [oracle@asmdb1 bin]$ ./srvctl enable database -d asmdb [oracle@asmdb1 bin]$ ./srvctl disable database -d asmdb[@more@]