Yes, you need a reload so that it takes immediate
effect.
- "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> wrote:
> Excellent! Glag to see I won't exactly be a guinea
> pig for this.
>
> One question: Do you issue an ONAMES RELOAD after
> this is done? I'm not
> sure how else the Names Server would be made aware
> of the change, except
> after it's daily (by default) region DB refresh.
>
> Thanks!
>
> Rich Jesse System/Database
> Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech
> International, Sussex, WI USA
>
> > -----Original Message-----
> > From: Johnson Poovathummoottil
> [mailto:joni_65_at_yahoo.com]
> > Sent: Wednesday, September 25, 2002 2:59 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Changing ONAMES enrtries fiasco
> >
> >
> > After having little success with registering and
> > dropping using the namesctl commands. I have used
> > direct insert, update to the ONRS_REGION table as
> the
> > peferred method to tp update the region database.
> No
> > problems so far. make sure you have no space in
> any
> > descriptions.
> > I even have script to do the registering.
> > #!/usr/bin/ksh
> > #######################
> > ### created by J. JOB 11/22/2001
> > # This Script registers a database to the Oracle
> Names
> > server.
> > # Parameters expected are
> > # 1: SID : SID of the databse
> > # 2: Service Name : The Name by which the
> > database will be called.
> > # 3: Host Name : The Name of the
> machine
> > on which the database resides
> > # 4: Connection type : dedicated or shared
> > #######################
> > PATH=/usr/local/bin
> > PATH=${PATH}:.
> > PATH=${PATH}:/bin:/sbin:/usr/bin:/usr/sbin:/etc
> > export PATH
> >
> > SID_NAME=$1
> > SERVICE_NAME=$2
> > HOST_NAME=$3
> > DEDI_SHARED=$4
> >
>
DESCRIPTION="(DATA_LIST=(FLAGS=0x1)(DATA=(TYPE=a.smd.)(DESCRIP
> > TION=(ADDRESS_LIST=(ADDRESS=
> >
>
(PROTOCOL=TCP)(HOST=${HOST_NAME})(PORT=1521)))(CONNECT_DATA=(S
> > ERVICE_NAME=${SID_NAME})(ser
> > ver=${DEDI_SHARED})))))"
> > echo $DESCRIPTION
> > . local_oraenv ORTL
> >
> > sqlplus <<EOF
> > oname/oname_at_ORTL
> > insert into ONRS_REGION
> >
> values('(root)','${SERVICE_NAME}','${DESCRIPTION}');
> > commit;
> > exit
> > EOF
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.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).
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
INET: joni_65_at_yahoo.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 Wed Sep 25 2002 - 16:53:57 CDT