Consegui! O problema foi que o listener não estava "reconhecendo" as
configurações MTS do banco. Executei o seguinte comando e funcionou: ALTER
SYSTEM SET LOCAL_LISTENER =
'(ADDRESS=(PROTOCOL=TCP)(HOST=SERVIDOR-PRODUCAO)(PORT=1521))'.
Service "prod" has 1 instance(s).
Instance "prod", status READY, has 9 handler(s) for this service...
Handler(s):
"D007" established:62 refused:0 current:19 max:1002 state:ready
DISPATCHER <machine: servidor-producao, pid: 21046>
(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=32785))
"D006" established:49 refused:0 current:19 max:1002 state:ready
DISPATCHER <machine: servidor-producao, pid: 21044>
(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=32784))
"D005" established:52 refused:0 current:19 max:1002 state:ready
DISPATCHER <machine: servidor-producao, pid: 21042>
(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=32783))
"D004" established:54 refused:0 current:19 max:1002 state:ready
DISPATCHER <machine: servidor-producao, pid: 21040>
(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=32782))
"D003" established:47 refused:0 current:19 max:1002 state:ready
DISPATCHER <machine: servidor-producao, pid: 21038>
(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=32781))
"D002" established:50 refused:0 current:19 max:1002 state:ready
DISPATCHER <machine: servidor-producao, pid: 21036>
(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=32780))
"D001" established:55 refused:0 current:19 max:1002 state:ready
DISPATCHER <machine: servidor-producao, pid: 21034>
(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=32779))
"D000" established:54 refused:0 current:19 max:1002 state:ready
DISPATCHER <machine: servidor-producao, pid: 21032>
(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=32778))
"DEDICATED" established:22 refused:0 state:ready
LOCAL SERVER
The command completed successfully
--- Em oracle_br@yahoogrupos.com.br, Augusto Cesar <cesarssan...@...> escreveu
>
>
> Olá pessoal,
> Estou com o seguinte problema: o oracle está configurado MTS (Shared Server)
> mas todas as conexões estão como dedicadas. Os parâmetros do banco
> são:DISPATCHERS = "(PROTOCOL=TCP)(DISPATCHERS=8)"SHARED_SERVERS =
> 15MAX_SHARED_SERVERS = 30 MAX_DISPATCHERS = 20
> Os serviços do listener são:Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SERVIDOR-PRODUCAO)(PORT=1521)))Services
> Summary...Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc",
> status UNKNOWN, has 1 handler(s) for this service... Handler(s):
> "DEDICATED" established:0 refused:0 LOCAL SERVERService "prod" has 1
> instance(s). Instance "prod", status UNKNOWN, has 1 handler(s) for this
> service... Handler(s): "DEDICATED" established:442 refused:0
> LOCAL SERVERThe command completed successfully
> A configuração é a seguinte: Oracle 9.2.0.8, Linux RedHat 4.8 x86_64
> _____________________________
>
> Augusto César
>
>
>
>
> _________________________________________________________________
> Acesse seu Hotmail de onde quer que esteja através do celular. Clique aqui.
> http://www.windowslive.com.br/celular/home.asp?utm_source=MSN_Hotmail&utm_medium=Tagline&utm_campaign=MobileServices200908
>
> [As partes desta mensagem que não continham texto foram removidas]
>
