topics

全部话题 - 话题: 11gr2
1 (共1页)
y***a
发帖数: 733
1
来自主题: Database版 - oracle 11gr2 installation problem
I just installed oracle 11gr2 but got the net configuration assistant failed
at the end. The log doesn't help. Any suggestions for the problem?
Thanks.
b*****r
发帖数: 239
2
Job Description:
Interactive Data has an opening for an Oracle Database Administrator in our
White Plains, New York office. In addition to the following responsibilities
, you must be available via cell phone for 7x24 on-call rotation for support
of production databses.
Install, configure and troubleshoot Oracle 10gR2, 11gR1 and 11gR2 RAC
clusters.
Configure and troubleshoot Oracle Dataguard for disaster recovery.
Work with the Business Continuity Team to refine and test disaster recovery
system... 阅读全帖
a*****o
发帖数: 136
3
来自主题: Database版 - DBA职业要求
女DBA一点也不少。前几天去开ORACLE 11gR2的一个SEMINAR,在座中国DBA(或者东亚
面孔)中,女DBA快有一半了
是不是体力活,跟公司有关。如果是稳定的行业和政府,或非IT的公司的IT部门,一般
不忙;IT公司,尤其小公司,往往累得贼死。
n*******r
发帖数: 425
4
来自主题: Database版 - DBA职业要求
是oracle 11gr2 upgrade seminar? 我也去了呀。
反正我没见到女dba做得特别优秀的,一般的dbo有一些吧
M*****r
发帖数: 1536
v*****r
发帖数: 1119
6
来自主题: Database版 - Oracle 11gR2 for x64 windows out
Curious, anyone choose Windows to run Oracle? and for what reason (I mean
over linux/unix)?
i****a
发帖数: 36252
7
来自主题: Database版 - Oracle 11gR2 for x64 windows out
I did that when I was in college, as a research project, hee

mean
M*****r
发帖数: 1536
i****0
发帖数: 115
9
来自主题: Database版 - oracle 11gr2 installation problem
如果netca配置出错就直接自己写好了
或者copy其他主机上的listener.ora, tnsnames.ora, sqlnet.ora
j***a
发帖数: 10844
10
来自主题: Database版 - oracle 11gr2 installation problem
Windows?
Did you use DHCP?
Can you login as sysdba?

failed
g*********0
发帖数: 80
11
finally finished installations of Oracle 11g R2 RAC on Oracle Enterprise
Linux 5 on VMWare Server 2. The complete screenshots are placed in one PDF
file in the following link:
http://clusterwhere.wordpress.com/
Welcome to critique and comment.
Thanks.
y****9
发帖数: 144
12
Good effort! Thanks for sharing.
Would be nice if doing some testing/simulations on the RAC to demonstrate
its features.
Previously I have done some test about load balancing on a 10g RAC, for
example:
http://oracle-study-notes.blogspot.com/2010/04/play-with-my-toy
v*****r
发帖数: 1119
13
Nice blog!
I configured a couple of 10g RAC (both are 2 node on Linux) last year to
host a sort of mixed but more DW intensive application. If I turn on LB (
either client side or server side), the performance got hit pretty bad due
to heavy traffic on interconnect (gigabyte switch). I have to disable LB for
for those 10g RACs to pass the performance testing. Now there are both
running well for about 6 month in production without LB. Maybe a bias, but
it seems to me disabling LB might be a best ... 阅读全帖
M*********e
发帖数: 190
14
Thank you for sharing.
You used Bridged network in the description, while the graphs showed NAT.
Which did you actually use?
Thanks.

PDF
v*****r
发帖数: 1119
15
Either bridged network or NAT is okay. The key is to use static ip instead
of dhcp.
g*******g
发帖数: 108
16
RAC has high demand for interconnect. enable jumbo frame on the dedicated
interconnect subnet helps with bandwidth related "waiting time".
RAC is good for a well tuned system. It could be performance killer for
poorly tuned application/system.
CINAOUG-- chinese Oracle User Group.
w*********r
发帖数: 2095
17
来自主题: Database版 - Oracle在Ubuntu 10.04上的安装问题
我想在我的Ubuntu 10.04上安装Oracle 11g.
基本按照一下步骤:
http://www.pythian.com/news/13291/installing-oracle-11gr2-enter
安装过程出现附件图片的错误。大牛帮忙看我是哪里的问题?
B*****g
发帖数: 34098
18
要学Oracle,先需要装Oracle。关于新手安装Oracle的几点建议:
1. Oracle非商业使用免费下载,尽量选用Linux版本的Oracle (12c)
http://www.oracle.com/technetwork/database/enterprise-edition/d
2. 免费下载Linux
http://edelivery.oracle.com/linux
http://www.centos.org/modules/tinycontent/index.php?id=30
3. 尽量使用VitualMachine安装
http://www.oracle.com/technetwork/server-storage/virtualbox/dow
http://my.vmware.com/web/vmware/info/slug/desktop_end_user_comp
4. 安装教学视屏 (播布客)CentOS 5 + VMWare,使用CentOS 6 + VitualBox过程大
体相同,只是centOS6里没有pdksh的包
http://www.boo... 阅读全帖
b*****r
发帖数: 239
B*****g
发帖数: 34098
20
来自主题: Database版 - 请教PL/SQL 语法
我个人认为学习解决问题的方法远比学习一个知识点重要得多。
以你写的code为例,大家来探讨一下:
UPDATE INVENTORY
SET stockqty = (SELECT INVENTORY.stockqty - v_qty
FROM INVENTORY
WHERE INVENTORY.partid = v_Partid)
WHERE partid = v_Partid;
这个你自己看着都觉得别扭,怎么办?当然,去问会的同学也是一种方法,但肯定不是
最好的。
学习第一大法,***读文档***
找到oracle 11gR2的关于update的文档(怎么找到文档的?晕倒)。
http://docs.oracle.com/cd/E11882_01/server.112/e17118/statement
一共没几行,里面已经给出例子能解决你的问题。
如果你仔细阅读这篇文档,你会发现你的code还可以继续优化。基本上就解决了另外一
个问题,为什么update后还要再用一... 阅读全帖
a****l
发帖数: 120
21
成功migrate;今天抽空共享下心得和步骤。感谢bridger提供思路。
详细点就是
1. 把windows instance,包括spfile,controlfile,datafile全部 convert to
linux instace。
http://anandoracle.wordpress.com/2012/12/24/migration-database-
2. 把NON-ASM的LINUNX databaseconvert成ASM的LINUX database
http://anandoracle.wordpress.com/2012/12/13/migrating-non-asm-t
3. 我使用的是用rconfig把single linux instance with ASM 转换成 RAC with asm
http://zakkiahmed.wordpress.com/2010/08/04/convert-11gr2-non-ra
注意的事项是
1.如果你的datafile有corrupted block,需要用备份先修复,再convert;可以先用
dbv和v... 阅读全帖
s********e
发帖数: 893
22
来自主题: Database版 - 挖一大坑+奔
看到奔就赶紧进来了。结果看到一对术语Data Redaction, heatmap什么的不知所云。
我们最近才升到11g r2。估计几年后才会升到12吧。不管什么版本,我们developer用
的也不过就是些简单sql,好像用不着这些新功能。不过最近俺写了个query用了
LISTAGG,把我们办公室的16年经验的大牛给震惊了一下,说从来不知道这个东东。后
来一查,这个function从11GR2才有的。
俺以前也参加过一次Oracle BI的发布会,早饭中饭都管,还有帽子随便拿。反正是上
班时间去,今后有还去。呵呵。
1 (共1页)