4 Replies Latest reply: Aug 4, 2010 6:58 AM by Lokanath Giri RSS

    ORA-28575: unable to open RPC connection to external procedure agent

    Lokanath Giri
      Hi,

      When I installed the database I missed out the Domain_Name.
      SQL> SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME = 'db_domain'; 
      
      NAME                                                                             VALUE
      -------------------------------------------------------------------------------- -------------------
      db_domain
      I modified DB_Domain to world as follows
      alter system set db_domain=world scope=spfile
      After this my database console didn't startup so I reverted back with
      alter system set db_domain='' scope=spfile
      Now database console is OK but I am getting error
      ORA-28575: unable to open RPC connection to external procedure agent

      Can anybody help in this matter.

      Thanks

      Regards,
      Lokanath
        • 1. Re: ORA-28575: unable to open RPC connection to external procedure agent
          618702
          Dear Lokanath Giri,

          Please check below link and read the error description first;

          http://ora-28575.ora-code.com/

          So you need to see the extproc lines in the listener.ora file.

          Can you please show us the listener.ora and tnsnames.ora files located under $ORACLE_HOME/network/admin.

          Hope That Helps.

          Ogan
          • 2. Re: ORA-28575: unable to open RPC connection to external procedure agent
            Lokanath Giri
            TNSNAME.ora
            orcl=
              (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = Server.in.bosch.com)(PORT = 1521))
                (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = orcl)
                )
              )
            
            orcl1=
              (DESCRIPTION =
                (ADDRESS = (PROTOCOL = TCP)(HOST = Server.in.bosch.com)(PORT = 1521))
                (CONNECT_DATA =
                  (SERVER = DEDICATED)
                  (SERVICE_NAME = orcl1)
                )
              )
            
            EXTPROC_CONNECTION_DATA =
              (DESCRIPTION =
                (ADDRESS_LIST =
                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                )
                (CONNECT_DATA =
                  (SID = PLSExtProc)
                  (PRESENTATION = RO)
                )
              )
            Listener.ora
            # Generated by Oracle configuration tools.
            
            LISTENER =
              (DESCRIPTION_LIST =
                (DESCRIPTION =
                  (ADDRESS = (PROTOCOL = TCP)(HOST = server.in.bosch.com)(PORT = 1521))
                  (ADDRESS = (PROTOCOL = IPC)(KEY = PLSExtProc))
                )
              )
            
            SID_LIST_LISTENER =
              (SID_LIST =
                (SID_DESC =
                  (GLOBAL_DBNAME = orcl1.world)
                  (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
                  (SID_NAME = orcl1)
                )
                (SID_DESC =
                  (GLOBAL_DBNAME = orcl.world)
                  (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
                  (SID_NAME = orcl)
                )
                (SID_DESC =
                  (PROGRAM = D:\oracle\product\10.2.0\db_1\bin\extproc)
                  (SID_NAME = PLSExtProc)
                  (ENVS = "EXTPROC_DLLS=ANY")
                  (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
                )
              )
            
            DIRECT_HANDOFF_TTC_LISTENER=OFF
            • 3. Re: ORA-28575: unable to open RPC connection to external procedure agent
              618702
              What happens when you run below command as the Oracle user?;
              # tnsping Server.in.bosch.com
              Ogan
              • 4. Re: ORA-28575: unable to open RPC connection to external procedure agent
                Lokanath Giri
                C:\WINDOWS\system32>tnsping server.in.bosch.com
                
                TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 04-AUG-2010 17:14:04
                
                Copyright (c) 1997, 2006, Oracle.  All rights reserved.
                
                Used parameter files:
                D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
                
                Used HOSTNAME adapter to resolve the alias
                Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=server.in.bosch.com))(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx)(PORT=1521)))
                OK (10 msec)
                Regards,
                Lokanath