Segue:
a)[oracle@dc-f-ora-prd01 ~]$ ps -efl | grep -i listener1 S zabbix 1821 1810
0 80 0 - 21239 - Jan28 ? 00:00:00 /usr/sbin/zabbix_agentd:
listener #1 [waiting for connection]1 S zabbix 1822 1810 0 80 0 - 21239
- Jan28 ? 00:00:00 /usr/sbin/zabbix_agentd: listener #2 [waiting
for connection]1 S zabbix 1823 1810 0 80 0 - 21239 - Jan28 ?
00:00:00 /usr/sbin/zabbix_agentd: listener #3 [waiting for connection]0 S
oracle 15253 15176 0 80 0 - 28174 pipe_w 13:16 pts/0 00:00:00 grep
--color=auto -i listener0 S oracle 30570 1 0 80 0 - 54347 poll_s
12:01 ? 00:00:13 /oracle/app/oracle/product/11.2.0.4/db_1/bin/tnslsnr
LISTENER -inherit
b)[oracle@dc-f-ora-prd01 ~]$ lsnrctl status listener
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-FEB-2019 13:19:07
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150..10)(PORT=1521)))STATUS
of the LISTENER------------------------Alias
LISTENERVersion TNSLSNR for Linux: Version 11.2.0.4.0 -
ProductionStart Date 22-FEB-2019 12:01:10Uptime
0 days 1 hr. 17 min. 57 secTrace Level offSecurity
ON: Local OS AuthenticationSNMP OFFListener Parameter
File
/oracle/app/oracle/product/11.2.0.4/db_1/network/admin/listener.oraListener Log
File
/oracle/app/oracle/diag/tnslsnr/dc-f-ora-prd01/listener/alert/log.xml
[oracle@dc-f-ora-prd01 ~]$ lsnrctl service listener
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-FEB-2019 13:19:53
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150..10)(PORT=1521)))Services
Summary...
[oracle@dc-f-ora-prd01 ~]$ ls -l $ORACLE_HOME/network/admintotal 48-rwxrwxr-x.
1 oracle oinstall 1807 Fev 22 07:58 listener.oradrwxrwxr-x. 2 oracle oinstall
64 Ago 30 2017 samples-rwxrwxr-x. 1 oracle oinstall 381 Dez 17 2012
shrept.lst-rwxrwxr-x. 1 oracle oinstall 32976 Fev 22 08:19
sqlnet.ora-rwxrwxr-x. 1 oracle oinstall 3513 Fev 12 14:32 tnsnames.ora
INBOUND_CONNECT_TIMEOUT_LISTENER = 220LISTENER = (DESCRIPTION_LIST =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.150.10)(PORT =
1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
) )
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/app/oracle/product/11.2.0.4/db_1) (PROGRAM =
extproc) ) (SID_DESC = (ORACLE_HOME =
/oracle/app/oracle/product/11.2.0.4/db_1) (SID_NAME = wickbold) )
(SID_DESC = (ORACLE_HOME = /oracle/app/oracle/product/11.2.0.4/db_1)
(SID_NAME = NFE) ) (SID_DESC = (ORACLE_HOME =
/oracle/app/oracle/product/11.2..0.4/db_1) (SID_NAME = MERCANET) )
(SID_DESC = (ORACLE_HOME = /oracle/app/oracle/product/11.2.0.4/db_1)
(SID_NAME = RM) ) (SID_DESC = (ORACLE_HOME =
/oracle/app/oracle/product/11.2.0.4/db_1) (SID_NAME = android) )
(SID_DESC = (ORACLE_HOME = /oracle/app/oracle/product/11.2.0.4/db_1)
(SID_NAME = nfehist) ) (SID_DESC = (ORACLE_HOME =
/oracle/app/oracle/product/11.2.0.4/db_1) (SID_NAME = LEGADOS) )
(SID_DESC = (ORACLE_HOME = /oracle/app/oracle/product/11.2.0.4/db_1)
(SID_NAME = WICKHIST) ) (SID_DESC = (ORACLE_HOME =
/oracle/app/oracle/product/11.2.0.4/db_1) (SID_NAME = CSC) )
(SID_DESC = (ORACLE_HOME = /oracle/app/oracle/product/11.2.0.4/db_1)
(SID_NAME = TAF) ) (SID_DESC = (ORACLE_HOME =
/oracle/app/oracle/product/11.2.0.4/db_1) (SID_NAME = TSS) )
c)[mastersaf@dc-f-ora-prd01 ~]$ ls -l $ORACLE_HOME/network/admintotal
48-rwxr-xr-x 1 oracle oinstall 700 Fev 22 13:21 listener.oradrwxr-xr-x 2
oracle oinstall 64 Jan 29 09:19 samples-rwxr-xr-x 1 oracle oinstall 1441
Ago 28 2015 shrept.lst-rwxr-xr-x 1 oracle oinstall 32976 Fev 22 08:19
sqlnet.ora-rwxr-xr-x 1 oracle oinstall 3513 Fev 12 14:32 tnsnames.ora
INBOUND_CONNECT_TIMEOUT_LISTENER = 220LISTENER12C = (DESCRIPTION_LIST =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.150.10)(PORT =
1522)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
) )
SID_LIST_LISTENER12C = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/app/oracle/product/12.2.0.1/db_1) (PROGRAM =
extproc) ) (SID_DESC = (ORACLE_HOME =
/oracle/app/oracle/product/12.2.0.1/db_1) (SID_NAME = msaf) )
[mastersaf@dc-f-ora-prd01 ~]$ lsnrctl status listener12c
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-FEB-2019 13:24:25
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150..10)(PORT=1522)))TNS-12541:
TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener
Linux Error: 111: Connection refusedConnecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))STATUS of the
LISTENER------------------------Alias LISTENERVersion
TNSLSNR for Linux: Version 11.2.0.4.0 - ProductionStart Date
22-FEB-2019 12:01:10Uptime 0 days 1 hr. 23 min. 15
secTrace Level offSecurity ON: Local OS
AuthenticationSNMP OFFListener Parameter File
/oracle/app/oracle/product/11.2.0.4/db_1/network/admin/listener.oraListener Log
File
/oracle/app/oracle/diag/tnslsnr/dc-f-ora-prd01/listener/alert/log.xmlListening
Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.150.10)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))Services Summary...Service
"CSC" has 2 instance(s). Instance "CSC", status UNKNOWN, has 1 handler(s) for
this service... Instance "CSC", status READY, has 1 handler(s) for this
service...Service "LEGADOS" has 1 instance(s). Instance "LEGADOS", status
UNKNOWN, has 1 handler(s) for this service...Service "MERCANET" has 2
instance(s). Instance "MERCANET", status UNKNOWN, has 1 handler(s) for this
service... Instance "mercanet", status READY, has 1 handler(s) for this
service...Service "NFE" has 2 instance(s). Instance "NFE", status UNKNOWN, has
1 handler(s) for this service... Instance "NFE", status READY, has 1
handler(s) for this service...Service "PLSExtProc" has 1 instance(s). Instance
"PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...Service "RM"
has 2 instance(s). Instance "RM", status UNKNOWN, has 1 handler(s) for this
service... Instance "rm", status READY, has 1 handler(s) for this
service...Service "ROADNET" has 1 instance(s). Instance "ROADNET", status
READY, has 1 handler(s) for this service...Service "TAF" has 2 instance(s).
Instance "TAF", status UNKNOWN, has 1 handler(s) for this service... Instance
"TAF", status READY, has 1 handler(s) for this service...Service "TRADE" has 1
instance(s). Instance "TRADE", status READY, has 1 handler(s) for this
service...Service "TSS" has 2 instance(s). Instance "TSS", status UNKNOWN, has
1 handler(s) for this service... Instance "TSS", status READY, has 1
handler(s) for this service...
[mastersaf@dc-f-ora-prd01 ~]$ lsnrctl service listener12c
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-FEB-2019 13:25:11
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.150..10)(PORT=1522)))TNS-12541:
TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener
Linux Error: 111: Connection refusedConnecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))Services Summary...Service
"CSC" has 2 instance(s). Instance "CSC", status UNKNOWN, has 1 handler(s) for
this service... Handler(s): "DEDICATED" established:13 refused:0
LOCAL SERVER Instance "CSC", status READY, has 1 handler(s) for this
service... Handler(s): "DEDICATED" established:359 refused:0
state:ready LOCAL SERVERService "LEGADOS" has 1 instance(s). Instance
"LEGADOS", status UNKNOWN, has 1 handler(s) for this service.... Handler(s):
"DEDICATED" established:0 refused:0 LOCAL SERVERService "MERCANET"
has 2 instance(s). Instance "MERCANET", status UNKNOWN, has 1 handler(s) for
this service... Handler(s): "DEDICATED" established:5 refused:0
LOCAL SERVER Instance "mercanet", status READY, has 1 handler(s) for this
service... Handler(s): "DEDICATED" established:672 refused:0
state:ready LOCAL SERVERService "NFE" has 2 instance(s). Instance
"NFE", status UNKNOWN, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:143 refused:0 LOCAL SERVER Instance "NFE",
status READY, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:535 refused:0 state:ready LOCAL SERVERService
"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 "RM" has 2 instance(s). Instance "RM",
status UNKNOWN, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:15 refused:0 LOCAL SERVER Instance "rm",
status READY, has 1 handler(s) for this service... Handler(s):
"DEDICATED" established:1228 refused:0 state:ready LOCAL SERVERService
"ROADNET" has 1 instance(s). Instance "ROADNET", status READY, has 1
handler(s) for this service... Handler(s): "DEDICATED" established:83
refused:0 state:ready LOCAL SERVERService "TAF" has 2 instance(s).
Instance "TAF", status UNKNOWN, has 1 handler(s) for this service...
Handler(s): "DEDICATED" established:1 refused:0 LOCAL SERVER
Instance "TAF", status READY, has 1 handler(s) for this service...
Handler(s): "DEDICATED" established:411 refused:0 state:ready
LOCAL SERVERService "TRADE" has 1 instance(s). Instance "TRADE", status READY,
has 1 handler(s) for this service.... Handler(s): "DEDICATED"
established:54 refused:0 state:ready LOCAL SERVERService "TSS" has 2
instance(s). Instance "TSS", status UNKNOWN, has 1 handler(s) for this
service...
Abs.Márcio
Em sexta-feira, 22 de fevereiro de 2019 13:11:00 BRT,
jlchia...@yahoo.com.br [oracle_br] <oracle_br@yahoogrupos.com.br> escreveu:
Tá : antes de mais nada, ACREDITO que pelo que vc mostrou, vc NÂO TEM a
variável TNS_ADMIN setada, né ? Se tiver, remova-a ou atualize pra ela apontar
acredito que vc vai ir pro caminho de DESATIVAR o Listener da versão 11g, e ter
o Listener 12c (na porta default 1521, então não precisa setar LOCAL_LISTENER)
atendendo as duas instâncias, certo ? Então pergunto de nov, na hora de PARAR o
Listener 11g vc ESTAVA com ORACLE_HOME e PATH setadas ?? Vc PAROU o listener
11g com lsnrct stop nomedolistener11g, né ? Feito isso, na hora de CRIAR e
CONFIGURAR o listener 12c , vc SETOU ORACLE_HOME e PATH pra apontarem
respectivamente pra home 12c E para o diretório BIN da home 12c, antes de
chamar o configurador netca ?? Depois disso, AINDA com a ORACLE_HOME e o PATH
corretos, vc CONFIRMOU que a config foi gravada OK (com um cat
$ORACLE_HOME/network/admin/nomedolistener.ora) , e isso ok vc STARTOU o
listener 12c, com lsnrctl start nomedolistener12c ?? SE FEZ TUDO ISSO, não tem
porque as duas instâncias não terem se registrado nesse novo listener 12c....
SE TUDO foi feito ok, faça no prompt de comando e copia/cola numa msg e mostra
pra gente poder confirmar :
a. um ps -efl | grep -i listener
b. muda pro ambiente 11g e CONFIRMA que o listener 11g tá inativo, digitando :
export ORACLE_UNQNAME=ORCL
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/db_1
export ORACLE_SID=ORCL
export ORACLE_TERM=xterm
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
lsnrctl status nomedolistener11g
lsnrctl service nomedolistener11g
ls -l $ORACLE_HOME/network/admin
cat $ORACLE_HOME/network/admin/nomedolistener11g.ora
c. muda pro ambiente 12c, mostra a config dele E o status :
export ORACLE_UNQNAME=mastersaf
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1
export ORACLE_SID=msaf
export ORACLE_TERM=xterm
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
ls -l $ORACLE_HOME/network/admin
cat $ORACLE_HOME/network/admin/nomedolistener11g.ora
lsnrctl status nomedolistener11g
lsnrctl service nomedolistener11g
e vamos ver o que vc tem aí.....
[]s
Chiappa
#yiv6675884816 #yiv6675884816 -- #yiv6675884816ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6675884816
#yiv6675884816ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6675884816
#yiv6675884816ygrp-mkp #yiv6675884816hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6675884816 #yiv6675884816ygrp-mkp #yiv6675884816ads
{margin-bottom:10px;}#yiv6675884816 #yiv6675884816ygrp-mkp .yiv6675884816ad
{padding:0 0;}#yiv6675884816 #yiv6675884816ygrp-mkp .yiv6675884816ad p
{margin:0;}#yiv6675884816 #yiv6675884816ygrp-mkp .yiv6675884816ad a
{color:#0000ff;text-decoration:none;}#yiv6675884816 #yiv6675884816ygrp-sponsor
#yiv6675884816ygrp-lc {font-family:Arial;}#yiv6675884816
#yiv6675884816ygrp-sponsor #yiv6675884816ygrp-lc #yiv6675884816hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6675884816
#yiv6675884816ygrp-sponsor #yiv6675884816ygrp-lc .yiv6675884816ad
{margin-bottom:10px;padding:0 0;}#yiv6675884816 #yiv6675884816actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6675884816
#yiv6675884816activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6675884816
#yiv6675884816activity span {font-weight:700;}#yiv6675884816
#yiv6675884816activity span:first-child
{text-transform:uppercase;}#yiv6675884816 #yiv6675884816activity span a
{color:#5085b6;text-decoration:none;}#yiv6675884816 #yiv6675884816activity span
span {color:#ff7900;}#yiv6675884816 #yiv6675884816activity span
.yiv6675884816underline {text-decoration:underline;}#yiv6675884816
.yiv6675884816attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6675884816 .yiv6675884816attach div a
{text-decoration:none;}#yiv6675884816 .yiv6675884816attach img
{border:none;padding-right:5px;}#yiv6675884816 .yiv6675884816attach label
{display:block;margin-bottom:5px;}#yiv6675884816 .yiv6675884816attach label a
{text-decoration:none;}#yiv6675884816 blockquote {margin:0 0 0
4px;}#yiv6675884816 .yiv6675884816bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6675884816
.yiv6675884816bold a {text-decoration:none;}#yiv6675884816 dd.yiv6675884816last
p a {font-family:Verdana;font-weight:700;}#yiv6675884816 dd.yiv6675884816last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6675884816
dd.yiv6675884816last p span.yiv6675884816yshortcuts
{margin-right:0;}#yiv6675884816 div.yiv6675884816attach-table div div a
{text-decoration:none;}#yiv6675884816 div.yiv6675884816attach-table
{width:400px;}#yiv6675884816 div.yiv6675884816file-title a, #yiv6675884816
div.yiv6675884816file-title a:active, #yiv6675884816
div.yiv6675884816file-title a:hover, #yiv6675884816 div.yiv6675884816file-title
a:visited {text-decoration:none;}#yiv6675884816 div.yiv6675884816photo-title a,
#yiv6675884816 div.yiv6675884816photo-title a:active, #yiv6675884816
div.yiv6675884816photo-title a:hover, #yiv6675884816
div.yiv6675884816photo-title a:visited {text-decoration:none;}#yiv6675884816
div#yiv6675884816ygrp-mlmsg #yiv6675884816ygrp-msg p a
span.yiv6675884816yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6675884816
.yiv6675884816green {color:#628c2a;}#yiv6675884816 .yiv6675884816MsoNormal
{margin:0 0 0 0;}#yiv6675884816 o {font-size:0;}#yiv6675884816
#yiv6675884816photos div {float:left;width:72px;}#yiv6675884816
#yiv6675884816photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv6675884816
#yiv6675884816photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6675884816
#yiv6675884816reco-category {font-size:77%;}#yiv6675884816
#yiv6675884816reco-desc {font-size:77%;}#yiv6675884816 .yiv6675884816replbq
{margin:4px;}#yiv6675884816 #yiv6675884816ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6675884816 #yiv6675884816ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6675884816
#yiv6675884816ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6675884816
#yiv6675884816ygrp-mlmsg select, #yiv6675884816 input, #yiv6675884816 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6675884816
#yiv6675884816ygrp-mlmsg pre, #yiv6675884816 code {font:115%
monospace;}#yiv6675884816 #yiv6675884816ygrp-mlmsg *
{line-height:1.22em;}#yiv6675884816 #yiv6675884816ygrp-mlmsg #yiv6675884816logo
{padding-bottom:10px;}#yiv6675884816 #yiv6675884816ygrp-msg p a
{font-family:Verdana;}#yiv6675884816 #yiv6675884816ygrp-msg
p#yiv6675884816attach-count span {color:#1E66AE;font-weight:700;}#yiv6675884816
#yiv6675884816ygrp-reco #yiv6675884816reco-head
{color:#ff7900;font-weight:700;}#yiv6675884816 #yiv6675884816ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6675884816 #yiv6675884816ygrp-sponsor
#yiv6675884816ov li a {font-size:130%;text-decoration:none;}#yiv6675884816
#yiv6675884816ygrp-sponsor #yiv6675884816ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6675884816
#yiv6675884816ygrp-sponsor #yiv6675884816ov ul {margin:0;padding:0 0 0
8px;}#yiv6675884816 #yiv6675884816ygrp-text
{font-family:Georgia;}#yiv6675884816 #yiv6675884816ygrp-text p {margin:0 0 1em
0;}#yiv6675884816 #yiv6675884816ygrp-text tt {font-size:120%;}#yiv6675884816
#yiv6675884816ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6675884816
