Delphi 2007 x Oracle XE

Delphi

27/04/2009

Boa noite Amigos, estou com um problema, n�o consigo conexao com o Oracle 10g XE que est� instalado localmente. Utilizo o win vista ultimate x64, delphi 2007, oracle XE.
ao tentar conectar recebo o erro ORA - 12154. J� nao sei mais o que fazer pois pelo delphi nao consigo conectar, por�m pelo endereco
http://127.0.0.1:8080/apex vai normalmente e pelo Aqua Data Studio (muito bom esse prg para manutencao no BD) tamb�m conecto sem problemas.

tnsnames.ora
C�digo:

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = josehenrique-pc )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

listener.ora
C�digo:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = extproc)
    )
#  (SID_LIST =
    (SID_DESC =
      (SID_NAME = XE)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
      (PROGRAM = extproc)
    )

  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = JoseHenrique-PC)(PORT = 1521))
    )
  )

DEFAULT_SERVICE_LISTENER = (XE)

sqlnet.ora
C�digo:

# This file is actually generated by netca. But if customers choose to
 install "Software Only", this file wont exist and without the native
 authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

por favor me ajudem , j� nao sei mais o que fazer ....pensei em at� instalar o server e o client na minha maquina para ver se esse eh o problema, mas achei que tento o server nao preciso do cliente correto??

Josehenrique

Curtidas 0

POSTAR