ITPub博客

alter system flush shared_pool;生产库勿用

一、打开sql_trace会话级别alter session set sql_trace=ture;全局级别alter system set sql_trace=ture;关闭sql_trace会话级别alter session set sql_trace=false;全局级别alter system set sql_trace=false;二、查看路径名11g可以通过v$diag_ino来查看下一个生成的sql_trace文件路径名10g可以通过v...

以上问题主要是因为要导入的用户没有创建materialized view的权限，将权限赋予该用户即可grant create materialized view to user;

CPU(critical patch update）升级:1.下载相应的patch,将patch拷贝到数据库服务器相应的目录中并解压2.关闭数据库服务和监听，进入到解压的包的路径下，通过图形化界面对数据库软件进行升级3.升级完数据库软件之后对数据库文件的数据字典进行更新  1.以startup upgrade的方式打开数据库  2.运行@?/rdbms/adm...

1、启动所有监听2、验证是否能够远程登陆数据库sqlplus sys/oracle@prod as sysdba3、跑脚本@?/rdbms/admin/dbmspool4、解锁两个oracle账户sysman和dbsnmpalter user sysman identified by oracle account unlock;alter user dbsnmp identified by oracle account unlock;5、如果之前安装过OEM，删除原来的OEMemca ...

用into赋予多个变量时只需要一个into就可以了，如下select NEXT_EXPIRY_DATE,CURR_LIMIT,TOTAL_LIMIT into V_NEXT_EXPIRY_DATE,V_CURR_LIMIT,V_TOTAL_LIMIT from p2p.s_fin_prod_interest_info where FINANCE_PROD_ID=i_prod_id;

http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel5-084877.html

错误事件：从另外一个库上导出的数据，在本台机器上做remap导入时遇到无法读取指定对象的元数据和数据的问题，错误如下图所示经查阅资料发现，如果去掉include塞选条件可以通过，因此，这可能是一个oracle10g的bug但是我只要导入这12张表怎么办规避方法可以在导出数据阶段进行include塞选然后在导入到另外一个...

SQL> alter database archivelog;alter database archivelog*ERROR at line 1:ORA-00265: instance recovery required,cannot set ARCHIVELOG mode原因为上次库非正常关闭导致数据库处于不一致状态，重新启动实例到mount状态即可SQL> shutdown immediateDatabase closed.Database dismo...

SQL> alter system setlog_archive_dest_1='/u02/archive_log/' scope=both;alter system setlog_archive_dest_1='/u02/archive_log/' scope=both*ERROR at line 1:ORA-32017: failure in updating SPFILEORA-16179: incremental changes to"log_archive_dest_1" not allowed with SPFILE在设...

1、  创建SWAP目录[root@node2 ~]# mkdir /u01/swapdir2、  创建SWAP文件[root@node2 ~]# dd if=/dev/zeroof=/u01/swapdir/myswap bs=1M count=20482048+0 records in2048+0 records out2147483648 bytes (2.1 GB) copied, 24.4351seconds, 87.9 MB/s[root@node2 ~]# ll -h /u01...

增加磁盘空间1、  在虚拟机上创建新的硬盘一直下一步至选固定大小创建完成2、  切片[root@node2 ~]# fdisk -l Disk /dev/sda: 8589 MB, 8589934592 bytes255 heads, 63 sectors/track, 1044 cylindersUnits = cylinders of 16065 * 51...

修改/etc/sysconfig/network-scripts/ifcfg-eth0文件[root@node1 ~]# vi/etc/sysconfig/network-scripts/ifcfg-eth0  # Intel Corporation 82540EM GigabitEthernet ControllerDEVICE=eth0BOOTPROTO=noneONBOOT=yesHWADDR=08:00:27:02:95:38TYPE=Ether...

RMAN> backup database include currentcontrolfile plus archivelog; Starting backup at 09-APR-14current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive logbackupsetchannel ORA_DISK_1: spec...

RMAN> crosscheck archivelog all; released channel: ORA_DISK_1released channel: ORA_DISK_2released channel: ORA_DISK_3allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=138 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=135 devtype=DISKal...

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPEDISK clear; old RMAN configuration parameters:CONFIGURE CHANNEL 2 DEVICE TYPE DISKFORMAT  '/u02/backup/rman/BJDB/disk2_1/BJDB_%U.bak',   '/u02/backup/rman/BJDB/disk2_2/BJDB_%U.bak';old RMAN configuration parameters ar...

1、首先在客户机中安装oracle客户端 2、安装完之后打开服务器的监听 [oracle@zhang admin]$ lsnrctl start   LSNRCTL for Linux: Version 10.2.0.1.0- Production on 07-APR-2014 12:55:53   Copyright (c) 1991, 2005, Oracle.  All rights reserved.   Starting ...

如果数据文件中存在多个实例的情况，就应该配置shared_server_sessions和shared_servers参数的值如：设置之前SQL> show parameter shared NAME                       &n...

在用数据泵导出emp表工资高于 2500 那些记录的时候报ORA-31693: Table data object"SCOTT"."EMP" failed to load/unload and is being skippeddue to error:ORA-00920: invalid relational operator的错误出现此错误的命令为[oracle@zhang u02]$ expdp scott/tigerdirectory=dump_dir dumpfile=sa...