Menu de navegação

[Anônimo]

Sempre que tento levantar minha estância da esse erro.
Parece que esta tudo certo com meu listner, no log aparentemente ta dando falta de alguma coisa TNS_ADMIN. Será que eu terei que reinstalar alguma coisa?

ORA-12500: TNS:listener falhou ao iniciar um processo de servidor dedicado

Make sure connection parameters are correct and try again

Connection trace
oci.dll found
2) Oracle Home Key is SOFTWAREORACLEHOME0
Looking for TNS_ADMIN environmental variable
TNS_ADMIN environmental variable doesnt exist,
looking for TNS_ADMIN reg key using home key: >SOFTWAREORACLEHOME0< TNS_ADMIN does not exist in SOFTWAREORACLEHOME0 looking for TNS_ADMIN reg key in Oracle: >SOFTWAREORACLEHOME0< Looking for OracleHomeKeyORACLE_HOME Oracle Path is now C:oracleora90NetworkAdmin Looking for C:oracleora90NetworkAdmintnsnames.ora tnsnames.ora found tnsnames entry: DESENV tnsnames entry: IV02 tnsnames entry: IV04 tnsnames.ora found tnsnames entry: DESENV tnsnames entry: IV02 tnsnames entry: IV04 2) Oracle Home Key is SOFTWAREORACLEHOME0 Looking for TNS_ADMIN environmental variable TNS_ADMIN environmental variable doesnt exist, looking for TNS_ADMIN reg key using home key: >SOFTWAREORACLEHOME0< TNS_ADMIN does not exist in SOFTWAREORACLEHOME0 looking for TNS_ADMIN reg key in Oracle: >SOFTWAREORACLEHOME0< Looking for OracleHomeKeyORACLE_HOME Oracle Path is now C:oracleora90NetworkAdmin Looking for C:oracleora90NetworkAdmintnsnames.ora tnsnames.ora found tnsnames entry: DESENV tnsnames entry: IV02 tnsnames entry: IV04 tnsnames.ora found tnsnames entry: DESENV tnsnames entry: IV02 tnsnames entry: IV04 tnsnames.ora

####################################
# TNSNAMES.ORA Configuration File:C:oracleora90NETWORKADMINtnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date……….: Tue Jul 11 10:43:23 GMT-03:00 2006
####################################

DESENV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gv00336543)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = DESENV))
)

IV02 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.184.79)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = iv02))
)

IV04 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ivcsta001)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = iv04))
)

[rosterneParticipante]

Set o TNS_ADMIN, que é a variavel que aponta pra o Tnsnames.ora e listener.ora.

“set TNS_ADMIN = $ORACLE_HOMENETWORKADMIN”

ou

My computer -> Properties -> Advanced -> Environment Variables -> System Variables -> New…

Variable Name: TNS_ADMIN
Variable Value: $ORACLE_HOMENETWORKADMIN
OK

Abraço.

[Autor]

Posts