10 G RAC (ZZ)

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 thoselisteners with the suffix (host_name), So, please be very carefullywhen modifying; (6) Check and modify the initialization paratemter file if possible; Steps: 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 line: orcl1.local_listener = listener_orcl1orcl2.local_listener = listener_orcl2orcl1.remote_listener = listener_orclorcl2.Remote_li . Stener = listeners_orclremove or comment this line: * remote_listener = listeners_orcl (* represents this parameter will be used by each instance) save the modification.3 Invoke SQLPLUS again SQL> shutdown immediate; SQL> exitSQL> startup pfile = 'xxx'SQL. > create spfile from pfile = 'xxx'SQL> shutdown immediate; SQL> exitSQL> startup (new spfile will be used this time) Note :. If you do not change the listener's default port (1521), It'sunnecessary to add Sid's entry in "listener.ora"

, Oraclebackground process PMON will discovery all available services every 60 seconds .. If you use listener's default port (1521), It's unnecessary toconfig parameter 'instance_name.local_listener = xxx' in "init.ora", you also should not add this entry IN "tnsnames.ora" for example, a type, a type "listener.ora" Should Be like this: listener_hostname = (deScription = (pecol = tcp) (host = xxx) (port = 1521 )) (ADDRESS = (PROTOCOL = TCP) (host = your-vip-addr) (port = 1521))) sid_list_listener_hostname = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = xxx) (PROGRAM = extproc)) (SID_DESC = (ORACLE_HOME = xxx)))) for Example, a type "tnsnames.ora" Should Be Like this: listener_hostname1 = (Address = (protocol = TCP) (Host = Test1) (port = 1521) Listener_hostname2 = (address = (protocol = tcp) (host = TEST2) (port = 1521)) listeners_orcl = (address_list = (address = (protocol = tcp) (port = 1521)) (Address = (Protocol = TCP) (host = test2-VIP) (port = 1521)) # Database Connection: OR ClorCl = (deScription = (address = (protocol = tcp) (host = Test1-VIP) (address = (protocol = TCP) (Host = Test2-VIP) (port = 1521 ))) # instance connection: orcl1orcl1 = (deScription = (petrol = tcp) (host = TEST1-VIP) (address = (protocol = tcp) (Host = TEST2-VIP) (port_balance = yes) (connection_data = (server_name = orcl) (instance_name =

ORCL1)) # instance connection: orcl2orcl2 = (description = (address = (protocol = tcp) (port = test1-VIP) (address = (protocol = TCP) (Host = Test2-VIP) Port = 1521)) (logAD_Data = (service_name = orcl2) (a method = 180) (delay = 5)))) Q2 .? How to recofig VIP A2: (1) delete the database using DBCA; (2) delete the ASM (if configured) using documented procedure in 10gRelease notes; (3) delete listeners using NetCA; (4) delete nodeapps using srvctl as root user for all nodes.for example: srvctl stop nodeapps -n srvctl remove nodeapps -n Then you rerun vipca to reconfigure the VIPs, run netca to configurelisteners 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 t tablespace_name from dba_tablespaces) ;. Check if there is a directory has beencreated under $ ORACLE_HOME ;. Issue these commands to check dbconsole's status: emctl start (stop / status) dbconsole2 Trouble Shooting:. Q: Target's information is wrong or lostA :. 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 does not include all targets' information you NEED, You CAN TRY: EMCTL Stop Dbconsole; Remove All Files Under these Directories;