The Oracle ODBC Test utility may be used to test an ODBC data source. An Oracle DBA may need to provide the correct connection information. The configuration for the service name must be checked using the Oracle Net Assistant or Net Configuration Assistant.
If the TNS Ping fails, there is a problem with the Oracle Service Name. In the event of a "Connect failed" message, a cause or reason will be included (for example, "TNS-12545: Connect failed because target host or object does not exist"). The TNS Ping Utility will result in an "OK" or a "Connect failed" message. To use it:ġ.Open a Command Prompt (click Start, click Run, type cmd, and then click OK).Ģ.Type tnsping (for Oracle 7.3 or Oracle 8i and later) or tnsping80 (for Oracle 8.0), and then press enter. The TNSPING utility can be used to test an Oracle Service Name.
When connection problems occur, it is best to test each piece of the connection to determine where the problem lies. How do I test Oracle connectivity? More InformationĬonnecting to an Oracle database via ODBC requires two things:Īn Oracle Service Name (known as an Alias in versions prior to Oracle 8.0) defines the location (server name and port) and database (instance) for the connection.Īn ODBC Data Source simply defines which service name should be used for the ODBC connection.Įach of these items must be set up correctly for a connection to work.
0 kommentar(er)
