RE: shared tnsnames.ora

2003-03-03 Thread Pete Sharman 
IIRC, the announcement was that Oracle Names was obsolescent in 9i,
which means it will be desupported completely in a later release.

Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
Sent: Monday, March 03, 2003 10:36 AM
To: Multiple recipients of list ORACLE-L



Nope.  namectl, names, et al binaries are still there and functional at
9.2

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


 

  [EMAIL PROTECTED]

  et   To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  Re: shared
tnsnames.ora

 

 

  03/03/2003 11:04

  AM

  Please respond to

  ORACLE-L

 

 





My understanding was that ONAMES was removed from 9i and that they
provided some sort of wrapper that goes around OID to make it look like
a names server until you can covert all your clients. Can anyone
confirm? I am not running 9i on any of my servers yet.
--
Chuck

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 03, 2003 11:54 AM


> hello to everybody
>
> we tried oracle OID. it works fine. check it out, it's worthwhile.
>
> btw.:afaik oracle names is deprecated and will be withdrawn (... ok
somewhen).
>
> pls fogive if i'm wrong about that, but i read it somewhere in the 
> docu
that comens with 9i.
>
>
> Apologies for any typing mistakes I failed to notice.
>
>
> Markus Reger
>
> Oracle Applications DBA
> Webmaster
> MBC
>
> University for Music and Performing Art
> Vienna
> >>> [EMAIL PROTECTED] 02/27/03 21:48 PM >>>
> I am looking for info on how you support a large number of PCs (200+) 
> and
keep each ones tnsnames.ora file in sync.  It seems that most people do
not touch them.  Some try to modify them and when new databases are
created, the tnsnames.ora files must be changes as well.  It seems to be
that a shared
tnsnames.ora file on a network drive may work.   I remember a thread
awhile
back about the order of resolution (home directory, then
OH/network/admin
.).   Again, I am asking about people using the Oracle client to
connect
to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers.   I have
just
started to think about this and posted here before I started my MetaLink
search.
>
>
>  TIA for any info.
>
> JF
>
> John Fedock
> "K" Line America, Inc.
> www.kline.com
> * 804.327.
> * [EMAIL PROTECTED]
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Markus Reger
>   INET: [EMAIL PROTECTED]
>
> 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: [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.net
--
Author: Chuck Hamilton
  INET: [EMAIL PROTECTED]

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: [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.net
-- 
Author: Ron Thomas
  INET: [EMAIL PROTECTED]

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

Re: shared tnsnames.ora

2003-03-03 Thread Ron Thomas 

Nope.  namectl, names, et al binaries are still there and functional at 9.2

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


   
  
  [EMAIL PROTECTED]
  
  et   To:   [EMAIL PROTECTED] 
   
  Sent by: cc: 
  
  [EMAIL PROTECTED] Subject:  Re: shared tnsnames.ora  
   
   
  
   
  
  03/03/2003 11:04 
  
  AM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




My understanding was that ONAMES was removed from 9i and that they provided
some sort of wrapper that goes around OID to make it look like a names
server until you can covert all your clients. Can anyone confirm? I am not
running 9i on any of my servers yet.
--
Chuck

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 03, 2003 11:54 AM


> hello to everybody
>
> we tried oracle OID. it works fine. check it out, it's worthwhile.
>
> btw.:afaik oracle names is deprecated and will be withdrawn (... ok
somewhen).
>
> pls fogive if i'm wrong about that, but i read it somewhere in the docu
that comens with 9i.
>
>
> Apologies for any typing mistakes I failed to notice.
>
>
> Markus Reger
>
> Oracle Applications DBA
> Webmaster
> MBC
>
> University for Music and Performing Art
> Vienna
> >>> [EMAIL PROTECTED] 02/27/03 21:48 PM >>>
> I am looking for info on how you support a large number of PCs (200+) and
keep each ones tnsnames.ora file in sync.  It seems that most people do not
touch them.  Some try to modify them and when new databases are created, the
tnsnames.ora files must be changes as well.  It seems to be that a shared
tnsnames.ora file on a network drive may work.   I remember a thread awhile
back about the order of resolution (home directory, then OH/network/admin
.).   Again, I am asking about people using the Oracle client to connect
to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers.   I have just
started to think about this and posted here before I started my MetaLink
search.
>
>
>  TIA for any info.
>
> JF
>
> John Fedock
> "K" Line America, Inc.
> www.kline.com
> * 804.327.
> * [EMAIL PROTECTED]
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Markus Reger
>   INET: [EMAIL PROTECTED]
>
> 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: [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.net
--
Author: Chuck Hamilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-

Re: shared tnsnames.ora

2003-03-03 Thread Chuck Hamilton 
My understanding was that ONAMES was removed from 9i and that they provided
some sort of wrapper that goes around OID to make it look like a names
server until you can covert all your clients. Can anyone confirm? I am not
running 9i on any of my servers yet.
--
Chuck

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, March 03, 2003 11:54 AM


> hello to everybody
>
> we tried oracle OID. it works fine. check it out, it's worthwhile.
>
> btw.:afaik oracle names is deprecated and will be withdrawn (... ok
somewhen).
>
> pls fogive if i'm wrong about that, but i read it somewhere in the docu
that comens with 9i.
>
>
> Apologies for any typing mistakes I failed to notice.
>
>
> Markus Reger
>
> Oracle Applications DBA
> Webmaster
> MBC
>
> University for Music and Performing Art
> Vienna
> >>> [EMAIL PROTECTED] 02/27/03 21:48 PM >>>
> I am looking for info on how you support a large number of PCs (200+) and
keep each ones tnsnames.ora file in sync.  It seems that most people do not
touch them.  Some try to modify them and when new databases are created, the
tnsnames.ora files must be changes as well.  It seems to be that a shared
tnsnames.ora file on a network drive may work.   I remember a thread awhile
back about the order of resolution (home directory, then OH/network/admin
).   Again, I am asking about people using the Oracle client to connect
to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers.   I have just
started to think about this and posted here before I started my MetaLink
search.
>
>
>  TIA for any info.
>
> JF
>
> John Fedock
> "K" Line America, Inc.
> www.kline.com
> * 804.327.
> * [EMAIL PROTECTED]
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Markus Reger
>   INET: [EMAIL PROTECTED]
>
> 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: [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.net
-- 
Author: Chuck Hamilton
  INET: [EMAIL PROTECTED]

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: [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: shared tnsnames.ora

2003-03-03 Thread Markus Reger 
hello to everybody

we tried oracle OID. it works fine. check it out, it's worthwhile.

btw.:afaik oracle names is deprecated and will be withdrawn (... ok somewhen).

pls fogive if i'm wrong about that, but i read it somewhere in the docu that comens 
with 9i.


Apologies for any typing mistakes I failed to notice.


Markus Reger

Oracle Applications DBA
Webmaster
MBC

University for Music and Performing Art
Vienna
>>> [EMAIL PROTECTED] 02/27/03 21:48 PM >>>
I am looking for info on how you support a large number of PCs (200+) and keep each 
ones tnsnames.ora file in sync.  It seems that most people do not touch them.  Some 
try to modify them and when new databases are created, the tnsnames.ora files must be 
changes as well.  It seems to be that a shared tnsnames.ora file on a network drive 
may work.   I remember a thread awhile back about the order of resolution (home 
directory, then OH/network/admin ).   Again, I am asking about people using the 
Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers.   
I have just started to think about this and posted here before I started my MetaLink 
search.
 
 
 TIA for any info.
 
JF

John Fedock 
"K" Line America, Inc. 
www.kline.com 
* 804.327. 
* [EMAIL PROTECTED] 


 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Markus Reger
  INET: [EMAIL PROTECTED]

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: [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: shared tnsnames.ora

2003-02-27 Thread Jesse, Rich 
With Oracle, you MUST run OID for LDAP.  There is no other supported LDAP,
and since OID doesn't generate v3-compatible LDIFs, the Oracle schemas in
OID are not easily ported to a non-supported LDAP (like SunOne).

Oracle says "Sure!  We support any v3-compliant LDAP!"  Not really.  They
support a *gateway* from other LDAPs to OID (and perhaps vice versa), but
Oracle only supports their software talking to OID.

Which is horse hockey!  First of all, ONames is stable and reliable -- even
on 8.0.5.  Second, it is relatively easy to install it fault-tolerant --
create another ONames server on a separate box that hits your region DB (OID
9.0.1 does not correctly multi-master replicate on Linux).  Third, it is
included in the cost of the DB.  OID is none of those (I believe OID is only
included with 9iAS).

Oracle Corp:  If you want us to use OID, comply with the above three points.

After a CPU fried on our ERP system today, I'm off in search of good beer!

Rich

Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Thursday, February 27, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L


John - Here is a white paper on Oracle's site. I keep seeing where Oracle is
encouraging people to switch to LDAP and that Names will eventually go away,
and that has discouraged me from going the Names route. Maybe that will
never occur and 10 years from now Names will be going strong. Of course,
when I talk to our network people they say that we are going LDAP but they
are still trying to chose which one :-)
 
http://otn.oracle.com/products/oid/htdocs/namesmigration.html
 
 


Dennis Williams 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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: [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: shared tnsnames.ora

2003-02-27 Thread Reardon, Bruce (CALBBAY) 
Regarding distributing the tnsnames - you could use a very simple Windows batch file 
to do that (eg have PC names in 1 text file) and use FOR /F to process it.  This works 
best if tnsnames lives in the same place on each client.
Or create an env variable / registry key on each client to point to a common network 
share (that had better be available all the time).

With respect to listener.ora and localhost - has anyone using OEM's Intelligent Agent 
(IA) got the IA to be able to discover databases where you use localhost in the 
listener - I haven't yet.

Regards,
Bruce Reardon
-O  riginal Message-
Sent: Friday, 28 February 2003 9:14 AM
To: Multiple recipients of list ORACLE-L

If you are not going to use Onames, another consideration is to create an DNS alias 
for your db server host and use the alias in the tnsnames file for host value.  It 
makes it easy to the move database to another server and make 1 change to DNS.

On the listener side, I always use localhost for host value.
hth,
Gene
>>> [EMAIL PROTECTED] 02/27/03 03:49PM >>>
Below is the end of my own tnsnames.ora located on my PC.  There is a common
network tnsnames.ora on a network share located on my 'R' drive.  The
network version has all the permanent databases defined in it.  I can add
any temporary or new test servers to my copy of tnsnames.ora and still get
to all the permanent entries when ever I need to.  Works great!

R. Smith

test.world =
  (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
  (PROTOCOL = TCP)
  (Host = someserver)
  (Port = 1521)
)
)
(CONNECT_DATA = (SID=test)
)
  )
ifile=r:\tnsnames.ora

-Original Message-
Sent: Thursday, February 27, 2003 2:24 PM

Use Oracle Names.  Easy to setup/maintain.  never touch a client config
again.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan

-

I am looking for info on how you support a large number of PCs (200+) and
keep each ones tnsnames.ora file in sync.  It seems that most people do not
touch them.  Some try to modify them and when new databases are created, the
tnsnames.ora files must be changes as well.  It seems to be
that a shared tnsnames.ora file on a network drive may work.   I remember a
thread awhile back about
the order of resolution (home directory, then OH/network/admin .).
Again, I am asking about
people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x)
on 10+ different
servers.   I have just started to think about this and posted here before I
started my MetaLink
search.
TIA for any info.
JF
John Fedock
"K" Line America, Inc.
www.kline.com
( 804.327.
* [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

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: [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: shared tnsnames.ora

2003-02-27 Thread Odland, Brad 
The problem is if that shared tnsnames.ora then becomes a massive single
point of failure.

If for some reason someone messes up this file or it becomes unavailable.
All your users would be left out of the databases.

I REALLY think Oracle Names is the way to go. (I have used it in 1000+ user
environments with very little problems) When you use two names servers you
really have a solid reliable set up that makes adding and removing dbs a
snap. (those huge tnsnames.ora files drive me nuts)

Set up two servers and lose the tnsnames.ora file. you only need the
SQLNET.ora file with preferred oracle names entries.

What can be done too is to use DNS aliases to direct users to servers
aliased as ONAMES1 and ONAMES2. That way if you swap out boxes in the future
you no longer have to mess editing a sqlnet.ora file. Just change the DNS
alias name to point at the new names server...

Security wise it makes big sence too as the SID, host and port are hidden
from the user community. 

Unless you WANT to make busy work for yourself maintaining tnsnames
files(yuk)

BRad


-Original Message-
Sent: Thursday, February 27, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L


Below is the end of my own tnsnames.ora located on my PC.  There is a common
network tnsnames.ora on a network share located on my 'R' drive.  The
network version has all the permanent databases defined in it.  I can add
any temporary or new test servers to my copy of tnsnames.ora and still get
to all the permanent entries when ever I need to.  Works great!

R. Smith

test.world =
  (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
  (PROTOCOL = TCP)
  (Host = someserver)
  (Port = 1521)
)
)
(CONNECT_DATA = (SID=test)
)
  )
ifile=r:\tnsnames.ora

-Original Message-
Sent: Thursday, February 27, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L



Use Oracle Names.  Easy to setup/maintain.  never touch a client config
again.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


 

  [EMAIL PROTECTED]

  ine.com  To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  shared tnsnames.ora

 

 

  02/27/2003 12:56

  PM

  Please respond to

  ORACLE-L

 

 





I am looking for info on how you support a large number of PCs (200+) and
keep each ones tnsnames.ora file in sync.  It seems that most people do not
touch them.  Some try to modify them and when new databases are created, the
tnsnames.ora files must be changes as well.  It seems to be
that a shared tnsnames.ora file on a network drive may work.   I remember a
thread awhile back about
the order of resolution (home directory, then OH/network/admin .).
Again, I am asking about
people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x)
on 10+ different
servers.   I have just started to think about this and posted here before I
started my MetaLink
search.


 TIA for any info.

JF


John Fedock
"K" Line America, Inc.
www.kline.com
( 804.327.
* [EMAIL PROTECTED]







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Thomas
  INET: [EMAIL PROTECTED]

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: [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).
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

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: [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.net
-- 
Author: Odland, Brad
  INET: [EMAIL PROTECTED]

Fat City Networ

RE: shared tnsnames.ora

2003-02-27 Thread Gene Sais 



If you are not going to use Onames, another consideration is to create an 
DNS alias for your db server host and use the alias in the tnsnames file for 
host value.  It makes it easy to the move database to another server and 
make 1 change to DNS.
 
On the listener side, I always use localhost for host value.hth,
Gene>>> [EMAIL PROTECTED] 02/27/03 03:49PM >>>Below 
is the end of my own tnsnames.ora located on my PC.  There is a 
commonnetwork tnsnames.ora on a network share located on my 'R' drive.  
Thenetwork version has all the permanent databases defined in it.  I 
can addany temporary or new test servers to my copy of tnsnames.ora and 
still getto all the permanent entries when ever I need to.  Works 
great!R. Smithtest.world =  (DESCRIPTION 
=    (ADDRESS_LIST 
=    (ADDRESS 
=  (PROTOCOL = 
TCP)  (Host = 
someserver)  (Port = 
1521)    )    
)    (CONNECT_DATA = (SID=test)    
)  )ifile=r:\tnsnames.ora-Original 
Message-Sent: Thursday, February 27, 2003 2:24 PMTo: Multiple 
recipients of list ORACLE-LUse Oracle Names.  Easy to 
setup/maintain.  never touch a client configagain.Ron 
ThomasHypercom, Inc[EMAIL PROTECTED]Each new user of a new system 
uncovers a new class of bugs. -- 
Kernighan  
[EMAIL PROTECTED]  
ine.com  
To:[EMAIL PROTECTED]  
Sent 
by: 
cc:  
[EMAIL PROTECTED] Subject:  
shared 
tnsnames.ora  
02/27/2003 
12:56  
PM  
Please respond 
to  
ORACLE-LI am looking for info on how you 
support a large number of PCs (200+) andkeep each ones tnsnames.ora file in 
sync.  It seems that most people do nottouch them.  Some try to 
modify them and when new databases are created, thetnsnames.ora files must 
be changes as well.  It seems to bethat a shared tnsnames.ora file on a 
network drive may work.   I remember athread awhile back 
aboutthe order of resolution (home directory, then OH/network/admin 
.).Again, I am asking aboutpeople using the Oracle client to connect 
to 15+ databases (v7.3.4 - 9.0.x)on 10+ differentservers.   I 
have just started to think about this and posted here before Istarted my 
MetaLinksearch.TIA for any info.JFJohn 
Fedock"K" Line America, Inc.www.kline.com( 804.327.* 
[EMAIL PROTECTED]-- Please see the 
official ORACLE-L FAQ: http://www.orafaq.net-- Author: Ron 
Thomas  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
California    -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in themessage 
BODY, include a line containing: UNSUB ORACLE-L (or the name ofmailing list 
you want to be removed from).  You may also send the HELPcommand for 
other information (like subscribing).If you are not the intended recipient 
of this e-mail message, any use,distribution or copying of the message is 
prohibited.  Please let me knowimmediately by return e-mail if you have 
received this message by mistake,then delete the e-mail message. Thank 
you.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Smith, 
Ron L.  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- 858-538-5051 http://www.fatcity.comSan Diego, 
California    -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: shared tnsnames.ora

2003-02-27 Thread DENNIS WILLIAMS 
John - Here is a white paper on Oracle's site. I keep seeing where Oracle is
encouraging people to switch to LDAP and that Names will eventually go away,
and that has discouraged me from going the Names route. Maybe that will
never occur and 10 years from now Names will be going strong. Of course,
when I talk to our network people they say that we are going LDAP but they
are still trying to chose which one :-)
 
http://otn.oracle.com/products/oid/htdocs/namesmigration.html
 
 


Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, February 27, 2003 3:14 PM
To: '[EMAIL PROTECTED]'


John 
In the past the answer was to set up Oracle Names. I think Oracle said
they will be phasing that out in favor of LDAP systems. I believe if you are
starting today the best idea would be to consider Oracle Internet Directory,
or more generically an LDAP system of some type.



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, February 27, 2003 1:56 PM
To: Multiple recipients of list ORACLE-L


I am looking for info on how you support a large number of PCs (200+) and
keep each ones tnsnames.ora file in sync.  It seems that most people do not
touch them.  Some try to modify them and when new databases are created, the
tnsnames.ora files must be changes as well.  It seems to be that a shared
tnsnames.ora file on a network drive may work.   I remember a thread awhile
back about the order of resolution (home directory, then OH/network/admin
).   Again, I am asking about people using the Oracle client to connect
to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers.   I have just
started to think about this and posted here before I started my MetaLink
search.
 
 
 TIA for any info.
 
JF

John Fedock 
"K" Line America, Inc. 
www.kline.com 
* 804.327. 
* [EMAIL PROTECTED] 


 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [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: shared tnsnames.ora

2003-02-27 Thread DENNIS WILLIAMS 
John 
In the past the answer was to set up Oracle Names. I think Oracle said
they will be phasing that out in favor of LDAP systems. I believe if you are
starting today the best idea would be to consider Oracle Internet Directory,
or more generically an LDAP system of some type.



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, February 27, 2003 1:56 PM
To: Multiple recipients of list ORACLE-L


I am looking for info on how you support a large number of PCs (200+) and
keep each ones tnsnames.ora file in sync.  It seems that most people do not
touch them.  Some try to modify them and when new databases are created, the
tnsnames.ora files must be changes as well.  It seems to be that a shared
tnsnames.ora file on a network drive may work.   I remember a thread awhile
back about the order of resolution (home directory, then OH/network/admin
).   Again, I am asking about people using the Oracle client to connect
to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers.   I have just
started to think about this and posted here before I started my MetaLink
search.
 
 
 TIA for any info.
 
JF

John Fedock 
"K" Line America, Inc. 
www.kline.com 
* 804.327. 
* [EMAIL PROTECTED] 


 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [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: shared tnsnames.ora

2003-02-27 Thread Jesse, Rich 
Easy to maintain??  The "maintenance" of an alias is to DELETE it, then
add it again.  Oracle officially does not support maintenance of alias
information in ONames.  This really bites, especially when your network
domain changes.

The solution is to modify the repository directly.  If you're using a region
DB, you can modify the repository directly.  Of course, this isn't
supported, either...

It IS easy to add/delete aliases, but not to change them.

Rich

Rich JesseSystem/Database Administrator
[EMAIL PROTECTED]   Quad/Tech International, Sussex, WI USA


-Original Message-
Sent: Thursday, February 27, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L



Use Oracle Names.  Easy to setup/maintain.  never touch a client config
again.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


 

  [EMAIL PROTECTED]

  ine.com  To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  shared tnsnames.ora

 

 

  02/27/2003 12:56

  PM

  Please respond to

  ORACLE-L

 

 





I am looking for info on how you support a large number of PCs (200+) and
keep each ones
tnsnames.ora file in sync.  It seems that most people do not touch them.
Some try to modify them
and when new databases are created, the tnsnames.ora files must be changes
as well.  It seems to be
that a shared tnsnames.ora file on a network drive may work.   I remember a
thread awhile back about
the order of resolution (home directory, then OH/network/admin .).
Again, I am asking about
people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x)
on 10+ different
servers.   I have just started to think about this and posted here before I
started my MetaLink
search.


 TIA for any info.

JF


John Fedock
"K" Line America, Inc.
www.kline.com
( 804.327.
* [EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

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: [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: shared tnsnames.ora

2003-02-27 Thread Smith, Ron L. 
Below is the end of my own tnsnames.ora located on my PC.  There is a common
network tnsnames.ora on a network share located on my 'R' drive.  The
network version has all the permanent databases defined in it.  I can add
any temporary or new test servers to my copy of tnsnames.ora and still get
to all the permanent entries when ever I need to.  Works great!

R. Smith

test.world =
  (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
  (PROTOCOL = TCP)
  (Host = someserver)
  (Port = 1521)
)
)
(CONNECT_DATA = (SID=test)
)
  )
ifile=r:\tnsnames.ora

-Original Message-
Sent: Thursday, February 27, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L



Use Oracle Names.  Easy to setup/maintain.  never touch a client config
again.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


 

  [EMAIL PROTECTED]

  ine.com  To:
[EMAIL PROTECTED]

  Sent by: cc:

  [EMAIL PROTECTED] Subject:  shared tnsnames.ora

 

 

  02/27/2003 12:56

  PM

  Please respond to

  ORACLE-L

 

 





I am looking for info on how you support a large number of PCs (200+) and
keep each ones tnsnames.ora file in sync.  It seems that most people do not
touch them.  Some try to modify them and when new databases are created, the
tnsnames.ora files must be changes as well.  It seems to be
that a shared tnsnames.ora file on a network drive may work.   I remember a
thread awhile back about
the order of resolution (home directory, then OH/network/admin .).
Again, I am asking about
people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x)
on 10+ different
servers.   I have just started to think about this and posted here before I
started my MetaLink
search.


 TIA for any info.

JF


John Fedock
"K" Line America, Inc.
www.kline.com
( 804.327.
* [EMAIL PROTECTED]







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Thomas
  INET: [EMAIL PROTECTED]

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: [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).
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

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: [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: shared tnsnames.ora

2003-02-27 Thread Stephen Lee 

-Original Message-
> I am looking for info on how you support a large
> number of PCs (200+) and keep each ones tnsnames.ora
> file in sync.
---

One way is to use Oracle names servers.  For some reason, I have never liked
this.  No particular reason.

Another way is to use push software, like Tivoli, to push a tnsnames.ora out
to client PC's.

If you have fewer PC's to fiddle with -- for example, a department -- and if
you have NT admins with enough knowledge to set it up, you can e-mail a link
to the users for them to click on to update their tnsnames.ora

I've seen all of these methods used.  The one I thought worked the best was
the push method.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

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: [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: shared tnsnames.ora

2003-02-27 Thread John Kanagaraj 
John,
 
Your answer is. Oracle Name Server. There were some details on the list
a few weeks back. ML has a number of notes.
 

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

What would you see if you were allowed to look back at your life at the end
of your journey in this earth?

** The opinions and statements above are entirely my own and not those of my
employer or clients **


-Original Message-
Sent: Thursday, February 27, 2003 11:56 AM
To: Multiple recipients of list ORACLE-L


I am looking for info on how you support a large number of PCs (200+) and
keep each ones tnsnames.ora file in sync.  It seems that most people do not
touch them.  Some try to modify them and when new databases are created, the
tnsnames.ora files must be changes as well.  It seems to be that a shared
tnsnames.ora file on a network drive may work.   I remember a thread awhile
back about the order of resolution (home directory, then OH/network/admin
).   Again, I am asking about people using the Oracle client to connect
to 15+ databases (v7.3.4 - 9.0.x) on 10+ different servers.   I have just
started to think about this and posted here before I started my MetaLink
search.
 
 
 TIA for any info.
 
JF

John Fedock 
"K" Line America, Inc. 
www.kline.com 
* 804.327. 
* [EMAIL PROTECTED] 


 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

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: [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: shared tnsnames.ora

2003-02-27 Thread Ron Thomas 

Use Oracle Names.  Easy to setup/maintain.  never touch a client config again.

Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan


   
  
  [EMAIL PROTECTED]
  
  ine.com  To:   [EMAIL PROTECTED] 
   
  Sent by: cc: 
  
  [EMAIL PROTECTED] Subject:  shared tnsnames.ora  
   
   
  
   
  
  02/27/2003 12:56 
  
  PM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  




I am looking for info on how you support a large number of PCs (200+) and keep each 
ones
tnsnames.ora file in sync.  It seems that most people do not touch them.  Some try to 
modify them
and when new databases are created, the tnsnames.ora files must be changes as well.  
It seems to be
that a shared tnsnames.ora file on a network drive may work.   I remember a thread 
awhile back about
the order of resolution (home directory, then OH/network/admin .).   Again, I am 
asking about
people using the Oracle client to connect to 15+ databases (v7.3.4 - 9.0.x) on 10+ 
different
servers.   I have just started to think about this and posted here before I started my 
MetaLink
search.


 TIA for any info.

JF


John Fedock
"K" Line America, Inc.
www.kline.com
( 804.327.
* [EMAIL PROTECTED]







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Thomas
  INET: [EMAIL PROTECTED]

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