1 Reply Latest reply on Dec 2, 2004 7:37 PM by 433977

    NCR-00002: NCR: Invalid usage

    433977
      Hi all,

      Just installed Oracle 9.2.0.4 or RedHat Linux AS 2.1

      When ORACLE_SID is set in environment I can connect without any problem to the database I created using:
      # sqlplus user/password

      It is when I am using:
      #sqlplus user/password@bluetest
      that things start to fall apart. I am getting ORA-03113: end-of-file on communication channel.

      # tnsping bluetest works fine though.

      In $ORACLE_HOME/rdbms/log/bluetest_agt_XXXX.trc I found the following that explains the problem I guess. If only I would understand what it is trying to tell me, I may be able to solve the problem and correct ok. Here is what I found:
      Oracle Corporation --- THURSDAY DEC 02 2004 20:13:11.018


      Heterogeneous Agent Release
      9.2.0.4.0


      HS Agent diagnosed error on initial communication,
      probable cause is an error in network administration
      Network error 2: NCR-00002: NCR: Invalid usage

      There is one other post on this forum - actually only found 1 entry using google :-( but that is somebody having trouble setting up Transparent Gateway for Ms Sql Server. That post indicated that there could be something wrong with tnsnames.ora and listener.ora I am posting those for completeness' sake.

      TNSNAMES.ORA:
      # TNSNAMES.ORA Network Configuration File: /home/oracle/OraHome1/network/admin/tnsnames.ora
      # Generated by Oracle configuration tools.

      EXTPROC_CONNECTION_DATA.LOCALDOMAIN =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )

      BLUETEST.LOCALDOMAIN =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )
      (CONNECT_DATA =
      (SID = bluetest)
      (SERVER = DEDICATED)
      )
      )

      LISTENER.ORA:
      # LISTENER.ORA Network Configuration File: /home/oracle/OraHome1/network/admin/listener.ora
      # Generated by Oracle configuration tools.

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
      )
      )
      )

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/OraHome1)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (SID_NAME = bluetest)
      (ORACLE_HOME = /home/oracle/OraHome1)
      (PROGRAM = extproc)
      )
      )

      Thanks in advance (and sorry for this lenghtly post).

      Rudi.