不能成功配置LISTENER,请看具体信息.

whuijun

最初由 LostHorizon 发布
[B]could you post the inforamtion from file listener.ora under $oracle_home\ora92\network\admin [/B]

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = X.X.X.X)(PORT = 1526))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )
  )

有问题吗?

whuijun

最初由 LostHorizon 发布
[B]netstat -an instead. [/B]

有1526那个端口啊!

LostHorizon

最初由 whuijun 发布
[B]

有1526那个端口啊! [/B]

then try to use tool 'Net Configuration Assistant' to delete the listener 'listener' and create one using different port#.

whuijun

还是不行,我删除了原来基于1526的那个listener,然后重新创建了一个,端口是不是1527,这次成功了,但是还是创建不了数据库,错误代码ra-03114 not connected to Oracle.
how to do next??thanks.

LostHorizon

最初由 whuijun 发布
[B]还是不行,我删除了原来基于1526的那个listener,然后重新创建了一个,端口是不是1527,这次成功了,但是还是创建不了数据库,错误代码ra-03114 not connected to Oracle.
how to do next??thanks. [/B]

change the port to 1527 in the file 'tnsnames.ora' as well.

whuijun

还是不行,错误代码还是ora-03114

husthxd

Can u configure the listener manually?
U can edit listener.ora and then use lsnrctl to start/stop the listener.
btw:u can use dbca to create database unless listener start or not.

whuijun

but there is always an errorra-03114 not connected to oracle.why?

LostHorizon

最初由 whuijun 发布
[B]but there is always an errorra-03114 not connected to oracle.why? [/B]

could you post the information for  configruation 'tnsnames.ora' ?

whuijun

# TNSNAMES.ORA Network Configuration File: /oracle/app/oracle/product/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORAL =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hpl3000)(PORT = 1527))
  )

ORAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hpl3000)(PORT = 1527))
    )
    (CONNECT_DATA =
      (SID = ORAL)
    )
  )

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