ITPub博客

Timesten 数据库端需要的配置[@more@][oracle@qht131 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 23 16:08Copyright (c) 1982, 2009, Oracle. All rights reserved.1.建立ttusers表空间Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -With the Partitioning, OLAP, Data Mining and Real ApplicatiSQL> create tablespace ttusers datafile 'ttusers.dbf' sizeTablespace created.2.建立 TIMESTEN schemaSQL> @ initCacheGlobalSchema.sqlPlease enter the tablespac

Timesten11g建立datastore[@more@]在完成上面的安装任务之后，因为我们需要TT存放我们应用的数据，我们就要配置自己的data store了(理解为oracle里面的schema)。在做这个任务之前，需要厘清一个概念，DSN=data source name ,这个是标准的ODBC的用语，用来描述一个可以提供odbc连接的数据库服务器，在timesten里面，所有的连接都是通过odbc的，就算是jdbc也是通过odbc连接到到TT上的。在TT里面，有两种DSN1.系统一级的DSN定义在服务器端，定义该data store的文件存放位置，以及其他的一些控制参数，比如是否需要log，是否打开checkpoint等等

Timesten11G安装[@more@]1.修改内核参数，由于之前已安装过11gR2 client端，此部忽略修改/etc/sysctl.conf文件，加上如下列kernel.shmmax = 2147483648kernel.sem = 270 32000 100 128net.ipv4.tcp_rmem = 4096 4194304 4194304net.ipv4.tcp_wmem = 98304 4194304 4194304net.ipv4.tcp_mem = 98304 4194304 4194304net.core.rmem_default = 65535net.core.wmem_default = 65535net.core.rmem_max = 4194304net.core.wmem_max = 4194304net.ipv4.tcp_window_scaling = 1net.ipv4.ip_local_port_range = 1024 65000然后执行 sysctl -p ，使修

Linux 4安装11R2 Client[@more@]1.修改内核参数修改/etc/sysctl.conf文件，加上如下列kernel.shmmax = 2147483648kernel.sem = 270 32000 100 128fs.file-max=6915744net.ipv4.tcp_rmem = 4096 4194304 4194304net.ipv4.tcp_wmem = 98304 4194304 4194304net.ipv4.tcp_mem = 98304 4194304 4194304net.core.rmem_default = 262144net.core.wmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_max = 4194304net.ipv4.tcp_window_scaling = 1net.ipv4.ip_local_port_range = 9000 65500[root@rhel132 ~]# sysctl -p2.增加用户和

Linux version: Red Hat 4 U5 Disk info: hda with 3 partitions, hdb with 3 partitions, hdc with 1 partition[@more@] v:* {behavior:url(#default#VML);} o:* {behavior:url(#default#VML);} w:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-

作者 ora110 http://www.itpub.net/viewthread.php?tid=1044449 http://www.eygle.com/archives/2004/10/recover_backup_missing_datafile.htmlhttp://hi.baidu.com/dba_dream/blog/item/0ddc3013eb60be56f919b84b.html [@more@]使用lsof删除恢复的文件 模拟lsof恢复删除的文件（tools.dbf）： Solaris 9 + lsof 4.77 + oracle 8.1.7 1. 数据文件由dbwr进程打开。 bash-2.05# ps -ef | grep ora_ | grep 817 oracle 817 1 0 15:56:30 ? 0:00 ora_pmon_test817 oracle 819 1 0 15:56:30 ? 0:00 ora_dbw0_test817 ora

http://www.xifenfei.com/2289.html[@more@]一.模拟数据文件删除 [oracle@node1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Sat Dec 31 22:00:52 2011 Copyright (c) 1982, 2011, Oracle. All rights reserved. --数据库版本Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Oracle Label Security, OLAP, Data Mining,Oracle Database Vault and Real Application Testing options --所有数据文件SQL> select name from v$datafile; N