Re: 9i on Windows 2000 Server Workgroup

From: fu manchu <leondobr_at_verizon.net>
Date: Fri, 25 Jun 2004 04:26:48 GMT
Message-ID: <pg9nd050vc9h2ql7l2kh3p5kbg6r4ma097@4ax.com>

Okay, I want to get on with this so I setup a fixed IP for my server. Here's the result of 'lsnrctl services' and the .ora files (only interesting point is STATUS UNKNOWN):

I:\>lsnrctl services

LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 25-JUN-2004 00:06:
23

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.20)(PORT=1521) ))
Services Summary...
Service "len92.beast" has 1 instance(s). Instance "len92", status UNKNOWN, has 1 handler(s) for this service...

Handler(s):

      "DEDICATED" established:0 refused:0
         LOCAL SERVER

The command completed successfully

# TNSNAMES.ORA Network Configuration File: I:\oracle\ora92\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

LEN92 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = len92.beast)

    )
  )

LISTENER.ORA Network Configuration File: I:\oracle\ora92\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521))
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = len92.beast)
(ORACLE_HOME = I:\oracle\ora92)
(SID_NAME = len92)

    )
  )

These are complete listings. I removed the EXT_PROC lines.

Here is the SQL show parameter output:
I:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jun 25 00:17:10 2004

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL> show parameter instance

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
active_instance_count                integer
cluster_database_instances           integer     1
instance_groups                      string
instance_name                        string      len92
instance_number                      integer     0
open_links_per_instance              integer     4
parallel_instance_group              string
parallel_server_instances            integer     1

SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
mts_service                          string      len92
service_names                        string      len92.beast

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
spfile                               string
%ORACLE_HOME%\DATABASE\SPFILE%
                                                 ORACLE_SID%.ORA

SQL> Everything looks okay to me except the status UNKOWN bit early in the lnsrctl services output.

It wouldn't work at all until I set HOST = 192.168.1.20 instead of HOST = beast.

The listener still immediately dies after the first time it establishes a connection. I'm stumped. Any ideas? Received on Thu Jun 24 2004 - 23:26:48 CDT