Re: emca fails to create database control repository with ORA-01034

From: Frank R. <trek1s_at_gmail.com>
Date: Sat, 19 Jan 2008 12:25:45 -0800 (PST)
Message-ID: <24a6e58d-bc36-4475-b8f4-55b3c35e2461@f10g2000hsf.googlegroups.com>


On Jan 19, 7:38 pm, "allen.dar..._at_gmail.com" <allen.dar..._at_gmail.com> wrote:
> You might check the TNSNAME.ora file.
>
> Check on both the client machine and server.

Thanks for the suggestion.

OracleNet configuration seems to be correct (at least, client connections through the listener are opened properly).

Anyway, these are listener.ora and tnsnames.ora, just in case someone can point something wrong out.

#Listener.ora
LISTENER_10gr2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = pegasus)(PORT = 1521))     )
  )

SID_LIST_LISTENER_10gr2 =
  (SID_LIST =
    (SID_DESC =

      (ORACLE_HOME = /oracle/app/oracle/product/10.2.0 )
      (SID_NAME = 10gr2)

    )
  )

#tnsnames.ora
10gr2, 10gr2.WORLD=

   (DESCRIPTION=

      (ADDRESS_LIST=
         (ADDRESS=(PROTOCOL=TCP)(HOST=pegasus)(PORT=1521))
      )
      (CONNECT_DATA=
        (SID = 10gr2)
        (SERVER = DEDICATED)
      )

   )

I'll keep troubleshooting.

regards Received on Sat Jan 19 2008 - 14:25:45 CST

Original text of this message