Re: NT4.0 + IIS + WebDb

Inline...

Alessandro Nazzani wrote:

> 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

which also states it is best to install in a separate oracle home. Looks like
that is not doen for WebDB (judging the location of the files). The files are all in Oracle\Ora81, whereas your WebDB home is supposedly

Oracle\WebDB...

> > 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)
> )
> )

Try what happens with:
(SID_DESC =
      (SID_NAME = plmd)
   )

>
> -------------------- 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 --------------------
>

Reduce that; remove all examples, etc... You may take a copy, but most of it is in the samples directory... Try: PLURIMED.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1521))     )
    (CONNECT_DATA =
      (SID = PLMD)
    )
  )

>
> > 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.

One or two more things to check:
In a command session ("DOS" box), type hostname. It should be webserver, not more, no less. What service do you start? (Control Panel->Services) It should be something like OracleServiceXXXX - I'm especially interested in XXXX - that is your SID! Where I changed plurimed to plmd, this (now plmd) should be the same as the XXXX in your OracleService. Received on Wed Oct 04 2000 - 10:44:49 CDT