WAS3.0.2 RDBMS8.0.5 ICS 2.0

From: <iaintnodba_at_my-deja.com>
Date: Mon, 13 Sep 1999 14:25:13 GMT
Message-ID: <7rj1fr$m1c$1@nnrp1.deja.com>

I'm trying to get ICS2.0 to work with 8.0.5 and WAS 3.0.2.

I have 8.0.5 and 3.0.2 installed in two separate ORACLE_HOMEs (1. /u01/app/oracle/product/8.0.5
 2. /u01/app/oracle/product/7.3.4 )
and installed by two separate users (user oracle installed 8.0.5 and user ics installed OWAS).

When I try to use the server manager from the 7.3.4 ORACLE_HOME I get the following error message ORA-12545: TNS:name lookupo failure.

Both Oracle homes have identical tnsnames.ora and listener.ora files, in fact I copied 8.0.5 $TNS_ADMIN directory to 7.3.4 $TNS_ADMIN.

I am using the IP address of the Host.

The Oracle tech support guy said not to use TWO_TASK. So I am using BEQ.

Here's a sample of my tnsnames.ora file:

#
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#

extproc_connection_data =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = db))
(CONNECT_DATA = (SID = extproc))

  )

db =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 192.168.0.31)(Port= 1521))
(CONNECT_DATA = (SID = db))

  )

webdb =
  (DESCRIPTION =
(ADDRESS =

                (PROTOCOL=tcp)
                (Host=192.168.0.31)
                (Port=2649))


    (CONNECT_DATA=


                (SID=db))

  )

db_BEQ =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM =
/u01/app/oracle/product/8.0.5/bin/orac
le)

               (argv0 = oracledb)
               (args = '(DESCRIPTION =
(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
               (envs =

'ORACLE_HOME=/u01/app/oracle/product/8.0.5,ORACLE_SID=db' )

     )
   )

Here's a sample of the listener.ora:

#
# Installation Generated Net8 Configuration
# Version Date: Jun-17-97
# Filename: Listener.ora
#

LISTENER =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= db))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host= 192.168.0.31)(Port= 1521))

  )

WEBLISTENER =

        (ADDRESS=
                 (PROTOCOL= TCP)
                 (KEY = webdb)
                 (Host= 192.168.0.31)
                 (Port= 2649)
        )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME= orawdemo.)
      (ORACLE_HOME= /u01/app/oracle/product/8.0.5)
      (SID_NAME = db)

    )
(SID_DESC =

      (SID_NAME = extproc)
      (ORACLE_HOME = /u01/app/oracle/product/8.0.5)
      (PROGRAM = extproc)

    )
  )

SID_LIST_WEBLISTENER =
  (SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME= orawdemo.)
      (ORACLE_HOME= /u01/app/oracle/product/8.0.5)
      (SID_NAME = db)

    )
(SID_DESC =

      (SID_NAME = extproc)
      (ORACLE_HOME = /u01/app/oracle/product/8.0.5)
      (PROGRAM = extproc)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ON
#LOG_DIRECTORY_WEBLISTENER=/u01/app/oracle/product/7.3.4/network/log #TRACE_DIRECTORY_WEBLISTENER=/u01/app/oracle/product/7.3.4/network/trace LOG_DIRECTORY_WEBLISTENER=/u01/app/oracle/product/805/network/log TRACE_DIRECTORY_WEBLISTENER=/u01/app/oracle/product/805/network/trace

I can tnsping all of the services by name (db, webdb, extproc_connection_data and db_BEQ) using both oracle tnsping binaries (7.3.4 and 8.0.5). It's only when I use the server manager, that I get the following message:

$ svrmgrl

Oracle Server Manager Release 2.3.4.0.0 - Production

Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.

ORA-12545: TNS:name lookup failure
SVRMGR> I need to use the server manager line mode, to install the demos using the web interface (http://websr:8888/owas-abin/boot).

The web broker and the web admin interface have been successfully started.

Thanks for any and all help with this problem.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 13 1999 - 09:25:13 CDT