Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!64.245.249.27.MISMATCH!jfk3-feed1.news.algx.net!dca6-feed2.news.algx.net!allegiance!newsfeed1.cidera.com!Cidera!telocity-west!TELOCITY!sn-xit-03!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Ron Reidy <rereidy@indra.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: default database over TCP/IP?
Date: Thu, 06 Jun 2002 08:29:16 -0600
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <3CFF71BC.73BAFBFB@indra.com>
X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2 i686)
X-Accept-Language: en
MIME-Version: 1.0
References: <3CF8C86E.7B8F0C43@boim.com> <ufjsq69mfha0fb@corp.supernews.com> <adnl4m$1e0$02$1@news.t-online.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: newsabuse@supernews.com
Lines: 98
Xref: easynews comp.databases.oracle.tools:51678
X-Received-Date: Thu, 06 Jun 2002 07:32:40 MST (news.easynews.com)

From the Oracle docs
(http://technet.oracle.com/doc/solaris/server.815/a67456/ch1.htm#24618)


TWO_TASK 
  Function 
    Sets the default Net8 connect string descriptor alias defined in the
    tnsnames.ora file.  
  Syntax 
    Available network alias. 
  Range of Values 
    Any valid Net8 alias defined in the tnsnames.ora file. 
  Example 
    PRODDB_TCP 

Thomas Forstmeier wrote:
> 
> hello,
> 
> what ist the kind of teh TWO_TASK Variabel ????
> 
> Thomas
> 
> "Sybrand Bakker" <postbus@sybrandb.demon.nl> schrieb im Newsbeitrag
> news:ufjsq69mfha0fb@corp.supernews.com...
> >
> > "Aaron Birenboim" <aaron@boim.com> wrote in message
> > news:3CF8C86E.7B8F0C43@boim.com...
> > > Can I make the default oracle database (SID) be over
> > > a local TCP/IP network from the client?
> > > Oracle support said no.... but I kind of doubt this.
> > > I think they just wanted to close the call.
> > >
> > > We had (most) of our clients on the same machine as the server
> > > (Oracle 7.something).  They just installed a new 9i server
> > > on a new machine.  I'd like to get the clients (still on the
> > > old server machine) connecting to the new database as the
> > > first step in our migration to new hardware.
> > >
> > > I have ORACLE_SID=hdb  # this is our database name (SID)
> > > The old server is shut down.
> > > The tnsnames.ora file is altered on the old machine to point
> > >      to the new machine for hdb.
> > > The new server is up and listening.
> > >
> > > I CAN connect with:
> > >
> > >      sqlplus user/password@hdb
> > >
> > > I get errors with
> > >
> > >      sqlplus user/password
> > >
> > > I get the same error as above with our PRO*C clients
> > > which DO connect with the 'AT hdb' clause.
> > >
> > > Is there not a way to set the default database to be
> > > across a TCP/IP network?  How is using an 'AT' clause
> > > in pro*c different from saying @hdb with sqlplus?
> > >
> > > Is there a magic word or phrase I can utter to get my
> > > oracle support request transfered to a real guru whose
> > > answers I can trust?
> > >
> > > This is a case of Laziness and Impatience (as noted below).
> > > It will save a lot of work to NOT have to re-build, re-test,
> > > and re-install all the clients on the old machines.
> > > I'd rather focus on porting the clients to the new machines.
> > > --
> > > Aaron Birenboim | The top three attributes of a good programmer:
> > > Albuquerque, NM |    Laziness, Impatience, and Hubris
> > > aaron@boim.com  |
> > > boim.com/~aaron |     -- Randall Schwartz, author of perl references
> >
> >
> > export TWO_TASK=<default servicename> on Unixes
> >
> > hklm\software\oracle\local=<default servicename> on Windoze.
> >
> > In both cases afterwards sqlplus <un/pw>
> > should work without problem.
> >
> >
> >
> > Hth
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> > to reply remove '-verwijderdit' from my e-mail address
> >
> >
> >

-- 
Ron Reidy
Oracle DBA