Re: Where are the files

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Tue, 29 Sep 1998 19:18:48 -0700
Message-ID: <6us45a$qth@sjx-ixn4.ix.netcom.com>

Most of the time, (not necessary), you can find the initSID.ora file in $ORACLE_HOME/dbs, or if you are using OFA, it will be in $ORACLE_BASE/admin/<SID>/pfile (a symbolic link of the ?/dbs file). The SQL*NET file will be in $ORACLE_HOME/network/admin, or in /etc or under

$TNS_ADMIN. For other file like alertSID.log file, they will be in the
user_dump_dest. Query the v$parameter file to find out the directory of your
user_dump_dest.

Winnie

Mark G. Woodruff wrote in message <6urmig$7kl$1_at_comet3.magicnet.net>...
>
>Rob Forster wrote in message ...
>>select * from v$datafiles (or dba_data_files view) - for the names of the
>>datafiles
>>v$controlfile - for the location(s) of the control files
>>v$log - for the names of the redo logs
>
>
>Thanks.
>
>Any suggestions for the SQL*Net files (e.g. tnsnames.ora) and init.ora
file?
>
>
Received on Tue Sep 29 1998 - 21:18:48 CDT