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.)(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=
(PROTOCOL=TCP)(HOST=${HOST_NAME})(PORT=1521)))(CONNECT_DATA=(SERVICE_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
- "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> wrote:
> Hey all,
>
> I want to make changes to the ONAMES region database
> (8.0.5.0.1 on OpenVMS)
> entries because I didn't fully qualify the host
> names in the network
> aliases. And now that I can VPN in to work (thanks
> to DirecTV DSL!), I
> can't use ONAMES because my machine at home is in a
> different IP domain.
>
> After going round with Oracle Support because they
> thought I wanted to
> default domain the alias instead of the IP host,
> they say that the only way
> to change an existing ONAMES alias is to drop and
> recreate it. EEEEW! So,
> I've experimented with directly modifying the rows
> of the ONRS_REGION table
> in the region database with some success. e.g. I've
> changed this:
>
>
(DATA_LIST=(FLAGS=0x1)(DATA=(TYPE=a.smd.)(DESCRIPTION
> = (ADDRESS = (PROTOCOL
> = TCP)(HOST = myhost)(PORT = 1521)) (CONNECT_DATA =
> (SID = mysid)))))
>
> to this:
>
>
(DATA_LIST=(FLAGS=0x1)(DATA=(TYPE=a.smd.)(DESCRIPTION
> = (ADDRESS = (PROTOCOL
> = TCP)(HOST = myhost.qtiworld.com)(PORT = 1521))
> (CONNECT_DATA = (SID =
> mysid)))))
>
> ...in the aforementioned table and reloaded the
> primary and secondary ONAMES
> servers with "NAMESCTL RELOAD". A 9iR2 "tnsping"
> using ONAMES for names
> resolution proved that the new address was used
> successfully.
>
> Has anyone else done this change safely and
> successfully in a production
> environment? I'm not able to reproduce the
> production Oracle Networking
> environment, so I can't really make a valid test
> area.
>
> TIA!
>
> Rich Jesse System/Database
> Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech
> International, Sussex, WI USA
> --
> 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 - 14:58:34 CDT
