Personal Oracle and Oracle Client on same box - UPDATE

Personal Oracle and Oracle Client on same box - UPDATE

Post by Norman Dunba » Tue, 30 Oct 2001 20:37:17

Morning all,

I recently posted a query asking if anyone had managed to get PO plus
client working on the same box. (No replies :o))
I then posted an answer from a TAR I raised with support - they say it
doesn't work without much farkling with registery
dumps/restores/changing paths and rebooting the box.

I have just installed PO817 on two laptops and my own PC just to check.
It appears that PO817 has client built in and the following changes are
all that are required to make it all work :

I installed on a clean machine.
I accepted the defaults for the install type, and also a typical
I set the local instance name to ORCL (just to be standard !)

When done, edit the SQLNET.ORA file and change the authentication to
Add a line with NAMES.DEFAULT_DOMAIN = world (in your case it may be
different - adjust as required)

Edit the installed TNSNAMES.ORA file and change ORCL to ORCL.WORLD (or
as poer your default domain defined above) and then merge in all the
other databse details as appropriate.

It all just works !

Hope this proves useful to someone out there !


PS. Don't forget to shut down the Apache http server that the
installation starts up - if you don't need it !


Database/Unix administrator     Phone:  0113 289 6265
                                Fax:    0113 289 3146
Lynx Financial Systems Ltd.     URL:


1. Oracle 8 client and Oracle 8i Personal Edition

I have Oracle client software  installed on my pc at work and use it to
contact a server back east on our LAN. Can I also install Oracle 8I Personal
Edition and Oracle Developer on my system so I can do Homework for a 'Forms
& Reports' class without disturbing the client software already installed?
If so, could you point me to the area which would show me how to do this

Thanks in advance,

2. !RUN & DOS errorlevel?

3. Personal Oracle and Oracle client on same machine--URGENT

4. Error occured during transferring tables

5. Personal oracle 7.3 to Personal oracle 7.3 ( SQL*NET)

6. Accessing DAO Like the Data Control Does

7. ??? ORACLE client & personal

8. vba x webservice x sql toolkit -> problem

9. install Oracle client AND personal on same PC

10. Connecting 16 bit client to Oracle Personal Edition 8.0.4

11. Can I use personal oracle as client in 8i version

12. Personal Oracle and clients - W95

13. Updating long column in Personal Oracle