Boa tarde galera,

Já faz alguns anos que não trabalho com Oracle. Agora estou começando novamente.

Temos aqui na empresa um banco Oracle 8 rodando tudo certo.

Estou tentando conectar pelo SQL Developer mas não consigo, já tentei por Conexão Básica e TNS.

No server eu tenho os seguintes arquivo:

LISTENER.ORA

>

LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= IPC)
(KEY= oracle.world)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= ORCL)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= EXTPROC0)
)
(ADDRESS=
(COMMUNITY= NMP.world)
(PROTOCOL= NMP)
(SERVER= DAVINCI)
(PIPE= ORAPIPE)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= DaVinci)
(Port= 1521)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= DaVinci)
(Port= 1526)
)
(ADDRESS=
(PROTOCOL= TCP)
(Host= 127.0.0.1)
(Port= 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = 0
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DaVinci)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
PASSWORDS_LISTENER = (oracle)

SQLNET.ORA

>

TRACE_LEVEL_CLIENT = OFF
#sqlnet.authentication_services = (NONE)
names.directory_path = (TNSNAMES, HOSTNAME)
names.default_domain = world
name.default_zone = world
automatic_ipc = off

TNSNAMES.ORA

>

F:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:F:\Orant\net80\admin\tnsnames.ora

Generated by Oracle Net8 Assistant

DAVINCI.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.251)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)

CMEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = tcp)(PORT = 1610)(HOST = CM_SERVER))
(ADDRESS = (PROTOCOL = tcp)(PORT = 1521)(HOST = LSNR_SERVER))
)
(CONNECT_DATA = (SID = ORCL))
(SOURCE_ROUTE = yes)
)

TCPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = Production1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))
)

NMPEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe = ORAPIPE))
(CONNECT_DATA = (SID = ORCL))
)

SOCRATES.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.251)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)

EXTPROC_CONNECTION_DATA.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(CONNECT_DATA = (SID = extproc))
)

BEQ-LOCAL.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 = oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
(CONNECT_DATA = (SID = ORCL))
)

SPXEXAMPLE.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
(CONNECT_DATA = (SID = ORCL))
)

TCP-LOOPBACK.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))
)

Eu preciso me conectar no SOCRATES.WORLD, como devo fazer para conectar pelo SQL Developer?

Valeu, abraço!