DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Configuring Multi Threaded Server

  1. #1
    Join Date
    Feb 2001
    Posts
    8

    Post

    Our database has the following settings in init.ora :

    mts_dispatchers="tcp,1"
    mts_max_dispatchers=10
    mts_servers=1
    mts_max_servers=5
    mts_service=EXPSRVR
    mts_listener_address="(ADDRESS=(PROTOCOL=TCP)(HOST=NH_ORACLE)(PORT=1521))"

    The listener.ora file is as follows :
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = NH_ORACLE)(PORT = 1521))
    )
    )


    The users are able to connect. But when I run the query :

    select username, server from v$session; I see that every user is DEDICATED. V$CIRCUIT view is also empty. I have also checked the TNSNAMES.ORA file and it does NOT contain
    (SRVR = DEDICATED) in the CONNECT_DATA.

    Any idea why everybody is still connecting using a dedicated server...???

    Regards
    Puneet Sachdev

  2. #2
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Checkup if the dispatcher process is startted or not.

  3. #3
    Join Date
    Feb 2001
    Posts
    8
    The V$dispatcher view is showing one D000 with WAIT in the status column.

    Regards
    Puneet Sachdev

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Whats your dataabse name ? Is it EXPSRVR ?
    Reddy,Sam

  5. #5
    Join Date
    Feb 2001
    Posts
    8
    Yes this is the DB_NAME. This is also the GLOBAL_DBNAME and SID defined in SID_LIST clause of listener.ora.
    Puneet Sachdev

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    type in at the prompt "lsnrctl services" and see you have the services runnning and dispathers are active.

    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width