Shulou(Shulou.com)06/01 Report--

Background:

In the early stage of the project, two instances were established on one server, and the client configured two connections. Now it is necessary to integrate the two instances into one of the instances, requiring that the configuration of the client not be changed.

For example

There are two instances of test,standby2 before consolidation.

Only standby2 is the instance after integration.

It has been configured with srvctl on RAC before, but not on a single instance. Now, the specific operations are as follows:

1. Create a service

Exec dbms_service.create_service ('test','test')

Select t.name,t.NETWORK_NAME from v$services t

Standby2,standby2

2. The setting service will take effect immediately.

Alter system set service_names='standby2,test'

Select t.name,t.NETWORK_NAME from v$services t

Standby2,standby2

Test,test

3. Reload monitoring

[oracle@standby2 ~] $lsnrctl reload

[oracle@standby2 ~] $lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0-Production on 15-SEP-2014 12:52:32

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=standby2) (PORT=1521)

STATUS of the LISTENER

-

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.4.0-Production

Start Date 15-SEP-2014 12:39:28

Uptime 0 days 0 hr. 13 min. 4 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File / u01/app/oracle/diag/tnslsnr/standby2/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=standby2) (PORT=1521))

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1521)

Services Summary...

Service "test" has 1 instance (s).

Instance "standby2", status READY, has 1 handler (s) for this service...

Service "standby2" has 1 instance (s).

Instance "standby2", status READY, has 1 handler (s) for this service...

Service "standby2_DGMGRL" has 1 instance (s).

Instance "standby2", status UNKNOWN, has 1 handler (s) for this service...

The command completed successfully

These are the standby2,test of the two services monitored by standby2

4. Close or delete the previous test instance

It is recommended to close it and delete it after running for a period of time to make sure that this instance is not needed.

5. Test

The above just shows how to save the normal access to the application without changing the client configuration. There is no detailed description on how to integrate instance test into standby2. The process is as follows:

A. The user and authorization used to create the test instance

B. The tablespace needed to create a test instance

C. Export data from test instance

B. Import data to standby2 instance

F, refer to point 5 test

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.