How to know the database was configure MTS or not?

Hi All,

I'm a new DBA. I want to know my database server have already configure MTS(Multi-Thread Sever) or not? How to Know?

I met the error : ORA-24777: use of non-migratable database link not allowed => I don't know the reason and how to fixed this error? Please help me.

Thank in advance.

look at the tnsnames file, its the client that decides how to connect, not the database

well his question was so simple, how do i know if my DB is configured to accept Shared Connections.. the answer would be look at the parameters shared_server and dispatchers..

its only not the client that decides how to connect.. but the DB as well, as it should be pre-configured to accept shared connections..

rgds
abhay

well yes, but the db could be set up to use shared server and no client uses it - so the client is more important

well it could be other way round as well.. and you end up getting errors while connection..

Try this SQL*Plus command, if MTS is configured, you get some values else nothing:

Code:

---

SHOW PARAMETER MTS

---

;)

Thanks for your help.
I showed parameter and result as below :

SQL> show parameter mts

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
mts_circuits integer 0
mts_dispatchers string
mts_listener_address string
mts_max_dispatchers integer 5
mts_max_servers integer 20
mts_multiple_listeners boolean FALSE
mts_servers integer 0
mts_service string CCBS1
mts_sessions integer 0

As it show, value of parameter MTS_DISPATCHERS is blank string. Is my DB configured MTS successfull?

Thanks in advance.

You are not

Regards

Here is an example of a working MTS config:

Code:

---

mts_circuits        integer 225
mts_dispatchers      string  (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer), (protocol=TCP)(disp=1)(con=50)
mts_listener_address string
mts_max_dispatchers  integer 3
mts_max_servers      integer 6
mts_multiple_listeners boolean FALSE
mts_servers          integer 2
mts_service          string  mydb
mts_sessions        integer 220

---

;)