How to know the database was configure MTS or not?

[danghongsinh]

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.

[davey23uk]

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

[abhaysk]

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

[davey23uk]

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

[abhaysk]

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

[LKBrwn_DBA]

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

SHOW PARAMETER MTS

[danghongsinh]

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.

[Bore]

You are not

Regards

[LKBrwn_DBA]

Here is an example of a working MTS config:

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