RE: Changing ONAMES enrtries fiasco

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).