6 Replies Latest reply: Oct 31, 2008 9:41 AM by user477000 RSS

    ORA-28575:

    user477000
      Hi everyone.
      Env: Oracle 11g, WinXPSP2. VS2008 SP1
      I have problem with .NET Stored procedures. I already spent few days tring to figure out what is the source of my problem (Including going through similar/identical posts here), unfortunately I could not find a solution.
      After deploying an assembly -succesfully, I get :
      ORA-28575: unable to open RPC connection to external procedure agent
      ORA-06512: at "SYS.DBMS_CLR", line 243
      ORA-06512: at "MYUSER.FUNCTIONNAME", line 6

      I cant see what's wrong. Any feedback's appreciated.
      Thanks in advance

      tnsnames:

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

      EXTPROC_CONNECTION_DATA=
      (DESCRIPTION=
      (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))
      (CONNECT_DATA=
      (SID=plsextproc)))

      ORACLR_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
      )
      )

      listener.ora
      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
      )
      )

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\11.1.0\db_1)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oracle\product\11.1.0\db_1)
      (PROGRAM = extproc)
      )
      (SID_DESC =
      (SID_NAME = ORCL)
      (ORACLE_HOME = C:\oracle\product\11.1.0\db_1)
      )
      )
        • 1. Re: ORA-28575:
          502182
          Please try changing key from EXTPROC1 to EXTPROC1521 for ORACLR_CONNECTION_DATA in tnsnames.ora. As I can see that EXTPROC1521 is the key mentioned in listener.ora.
          • 2. Re: ORA-28575:
            user477000
            Thanks it was a it. I wonder Though, why installer generated those different keys anyway?
            Regards
            • 3. Re: ORA-28575:
              502182
              Will it be possible for you to explain your exact installation steps? It will help in tracking down if it was an installer bug.
              • 4. Re: ORA-28575:
                user477000
                I installed 11g. Then VStudio 2008.
                I figured out that I forgot to install Oracle Database Extension for .NET, so I run Installator and added it.
                That'd be all.
                I have another question but this goes to another thread
                • 5. Re: ORA-28575:
                  502182
                  I spent some time in reproducing this problem but I could not! I tried custom installation and custom database options but the entries were all fine. However by installing ODE component later, I could not automatically get the tns/listener entries created (such as ORACLR_CONNECTION_DATA) etc.

                  By any chance did you upgrade from 10gR2 to 11g database? Or was it a fresh installation?
                  • 6. Re: ORA-28575:
                    user477000
                    It was a fresh 11g installation. I had some issues with choosing a proper home for ODE installation - it was not that obvious for which one I should choose.