08-01-2009
If you are running Oracle on a Linux machine then run the following as root to find it:
#
updatedb
#
locate tnsname.ora
10 More Discussions You Might Find Interesting
1. HP-UX
Hi:
i have writen a script that needs a finishing
Pourpouse is to find a particular error in a file after we enter file name
and the return msg would describe if >there is a error -> "Contact DBA"
if there is no oracle error ->"No ora error found."
for the same i have written a script... (6 Replies)
Discussion started by: techbravo
6 Replies
2. Shell Programming and Scripting
Hi,
Can anyone tell me how to get all ORA errors between two particular times in an alertlog file using shell script.
Thanks (3 Replies)
Discussion started by: suman_dba1
3 Replies
3. Shell Programming and Scripting
Hi Everyone,
I have 1.txt
here
a
b
c' funny"yes";
d
e
The finally output is:
here
a
b
c
d
e' funny"yes"; (1 Reply)
Discussion started by: jimmy_y
1 Replies
4. Shell Programming and Scripting
Hi,
Please guide me where i am doing wrong, i am getting
ORA-01756:quoted string not properly terminated when i am trying to insert file into CLOB cloumn of Oracle DB.
Please find below the code where log file variable is myLogFile. Please let me know where i am doing wrong.
... (0 Replies)
Discussion started by: rajeshorpu
0 Replies
5. Solaris
Hi all,
Am intermittently getting the following errors on one of my databases.
Errors in file /oracle/HRD/saptrace/background/hrd_psp0_13943.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302:... (1 Reply)
Discussion started by: newbie_01
1 Replies
6. UNIX for Advanced & Expert Users
Hi - I am trying to grep all "ORA" errors in a log files.I have to grep all ORA errors except one error for example ORA-01653.How can exclude that error in "grep" command?
In following "grep" command I want to exclude "ORA-01653" error
grep -i ORA alert.log >>/tmp/ora_errors.txt
... (7 Replies)
Discussion started by: Mansoor8810
7 Replies
7. Shell Programming and Scripting
Hi,
I am logging to a linux server through a user "user1" in /home directory.
There is a script in a directory in 'root' for which all permissions are available including the directory. This script when executed creates a file in the directory.
When the script is added to crontab, on... (1 Reply)
Discussion started by: archana.n
1 Replies
8. Shell Programming and Scripting
I have file file1.txt in location 'loc1'. Now i want a copy of this file in location 'loc2' with a new file called test.txt.
Please help me how to do this in shell script. (1 Reply)
Discussion started by: vel4ever
1 Replies
9. Shell Programming and Scripting
Hi
This is my third past and very impressed with previous post replies
Hoping the same for below query
How to find a existing file location and directory location in solaris box (1 Reply)
Discussion started by: buzzme
1 Replies
10. 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.
ORA-27603: Cell storage I/O error, I/O failed on disk o/192.168.10.3/RECO_DM01_CD_01_drm01 at offset 13335789568 for data length 1048576
ORA-27626: Exadata error: 2201 (IO... (2 Replies)
Discussion started by: Maddy123
2 Replies
LEARN ABOUT DEBIAN
updatedb.conf
updatedb.conf(5) File Formats Manual updatedb.conf(5)
NAME
/etc/updatedb.conf - a configuration file for updatedb(8)
DESCRIPTION
/etc/updatedb.conf is a text file. Blank lines are ignored. A # character outside of a quoted string starts a comment extending until end
of line.
Other lines must be of the following form:
VARIABLE = "VALUE"
White space between tokens is ignored. VARIABLE is an alphanumeric string which does not start with a digit. VALUE can contain any char-
acter except for ". No escape mechanism is supported within VALUE and there is no way to write VALUE spanning more than one line.
Unknown VARIABLE values are considered an error. The defined variables are:
PRUNEFS
A whitespace-separated list of file system types (as used in /etc/mtab) which should not be scanned by updatedb(8). The file system
type matching is case-insensitive. By default, no file system types are skipped.
When scanning a file system is skipped, all file systems mounted in the subtree are skipped too, even if their type does not match
any entry in PRUNEFS.
PRUNENAMES
A whitespace-separated list of directory names (without paths) which should not be scanned by updatedb(8). By default, no directory
names are skipped.
Note that only directories can be specified, and no pattern mechanism (e.g. globbing) is used.
PRUNEPATHS
A whitespace-separated list of path names of directories which should not be scanned by updatedb(8). Each path name must be exactly
in the form in which the directory would be reported by locate(1).
By default, no paths are skipped.
PRUNE_BIND_MOUNTS
One of the strings 0, no, 1 or yes. If PRUNE_BIND_MOUNTS is 1 or yes, bind mounts are not scanned by updatedb(8). All file systems
mounted in the subtree of a bind mount are skipped as well, even if they are not bind mounts. As an exception, bind mounts of a
directory on itself are not skipped.
By default, bind mounts are not skipped.
NOTES
When a directory is matched by PRUNEFS, PRUNENAMES or PRUNEPATHS, updatedb(8) does not scan the contents of the directory. The path of the
directory itself is, however, entered in the created database. For example, if /tmp is in PRUNEPATHS, locate(1) will not show any files
stored in /tmp, but it can show the /tmp directory. This behavior differs from traditional locate implementations.
In some updatedb(8) implementations PRUNEPATHS can be used to exclude non-directory files. This is not the case in this implementation.
/etc/updatedb.conf is a shell script in some implementations, which allows much more flexibility in defining the variables. Equivalent
functionality can be achieved by using the command-line options to updatedb(8).
AUTHOR
Miloslav Trmac <mitr@redhat.com>
SEE ALSO
locate(1), updatedb(8)
mlocate Jun 2008 updatedb.conf(5)