Ao tentar usar o SQL*PLUS:
C:\>sqlplus /nolog
SQL*Plus: Release 9.0.1.4.0 - Production on Sex Jul 13 16:19:10 2007
© Copyright 2001 Oracle Corporation. All rights reserved.
SQL> conn system as sysdba
Informe a senha:
ERROR:
ORA-12560: TNS:erro de adaptador de protocolo
C:\>tnsping db10g
TNS Ping Utility for 32-bit Windows: Version 9.0.1.4.1 - Production on 13-JUL-2007 15:50:12
Copyright © 1997 Oracle Corporation. All rights reserved.
Arquivos de parÔmetros usados:
C:\DevSuiteHome\network\admin\sqlnet.ora
Usado o adaptador TNSNAMES para resolver o apelido
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))) (CON
NECT_DATA = (SERVICE_NAME = DB10G)))
TNS-12541: TNS:nÒo hß listener
listener.ora
LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (ORACLE_HOME = /app/oracle/product/10.2.0) (SID_NAME = DB10G) ) (SID_DESC = (ORACLE_HOME = /app/oracle/product/9.2.0) (SID_NAME = DB9I) )
tnsnames.ora
DB10G = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = DB10G) ) )
Não há como configurar somente pelo Net Manager?
Agradeço desde já!
Edição feita por: Eclesiastes, 15/07/2007, 22:40.