On May 29, 12:45 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> cptkirkh wrote:
> > Ok with that in mind I have one more question. If theserverI am
> > using to do a testrestorehas adatabasewith the samenameand if
> > there is an application on thatserverthat connects to the production
> > DB will the application be able to connect to the production DB after
> > I create a DB by the samename?
>
> Naming has little to do with it (or everything...).
> As the application connects to the production db, which is
> on another machine (names....), the application will still
> connect to the originaldatabaseinstance, not the clone.
>
> Depends somewhat on how the application connects:
> - - using jdbc, the connection would be of the form
> machine_name:listener_port:service_name.
> - - using Oracle Net, the connection would either be using
> the same form, or a TNS alias.
>
> In the first case, the machinenamediffers, so the application
> will connect to the originaldatabaseinstance.
> In the seconds case, you either have the first case, or your
> TNS alias would point to the original machine, causing the
> application to connect to the originaldatabaseinstance.
>
> In short: it will connect to the original one, unless you
> change the way the application connects. You may consider
> defining duplicate connections - SQL*Net does try all defined
> connections sequentially, until the connection succeeds (or
> fails completely, of course)
> - --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (MingW32)
>
> iD8DBQFGXGayLw8L4IAs830RAp1lAKCX9stXOAKEhi0QzDQUEZ0g+8GJuQCeKCXe
> C0LSujKkioBUrMuWjqEiHJc=
> =J0CK
> -----END PGP SIGNATURE-----
Thnaks Frank... after talkign to one of the developers I think I am
going to move the app and then do the restore.
Received on Tue May 29 2007 - 13:18:02 CDT
