Oracle Database remote connection configuration steps and FAQs

Oracle Database remote connection configuration steps and FAQs objective computer needs: Open net manager1: In the listener: Change "host" to the computer name (ensure that the name is unique) 2: with the listener, you need to specify the database service. In this case, you need to modify the global database name (which is used for custom connection to the other party, so as to keep the database name of the local server confidential). 3: file --> Save network configuration 4: you also need to use sys to create a common user that needs to assign permissions (as the login user of the Link) to connect to the computer. You need to: Open oracle net configuration Assistant1: configure the service name of the local network. 2. Add the next step. 3. The server name is the database alias in the second entry required by the computer above. 4. The protocol is tcp. 5: the host name is the name of the computer on which the target computer is located, that is, the name of the computer in the first section of the target computer. 6: Test 7: if the connection is not successful, click "Change login". the user name and password are the four users that need to be created in the above destination computer, namely, the password. There are several errors: 1: invalid username password login denied // The database alias is incorrect (that is, the database alias in the second entry is required for the above destination computer); 2: No listener: the host name is incorrect (that is, the name of the computer in the first article required by the target computer); or restart the listener service. 3: The listener cannot connect to the request service. In this case, there may be a listener but no database service, pay attention to 23 of the 23 "destination computers need;