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 ?
Printable View
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 ?
Yes you can, it is very easy just use dbasst and change your database - no problem
Sorry dbassist
Is it really that easy
are u sure about this, please dont give any vague answer becoz it is my production database
Try changing from MTS to dedicated in TEST. If you do not have a test environment, I apologize.
Good luck.
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
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:
becomes:Code:TEST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=dev1)(PORT=1521))
(CONNECT_DATA=(SID=test))
)
Code:TEST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=dev1)(PORT=1521))
(CONNECT_DATA=(SID=test)(SERVER=DEDICATED))
)