Re: WAS3.0.2 RDBMS8.0.5 ICS 2.0

Dont U think the ORACLE_HOMEs should differ in the Listener.ora files in Oracle 7 & 8 versions ?

-Thiru

iaintnodba_at_my-deja.com wrote:

> 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 - 10:20:30 CDT