PLSQL remote connection to Oracle ..

The title is very personal, and finally crashes ..

In the afternoon, an oracle instance is created on the server (win2003 64bit) and the service name in tnsname. ora is configured locally on the client.

Testxgd =
(Description =
(Address = (Protocol = TCP) (host = 192.168.1.132) (Port = 1521 ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = testxgd)
)
)

Result PLSQL cannot be connected.

Enable listening on the serverProgram:

Enable the remote listening service:
LSNRCTL start
Disable the remote listening service:
LSNRCTL stop
View the listening status:
LSNRCTL status

The server can be tested locally:

C:> tnsping testxgd

If the Oracle client is installed locally on the client, you can perform a remote test:
C:> tnsping 192.168.1.132: 1521/testxgd

As a result, the local test on the server has failed, and the three ora configuration files under the D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ Network \ ADMIN Directory have been studied for various changes.

Or not. Finally, change the three files to the original configuration as follows:

Tnsname. ora:

Testxgd =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = svctag-8d8bk2x) (Port = 1521 ))
)
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = testxgd)
)
)

Listener. ora:

Listener =
(Description_list =
(Description =
(Address = (Protocol = IPC) (Key = extproc1521 ))
)
(Description =
(Address = (Protocol = TCP) (host = svctag-8d8bk2x) (Port = 1521 ))
)
)

Sqlnet. ora:

Sqlnet. authentication_services = (CNT)

Names. directory_path = (tnsnames, ezconnect)

We hereby record it in case you forget to modify it later ..

Suddenly remembered the firewall .. So I ran to other Oracle servers in the group and checked that the firewall was shut down. Although this was not safe, it was .. So much ..

As a result, 132 of the firewalls were shut down and no filtering rules were selected .. As a result, it was easy to succeed!

Although the local tnsping testxgd still reports invalid TNS 03505: The name cannot be parsed. In addition, I deleted the instance and re-built it, which is perfect.

Yes ..

Conclusion: do not think about the problem as complicated as possible. Start with common sense. Firewall...