![]() You can use the Listener Control utility SERVICES command to see what service handlers are currently registered with the listener. The tnsnames.ora and sqlnet.ora files are located in the default network administration directory on the client system. Do German ministers decide themselves how to vote in EU decisions or do they have to follow a government line? Setting Tracing During Control Utilities Run Time, Evaluating Oracle Net Services Trace Files, Using the Trace Assistant to Examine Trace Files. But, tnsping to DB machine is not connecting. For information about the specific return codes, use the Oracle error tool oerr, by entering the following at any command line: As an example, consider the following nserror entry logged in the trace file shown in Example 16-12: In the preceding entry, the main TNS error is 12537, and its secondary error is 12560. Example 16-5 Listener Log Events for a Successful Connection Request. On the client side, the sqlnet.log file as shown in Example 16-3 contains an error stack corresponding to the ORA-12543 error. ![]()
0 Comments
Leave a Reply. |