Re: Oracle Parallel Server and 24x7 availability

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/06/05
Message-ID: <5VW_4.234635$Tn4.2117837@news1.rdc2.pa.home.com>#1/1

# this connection uses MTS
RPSDEV02.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = p31db1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = p31db2)(PORT = 1521))

    )
(CONNECT_DATA = (SID = RPSDEV02)(ORACLE_HOME =
/oracle/app/oracle/product/8.0.5))
  )

# this is a dedicated connection to instance 2 RPSDEV02_2.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = p31db2)(PORT = 1521))     )
(CONNECT_DATA = (SID = RPSDEV02)(ORACLE_HOME =
/oracle/app/oracle/product/8.0.5)(SERVER = DEDICATED))   )

# this is a dedicated connection to instance 1 RPSDEV02_1.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = p31db1)(PORT = 1521))     )
(CONNECT_DATA = (SID = RPSDEV02)(ORACLE_HOME =
/oracle/app/oracle/product/8.0.5)(SERVER = DEDICATED))   )

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
<asokol99_at_my-deja.com> wrote in message news:8hgt2i$f33$1_at_nnrp1.deja.com...
>    I have just installed OPS (8.1.5) on NT cluster running on
>    Compaq Proliant. Database servers are running fine on both
>    nodes and i can connect to the database from both nodes as
>    well, read and write.
>
>    Now i'm trying to configure a client workstation and no matter
>    how i setup my tnsnames.ora i still get one of 3 errors:
>
> mywork> conn system/manager_at_win1
> ERROR:
> ORA-12154: TNS:could not resolve service name
>
> mywork> conn system/manager_at_win11
> ERROR:
> ORA-12500: TNS:listener failed to start a dedicated server process
>
> mywork> conn system/manager_at_win11
> ERROR:
> ORA-12202: TNS:internal navigation error
>
>   I tried to look into 8.1.5 Appendix C of Net8 (Configuration params)
>    without much luck.
>
>   Robert, if you could post samples of your tnsnames.ora and
> listener.ora it would be greatly appreciated.
>
> Thanks, Alex Sokol
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Mon Jun 05 2000 - 00:00:00 CDT