eygle.com   eygle.com
eygle.com  
 
留言簿 - Oracle Life - Powered by Eygle.com
eygle.com 我要留言
《深入浅出Oracle》内容简介
昵称
内容 页: 1 - << < 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 > >> - 404
# 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 oinstall2990 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 oinstall2990 6月18日 10:25 runcluvfy.sh

6. /HOME/ORACLE的目录权限:
drwxr-xr-x 3 oracle oinstall8192 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.21bl870_1
35.1.90.23bl870_2
35.1.90.22bl870_1-vip
35.1.90.24bl870_2-vip
10.0.0.1bl870_1-priv
10.0.0.2bl870_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

版主选项: 回复 编辑
# 44400
anycall2010




To:
  我的主机环境是:
HP BL870 安腾2的刀片小型机
操作系统是:
HP-UNIX 11.3.1
遇到问题:
$ ./runcluvfy.sh stage -pre crsinst -n-verbose bl870_1,bl870_2

Checking user equivalence...
User equivalence check passed for user "oracle".

Checking administrative privileges...
User existence check passed for "oracle".
Group existence check passed for "oinstall".
Membership check for user "oracle" in group "oinstall" [as Primary] passed.

Administrative privileges check passed.

Checking node connectivity...

ERROR:
Network interface information could not be obtained from any of the nodes.

ERROR:
Network interface information could not be obtained from any of the nodes.

Node connectivity check failed.





From: anycall2010
2009.06.17 21:49

版主选项: 回复 编辑
# 44399
chopin




To: 盖大师:
  我在做physical standby database 转为logical standby database时:
alter database recover to logical standby database toms;
报了一个罕见的ORA-20000错误,我在GOOGLE上找不到同样的案例,请大师帮我看看!
 ORA-20000: File /u01/app/oracle/oradata/toms/temp01.dbf has wrong dbid or dbname, remove or restore the offending file.
From: chopin
2009.06.12 04:51

版主选项: 回复 编辑
# 45050
wzh617




To:
  eygel你好 ,最近我测试oracle 10g 和for sybase互连.
我今天遇到了一个问题,我想配置异构,tns 和lisener文件写好了,但是我创建dblink后,我tnsping 成功了,但我运用dblink执行查询的时候sqlplus给报了这样一个错误:
“ORA-28545:连接代理时Net8诊断到错误”
NCRO:无法执行RSLV连接
ORA-02063:紧接着2 lines(源于SID)"
请指教一下.谢谢.
From: wzh617
2009.06.11 03:39

版主选项: 回复 编辑
# 44398
pengge


来自: 山西


To:
  建议将恩墨科技的网址放在你网站的首要位置,一则便于链接方便大家,同时也起到宣传的作用。(来自山西的建议)
From: pengge
2009.06.10 18:50
To: pengge
  加入,看看效果,谢谢建议!
From: eygle
2009.06.11 03:17

版主选项: 回复 编辑
# 44397
etl2009




To:
  
感觉oracle10g以后,instance_name没有多大意义,
看了eygle哥你那本<<深入浅出Oracle>>书,因为10g以后,instance_name已经不在初始化参数设置
大概没有人用alter system set paramter ...
这种方式去修改把?
这样理解对吗?
From: etl2009
2009.06.08 21:11
To: etl2009
  是的,对于用户来说意义不大,但是对于数据库来说来时不可缺少的,比如实例注册等。
From: eygle
2009.06.11 03:17

版主选项: 回复 编辑
# 44396
咪咪同学




To: Eygle
  猫咪同学,猪你生日快乐 =(^ . ^)=
From: 咪咪同学
2009.06.07 18:19
To: 咪咪同学
  谢谢咪咪同学!
From: eygle
2009.06.07 20:33

版主选项: 回复 编辑

页: 1 - << < 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 > >> - 404
我要留言
Copyright © 2003~2012 eygle.com All Rights Reserved.
Powered by: www.eygle.com