ITPub博客

错误日志：ORA-20115: datapump export encountered error: ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CUBE_EXP.INSTANCE_EXTENDED_INFO_EXP('AW$EXPRESS','SYS',1,2,0,'SYS',1,'11.02.00.04.00',newblock) ORA-04063: package body "SYS.DBMS_CUBE_EXP" ha s errors...

concepts:Oracle Database enables you to transport AWR data between systems. This is useful in cases where you want to use a separate system to perform analysis of the AWR data. To transport AWR data, you must first extract the AWR snapshot data from the database on the source system, then load...

安装社区版mongo：一、准备软件从官方站点（https://www.mongodb.org/downloads）下载相关软件二、解压安装软件tar -zxvf mongodb-linux-x86_64-3.4.0.tgz三、创建安装目录，并拷贝相关安装程序mkdir -p mongodbcp -R -n mongodb-linux-x86_64-3.4.0/ mongod四、配置环境变量export PAT...

语句：import cx_Oraclecon = cx_Oracle.connect('system/oracle@192.168.162.120/test')cur = con.cursor()  #cursor() 方法打开语句要使用的游标。cur.execute('select * from scott.emp') #execute() 方法分析并执行语句。for result in cur:  #循环从游标获取每一行并输出该行。    print (r...

在windows上安装cx_oracle模块，遇到如下错误：此原因为未找到相应的注册表，打开注册表编辑器，将“HKEY_CURRENT_USER\HKEY_CURRENT_USER\Software\HKEY_CURRENT_USER\Software\Python\HKEY_CURRENT_USER\Software\Python\PythonCore\HKEY_CURRENT_USER\Software\Python\PythonCore\3.5-32”改为“HKEY_CURRENT_USER\HKE...

操作系统：AIX5.3数据库版本：10.2.0.4.12一、11月27日 11：40到11月28日 6：00做undo数据文件转储，命令如下：run {allocate channel c1 type 'sbt_tape';allocate channel c2 type 'sbt_tape';allocate channel c3 type 'sbt_tape';allocate channel c4 type 'sbt_tape';set newname for datafile 714 to '+YYJC...

在使用nohup进行循环插入的过程中，如果发现在即插入的数据不对想要重新执行的时候，仅仅kill掉nohup进程是不行的，还需要通过v$session,v$process,v$sql查询到其发出的SQL命令，查出spid，并kill掉这个进程才可以，否则这个sqlplus的循环会一直跑下去，如果这时再起一个nohup的循环插入进程脚本的话，就会出现重复数据，...

安装基于OS的python版本：进入安装目录中的Python文件夹下面的scripts目录运行easy_install命令，如下图安装pip程序：测试pip测试安装使用pip安装自动化人机交互模块pexpect和paramiko模块（用于多线程SSh连接）pexpect安装成功，paramiko模块安装失败...

oraInventory没有写权限chmod -R 774 ./oraInventory

export ORACLE_SID=DWTHsqlplus / as sysdba <<EOFset feedback offset serveroutput ondeclarev_sql varchar2(4000);v_sqlerrm varchar2(4000);cursor cur_tab is select dt.owner,dt.table_name from dba_tables dt   where dt.owner in ('ODS_BUFF_KKX','SGDM','ZS_OUTPUT','NOVELL_IAS','ODS_B...

将数据库启动到mount状态，将现有的控制文件trace出来，修改之后在sqlplus中运行此SQL即可

从NBU转储数据文件：export ORACLE_SID=DWTHrman target / <<EOFrun {allocate channel c1 type 'sbt_tape';allocate channel c2 type 'sbt_tape';allocate channel c3 type 'sbt_tape';allocate channel c4 type 'sbt_tape';SEND 'NB_ORA_SERV=NBU-MEDIA2,NB_ORA_CLIENT=ods2';set newname for datafile 00001 t...

Health Monitor provides two ways to run health checks manually:By using the DBMS_HM PL/SQL packageBy using the Enterprise Manager interface, found on the Checkers subpage of the Advisor Central pageRunning Health Checks Using the DBMS_HM PL/SQL PackageThe DBMS_HM procedure for running a...

打开lpar控制台时发现的问题：原因：缺少JDK环境解决方法：安装1.6JDK版本，配置火狐浏览器（火狐浏览器版本控制在20-33之间）如下：

环境：VMware 12hmc v7.7注意点：1、创建SCSI类型的磁盘（大于80G）；2、下载一个hmc.rom放入到虚拟机目录下；3、在此虚拟机目录下的.vmx文件中增加下列语句bios440.filename = "hmc.rom"4、将drive A改为disabled

delete archivelog from sequence 1029289 until sequence 1029290 thread 1;

问题描述：VMware12 测试RAC二节点执行root.sh脚本时报错CRS-2800: Cannot start resource 'ora.asm' as it is already in the INTERMEDIATE state on server 'rac02'CRS-4000: Command Start failed, or completed with errors.Failed to start Oracle Grid Infrastructure stackFailed to start Cluster Ready Ser...

错误：[root@ora4 named]# nslookup 192.168.162.8;; Got SERVFAIL reply from 127.0.0.1, trying next server;; Got SERVFAIL reply from 127.0.0.1, trying next serverServer:         ::1Address:        ::1#53** server can't find 8.162.168.192.in-addr.arpa: SE...

Three packages must be installed on Linux for DNS Server:bind (includes DNS server, named)bind-utils (utilities for querying DNS servers about host information)bind-libs (libraries used by the bind server and utils package)You can obtain an account from the Yum Server wh...

出现问题Bringing up interface eth1:  Device eth1 does not seem to be present, delaying initialization解决办法# rm -rf /etc/udev/rules.d/70-persistent-net.rules# reboot