Oracle-L: RE: Solid DB and Oracle (NNM)

From: Sujatha Madan <Sujatha.Madan_at_cmc.cwo.net.au>
Date: Tue, 30 Apr 2002 22:23:19 -0800
Message-ID: <F001.004547EC.20020430222319@fatcity.com>

Hi,

I have checked on ITRC. There are some things, but they don't really explain much.

I thought as much that we couldn't have different Oracle instances on each collector.

Have you done this before?? Did it go alright?

Regs

suji

-----Original Message-----

Sent: Wednesday, 1 May 2002 3:38 PM
To: Multiple recipients of list ORACLE-L

I suggest you go to www.itrc.hp.com and study up there. Your sysadmin will have a full login that you can use to access all of the secrets. The openview manager probably has one linked to the openview license. I think only the management station will have a the oracle database. It is probably not a good idea to change the collectors even if you can as that might cause licensing concerns unless all those systems are already running Oracle instances and adding another instance for this is within current licenses you have.

Cheers

Peter McLarty               E-mail: Peter.Mclarty_at_mincom.com
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048
=================================================

A great pleasure in life is doing what people say you cannot do.

Walter Bagehot (1826-1877 British Economist)
Mincom "The People, The Experience, The Vision"

Sujatha Madan <Sujatha.Madan_at_cmc.cwo.net.au> Sent by: root_at_fatcity.com
01-05-2002 02:58 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Fax to: 
        Subject:        Solid DB and Oracle (NNM)

Hi,

Sorry but this situation is specific to a particular application ... so don't read past this line if you don't know what NNM (Network Node Manager)
is.

We're using NNM 6.2 with the default solid db for trend data, event data, topology etc. They have now decided that it is about time we move this to an
Oracle database/datawarehouse. I just want to know if anyone has been through this before.

We have four collector stations, each running NNM 6.2 and each with its own
solid db (on HP-UX 11). Can I confirm that this is how the process will work:

Each collection station will send the data to a management station. I then have to export all the data and via an ODBC connection transfer it to the Oracle datawarehouse which will reside on a different machine. What I don't
understand is, in this process do I convert each solid db on all 4 collectors to an Oracle db??? Or, will the collectors still use solid??? I am quite unclear on this.

Management won't buy another another Unix box because there are a few Windows servers lying around, so I have to put the Oracle datawarehouse db on one of them.

I'll appreciate any insights, experiences etc.

Thanks and regards,

Sujatha
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sujatha Madan
INET: Sujatha.Madan_at_cmc.cwo.net.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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

--

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sujatha Madan
INET: Sujatha.Madan_at_cmc.cwo.net.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message