Re: NT - Installing Multiple Instances - 8.0.5

From: Alexander Penev <alex_at_cska.net>
Date: Thu, 17 Aug 2000 21:47:23 GMT
Message-ID: <399C5D5C.C3D1DDEE@cska.net>

> Currently our company is having great success using Oracle 8.0.5 on NT.
> We're managing some 40 Gig of data across 5 instances.
>
> The only issue is that in managing those 5 instances, we have 5 NT servers do
> to Oracle's inability to support multiple instances on a single server. I've
> tried contacting their support without successful implementation, and even
> have been able to create multiple SIDs on a given box - - but the box only
> recognizes the common ORACLE_HOME entries and points to one vs. another.....
>
> Suggestions please?
>

I don't know what you're talking about?!?! I've run 2 instances on the same box (8.0.4 and NT 4.0) without any problems. The access was throught ODBC/Net8. Since there ware 2 fifferent sids , I could access the instance that I wanted even both through the same app (read the data from the first and wrote in the second)
What are your problems? ORACLE_HOME is the same for both instances only the sid is different.
I think the only thing you must set after creating the second instance (with the databes assistant) is to add an entry in the listener.ora something like that: LISTENER =
  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= TCP)(Host= 192.168.1.1)(Port= 1521))   )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= name1)
      (ORACLE_HOME= /home/oracle/product/8.0.5)

      (SID_NAME =ORCL1 )

    )
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= name2)
      (ORACLE_HOME= /home/oracle/product/8.0.5)

      (SID_NAME =ORCL2 )

    )

Since it was some time ago I'm not very sure so please correct me if I'm wrong HTH
>
> Multiple IPs? Ports? (and associative listener and tnsnames.ora file mods.)
>
> Has anyone out there been successful doing this? Many thanks in advance...
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Aug 17 2000 - 16:47:23 CDT