Re: Oracle Names Setup

From: Al <al_at_work>
Date: 1997/11/28
Message-ID: <01bcfc39$ce7809c0$e9c7e28e@alan_stutchbury>#1/1

We are running Oracle Names Server 2.0 on HP/UX (comes with 7.3.2). However, it required a lot of effort (and calls to Oracle) in order to get it to work. I have attached the names.ora and sqlnet.ora files that we use.

We have defined the well known server "oranamesrvr0" in our DNS to point to the main Names server. This was so that other Names Servers would be able to find the main Names server using the dynamic discovery option.
We start up the main Names server and use the REGISTER command to define all of the databases (approx 100) on our network. We had some operational problems with the dynamic discovery option. Using DDO will cause the databases to be added and deleted from the Names server when a listener is started and stopped. This can end up generating a misleading error if the client tries to connect when the listener is unavailable ("Could not resolve name" as opposed to "No listener")
We are not using a database as the Names repository. The config and checkpoint files get created in the /netwrok/admin/names sub-directory of $ORACLE_HOME.

begin 600 names.ora
M;F%M97,N=7-E7W!L=6=?86YD7W!L87D];VX@#0IN86UE<RYS97)V97)?;F%M M93U/5%0T,%].86UE<U]397)V97(-"FYA;65S+FUA>%]O<&5N7V-O;FYE8W1I M;VYS/38T#0IN86UE<RYD;VUA:6YS(#T@*$1/34%)3E],25-4/2A$3TU!24X] M*$Y!344]*2A-24Y?5%1,/3_at_V-# P,"DI*0T*;F%M97,N861D<F5S<V5S/0T* M"2AA9&1R97-S(#T-"@D)*'!R;W1O8V]L(#T@=&-P*0T*"0DH:&]S=" ](&]T ;=#0P*0T*"0DH<&]R=" ](#$U-S4I#0H)*0T*
`

end
end

begin 600 sqlnet.ora

M;F%M97-C=&PN;F]C;VYF:7)M/71R=64-"B,-"B,@(&UU<W0_at_8F4@9F%L<V4@
M9F]R(&-O;FYE8W1I;VX@=&\@3W)A8VQE(#<N, T*(PT*;W)A7V5N8W)Y<'1?
M;&]G:6X]9F%L<V4-"G1N<W!I;F<N=')A8V5?;&5V96P]861M:6X-"G1N<W!I

M;F<N=')A8V5?9&ER96-T;W)Y/2]U,2]O<F%C;&4O<')O9'5C="\W+C,N,B]N M971W;W)K+W1R86-E#0HC;F%M97,N9&ER96-T;W)Y7W!A=&@]*$].04U%4RQ4 M3E-.04U%4RD-"FYA;65S+G!R969E<G)E9%]S97)V97)S(#T-"@DH861D<F5S

M<U]L:7-T(#T@#0H)"2AA9&1R97-S(#T@#0H)"0DH<')O=&]C;VP]=&-P*0T*
M"0D)*&AO<W0@/2!O='0T,"D-"@D)"2AP;W)T(#T@,34W-2D-"@D)*0T*(" @
M(" @(" @(" @(" @("AA9&1R97-S(#T-"B @(" @(" @(" @(" @(" @(" @
M(" @("AP<F]T;V-O;#UT8W I#0H@(" @(" @(" @(" @(" @(" @(" @(" H

M:&]S=" ](&]R86YA;65S<G9R,"D-"B @(" @(" @(" @(" @(" @(" @(" @ H("AP;W)T(#T@,34W-2D-"B @(" @(" @(" @(" @(" I#0H)*2 -"B @
`

end
end Received on Fri Nov 28 1997 - 00:00:00 CST

Re: Oracle Names Setup - Help!