Today I installed an Oracle11g in our company's LAN. Need to set it up on it so we can all access it.
In fact, things are not difficult, it is nothing more than the configuration of Oracle on the server side. The client is much simpler. But there was an accident that kept me busy for a long time.
Later, I found out that the server-side firewall needed to be turned off (because in addition to Oracle's port 1521, there would be a random port access, which seemed to be growing ++, so even if I left port 1521 open, it wouldn't work).
Here are the steps:
1. To do server-side Oracle machines, you need to turn off the firewall. (If it is not closed, the network adapter could not establish the connection exception will appear, which is actually the same as the exception when the local monitoring is not configured)
2. First, configure yourself to access yourself in Net Manager, and the test is successful. The results are shown below
It seems that the above configuration has been successful, but in fact, there is still one less step, to configure the number of connections...
Here's what to do:
Open Net Configuration Assistant and select Local Net Service Name Configuration.
Next, select "Reconfigure";
Next, select the service name;
Next, enter your original service name;
Next, when choosing the protocol to use, select TCP.
Next, then the hostname, IP or computer name can be used, the port is generally the default, if you use your own port, you can;
Next, select Yes, test;
Next, generally the first time is the test failure, because the test uses the system username and password (system is locked by default, you can unlock it when installing Oracle, or unlock it later), you can enter your correct username and password by "Change Login", and it will be automatically tested after "OK", if it succeeds, it will be Next, until Over.
Here is a screenshot:
OK, there are quite a lot of pictures, and after all the above things are set up, you need to restart Oracle (this is very simple: lsnrctl stop/start; net stop/start oracleserverorcl; )
Next client:
If the client can use sqlplus in DOS, you can test it with these commands:
If not, it is best to download Oracle SQL Developer from Oracle's official website
The connection test is shown below:
|
Posted on 1/24/2015 1:57:19 PM
|
|
|
|
