主页 / user-10757

hmmftg's questions

Martin Hope
hmmftg
Asked: 2012-08-15 09:46:40 +0800 CST
  • 1

在 Oracle 10g 中，我有一个监听器问题，

这是 tnsnames.ora ：

MYTNS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = 
       (PROTOCOL = TCP)
       (HOST = testiold)
       (PORT = 1521)
      )
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mysid)
    )
  )

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

和 listener.ora：

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = mysid)
      (ORACLE_HOME = /oracle/10.2.4/db/OraHome_1)
      (SID_NAME = mysid)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
     (ADDRESS_LIST =
      (ADDRESS = 
        (PROTOCOL = TCP)
        (HOST = testiold)
        (PORT = 1521)
      )
     )
    )
  )

问题是我无法使用此配置启动侦听器，当我尝试lsnrctl start时，我得到了这个：

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 14-AUG-2012 22:11:44

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /oracle/10.2.4/db/OraHome_1/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
System parameter file is /oracle/10.2.4/db/OraHome_1/network/admin/listener.ora
Log messages written to /oracle/10.2.4/db/OraHome_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testiold)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testiold)(PORT=1521)))
TNS-12535: TNS:operation timed out
 TNS-12560: TNS:protocol adapter error
  TNS-00505: Operation timed out
   IBM/AIX RISC System/6000 Error: 78: Connection timed out

每当我尝试连接到数据库时，它都会说：

ORA-28547: connection to server failed, probable Oracle Net admin error

你能帮我么？

oracle listener
Martin Hope
hmmftg
Asked: 2012-08-15 07:14:08 +0800 CST
  • 2

我有一个应该从 pl/sql 函数调用的 C 库，所以我创建了一个 .so 库，然后创建了一个 pl/sql 函数来调用它。

C源（libcprog.c）是这样的：

int exec_hmmftg ( char *p1 , char *p2, char *p3 ){}

oracle数据库中的库是：

CREATE LIBRARY CPROGLIB UNTRUSTED AS '/libcprog.so';

创建的 pl/sql 函数是：

CREATE OR REPLACE FUNCTION CALL_C_PROGRAM(P1    IN     VARCHAR2,
                                          P2    IN     VARCHAR2,
                                          P3    IN OUT VARCHAR2)
    RETURN BINARY_INTEGER 
    IS EXTERNAL NAME "exec_hmmftg"
    LIBRARY CPROGLIB
    LANGUAGE C
    PARAMETERS(P1 STRING, P2, P3 BY REFERENCE STRING, RETURN INT);

当我尝试调用CALL_C_PROGRAM时，我发现：

ORA-01405: fetched column value is NULL

我怎么知道问题出在哪里？

新的

我更改了库定义以解决某个错误，但我仍然遇到相同的异常！

在调用函数之前我必须设置一个参数或其他东西吗？

oracle stored-procedures