Re: NT4.0 + IIS + WebDb

In article <39DB4E8A.A8E19391_at_home.nl>,
  frank <fbortel_at_home.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...

listener.ora is under E:\Oracle\Ora81, tnsnames.ora and sqlnet.ora are under E:\Oracle\WebDB.

Aren't these two distinct oracle homes?

<snip>

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

<snip>

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

Done and rebooted: it looks like nothing has changed.

> One or two more things to check:
> In a command session ("DOS" box), type hostname.
> It should be webserver, not more, no less.

Yep, it is.

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

It's OracleServicePLURIMED (both before and after the changes). I guess this is because the SID value in the registry is still plurimed, isn't it?

How about my ini file (pfile)? Could it be the culprit? I'm not even sure about which one is actually in use:

• E:\Oracle\Ora81\sysman\ifiles\def_PLURIMED.PLURIMEDIA.IT.ora?
• E:\Oracle\Ora81\DATABASE\initplurimed.ora?
• E:\Oracle\admin\plurimed\pfile\initplurimed.ora?

HELP!!!!!!!!!!!!! Alessandro.

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