RE: TNS_ADMIN variable location :Unix/Nt

On NT you set this in the registry at:
\\HKEY_LOCAL_MACHINE\Software\Oracle

Add a string named TNS_ADMIN and set the value to where you want your SQLNET.ORA and TNSNAMES.ORA located.
Rodd

-----Original Message-----
From: Ravindra Basavaraja [mailto:ravindra_at_sentica.com] Sent: Thursday, December 21, 2000 03:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: TNS_ADMIN variable location :Unix/Nt

that is a environment parameter to be set. on unix set that to point to the directory where the network files = are.set
this in the oracle .profile file.

$echo $TNS_ADMIN
should point to the right directory

ravindra

-----Original Message-----
Sent: Monday, December 18, 2000 5:56 PM
To: Multiple recipients of list ORACLE-L

On Mon, 18 Dec 2000, arif wrote:

> Hi ALL,
>
> Can anyone let me know as to where the TNS_ADMIN variable is located.
>
> Many Thanks and Regards,
> Arif Khan

It is normally set to $ORACLE_HOME/network/admin, or on Windoze %ORACLE_HOME%\net80\admin

>
> Schoen Volker wrote:
>
> > Hi list,
> >
> > I have a costumer, which has a system tablespaces with 1.2 GB. =
Default
> > storage parameter fpr initial and next extent are 102400 KB. My
question,
> > how can I minimize and reorganize system tablespace, Full DB =
export? Or
is
> > there another easier method?
> >
> > TIA
> >
> > Volker Sch=F6n
> > E-Mail: mailto:v.schoen_at_inplan.de
> > http://www.inplan.de
> >
> > --------
> > Think you know someone who can answer the above question? Forward =
it to
them!
> > to unsubscribe, send a blank email to =
oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) jkstill_at_teleport.com
jared_still_at_enron.net

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: jared still
  INET: jkstill_at_teleport.com

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: 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).

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
Author: Ravindra Basavaraja
  INET: ravindra_at_sentica.com

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: 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