Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Persistent Listener Problem - Aggravating!

Re: Persistent Listener Problem - Aggravating!

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sun, 31 Mar 2002 08:15:23 +1000
Message-ID: <a85dg9$rvr$1@lust.ihug.co.nz>


Your sqlnet.ora is wrong. The line

 NAMES.DEFAULT_DOMAIN = TEST.NHEMS.DB
...should read

 NAMES.DEFAULT_DOMAIN = NHEMS.DB
...since TEST is not part of the domain, but the name of the Instance you're
connecting to.

With that correctly set, you can get rid of the stuff in the tnsnames.ora that aliases 'TEST.NHEMS.DB' so that it only reads:

TEST =
  (DESCRIPTION =

     (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Q4E60KISR45DQ77)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = TEST.NHEMS.DB)
     )

   )

(Incidentally, that's an, er, 'interesting' host name. I didn't know you could have Windows host names that long... and I wouldn't like to try it even so).

Your listener.ora is also all over the place. In 9i, you don't need to specify the SIDs to be listened out for, because Instances register themselves with the Listener automatically. So it should read:

 LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = Q4E60KISR45DQ77)(PORT = 1521))
      )

    )
  )

And to make automatic Instance registration work properly, your init.ora needs to read:

db_domain=NHEMS.DB
db_name=TEST

Change these things, then on the server itself, bounce the Instance. Once it's up, exit to the O/S and type "lsnrctl services" (without the quotes, of course) at the command line. If the registration process is working well, you should see the TEST Instance appear as one of the handled services. Then try client connections "@TEST" using the command-line version of SQL Plus. If the Listener still blows up, then it's your Windows installation that's stuffed, because that should work perfectly. Then move on to testing TOAD and Powerbuilder and the GUI version of SQL Plus.

Regards
HJR

--
------------------------------------------
Resources for Oracle : www.hjrdba.com
============================

"William O'Neill" <wfoneill_at_mindspring.com> wrote in message
news:a85cj2$of3$2_at_slb2.atl.mindspring.net...
> Am still having problems with the Listener detaching at every 'call' to
the
> db.  Am using Oracle 9i on WIN2K, and am using Powerbuilder 8.0.1.  I am
not
> a DBA, nor do I intend to beome one.  Am just trying to familiarize myself
> with this version of Oracle.  The problem happens when I use Toad, SQL
Plus,
> or Powerbuilder.  I always recieve a Messagebox with the 'error' in it.  I
> have included these files for your perusal: 'error message',INIT.ora,
> TNSNAMES.ora, LISTENER.ora, and SQL.ora files:
>
> [ERROR Message]
> PROGRAM ERROR
> TNSLNR.EXE  has generated errors and will be closed by Windows.  You will
> need to restart the program.  An error log is being created. (However,
there
> does not appear to be any error log created!)
>
> INIT.ORA
> # Copyright (c) 1991, 2001 by Oracle Corporation
>
>
############################################################################
> ##
>
> # Cache and I/O
>
> ###########################################
>
> db_block_size=4096
>
> db_cache_size=33554432
>
> ###########################################
>
> # Cursors and Library Cache
>
> ###########################################
>
> open_cursors=300
>
>
>
> ###########################################
>
> # Diagnostics and Statistics
>
> ###########################################
>
> background_dump_dest=C:\oracle\admin\TEST\bdump
>
> core_dump_dest=C:\oracle\admin\TEST\cdump
>
> timed_statistics=TRUE
>
> user_dump_dest=C:\oracle\admin\TEST\udump
>
> ###########################################
>
> # Distributed, Replication and Snapshot
>
> ###########################################
>
> db_domain=DB
>
> remote_login_passwordfile=EXCLUSIVE
>
> ###########################################
>
> # File Configuration
>
> ###########################################
>
> control_files=("C:\oracle\oradata\TEST\CONTROL01.CTL",
> "C:\oracle\oradata\TEST\CONTROL02.CTL",
> "C:\oracle\oradata\TEST\CONTROL03.CTL")
>
> ###########################################
>
> # MTS
>
> ###########################################
>
> dispatchers="(PROTOCOL=TCP)(SER=MODOSE)",
> "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)",
> "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)", "(protocol=TCP)"
>
> ###########################################
>
> # Miscellaneous
>
> ###########################################
>
> compatible=9.0.0
>
> db_name=TEST.NHEMS.DB
>
> ###########################################
>
> # Network Registration
>
> ###########################################
>
> instance_name=TEST
>
> ###########################################
>
> # Pools
>
> ###########################################
>
> java_pool_size=33554432
>
> large_pool_size=1048576
>
> shared_pool_size=33554432
>
> ###########################################
>
> # Processes and Sessions
>
> ###########################################
>
> processes=150
>
> ###########################################
>
> # Redo Log and Recovery
>
> ###########################################
>
> fast_start_mttr_target=300
>
> ###########################################
>
> # Sort, Hash Joins, Bitmap Indexes
>
> ###########################################
>
> sort_area_size=524288
>
> ###########################################
>
> # System Managed Undo and Rollback Segments
>
> ###########################################
>
> undo_management=AUTO
>
> undo_tablespace=UNDOTBS
>
> # LISTENER.ORA Network Configuration File:
> C:\oracle\ora90\network\admin\listener.ora
>
> # Generated by Oracle configuration tools.
>
> LISTENER =
>
>   (DESCRIPTION_LIST =
>
>     (DESCRIPTION =
>
>       (ADDRESS_LIST =
>
>         (ADDRESS = (PROTOCOL = TCP)(HOST = Q4E60KISR45DQ77)(PORT = 1521))
>
>       )
>
>     )
>
>   )
>
> SID_LIST_LISTENER =
>
>   (SID_LIST =
>
>     (SID_DESC =
>
>     (GLOBAL_DBNAME = TEST.NHEMS.DB)
>
>     (ORACLE_HOME = C:\oracle\ora90)
>
>     (SID_NAME = TEST)
>
>     )
>
>   )
>
> # TNSNAMES.ORA Network Configuration File:
> C:\oracle\ora90\network\admin\tnsnames.ora
>
> # Generated by Oracle configuration tools.
>
> TEST =
>
>   (DESCRIPTION =
>
>     (ADDRESS_LIST =
>
>       (ADDRESS = (PROTOCOL = TCP)(HOST = Q4E60KISR45DQ77)(PORT = 1521))
>
>     )
>
>     (CONNECT_DATA =
>
>       (SERVICE_NAME = TEST.NHEMS.DB)
>
>     )
>
>   )
>
> TEST.NHEMS.DB =
>
>   (DESCRIPTION =
>
>     (ADDRESS_LIST =
>
>       (ADDRESS = (PROTOCOL = TCP)(HOST = Q4E60KISR45DQ77)(PORT = 1521))
>
>     )
>
>     (CONNECT_DATA = (SID = TEST))
>
>   )
>
> # SQLNET.ORA Network Configuration File:
> C:\oracle\ora90\network\admin\sqlnet.ora
>
> # Generated by Oracle configuration tools.
>
> NAMES.DEFAULT_DOMAIN = TEST.NHEMS.DB
>
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> Can anyone point out any inconsistences
> within these files that might help clear up my problem.  Appreciate it.
If
> you need more info, please ask...
> Bill
>
>
>
Received on Sat Mar 30 2002 - 16:15:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US