Current Position:Home > How to configure MTS

How to configure MTS

Update:11-30Source: network consolidation
Advertisement
I am running Oracle 8.1.7 on Sun Solaris. I have set the following in init.ora file.
mts_dispatchers="(protocol=tcp)(dispatchers=4)(connections=1000)"
mts_servers = 3
When I query the server column of v$session table I find DEDECATED for each user. So How the database can be configured in MTS mode.
Mohan

The Best Answer

Advertisement
The listener.ora file on the server looks like this
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sun_dev)(PORT = 1521))
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
(ADDRESS = (PROTOCOL = TCP)(HOST = sun_dev)(PORT = 2481))
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/OraHome/8.1.7)
(PROGRAM = extproc)
(SID_DESC =
(GLOBAL_DBNAME = dev)
(ORACLE_HOME = /home/OraHome/8.1.7)
(SID_NAME = dev)
The tnsnames.ora file is
sun_dev =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sun_dev)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = dev)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
I have put the same files on the client side also.
Mohan
  • Variant configuration MTS Update:11-30

    Can you anyone explain how to configure MTS in Variant configuration?Hi Neeraj I'm sorry by my late, I was out of office... I need to use Variant Configuration for materials in pulp & paper ind., I have at least for each one FERT material, 3 material

  • How to configure MTS Update:11-30

    I am running Oracle 8.1.7 on Sun Solaris. I have set the following in init.ora file. mts_dispatchers="(protocol=tcp)(dispatchers=4)(connections=1000)" mts_servers = 3 When I query the server column of v$session table I find DEDECATED for each us

  • MTS configuration problem on Oracle 9i. Update:11-30

    Hi all, I want to configure MTS for my database(versionn 9i Release 2).I add the following lines to initSID.ora file: dispatchers="(protocol=tcp)(service=oracle92)" max_shared_servers=10 local_listener="(addres=(protocol=tcp)(host=myhostnam

  • MTS Connection Issue Update:11-30

    Guys, your help is needed. I am trying to configure MTS. I think i have achieved this, however, when i try a sqlplus connection it takes about 30 minutes to succeed. Tnsping result is also slow. Below are excerpts of my configuration. init.ora: db_na

  • Setting port range for Oracle Listeners Update:11-30

    How do I configure MTS to specify which ports the Listener is going use when doing the redirect? I'm setting up a firewall and need to specify the portrange used. Regards, ThorbjornNot sure I understand your problem. If by "Printed Range" you wa

  • Dedicated or Shared Sessions? Update:11-30

    I have a 10g SE1 + ASM running in Windows 2003 ES with 4GB RAM with /3GB switch and 7TB JBOD storage. Our custom data mining applications access this database from a grid of 15 servers. Application architecture uses a mixture of hibernate, roll-your-

  • Make to Stock & Make to Order.... Update:11-30

    Hi , Can you please tell me the difference between MTO, MTS and STO with scenarios? Thanks....HI, MTO-Make to order Specially for customer requirment (Laptops) ..what ever you ask they will configure MTS-make to stock .....its internal process....bas

  • ALTER SYSTEM KILL SESSION 에 대하여(ORA-30) Update:11-30

    제품 : ORACLE SERVER 작성날짜 : 1997-07-30 ALTER SYSTEM KILL SESSION 에 대하여 --- Problem 사용자는 다음과 같은 상황에서 session 을 kill 하려는 시도를 하게 된다. 1. os 에는 process 가 존재하지 않지만, v$session 에는 active 로 존재하고 있을 경우 2. shadow process 는 살아 있는데, client machine 을 rebooting 한 경우

  • Allocation of SORT_AREA_SIZE Update:11-30

    At this moment, I have a doubt that still it was not clarified for the documentation of technet.oracle.com (at least until where I could read...). Is the following one: the allocation of the area of memory for ordinance (SORT_AREA_SIZE) in a data bas

  • OPEN TCP-Ports Update:11-30

    I've detected 4 open network-protzs on my Oracle 8.05 EE without configured MTS oder listener. Why ?? Older releases (7.3.4 on other platforms) don't have this "problem". Any hints are wellcome So long Christian nullThere is the standard set of