Re: default database over TCP/IP?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 1 Jun 2002 20:40:01 +0200
Message-ID: <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 Sat Jun 01 2002 - 20:40:01 CEST

Original text of this message