Re: NEWBIE: Oracle8 NT setup questions

David Thom wrote:
[yum-yum]
>
> I tried running the Net8 Easy Config on Server B, but its test fails with
> both Bequeath or IPC, so something's really wrong.

Those Oracle GUI configuration tools are only good if you want to crash your computer. You better edit configuration files like sqlnet.ora or tnsnames.ora manually and for testing database connections use tnsping80 or sql*plus.

> Questions:
>
> 1) do I have to configure Net8 even when connecting to a local database?

Yes. You have to add connect parameters into tnsnames.ora file either manually or using Net8 Easy Config or Oracle Net8 Assistant. Example from my tnsnames.ora:

BLAH.DOMAIN =
  (DESCRIPTION =
    (ADDRESS =

      (PROTOCOL = BEQ)
      (PROGRAM = oracle80)
      (ARGV0 = oracle80blah)
      (ARGS = '
        (DESCRIPTION=
          (LOCAL=YES)
          (ADDRESS=
            (PROTOCOL=BEQ)))'))
    (CONNECT_DATA =
      (SID = blah))

> 2) did my choosing "none" for the sample database (on Server B) during setup
> cause this problem?

Definetly no.  

> 3) what NT Services should be running on Server B? Mine show only
> OracleTNSListener80 and OracleWebAssistant as started

AFAIK neither of them are really needed if you are connecting to a local database via svrmgr30, but you must create database instance and a service oracleservice<sid> using oradim80.  

> Any help greatly appreciated!
>
> (replies via email preferred, but please post here too)
>
> David Thom

Cheers,
Juhan Received on Tue Apr 27 1999 - 07:15:03 CDT