If you get the error because of a slow network, then configure the following parameters on the client side and server side.Even after the tracing parameters are removed, the tracing for the already connected sessions on the server side is stopped only after the client session is closed. To turn off tracing, remove the tracing parameters from the sqlnet.ora file. Create a backup of the sqlnet.ora file, and then modify the following parameters in the file: Then, reproduce the error and capture the details in the trace files. Turn on sqlnet tracing on the client side.For more information, see Modifying connection properties using sqlnet.ora parameters. You can modify these values according to your use case. The parameter values mentioned in this article are examples. Also, be sure that the server has sufficient disk space available. Therefore, it's a best practice to turn on tracing during non-peak business hours or under isolated conditions when no other user is connecting to the database. The process also requires close monitoring. In rare cases, the listener or even the database might need to be restarted to stop tracing after the troubleshooting is completed. A large number of trace files might be generated quickly. Important: Turning on server-level tracing might have a few potential impacts. If you're using the default parameter group, then create a custom parameter group, modify the following parameters, and then modify the instance to use the newly created parameter group. To turn on tracing on the server side, modify the custom parameter group attached to the instance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |