Oracle can be equipped with more than one database, and only need to open a listener on it, for multiple databases as long as the appropriate service name can be configured to connect.
I'm using Oracle 8.1.7 Enterprise edition,os is Windows Server, and I've illustrated my configuration process and situation and discussed it with you.
The first step: using NET8 Configuration Assistant tool to configure the listener, always point to the next step, finally completed! Listening to the address is usually a default of 1521 on it.
You can also use the Net8 Assistant tool to verify or configure the listener, as shown in the following figure, which allows you to configure the host and port.
Step two: Use the NET8 Assistant tool to configure the naming service, as shown in the following figure:
Note The service name is the database name, host name and port number must be the same as the listener!
Test, connection successful, ok!
Well, then with the second library service name, the following figure:
Note that the service name should correspond to the second database name!
Then test the connection to the second library, connect successfully, ok!