|
# 44410
sailor
|
|
|
 To:
你好，我是一名初学者。编程艺术、管理艺术这两本书值得一看吗
From: sailor
2009.07.09 20:41
|
|
|
|
|
To: sailor
编程艺术 这本是好书。
From: eygle
2009.07.09 21:08
|
|
|
|
|
# 44409
panda
|
|
|
To:
一个问题
CRS的private ip可以和Cluster软件的心跳设在一起吗??
如果可以,是一个心跳网卡上绑定俩个ip这样做??
还是可以共用一个ip????
MC/SG记得好像可以设定private的ip的,HACMP也是可以的吗?
另外,Sun Cluster最少是要有俩个心跳网线,那CRS的private不是设在某一个网卡吧,而是在SC虚拟出来的一个网卡上,但是SC是无法设定private ip的,怎么防止不合CRS的private ip冲突呢???
From: panda
2009.07.08 00:37
|
|
|
|
|
To: panda
可以共用，但是独立更好一点！
From: eygle
2009.07.09 19:33
|
|
|
|
|
# 44407
pengpenglin
|
|
|
To: Eygle
盖老师，你好！
我在学习Oracle Concept资料的第8章《内存结构》时有一段话不是很明白，原文如下(第183页)：
A private SQL area continues to exist until the corresponding cursor is closed or the statement handle is freed. Although Oracle frees the runtime area after the statement completes, the persistent area remains waiting. Application developers close all open cursors that will not be used again to free the persistent area and to minimize the amount of memory required for users of the application.
我对上面这段话有几点不明：
1. curosr，run-time are，persistent area 的关系，是不是每执行一个SQL语句都会在PGA中首先run-time area，然后再是persistent area ？
2. 其次就是cursor的准确概念，如果是run-tiime area和persistent area 可以理解为实际的内存区域，那么cursor是不是一个逻辑上的概念，类似于内存指针？
3.run-time area和persistent area 存储的数据到底是什么？concept手册中对此的解析只提到persistent area包含了binding信息，但没有提到run-time的数据
4.文中提到persistent area 不会被自动关闭，必须显式关闭。为什么要这样？oracle这样做不是会留下存储空间隐患吗？除此之外会不会我们不关闭curor而导致记录被“锁”住的危险？
谢谢！望指点！
From: pengpenglin
2009.06.30 08:31
|
|
|
|
|
# 44404
|
|
|
To:
<script>alert(‘广告’)</script>
From:
2009.06.22 03:27
|
|
|
|
|
# 44403
anycall2010
|
|
|
To:
7.关于ORACLE用户下PING的问题：
su - oracle
ping 35.1.90.21
sh: ping:not found.
进入目录是可以的：
$ cd /usr/sbin
$ ping bl870_1
PING bl870_1: 64 byte packets
64 bytes from 35.1.90.21: icmp_seq=0. time=0. ms
64 bytes from 35.1.90.21: icmp_seq=1. time=0. ms
----bl870_1 PING Statistics----
2 packets transmitted, 2 packets received, 0% packet loss
round-trip (ms)min/avg/max = 0/0/0
$ ping bl870_1-priv
PING bl870_1-priv: 64 byte packets
64 bytes from 10.0.0.1: icmp_seq=0. time=0. ms
64 bytes from 10.0.0.1: icmp_seq=1. time=0. ms
----bl870_1-priv PING Statistics----
2 packets transmitted, 2 packets received, 0% packet loss
round-trip (ms)min/avg/max = 0/0/0
From: anycall2010
2009.06.17 21:52
|
|
|
|
|
# 44402
anycall2010
|
|
|
To:
3.每个用户的属主都是一致的
# id oracle
uid=109(oracle) gid=106(oinstall) groups=107(dba)
4.在ORACLE用户下，使用RSH也是没问题的：
# su - oracle
$ more .rhosts
bl870_1 oracle
bl870_2 oracle
bl870_1-vip
bl870_2-vip
bl870_1-priv
bl870_2-priv
$
5. 测试RSH的等效性：
$ rcp runcluvfy.sh bl870_2:/home/oracle
$ remsh bl870_2 ll
总数 16
-r-xr-xr-x 1 oracle oinstall2990 6月18日 10:22 runcluvfy.sh
$ rcp runcluvfy.sh bl870_1:/home/oracle
$ remsh bl870_1 ll
总数 32
-r--r--r-- 1 oracle oinstall 124 6月18日 10:20 README
-r-xr-xr-x 1 oracle oinstall2990 6月18日 10:25 runcluvfy.sh
6. /HOME/ORACLE的目录权限：
drwxr-xr-x 3 oracle oinstall8192 Jun 18 10:22 oracle
From: anycall2010
2009.06.17 21:51
|
|
|
|
|
# 44401
anycall2010
|
|
|
To:
1.每个节点的主机：
# more /etc/hosts
127.0.0.1 localhost
35.1.90.21bl870_1
35.1.90.23bl870_2
35.1.90.22bl870_1-vip
35.1.90.24bl870_2-vip
10.0.0.1bl870_1-priv
10.0.0.2bl870_2-priv
2.在ROOT用户下，任何一个节点网络的公有IP和私有IP都是没问题的：
# ping bl870_1
PING bl870_1: 64 byte packets
64 bytes from 35.1.90.21: icmp_seq=0. time=0. ms
64 bytes from 35.1.90.21: icmp_seq=1. time=0. ms
# ping bl870_2
PING bl870_2: 64 byte packets
64 bytes from 35.1.90.23: icmp_seq=0. time=0. ms
64 bytes from 35.1.90.23: icmp_seq=1. time=0. ms
# ping bl870_1-priv
PING bl870_1-priv: 64 byte packets
64 bytes from 10.0.0.1: icmp_seq=0. time=0. ms
64 bytes from 10.0.0.1: icmp_seq=1. time=0. ms
64 bytes from 10.0.0.1: icmp_seq=2. time=0. ms
# ping bl870_2-priv
PING bl870_2-priv: 64 byte packets
64 bytes from 10.0.0.2: icmp_seq=0. time=0. ms
64 bytes from 10.0.0.2: icmp_seq=1. time=0. ms
From: anycall2010
2009.06.17 21:50
|
|
|
|
|
eygle.com
我要留言
回复
编辑
To: nif_moon
racle:/opt/oracle] sqlplus "/ as sysdba"