Linux Error: 29: Illegal seek

沒有什麼問題。


檢查listener.ora:
LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
  )


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =       
      (GLOBAL_DBNAME = jing)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = orcl3939)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = tai)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = orcl3939)
    )
  )




SID_LIST_WEN =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
    )
  )
WEN =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )


檢查tnsnames.ora:

diy =
(DESCRIPTION =
    (ADDRESS_LIST =
        (ADDRESS=(PROTOCOL=TCP)(HOST = localhost.localdomain)(PORT = 1522))
    )
)
SQL> show parameter local_listener;


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      DIY
SQL> show parameter service_names;


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      a,b,c,d,diy
SQL> show parameter instance_name;


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      orcl3939