David Turner wrote:
>
> Is there any way to tell what connect string an application is using to connect
> to the database? I want to rename a host but I know some developers are going to
> forget to change their connect strings and I would like to catch them before we
> rename the box.
>
> My plan is to:
>
> o create a new cname for the host
>
> o create a new tnsalias based on the cname
>
> o Have developers reconnect using the new tnsalias
>
> o Monitor for any connections that still use the old connect string, and
> tell developers they still need to change their connect string.
>
> o Monitor again
>
> o Rename box
>
> o Have all applications connecting using the new name.
>
> Dave
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Turner
> INET: turner_at_tellme.com
If you do not change the alias, but keep the same alias pointing to the
new host name, you do not have to worry ...
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: sfaroult_at_oriole.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Nov 14 2002 - 14:23:24 CST
