Re: Listener and Windows 2000 domain

From: Paul Drake <drak0nian_at_yahoo.com>
Date: 10 Jun 2003 10:38:49 -0700
Message-ID: <1ac7c7b3.0306100938.79937ef6@posting.google.com>

daan_vdv_at_yahoo.fr (Daan) wrote in message news:<d34f13a7.0306100342.13f65924_at_posting.google.com>...
> Hello,
>
> I have a server in Oracle 8.17, W2k SP3. It works well as included in
> a workgroup.
>
> I want to include this server in a Windows 2000 domain (just as a
> server, not as a DC). But when I do it, after rebooting, I can't
> access to my databases and I have the following message :
>
> 12514 : TNS:listener could not resolve SERVICE_NAME given in
> connect descriptor
>
> I've checked my tnsnames.ora, sqlnet.ora, listener.ora...everything
> seems ok.
>
> What has changed with the admission in the domain ?
>
> If anybody has an idea....thanks for advance !
>
> Daan
> daan_vdv_at_yahoo.fr

Daan,

I would guess that you did not specify the domain in the sqlnet.ora, in which case it is being inherited from the OS. It changed when the server moved from a workgroup to a domain.

lsnrctl.exe can provide you with some info. For this example, I'll assume that you have a single 817 oracle_home, which is in the path.

ORACLE_SID, ip_addresses obfuscated to protect ... blah, blah.

D:\Oracle\ora81\BIN>lsnrctl

LSNRCTL for 32-bit Windows: Version 8.1.7.4.0 - Production on 10-JUN-2003 13:32:
31

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> set displaymode verobse
set displaymode RAW | COMPAT | NORMAL | VERBOSE: output mode for lsnrctl display

LSNRCTL> set displaymode verbose
Service display mode is VERBOSE
LSNRCTL> set password
Password:
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))) STATUS of the LISTENER

---

Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version

8.1.7.4.0 - Produc
tion

Start Date                15-APR-2003 18:55:08
Uptime                    55 days 18 hr. 37 min. 49 sec
Trace Level               user
Security                  ON
SNMP                      OFF
Listener Parameter File   D:\oracle\ora81\network\admin\listener.ora
Listener Log File         D:\oracle\ora81\network\log\listener.log
Listener Trace File       D:\oracle\ora81\network\trace\listener.trc

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.222)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.222)(PORT=1526)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myserver)(PORT=2481))(PROTOCOL_ST

ACK=(PRESENTATION=GIOP)(SESSION=RAW)))
Services Summary...
Service "DEV.mydomain.com" has 1 instances.

    Instance "DEV"

      Status: READY  Total handlers: 1  Relevant handlers: 1
      Class: ORACLE
Service "TEST.mydomain.com"               has 1 instances.
    Instance "TEST"
      Status: READY  Total handlers: 1  Relevant handlers: 1
      Class: ORACLE

The command completed successfully
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))) Services Summary...
Service "DEV.mydomain.com" has 1 instances.

    Instance "DEV"

      Status: READY  Total handlers: 1  Relevant handlers: 1
      Class: ORACLE
        DEDICATED established:7146 refused:0 current:0 max:0
state:ready
        (ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracledev)(ARGS='(DESCRIPT
ION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))'))
            Session: NS
Service "TEST.mydomain.com"               has 1 instances.
    Instance "TEST"
      Status: READY  Total handlers: 1  Relevant handlers: 1
      Class: ORACLE
        DEDICATED established:3189 refused:0 current:0 max:0
state:ready
        (ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracletest)(ARGS='(DESCRIPT
ION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))'))
            Session: NS

The command completed successfully
LSNRCTL> quit

in sqlplus, check the following parameters:

db_domain
service_names
global_name

if you do not explicilty set the service_name, it will append the db_name || db_domain to create the service_name. Again, if the names.default_domain is not set, it may be acquired from the OS, in which case the service_name that is registered at instance startup may not be what it used to be.

Are you using static or dynamic registration of the service with the listener?
(static means that you have an explicit descriptor in the listener.ora file).

hth.

Paul Received on Tue Jun 10 2003 - 12:38:49 CDT