Oracle Single Instance binding multiple services

Background:

Early in the project is the establishment of a server two instances, the client configuration two connections, now need to consolidate two instances of one instance, requires that the client's configuration is not changed.

For example

Pre-integration with Test,standby2 two + instances

Only standby2 this instance after integration

Previously configured on a RAC with SRVCTL and not yet configured on a single instance, here's how to do this:

1. Create a service

EXEC dbms_service.create_service (' Test ', ' test ');

Select T.name,t.network_name from V$services t;

Standby2,standby2

2. Set up service to 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 the Monitor

[Email protected] ~]$ Lsnrctl Reload

[[email protected] ~]$ lsnrctl status;

Lsnrctl for linux:version 11.2.0.4.0-production on 15-sep-2014 12:52:32

Copyright (c) 1991, 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. 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 ...
The Service "test" has 1 instance (s).
Instance "Standby2", status ready, have 1 handler (s) for the This service ...
Service "Standby2" has 1 instance (s).
Instance "Standby2", status ready, have 1 handler (s) for the This service ...
Service "STANDBY2_DGMGRL" has 1 instance (s).
Instance "Standby2", status UNKNOWN, have 1 handler (s) for the This service ...
The command completed successfully

These are the two services that are monitored at standby2 standby2,test

4. Close or delete the previous test instance

It is recommended to close, wait for a period of time to determine that this instance is not required to be deleted.

5. Testing

This is just a description of how to save your app's normal access without changing the client configuration. As for how to integrate the instance test into the standby2 is not described in detail, the process is as follows:

A, user and authorization to create the test instance

B. The table space required to create the test instance

C. Exporting data from the test instance

B. Import data to Standby2 instances

F, refer to the 5th test

This article is from the "Simon Qing his Little Uncle" blog, please be sure to keep this source http://718693.blog.51cto.com/708693/1553033

Oracle Single Instance binding multiple services