RE: where's the NT pfile?
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 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 key named like ora_sid_pfile and it will tell you the pfile used when the service was created. >From memory, 8.0.x might use a batch / command file located in the database directory and that might specify the pfile. Regards, Bruce -Original Message- Sent: Friday, 4 May 2001 6:06 To: Multiple recipients of list ORACLE-L 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 default? Or is this totally inaccessable?? Henry -Original Message- Sent: Thursday, May 03, 2001 2:51 PM To: Multiple recipients of list ORACLE-L 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 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.ora I want, but isn't there some way to see which one is currently used? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: where's the NT pfile?
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 key named like ora_sid_pfile and it will tell you the pfile used when the service was created. >From memory, 8.0.x might use a batch / command file located in the database directory and that might specify the pfile. Regards, Bruce -Original Message- Sent: Friday, 4 May 2001 6:06 To: Multiple recipients of list ORACLE-L 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 default? Or is this totally inaccessable?? Henry -Original Message- Sent: Thursday, May 03, 2001 2:51 PM To: Multiple recipients of list ORACLE-L 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 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.ora I want, but isn't there some way to see which one is currently used? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: where's the NT pfile?
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 default? Or is this totally inaccessable?? Henry -Original Message- Sent: Thursday, May 03, 2001 2:51 PM To: Multiple recipients of list ORACLE-L 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 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.ora I want, but isn't there some way to see which one is currently used? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Frank N. Pettinato INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: where's the NT pfile?
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 where's the NT pfile?: > 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.ora I want, but isn't there some way to > see which one is currently used? > Henry > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Henry Poras > INET: [EMAIL PROTECTED] > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: where's the NT pfile?
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 -Original Message- Pettinato Sent: Thursday, May 03, 2001 2:51 PM To: Multiple recipients of list ORACLE-L 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 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.ora I want, but isn't there some way to see which one is currently used? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Frank N. Pettinato INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: where's the NT pfile?
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 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.ora I want, but isn't there some way to see which one is currently used? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Frank N. Pettinato INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: where's the NT pfile?
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.ora I want, but > isn't there some way to > see which one is currently used? > > Henry > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Henry Poras > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brijesh Lal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
