Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Addition Oracle instance on separate server?
ORACLE DBA wrote:
>
> If you want easy and fast you can just copy the distribution over the
> network from one box to the other. Use a full export to recreate the
> prod database in a test environment. Maybe tweak a few TNS files.
> You are done.
>
>
> Jeff Garzik wrote:
>
> Interested in setting up an Oracle development system
> separate from our
> current production system, running Oracle 7.3.3 on
> Solaris/SPARC.
>
> We have the licenses already, is there an easy way to
> install Oracle
> client libraries (for Pro*C and Perl+Oracle user) and
> Developer/2000
> (for forms design) on a physically separate Sparc server?
>
> Ideally I would like to set up an instance of the same
> database, so that
> developers will not take up much CPU on the production
> server. I'm more
> hopeful there is a solution that will allow me to install
> the client
> libraries on the dev server and connect via TCP/IP to the
> production
> Oracle database.
>
> Any hints, pointers, and suggestions would be appreciated.
>
> Thanks,
> --
> Jeff Garzik Typhoon, Cyclone,
> Diablo, and INN
> http://www.spinne.com/usenet/ News tuning and
> consulting
>
>
>
> --
>
> Please respond to oradba_at_erols.com
>
>
Could you use snapshot to create a test dbase? I have a 60gig production
db. and my test db is a 'trimmed down' version.
Received on Thu Mar 12 1998 - 00:00:00 CST