Tnsnames. ora

Tnsnames. ora set up a strange problem to solve the oracle database connection problem that had just been solved for three days. It was really unpleasant to record it. Www.2cto.com needs to connect to the device database of the current network in the past few days. The connection method is still complicated. You need to set up the vpn environment. Fortunately, it was previously set up. Configure the tnsnames. ora file, open plsql, and start the connection. The system prompts that the remote Oracle cannot be connected. Try to connect to another database in the current network. Connect to the R & D database in the LAN. NND, so strange. I tried to telnet port 1521 of the Oracle server, prompting that the connection failed. D: \ Documents ents and Settings \ Administrator> telnet 172.16.73.6 1521 connecting to 172.16.73.6... the connection to the host cannot be opened. In port 1521: the connection fails because the vpn authorization file is not configured before, and the current database cannot be connected. If the problem is suspected to be a vpn problem, contact the O & M team. After two days of hard work, I couldn't do it. I simply re-generated the vpn certificate. I still can't. The O & M team surrendered. I really didn't encounter this situation. Even the current network database that can be connected previously cannot be connected now. Www.2cto.com
Today, let's try again. Edit the tnsnames. ora file. Delete the new database connection. The existing database that can be connected before the connection cannot be connected. Good. It seems that the problem is found. Join the new database connection and test again. MD. There is a problem with this connection. Yuan Fang, what do you think? Observe carefully. There are several spaces before the database connection name oss139_ccm. Delete and reconnect. Nima, that's simple. This is too mentally retarded. Oss139_ccm = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.73.6) (PORT = 1521) (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.73.8) (PORT = 1521) (LOAD_BALANCE = no) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ccmservice) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5 ))))