Yes, you need a reload so that it takes immediate effect. --- "Jesse, Rich" <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA > > > -----Original Message----- > > From: Johnson Poovathummoottil > [mailto:[EMAIL PROTECTED]] > > 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@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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).