RE: Anyone using onames on win2k server + 8.1.7 ?

From: Bob Metelsky <bmetelsky_at_CPS92.COM>
Date: Mon, 28 Jul 2003 07:34:25 -0800
Message-ID: <F001.005C77B6.20030728073425@fatcity.com>

I tried the whole process again this morning and got it to work, (after a couple of days playing with varios settings. Here is the summary of the tar.

This was a clean install on w2k sp2 oracle 8.17 with patch/sets 1,2,3,4 applied

Thanks to all who took the time to reply

Bob

##################################################

ORACLE TAR SUMMARY 28-JUL-03 13:37:09 GMT New info : I fixed the problem. Basically I deleted the names.ora file and checkpoint files located in the names dir, then used net8 configuration tool to create a new names server using the machine
name rather than ip address
saved the configuration, then through the GUI restarted the service. I noticed
the 3 checkpoint files were created.(as opposed to the chkpcfg.ora)not getting
created on friday.
Please see the basic config files below as well as the zip file I will upload.
Summary, it seems that the config has to be done in a specific order and being
consistent with the HOST= machine name oposed to one using machine name and the
other using ip address.
The machine has rebooted several times and the names server is working. Please
find the attached zip files for the record. This problem seems solved although
a little buggy.
also be advised I applied patch sets 1,2,3,4 Thanks
bob

################################################################

[names.ora]
NAMES.SERVER_NAME = NS_CPS012
NAMES.ADDRESSES =
(ADDRESS = (PROTOCOL = TCP)(HOST = cps012)(PORT = 1575))

################################################################

[sqlnet.ora]
SQLNET.EXPIRE_TIME = 10
SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (ONAMES,HOSTNAME)
NAMES.REQUEST_RETRIES = 1
NAMES.INITIAL_RETRY_TIMEOUT = 2
NAMES.PREFERRED_SERVERS =

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cps012)(PORT = 1575))
)

################################################################

[sample from ckpreg.ora] this was the file that was not getting populated with
the connect descriptors, here we show 1 connection # Generation date: 28-JUL-2003 09:01:01
# Server version banner: Oracle Names for 32-bit Windows: Version 8.1.7.4.0 - Production
#
. = (DATA_LIST=(FLAGS=0x11)
(DATA=(TYPE=ns.smd.)(NAME=NS_CPS012.) )

)
mydb. = (DATA_LIST=(FLAGS=0x1)(TTL=86400)

(DATA=(TYPE=a.smd.)(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HO
ST=hoat)
(PORT=1526)))(CONNECT_DATA=(SID=TEST2))) )
)

################################################################

[ckpcfg.ora]
# Generation date: 28-JUL-2003 08:54:39
# Server version banner: Oracle Names for 32-bit Windows: Version 8.1.7.4.0 - Production
# Region's ROS data store:
#

NAMES.SERVER_NAME = NS_CPS012
names.domains = (DOMAIN_LIST=(DOMAIN=(NAME=)(MIN_TTL=86400)))
NAMES.ADDRESSES = (ADDRESS = (PROTOCOL = TCP)(HOST = cps012)(PORT =

1575))

################################################################

Text continued in next action...

28-JUL-03 13:38:07 GMT Text continued from previous action...

[ckpcch.ora] blank file
# Generation date: 28-JUL-2003 08:54:39
# Server version banner: Oracle Names for 32-bit Windows: Version 8.1.7.4.0 - Production
#

> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com] 
> Sent: Monday, July 28, 2003 10:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Anyone using onames on win2k server + 8.1.7 ?
> 
> 
> Our secondary ONAMES server used to be 8.1.7 on WinTuke, SP3 
> with the primary ONAMES being 8.0.5.0.1 under OpenVMS and the 
> common repository Names DB 8.1.7.  At the time, the secondary 
> ONAMES server was my PC (one of those "quick-and-dirty" ideas 
> that became production).  I was also trying to get OEM 8.1.7 
> in the same ORACLE_HOME working properly with an intermittent 
> lack of notification e-mail.  I had decided to rebuild my 
> Windohs install from scratch and "upgrade" to Oracle9iR2 as 
> part of that.  The secondary 9.2.0 ONAMES ran OK against the 
> original 8.1.7 repository (minimum version required for 
> ONAMES in 9i) and the original primary 8.0.5 ONAMES server 
> without much of any issue until we migrated everything to 
> Linux servers.
> 
> Short story long, yes, we have had 8.1.7 ONAMES run OK on WinTuke.
> 
> Rich
> 
> Rich Jesse                           System/Database Administrator
> rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA
> 
> 
> > -----Original Message-----
> > From: Jared Still [mailto:jkstill_at_cybcon.com]
> > Sent: Saturday, July 26, 2003 5:40 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Anyone using onames on win2k server + 8.1.7 ?
> > 
> > 
> > 
> > I used onames on 8.1.7 without a problem.
> > 
> > It's the secondary server, but it always works.
> > 
> > Jared
> > 
> > On Friday 25 July 2003 12:54, Bob Metelsky wrote:
> > > All
> > >
> > > 	Ive gone round and round with  a new install of 8.17 
> and getting 
> > > names to work. Initially when a name server was greated and upi 
> > > opend the
> > NET8 config,
> > > it would crash
> > > Searching metalink provided the needed patches
> > > 1,2,3,4
> > > Aplied all in sequence without errors
> > > Import large tnsfile into names, save config and exit
> > > All the instances can be querried through the name server
> > both locally
> > > (on the machine) and remotely
> > > However
> > > When the service restarts, or machine reboots all
> > configuration is lost
> > >
> > > Searched metalnk and diddnt comeup with too much. I opned a
> > TAR and was
> > > suggested to move to 9.x
> > > Well, Ive spent so much time on this and I need to maintain
> > the 8.1.x
> > > version for this particullar server
> > > So, my question is anyone using onames on win2k server 8.1.7
> > >
> > > My banner is as follows
> > >
> > > SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jul 25 
> 13:37:17 2003
> > > (c) Copyright 2000 Oracle Corporation.  All rights reserved. 
> > > Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.1 - 
> > > Production With the Partitioning option
> > > JServer Release 8.1.7.4.1 - Production
> > >
> > > Input truncated to 14 characters
> > > SYSTEM_at_ORCL ->
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> 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).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.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 Mon Jul 28 2003 - 10:34:25 CDT