Configurei com sucesso meu banco de dados e posso fazer algumas consultas por meio do meu wxplorer da webiste
http://localhost:8080/apex/f?p=4500:1003:1042268341573744::NO:::
Mas, quando baixei o 4.1.5 Sql Developer com o pacote jdk, quando eu clico em New Connection e digitei:
Nome da conexão: MYONLINEEDU_XE
Nome de usuário: MYONLINEEDU
Senha: admin123
Quando clico em Conectar, recebo um erro:
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
no meu caminho C: \ app \ Stefan \ produto \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN aqui está meu tnsnames (adicionei configurações orcl):
# tnsnames.ora Network Configuration File: C:\app\Stefan\product.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE NAME = orcl)
)
)
Eu até tentei iniciar o serviço LSNRCTL, mas ele já foi iniciado.
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
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 SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:16 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: STEFAN-PC, pid: 2664>
(ADDRESS=(PROTOCOL=tcp)(HOST=STEFAN-PC)(PORT=18879))
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:71 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: STEFAN-PC, pid: 5228>
(ADDRESS=(PROTOCOL=tcp)(HOST=STEFAN-PC)(PORT=1547))
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
Também no meu sistema 32 / hosts eu adicionei 127.0.0.1 localhost
Como remover esse erro e conectar-se ao meu banco de dados?
Obrigado!