How can find tnsnames.ora

Red Hat. Hi, User claim that job is running slow from their end. I DBA found in database the below errors in alert log file. Shell Programming and Scripting. Removing section from tnsnames. Hi, I am trying to write a script or command to remove a section from tnsnames.

Hi Guys, I wanted to create an Unix Shell Script that should fetch a particular string from a text file on a particular date. We all know Oracle generates alert logs for each and every day for every actions in the database.

I have an alert log file now where it contains for about a months Hi - I am trying to grep all "ORA" errors in a log files. How can exclude that error in "grep" command? All: Can sombodoy help me out with a sed command? Hi all, Am intermittently getting the following errors on one of my databases.

Need to capture the service name from tnsnames. RedHat Commands. To do so: 1. Logon as Administrator. From System Properties, select Environment tab. The Environment tab lists System environment variables defined by Windows NT - these are the same no matter which user is logged on to the computer. When logged as as a member of the Administrator group, you can modify, add or delete values. Click Set, then apply.

Click OK to close window. Feel free to ask questions on our Oracle forum. This site uses Akismet to reduce spam. Learn how your comment data is processed. ORA file? ORA File Located? If the file is not found in this directory, it is assumed the file does not exist. You may need to create one. To start, open the Control Panel. Then, open System. Click on Advanced System Settings, on the left. Type regedit and press Enter. Copy the Value here, and paste it into Windows Explorer. ORA File?

You can choose what this is. In most cases the default port of will be fine. Then, make changes to it as needed. Save the file, and your changes will be saved. See below for an example of this. Expand the Database section and click on Advanced.

Then, click OK.