10 G RAC (zz)

原创 2004年11月03日 15:44:00
Q1. How to configure "listener.ora" and "tnsnames.ora"
A1. Usually, NETCA will launch automatically during the DBCA.
IF you have encountered some errors or want to reconfig
them later, please do the following things:

(1) Launch NETCA ;
(2) Choose the option "Cluster" in the first page;
(3) Choose one type such as "create listener",
"create local net service";
(4) Test the new created listener or local net service until success;
(5) By default, the application "srvctl" can only manage those
listeners with the suffix(host_name),So,please be very carefully
when modifying;
(6) Check and modify the initialization paratemter file if possible;

Create a new initialization parameter file 'init.ora' on host (test1),
this file will be shared by each instance.

1. Invoke SQLPLUS, issue the following command:

SQL> create pfile='xxx' from spfile;

2. open "init.ora", add the following lines:


remove or comment this line:
(* represents this parameter will be used by each instance)

save the modification.

3. Invoke SQLPLUS again
SQL> shutdown immediate;
SQL> exit

SQL> startup pfile='xxx'
SQL> create spfile from pfile='xxx'
SQL> shutdown immediate;
SQL> exit

SQL> startup (new spfile will be used this time)

. If you don't change the listener's default port(1521), It's
unnecessary to add SID's entry in "listener.ora", Oracle
background process PMON will discovery all available
services every 60 seconds.

. If you use listener's default port(1521), It's unnecessary to
config parameter 'instance_name.local_listener=xxx' in
"init.ora" , you also shouldn't add this entry in
"tnsnames.ora" (local_listener_name = ...)

For example, a typical "listener.ora" should be like this:

listener_hostname =
(ADDRESS = (PROTOCOL = TCP)(host=xxx)(port=1521))
(ADDRESS = (PROTOCOL = TCP)(host=your-vip-addr)(port=1521))

sid_list_listener_hostname =
(PROGRAM = extproc)


For example, a typical "tnsnames.ora" should be like this:


listeners_orcl =
(address_list =

# database connection: orcl
orcl =
(description =
(connect_data =

# instance connection: orcl1
orcl1 =
(description =
(load_balance = yes)
(connect_data =

# instance connection: orcl2
orcl2 =
(description =
(load_balance = yes)
(connect_data =
(failover_mode =
(type = select)
(method = basic)

Q2. How to recofig VIP ?
(1) delete the database using DBCA;
(2) delete the ASM(if configured) using documented procedure in 10g
Release notes;
(3) delete listeners using NetCA;
(4) delete nodeapps using srvctl as root user for all nodes.
for example:
srvctl stop nodeapps -n <node>
srvctl remove nodeapps -n <node>

Then you rerun vipca to reconfigure the VIPs, run netca to configure
listeners and dbca to create database to arrive at your initial state.

Q3: How to configure EM environment for RAC ?
1. Usually we only need run DBCA again to check the following
things exist:

. Check whether a schema "SYSMAN" has been created
(select username from all_users);

. Check if tablespace "SYSAUX" exists
(select tablespace_name from dba_tablespaces);

. Check if there is a directory <hostname_sid> has been
created under $ORACLE_HOME;

. Issue these commands to check dbconsole's status:

emctl start(stop/status) dbconsole

2. Trouble Shooting:

Q: Target's information is wrong or lost

. Go to directory: $ORACLE_HOME/hostname_sid/emd,
open "targets.xml" to check if all available targets have
been discovered by EM;

. If the file <targets.xml> doesn't include all targets'
information you need, You can try:

emctl stop dbconsole;
remove all files under these directories;

check file <targets.xml> again, make sure that at least
agent and host's info can be found from this file;

emctl start dbconsole; --wait for the new metic data
to be uploaded into the repository

3. If you've modified some settings of EM and the repository
has been created, you can execute "emca -r " to configure
the EM repository again;

4. Launch "http://host_name: port_number/em" on all nodes and
check them.


rac中节点的网卡MTU 参数不一致,导致实例启动不了

适用于oracle 企业版的9.0.1.0到11.2.0.3之间的版本 症状 如果集群中节点的私网网卡的mtu(最大传输单元)参数不一致,那么rac 实例将不能够启动 改变 修改网络配...
  • huoshuyinhua
  • huoshuyinhua
  • 2016年10月20日 17:24
  • 366


profile通常指配置文件,crs_profile望文生义可知,就是管理集群的配置文件。在Oraclele RAC中,所有的CRS资源存放在OCR磁盘中,对于OCR更形象的比喻是类似于Windows...
  • robinson_0612
  • robinson_0612
  • 2012年11月16日 22:33
  • 9106

什么叫做Oracle RAC中的nodename

什么叫做Oracle RAC中的nodename
  • msdnchina
  • msdnchina
  • 2015年11月19日 00:40
  • 793

Oracle 10gR2 RAC的启动和关闭步骤

Oracle 10gR2 RAC的启动和关闭步骤     1.RAC有随服务器启动的脚本,放在/etc/inittab里:  [oracle@node1 bin]$ cat /etc/init...
  • lnwf5188588
  • lnwf5188588
  • 2013年03月17日 15:59
  • 1120

vi 常用命令 zz

输入模式命令 进入输入输出的方法 命令 ...
  • beff2047
  • beff2047
  • 2006年12月06日 14:35
  • 4136


核心就在于以下两个语句,测试了redhat 5和redhat 6,语句中的b c d代表的是sdb sdc sdd等,要根据实际情况进行修改 redhat 5 for i in b c d e f ...
  • badly9
  • badly9
  • 2015年08月27日 16:16
  • 910

Solaris 10(x86)构建Oracle 11gR2 RAC之--配置系统环境(2)

Solaris 10(x86)构建Oracle 11gR2 RAC之--配置系统环境(2)系统环境:操作系统:Solaris 10(x86-64)Cluster: Oracle GRID 11.2.0...
  • lqx0405
  • lqx0405
  • 2015年03月31日 12:12
  • 842

zz 什么是朋友?

文      lcx我不知别人对朋友如何理解的?越来越搞不懂,朋友之间会因为金钱伤害感情吗?以诚待人是我的信条可怕的是你的信条在别人那儿不一定管用,因为涉及到了利益。记得有一个关系还不错的朋友,吃饭时...
  • freexploit
  • freexploit
  • 2005年07月29日 18:57
  • 1226

linux下安装Oracle10g RAC操作--根据[三思笔记]操作

--根据[三思笔记]手把手教你用VMware在linux下安装Oracle10g RAC操作 一、环境 1、RHEL5.4   kernel:2.6.18-164.el5 2、WMwar...
  • rumengjian
  • rumengjian
  • 2013年05月02日 16:28
  • 948

RAC优化之配置大帧(jumbo frame)

RAC优化之配置大帧(jumbo frame) 首先讲讲MTU的概念:在网络通信中,有个MTU(Max Transmission Unit)的概念,即网络传输中最大帧的大小,这个值默认是1500By...
  • zhou1862324
  • zhou1862324
  • 2014年10月27日 22:03
  • 1256
您举报文章:10 G RAC (zz)