RE: Impact caused because Domain Change?

Don't forget there is a difference in Database domain name an the server domain name. Our SA changed the domain for all the new servers (not the old ones) so we have 2 domain on the UNIX servers. But I kept running the databases in the original domain (Database domain). If the Unix server domain changes you just need to change the connect strings provide by TNSNAMES, ONAMES etc...

Regards,
Frank

-----Oorspronkelijk bericht-----
Van: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] Namens Paul Drake Verzonden: donderdag 11 november 2004 21:16 Aan: gabriel.aragon_at_ge.com
CC: oracle-l_at_freelists.org
Onderwerp: Re: Impact caused because Domain Change?

init.ora
v$parameter.name=3D'db_domain'

sqlnet.ora
names.default_domain=3D<mydomain.com>

tnsnames.ora
may need to replace domain_name in tns alias and in service_name.

If you are using HOSTNAME as a names resolution method, you'll need to make sure that the databases have CNAME entries in DNS for the new domain.

hth.

Pd

On Thu, 11 Nov 2004 11:23:26 -0500, Aragon, Gabriel (GE Commercial Finance) <gabriel.aragon_at_ge.com> wrote:
> Hi List,
>=20
> I have two Oracle databases and two SQL, all of them running in 4 =3D
> different windows boxes. Yesterday the network admin notified me that
=3D
> they are going to move the domain to other one. Because of this, I
have =3D
> to make an assessment of the impact for the db's
>=20
> Since I'm not an expert on network issues don't have idea which will
be =3D
> the impact of changing domain from XXX to YYY, the first thing that =
=3D
> comes to mind, is recreate the oracle OS users, and grant again all
the =3D
> privileges assigned to those accounts. Then verify listeners and =3D
> connections for clients. But dont know what else I should check.
>=20
> Any help will be appreciated
>=20
> TIA
> Gabriel
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l