One Oracle instance is bound to multiple services

One Oracle instance is bound to multiple services

Background:

In the early stage of the project, two instances were created on one server, and two connections were configured on the client. Now, you need to integrate the two instances into one of the two instances without changing the client configuration.

For example

There are two instances test and standby2 before integration.

After integration, only standby2 instances are available.

Previously configured with srvctl on RAC, but not on a single instance, 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. Set the 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 listener

[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,201 3, 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

The above are the two services standby2, test monitored in standby2.

4. Close or delete the previous test instance

We recommend that you disable it. After a period of operation, you do not need to delete this instance.

5. Test

The above only shows how to save the normal access to the application without changing the client configuration. The process of integrating instance test into standby2 is not detailed as follows:

A. Users and authorizations used to create the test instance

B. Table space required to create a test instance

C. Export data from the test instance

B. import data to the standby2 instance

F. Refer to test at 5th.

-------------------------------------- Split line --------------------------------------

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

-------------------------------------- Split line --------------------------------------