Estou com problemas em conectar a Instãncia !

[Mantek 0]

Quem poder me dar um apoio com está configuração, obrigado.

 

Meu Db é oracle.com

Sid=hir

 

ORA-28547: conexão com o servidor falhou; provável erro de admin do Oracle Net (DBD ERROR: OCISessionBegin)

 

Arquivo tnsnames.ora abaixo:

 

 

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

 

oracle.com=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = mentrix)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = hir.oracle.com)

)

)

 

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = hir)

(PRESENTATION = RO)

)

)

 

 

 

 

O Arquivo listener.ora abaixo:

 

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = hir)

(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)

(PROGRAM = extproc)

)

)

 

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = mentrix)(PORT = 1521))

)

)

[Motta 645]

Nunca vi isto, o manual informa isto :

 

ORA-28547: connection to server failed, probable Oracle Net admin error
    Cause: A failure occurred during initialization of a network connection from a client process to the Oracle server. 
The connection was completed but a disconnect occurred while trying to perform protocol-specific initialization, 
usually due to use of different network protocols by opposite sides of the connection. This usually is caused by 
incorrect Oracle Net administrative setup for database links or external procedure calls. The most frequent specific 
causes are: -- The connection uses a connect string which refers to a Heterogeneous Services agent instead of an 
Oracle server. -- The connection uses a connect string which includes an (HS=) specification. -- Hitting Ctrl+C before 
connection initialization is complete. -- Using DRCP on Windows with SQLNET.AUTHENTICATION_SERVICES set to NTS. -- 
Connection timeout due to SQLNET.INBOUND_CONNECT_TIMEOUT parameter when all shared servers are busy in shared server configuration.
    Action: Check Oracle Net administration in the following ways: -- When using TNSNAMES.ORA or an Oracle Names server, 
make sure that the client connection to the Oracle server uses the correct service name or SID. -- Check LISTENER.ORA on the connection end point's host machine to assure that this service name or SID refers to the correct server. -- 
Confirm in 
TNSNAMES.ORA or the equivalent service definition that the connect string does not contain (HS=). -- Set SQLNET.AUTHENTICATION_SERVICES to NONE when using DRCP on Windows.

Já tentei verificar isto ?

[Andre Renato 0]

Experimente configurar o tnsnames assim:

 

hir=
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = mentrix)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
        (SERVICE_NAME = hir)
     )
)

[alphamek 2]

Olá,

 

Seu DBNAME é Oracle.com ou é o DB_DOMAIN?

 

Tente não usar o SERVICE_NAME nesse momento e realize uma configuração baseado no SID.

 

Abraços,