Re: NT4.0 + IIS + WebDb

From: Alessandro Nazzani <alexnsb_at_tin.it>
Date: Wed, 04 Oct 2000 15:10:52 GMT
Message-ID: <8rfh9l$t7$1@nnrp1.deja.com>

In article <8rfdn5$rd1$1_at_porthos.nl.uu.net>,   "Frank" <frankbo_at_interaccess.nl> wrote:

<snip>

> Should be... but why the change?

It is described in the following note:

http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=91773.1

> Could you post E:\Oracle\Ora81\network\ADMIN\listener.ora and

--------------------Start--------------------

# LISTENER.ORA Network Configuration File: E:\Oracle\Ora81 \network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\Oracle\Ora81)
      (PROGRAM = extproc)

    )
(SID_DESC =

      (GLOBAL_DBNAME = plurimed)
      (ORACLE_HOME = E:\Oracle\Ora81)
      (SID_NAME = plurimed)

    )
  )

-------------------- End --------------------

> E:\Oracle\Ora81\WebDb\NET80\ADMIN\tnsnames.ora and

--------------------Start--------------------

# E:\ORACLE\WEBDB\NET80\ADMIN\TNSNAMES.ORA Configuration File:E:\Oracle\WebDb\NET80\ADMIN\tnsnames.ora # Generated by Oracle Net8 Assistant

CMEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = tcp)(PORT = 1610)(HOST = CM_SERVER))
      (ADDRESS = (PROTOCOL = tcp)(PORT = 1521)(HOST = LSNR_SERVER))

    )
(CONNECT_DATA = (SID = ORCL))
(SOURCE_ROUTE = yes)

  )

TCPEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = Production1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))

  )

NMPEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe =
ORAPIPE))
(CONNECT_DATA = (SID = ORCL))

  )

PLURIMED.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1521))     )
(CONNECT_DATA =

      (SID = PLURIMED)
    )
  )

EXTPROC_CONNECTION_DATA.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(CONNECT_DATA = (SID = extproc))

  )

BEQ-LOCAL.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 =
oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS= (PROTOCOL=beq)))'))

(CONNECT_DATA = (SID = ORCL))

  )

SPXEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
(CONNECT_DATA = (SID = ORCL))

  )

TCP-LOOPBACK.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))

  )

-------------------- End --------------------

> E:\Oracle\Ora81\WebDb\NET80\ADMIN\sqlnet.ora? Actual path: E:\Oracle\WebDb\NET80\ADMIN

--------------------Start--------------------

TRACE_LEVEL_CLIENT = OFF
#sqlnet.authentication_services = (NONE) names.directory_path = (TNSNAMES, HOSTNAME) names.default_domain = world
name.default_zone = world
automatic_ipc = off

-------------------- End --------------------

Look forward to hear from you:-)

Alessandro

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 04 2000 - 10:10:52 CDT