Oracle OCP试题解析（2）

ITAA-OCM

Your database is started with SPFILE. You want the database instance to be dynamically registered with a listener L2 with the following details:

Protocol:  TCP

Host:  indl151e

Port:  1525

Which is the correct order of the steps that you would follow to achieve this?

1. Set the LOCAL_LISTENER parameter to L2 dynamically.

2. Make an entry for L2 in tnsnames.ora on the database server.

3. Restart L2.

4. Modify the listener.ora file to add the instance name in SID_LIST of L2.

A) 1, 2, 4, 3

B) 1, 2, 3; 4 is not required.

C) 2, 1; 3 and 4 are not required.

D) 1, 2; 3 and 4 are not required.

Answer: C

实验：

Oracle 动态注册监听

1.修改tnsnames.ora

$ vi tnsnames.ora

LISTENER_1525 =

  (address = (protocol = tcp)(host = indl151e)(port = 1525))

2. SQL> alter system set local_listener='listener_1525';

System altered.

3.查看状态

$ lsnrctl status listener_1525

zbfx0123

感谢分享

∑≈⊙♂⊙

mickeymichael

huanghuafeng

GOOD

lana268.net

简单啊