Oracle local net service name configuration tnsnames. ora file has strict format requirements
Today, a service name is manually added to the configuration file. When a client is connected, the SERVICE_NAME resolution error is reported. As a result, the configuration of the Configuration tool provided by Oracle does not respond to the next step, it is assumed that the configuration file is incorrectly parsed. The configuration file is restored and configured successfully using the tool provided by Oracle. After analyzing the file, I found that a space was added manually, and it turned out that the space was at work. Local_ora = (Description = (Address_list = (Address = (Protocol = TCP) (host = localhost) (Port = 1521 )) ) (CONNECT_DATA = (SERVICE_NAME = ora) ) ) The explanation on the internet is:CodeMediumBlueSome rows cannot start with spaces,RedSome rows must start with spaces. I don't know why oracle is designed like this. |