Zhong Weicheng Study Notes

原创 Installation Oracle11gR2 RAC on SuSE Linux Enterprise Server 11

SLES11安装参考博文Installation SUSE Linux Enterprise Server 11vzwc1:~ # cat /etc/issueWelcome to SUSE Linux Enterprise Server 11 SP3 (x86_64) - Kernel \r (\l).vzwc1:~ # 配置/etc/hosts文件192.1

原创 SUSE Linux 使用UDEV配置ASMdisk

vzwc1:~ # uname -aLinux vzwc1 3.0.76-0.11-default #1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990) x86_64 x86_64 x86_64 GNU/Linuxvzwc1:~ # cat /etc/issueWelcome to SUSE Linux Enterprise Server 11 SP3

原创 Installation SUSE Linux Enterprise Server 11

原创 GreenPlum查看表和数据库大小

表大小zwcdb=# select pg_size_pretty(pg_relation_size('gp_test')); pg_size_pretty ---------------- 1761 MB(1 row)表和索引zwcdb=# select pg_size_pretty(pg_total_relation_size('gp_test')); pg_size_pr

转载 转MOS 中文文档列表 - Oracle Database (Doc ID 1533057.1)

安装/升级/降级/迁移相关Document 1525335.1 OPatch - 可以在什么位置找到最新版本的 OPatch？[视频]Document 1525396.1 跨 OS 平台迁移 Oracle DBDocument 1525777.1 如何从数据库 11.2 降级至之前的版本（包括 11.2.0.3-11.2.0.1）Document 1577660.1 数据库升级/降

原创 查看AIX和HP-UX文件系统类型

AIX# uname && whoamiAIXroot# df -gFilesystem GB blocks Free %Used Iused %Iused Mounted on/dev/hd4 2.25 0.14 94% 9425 22% //dev/hd2 4.62 0.11

原创 使用DBMS_METADATA.GET_DDL备份DDL

SQL> CREATE OR REPLACE FUNCTION SYS.F_GET_DDL (v_object_type varchar2, 2 v_object_name varchar2, 3 v_objec

原创 使用DBLINK访问LOB类型表

This is a bit twisted solution, but works. Basically you first need to convert LOB (in these example I refer to CLOB, BLOB is similar but you will probably not use varchar2) to multiple varchar2(4000)

原创 Oracle11g ORA-609 TNS 12537 TNS 12560

alert_sid.logWed Dec 18 08:25:58 2013***********************************************************************Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS

原创 跟踪Oracle启动状态

可以使用10046 event来跟踪[oracle@ggos ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 20 19:48:00 2013Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an

原创 GreenPlum创建外部表示例

Example 1—Single Greenplum file server (gpfdist) instance on multiple NIC machineCreates a readable external table named ext_expenses using the gpfdist protocol. The files are formatted with a pipe

原创 监控GreenPlum Segment磁盘空间

gp_toolkit Administrative Schema: The Greenplum Database includes the gp_toolkit schema, which collects system information through log files and operating system commands. You can run a query against

原创 Oracle还原RMAN初始配置

[oracle@ggos ~]$ rman target /Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 6 00:17:59 2013Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected t

原创 JDBC访问GreenPlum

JDBC is the driver used to access a database with Java. Greenplum has a full working JDBC implementation.In this short article we’ll see how to use it.## Download and installIt is possible t

原创 Oracle数据迁移到GreenPlum

Oracle端表结构SQL> select dbms_metadata.get_ddl('TABLE','TAB_ORA','ZWC') from dual; CREATE TABLE "ZWC"."TAB_ORA" ( "ID" NUMBER, "OWNER" VARCHAR2(30), "NAME" VARCHAR2(128),