Boa noite.
Após ver alguns vídeos no youtube e procurar na net não consegui conectar meu BD pra continuar o curso. To usando ubuntu 20.4. LTS. Tentei os comandos no terminal:
lsnrctl start que me retornou:
`LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-JUL-2021 21:41:28
Copyright (c) 1991, 2011, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
Posteriomente com o comando: lsnrctl status
retorno:
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-JUL-2021 21:43:12
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production Start Date 20-JUL-2021 21:26:31 Uptime 0 days 0 hr. 16 min. 40 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service XE Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
`
Ou seja, parece que está ok. Quando abro o BD e digito a senha, recebo a mensagem do título.
Eu estava usando normalmente, porém meu pc travou e precisei reiniciar. Quando voltei, só recebo essa mensagem.
Se tiverem alguma ideia, agradeço.
tsnames.ora:
(ADDRESS=
[ (COMMUNITY=<community_name>) ]
(PROTOCOL=tcp)
(HOST=<hostname>)
(PORT=<portnumber (1521 is a standard port used)>)
)
