Pular para o conteúdo

Fóruns Banco de dados Oracle Erro ORA-12514 10G para 8.0.5 Erro ORA-12514 10G para 8.0.5

#91081
airoosp
Participante

    O problema esta na hora de fazer a conexão com o servidor S1, segue abaixo o conteúdo do arquivo tnsnames.ora

    tnsnames.ora Network Configuration File: D:oracleproduct10.2.0db_1networkadmintnsnames.ora

    Generated by Oracle configuration tools.

    M1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.5.15)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ORCL)
    )
    )

    BANCO_TESTE =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.5.212)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ORCL)
    )
    )

    P1 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.5.6)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = ORCL)
    )
    )

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = bd10g.cen)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )

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

    S1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.5.16)(PORT = 1521))
    (CONNECT_DATA =
    (SERVICE_NAME = orcl)
    )
    )

    Obrigado.

    Airton