By default it is in $ORACLE_HOME/database in Oracle 8.0
Alex Hillman
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 7:16 PM
To: Multiple recipients of list ORACLE-L
Try looking in the registry.
Since you're using oradim80 I take it you're using 8.0.x which
Try looking in the registry.
Since you're using oradim80 I take it you're using 8.0.x which I can't give
the exact answer for.
But, for 816 look at HKLM\software\orace\all_homes to find the home id
number for your home - say it is 5.
Then look at HKLM\software\orace\home5 and you will find a ke
Thanks. I know those are the defaults, but when you create the Oracle
service on NT using oradim80, you can flag a specific pfile. This
information is obviously stored in the service as it is used each time the
service starts. Is there a way to find if the stored value is different from
the defaul
Henry,
If your database is up and running all ready you can do the following
query to find the pfile.
select name, value
from v$parameter
where name like 'ifile';
Rodd
>> Original Message <<
On 5/3/01, 1:20:59 PM, Henry Poras <[EMAIL PROTECTED]> wrote regarding
Actually that seems to be a file that points to the file in the pfile
directory, the password file is also located here. If you want to know what
pfile is associated with what db you can just open it up, not to mention
that it will be uder the directory with the same name as the DB.
Kev
-Ori
8.1.7 should be in the \oracle\ora81\database directory
8.0.X should be in the \orant\database directory
HTH,
Frank Pettinato
Oracle DBA
-Original Message-
Sent: Thursday, May 03, 2001 11:21 AM
To: Multiple recipients of list ORACLE-L
I've got an easy one. I'm getting back to NT and I a
The init.ora file is in
oracle/admin/sid/pfile/init.ora
--- Henry Poras <[EMAIL PROTECTED]> wrote:
> I've got an easy one. I'm getting back to NT and I
> am trying to find what
> parameter file was used when creating the Oracle
> service with oradim. I know
> I can edit the setting to any init.or
