Re: Oracle and a Y2K problem

From: Philip Chee <philip_at_aleytys.pc.my>
Date: Sat, 13 Feb 99 09:22:19 GMT
Message-ID: <918897739.4426snx@aleytys.pc.my>

In article <MPG.112ad89269315554989682_at_news.mtx.net.au> grants_at_dove.net.au writes:
>In article <36B92444.51237CA9_at_erols.com>, openmind_at_erols.com says...

>> Also, is there any way I can install Oracle client on a network, and have the
>> users access it this way rather than have it installed on each computer.

>I believe that this can be done (something to do with the Oracle Home
>setting in the registry?) but last I heard you still needed the registry
>on each PC and I think SQL*Net Client. You can have the TNS_ADMIN files
>on the server though, by specifying a TNS_ADMIN string in the registry
>which points to a server file, which helps a bit. Oracle Tech SUpport
>should surely be able to help you with this, I know it is in an
>Oracle manual somewhere.

Actually this is detailed in one of the readme files that was installed together with the client. Short summary:

1. Install to PC.
2. Copy Move C:\ORAWIN95 to server.
3. Export the ORACLE branch of the registry to a text file.
4. Do a search and replace on the text file to point to <SERVER_PATH>\ORAWIN95
5. Import text file back into the registry.

(Note backup your registry at every step if you value your sanity)

6. An easier way of doing steps 3,4,5 is to use the Ziff-Davis utility

   COA32.EXE available from their website.

Philip

Philip

---=====================================================================---

 Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA   e-mail: philip_at_aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932    Guard us from the she-wolf and the wolf, and guard us from the thief,

                  oh Night, and so be good for us to pass.

---
 þ 10125.11 þ Put on your seatbelt. I wanna try something ...! Received on Sat Feb 13 1999 - 03:22:19 CST