Oracle/백업 & 복구 & 장애

EM Agent Connection to Instance 오류

타울 2012. 3. 29. 17:14


listener.ora

# listener.ora Network Configuration File: /home/oracle/product/10g/network/admin/listener.ora

# Generated by Oracle configuration tools.


SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = testdb)

      (ORACLE_HOME = /home/oracle/product/10g)

    )

  )


LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))

      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))

    )

  )




tnsnames.ora 

 tnsnames.ora Network Configuration File: /home/oracle/product/10g/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.


TESTDB =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = testdb)

    )

  )


EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))

    )

    (CONNECT_DATA =

      (SID = testdb)

    )

  )