Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Dictionary location or initSID.ora and PWDsid.ora

Re: Dictionary location or initSID.ora and PWDsid.ora

From: Jared Still <jkstill_at_cybcon.com>
Date: Fri, 24 Jan 2003 07:34:33 -0800
Message-ID: <F001.00539AE1.20030124073433@fatcity.com>

D'oh! I forgot about those.

Getting them out of the registry is another problem.

Do you know Perl? Use Win32::TieRegistry.

Jared

On Thursday 23 January 2003 21:43, Naveen Nahata wrote:
> There are avaialable in the registry with String values
>
> 'ORA_SID_PFILE' and 'ORA_SID_PWFILE'
>
> From this you can find out the directory of the Password file
>
> Regards
> Naveen
>
>
> -----Original Message-----
> Sent: Friday, January 24, 2003 3:35 AM
> To: Multiple recipients of list ORACLE-L
>
>
> These aren't available dynamically, and are not available
> from the registry, at least I can't find them there.
>
> No need to hard code: just setup a conguration file for your
> script to use, that includes these locations.
>
> Jared
>
>
>
>
>
>
> "Bob Metelsky" <bmetelsky_at_cps92.com>
> Sent by: root_at_fatcity.com
> 01/23/2003 12:14 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
> Subject: Dictionary location or initSID.ora and PWDsid.ora
>
>
> Can I dynamicall find the location of initSID.ora
> Eg C:\admin\INSTANCE\PFILE\initSID.ora
> and the password dir
> E.g C:\Oracle\Ora81\DATABASE\*.ora
>
> Im setting up a cold backup script and would like to include these 2 dir
>
> Im poking around in the v$ tables but cant seem to find it
> Id like to avoid hardcoding the values
>
> Thanks!!
> bob

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).
Received on Fri Jan 24 2003 - 09:34:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US