ERROR ORA-12514 – TNS listener não…

[airoospParticipante]

Boa tarde, beleza?

Aqui também tenho o Oracle 11g XE em Windows, seguem as configurações dos arquivos:

LISTENER.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = “nome da máquina”)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

SQLNET.ORA

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 = (NONE)

SQLNET.AUTHENTICATION_SERVICES = (NTS)

NAMES.DEFAULT_DOMAIN = us.oracle.com

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT, ONAMES )

TNSNAMES.ORA

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = “nome da máquina”)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

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

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

.
.
.
.
.

Tenho também as variáveis de ambiente ORACLE_SID=XE e a TNS_ADMIN apontando para a pasta onde estão os arquivos LISTENER.ORA, SQLNET.ORA e TNSNAMES.ORA.

Veja se ajuda.

Obrigado.

Airton