Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Addition Oracle instance on separate server?

Re: Addition Oracle instance on separate server?

From: FlyingVee <b-horton_at_worldnet.att.net>
Date: 1998/03/12
Message-ID: <6ea87b$3b1@bgtnsc02.worldnet.att.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US