How to configure multiple databases in Oracle

(1) multiple databases can be configured in Oracle, and only one listener can be enabled. You only need to configure the corresponding service name (for example) for multiple databases to connect.

Note the following points:

1. generally, if multiple applications use Oracle databases, you only need to create one database. You can set up different users (different tablespaces) for different applications.

2. if the character sets of multiple applications are different, such as BIG5 and GB2312, you generally need to consider configuring multiple servers, creating multiple databases, or converting to character sets such as UTF-8.

3. if you need to install multiple versions of Oracle for development, for example, to install Oracle9i and Oracle8.1.7 at the same time, you need to configure the respective listening ports. The environment variables do not need to be configured and do not conflict with each other.

HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE, but will be divided into HOME0 ~ HOME... stores different keys, so there will be no conflict.

(2) When configuring multiple listeners or one listener to listen on multiple databases, pay attention to the need to configure the Database Service for the listener ():

After the Listener Configuration is modified, restart the listener service !!!