Re: default database over TCP/IP?

hello,

[Quoted] what ist the kind of teh TWO_TASK Variabel ????

Thomas

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag news:ufjsq69mfha0fb_at_corp.supernews.com...
>
> "Aaron Birenboim" <aaron_at_boim.com> wrote in message
> news:3CF8C86E.7B8F0C43_at_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_at_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 _at_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_at_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
>
>
>
Received on Thu Jun 06 2002 - 14:41:51 CEST