No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

AMI Smart Meter Reading Solution V200R010C10 Planning and Design Guide

This document describes the overall and detailed design of functions and services in the AMI Smart Meter Reading Solution.
Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Oracle Database Parameter Plan

Oracle Database Parameter Plan

When all application systems use the Oracle database, two Oracle databases need to be deployed. One Oracle database is used for data storage of the EEM and DCP, and the other one is used for data exchange with the third-party application system. The Oracle database in the single-node system or Oracle RAC can be deployed. In the AMI solution, the deployment mode is selected based on the number of connected devices, and different parameters are configured accordingly.

The EEM and DCP support both Oracle and MySQL databases. The EEM and DCP can connect to millions of smart meters and the service volume is large, so the Oracle database with high performance is recommended.

The AMI solution supports the Oracle database in the single-node system, Oracle RAC, and Oracle HA. The Oracle database in the single-node system and Oracle RAC are deployed on servers that run the Linux operating system, whereas Oracle HA is applied to the virtualized AMI solution and deployed on VMs that run Windows Server 2008 operating system.

Oracle Database in the Single-Node System

Table 6-5 describes the parameter plan of the Oracle database in the single-node system is deployed.
Table 6-5  Parameter plan of the Oracle database in the single-node system

Item

Parameter

Description

Basic Oracle parameters

Operating system User/Password

User name and password used by an administrator for logging in to the Oracle database server.

IP Address

IP address used by an application system to connect to the Oracle database. The value is the IP address of the Oracle database server.

Database Port

Port number used by an application system to connect to the Oracle database.

DB Username/Password

User name and password of the system administrator of the Oracle database.

Database service

Database Instance

Service name of each application system connected to the Oracle database. The service name of the same database is unique and corresponds to an application system.

Oracle RAC

Table 6-6 describes the parameter plan of Oracle RAC.
Table 6-6  Parameter plan of Oracle RAC

Item

Parameter

Description

IP addresses

Public IP

Internal IP address of a data center, which is used by the administrator to access and manage devices. The value is on the same network segment as VIP.

Private IP

Internal IP address in a data center, which is used for heartbeat synchronization. The value is used to detect faults of the Oracle database server and software. The value is on a network segment different from Public IP. The IP address is not detected by external systems or users.

SCAN IP

Virtual IP address, which is used by application systems to connect to the Oracle server. The value is mapped to the active and standby Oracle servers, so the application systems cannot detect the active/standby switchover of Oracle servers. The value is a floating IP address and the corresponding Oracle node is not fixed. When one Oracle node fails, the SCAN IP address corresponds to another Oracle node. It is on the same network segment as Public IP.

Virtual IP (VIP)

When one Oracle node is unavailable, the virtual IP address is used by another Oracle node. It is on the same network segment as Public IP, and is not detected by users.

Basic parameters of the Oracle database

Operating system User/Password

User name and password used by an administrator for logging in to the Oracle database server.

Database Port

Port number used by an application system to connect to the Oracle database.

DB Username/Password

User name and password of the system administrator of the Oracle database.

Database Instance

Service name of each application system connected to the Oracle database. The service name of the same database is unique and corresponds to an application system.

Oracle HA

Oracle HA is deployed in Windows Server 2008 VMs. Three VMs need to be deployed, among which one VM is used as the shared storage server and two VMs are used as database servers. Table 6-7 describes the parameter plan of Oracle HA.
Table 6-7  Parameter plan of Oracle HA

Server

Item

Parameter

Description

Shared storage server

IP addresses

Server IP address

IP address used by the database server and external device to communicate with the shared storage server.

Service floating IP address

IP address used by other components to communicate with the database. This parameter corresponds to the active database node. When the active database node fails, services are switched to the other database node and the floating IP address is also switched to this node.

Heartbeat floating IP address

IP address used for detecting the database node status.

Failover IP address

IP address used by a client to detect switching and other operations of the database node, which corresponds to a service set of the failover cluster.

Basic parameters

Operating system User/Password

User name and password used by an administrator for logging in to the shared storage server.

Database server

IP address

Service IP address

IP address used by the database server to communicate with external devices.

Heartbeat IP address

Heartbeat IP address, which is used to detect the database server status.

iSCSI service IP address

IP address used for the iSCSI server.

Basic parameters

Operating system User/Password

User name and password used by an administrator for logging in to the Oracle database server.

(Optional) Local Area Connection

Name of the local connection of the database server, which is user-defined. You are advised to name it to facilitate subsequent Oracle HA configuration.

(Optional) Server name

Name of the database server, which is automatically named by Windows Server 2008. You are advised to name it to facilitate subsequent Oracle HA configuration.

Database

Basic parameters

Database Port

Port number used by an application system to connect to the Oracle database.

DB Username/Password

User name and password of the system administrator of the Oracle database.

Database Instance

Service name of each application system connected to the Oracle database. The service name of the same database is unique and corresponds to an application system.

Translation
Download
Updated: 2019-03-07

Document ID: EDOC1100069579

Views: 6771

Downloads: 11

Average rating:
This Document Applies to these Products
Related Version
Related Documents
Share
Previous Next