ITPub博客

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

vmserver2.0+rhel5.4+oracle10gRAC+asm+dataguardvmserver2.0+rhel5.4+oracle10gRAC+ocfs2+dataguard[@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@]

今天restore database的时候出现：ORA-19693: backup piece %s already included 错误没有把图给截下来。原来发现controlfile中，存在两个相同的备份集。delete backup/ crosscheck backup --> delete expired backup清除备份集或者清楚相同的备份集。然后catalog start with 备份集到controlfile中。然后再次restore既可以了。[@more@]

windows server机器出现超过最大远程连接运行 mstsc -admin就可以使用了[@more@]

listern配置[@more@][root@rac1 admin]# more listener.ora # listener.ora.rac1 Network Configuration File: /u01/oracle/product/10.2.0/db_1/network/admin/listener.ora.rac1 # Generated by Oracle configuration tools. LISTENER_RAC1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.141)(PORT = 1521)(IP = FIRST)) ) ) SID_LIST_LISTENER_RAC1 = (SID_LIST = (SID_DE

今天测试oracle11g 使用scan ip连接数据库时出现，如下错误:[@more@]C:UsersFounder>sqlplus sys/oracle@racdb_scan as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期二 4月 9 14:22:36 2013Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR:ORA-12545: 因目标主机或对象不存在, 连接失败tnsnames.ora:racdb_scan =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.155)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = racdb)))解决办法:C:UsersFounder>sq

今天flashback table的时候出现了ORA-08194错误，临时办法将错误操作前的数据保存到另外一张表上面。下面是自己测试的笔记。SQL> create table tt (id int,name varchar2(20));Table created.[@more@]SQL> insert into tt values(1,'bruce');1 row created.SQL> commit;Commit complete.SQL> create materialized view tt_mv as select * from tt;Materialized view created.SQL> select dbms_flashback.get_system_change_number() from dual; DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER() ----------------------------

http://www.itpub.net/thread-1775304-1-1.html[@more@]

在执行logical standby switchover的时候，出现了ORA-16217: prepare to switchover has not completed错误.[@more@]SQL> alter database prepare to switchover to logical standby;Database altered.SQL> select switchover_status from v$database;SWITCHOVER_STATUS--------------------PREPARING SWITCHOVERSQL> alter database commit to switchover to logical standby;alter database commit to switchover to logical standby*ERROR at line 1:ORA-16217: prepare to switchover has not completedOR

今天做dataguard的时候出现了如下错误：[@more@]primary database使用的是asm，standby database 使用的系统文件ERROR: slave communication error with ASM; terminating process 3364Errors in file /u01/oracle/diag/rdbms/asmdg/asm/trace/asm_lgwr_3364.trc:Sat Mar 09 15:57:31 2013PMON (ospid: 3344): terminating the instance due to error 470Sat Mar 09 15:57:32 2013ORA-1092 : opitsk aborting processInstance terminated by PMON, pid = 3344原来以前创建dataguard的时候，在primary database中已经建立了standby_logfile

1,先使用expdp parallel导出文件[@more@]C:UsersFounder>expdp xxxx/founder2012 directory=temp_dir dumpfile=xxxx_%U.dmp parallel=3 Export: Release 11.2.0.1.0 - Production on 星期五 3月 8 09:48:53 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options 启动 "xxxx"."SYS_EXPORT_SCHEMA_01

获得 mysql帮助[@more@]mysql> help contents; ? contentsYou asked for help about help category: "Contents"For more information, type 'help <item>', where <item> is one of the followingcategories: Account Management Administration Compound Statements Data Definition Data Manipulation Data Types Functions Functions and Modifiers for Use with GROUP BY Geographic Features Help Metadata Language Structure Plugins Procedures Storage Engines Tab

Mysql多数据库启动方法[@more@]Mysqld_multiMysqld_multi is designed to manage several mysqld processes that listen for connection on different unix socket files and tcp/ip ports. It can start or stop servers,or report their current status,The mysql instance manager is an alternative means of managing multiple servers[root@oracle mysql5168]# mkdir data2[root@oracle mysql5168]# mkdir data3[root@oracle mysql5168]# chown -R mysql:mysql data[root@oracle mysql5168]# chown -R mysql:mysql data2[root@oracl

1,mysqld[@more@] Mysqld is the mysql server Mysql read options from the [mysqld] and [server] groups 直接调用的话，error message会定位到终端，不会到日志[root@oracle bin]# ./mysqladmin shutdown[root@oracle bin]# ps -ef | grep mysqlroot 14146 13810 0 07:02 pts/3 00:00:00 grep mysql[root@oracle bin]# cd ../libexec/[root@oracle libexec]# pwd/u02/mysql5168/libexec[root@oracle libexec]# ./mysqld --defaults-file=/u02/my.cnf --user=mysql130224 7:03:40 [Warning] '--skip-locking' is deprecated an

今天测试了一下mysql-5.1.68源码安装,具体步骤如下:[@more@]tar.gz 结尾的, 解压之后的目录中：Build 目录：各种平台的编译脚本，监测 cpu型号的编译脚本 Check-cpu脚本Client :客户端程序的源代码 , mysql.cc,mysqladmin.ccDocs:Storage :存储引擎目录，实现了 handerMysys: :mysql 为了实现跨平台对系统库封装Sql: 数据库主程序目录，存储引擎接口。Vio: 封装了各种协议的网络操作Limysqld： mysql链接库的源代码源码安装中 configure的作用, 有检查c的编译器，生产 makefile文件Configure的常用选项：--prefix 设

今天打开oracle数据库的时候出现了如下错误:[@more@]Errors in file d:appdiagrdbmstesttesttracetest_cjq0_4368.trc: ORA-00604: error occurred at recursive SQL level 2 ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select procedure#,entrypoint...","SQLA","tmp")不能shutdown immediateSQL> shutdown immediate ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select /*+ index(idl_sb4$ i_...",&qu

今天测试了一下mysql 5.6.10的源码安装，具体步骤如下：[@more@] 1,安装mysql 5.6.10之前，有几个包是必须的. gcc,bison,readline,cmake,其中cmake 的安装如下,先下载cmake-2.8.10.2.tar.gztar -zxvf cmake-2.8.10.2.tar.gzcd cmake-2.8.10.2./bootstrapgmakegmake install 2,切换到mysql 5.6.10解压目录groupadd mysqluseradd -g mysql mysql tar -zxvf mysql-5.6.10.tar.gzcd mysql-5.6.10cmake .makemake install --cmake . -DCMAKE_INSTALL_PREFIX=/u01/mysql5610 -DMYSQL_DATADIR=/u01/data -DWITH_INNOBASE_STORAGE_EN

今天在网上看到了一哥们写的取出字符串中的汉字的方法，记录下来.[@more@]SQL> create or replace function removehanzi(p_str varchar2) 2 return varchar2 3 as 4 v_str varchar2(3000); 5 v_char varchar2(6); 6 v_result varchar2(3000); 7 begin 8 if p_str is null then 9 return null;10 end if;11 for i in 1..length(p_str) loop12 v_char:=substr(p_str,i,1);13 if lengthb(v_char)=1 then14 v_result:=v_result||v_char;15 end if;16 end loop;17

上次使用的create function 查询的结果在pl/sql developer上面显示的cursor，并不能显示需要查询的结果。今天在网上查询到另外一种方法很好的替代了上次的方案，[@more@]具体步骤如下：1.CREATE OR REPLACE TYPE "HISSAAS"."EMP_ROW_TYPE" as object(tenant_id varchar2( 20 ),tenant_name varchar2 ( 50),mc varchar2 (50 ),mzl int,jzl int ,bll int ,sylint,qxs int ,qxl int );2.CREATE OR REPLACE TYPE "HISSAAS"."EMP_TABLE_TYPE" as table of emp_row_type;3.create or replace function