How to install Oracle on Windows Server 2016

1. Install Oracle There are too many Oracle installation instructions on the Internet, so I will not repeat them here. I will mainly explain the connection.

I am using a virtual machine server 2016. After reinstalling the system on the host, it took most of my time to reinstall and configure the client, so I will record it here, hoping to avoid detours in future configurations.

2. Install oracle client .

3. Configure oracle client network

If the server address changes due to reinstallation of the virtual machine, listerner.ora and tnsnames.ora data must be rewritten into the Oracle file.

Just take a look at the SID, KEY, and Service Name (the net manager will usually automatically configure them later).

HOST, this item needs to be changed to the local IP address.

(Install the Oracle client on the host, and then) check the host configuration net manager information.

The data is consistent with the previous configuration.

Oracle Connection

Generally, if you use the Oracle installation file, Oracle will automatically configure the variables and firewall.

variable:

Here I created a new OH to facilitate future changes when the address changes.

Firewall:

Then you can open the host connection.

Summarize

The above is the tutorial illustration of installing Oracle on Windows server 2016 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website! If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!