Changing from MTS to Dedicated Server (Urgent)

[Irfkhan]

HI all my database has been made using Multithreaded server, Now I m facing some problems with regards to it, SO i want to switch back to dedicated server.

Can I Change my database now to dedicated database server

If yes How ?

[truma1]

Yes you can, it is very easy just use dbasst and change your database - no problem

[truma1]

Sorry dbassist

[Irfkhan]

Is it really that easy

are u sure about this, please dont give any vague answer becoz it is my production database

[dknight]

Try changing from MTS to dedicated in TEST. If you do not have a test environment, I apologize.

Good luck.

[kiruba]

Hi Irfan

Is LTA is moving from dedicated server to multi-threaded server. You can actually convert from MTS to dedicated by changing Init.ora parameter. I guess you can make out from the Init parameter

[marist89]

MTS is defined by your MTS_ parameters in the init.ora file. Take out those parameters and MTS is disabled. I have read recently where the MTS_ parameters can be changed on the fly, but have not tested.

The easiest way for you to switch is to use the (SERVER=DEDICATED) information in your TNSNAMES.ORA file. Using this switch will guarantee that each connection to that alias will use a dedicated server. This way, you can change your init.ora when it is convienient and bounce the database. For example:

TEST=
   (DESCRIPTION=
      (ADDRESS=(PROTOCOL=TCP)(HOST=dev1)(PORT=1521))
      (CONNECT_DATA=(SID=test))
   )

becomes:

TEST=
   (DESCRIPTION=
      (ADDRESS=(PROTOCOL=TCP)(HOST=dev1)(PORT=1521))
      (CONNECT_DATA=(SID=test)(SERVER=DEDICATED))
   )