连续请了3个高手都无法搞定的问题!(在线等待)

oracle8i我不太清楚,但安装完9i后,系统的IIS将自动终止并转交Oracle控制,我不知道你的机器上都安装了什么服务,可能有些服务与Oracle的监听产生了冲突也说不定,要不你不要安装Oracle web试试.
搞不定也不要骂我,我对8i不熟,但我祝你成功.

网卡的问题, 我也怀疑的说,因为我是用双网卡, 但是几乎所有可能都试验过了,而且和几个工程师都讨论过,可能性不是很大,反而是操作系统出问题的可能性比较大;至于小数点兄给予的答复,十分感谢,我也想到了,几乎所有不关oracle的服务我全部关闭了,但是还是搞不定的说,神啊,救救我!to蓝色浮点, 当stop时报错如下:
tns-01103: 地址的协议专用组件指定不正确
tns-12541: Tns : 无监听器
tns-00511: 无监听器
32-bit windows Error: 61: Unknown Error

双网卡???
我觉得问题就出在你的双网卡上。
在双网卡的配置不能通过hostname连接（如果实在需要的话，必须在os中帮定你的ip），由于两个ip，hostname无法正常解析，你可需要在tnsname中或者是listener。ora中使用ip。
能否把你的服务器的listener。ora还有客户端的tnsname贴上来？
还有你的ip。

试过了,两块网卡不行后,我禁用了一块网卡,然后ping host一切正常,
比如, ip = 192.168.0.1 host = into_the_sky
ping into_the_sky = reply 192.168.0.1.....
在tnsname.ora 和listener.ora中ip也用过了, host也用过了,可是
还是没用的说........

tnsname.ora 如下:
# TNSNAMES.ORA Network Configuration File: F:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
SKDATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = database)
    )
  )listener.ora如下:# LISTENER.ORA Network Configuration File: F:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
      )
    )
  )SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\Oracle\Ora81)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      )
    )
  )SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ora9)
      (ORACLE_HOME = D:\oracle)
      (SID_NAME = ora9)
    )
  )如上，host修改，下面我的sid 和全局数据库名都是ora9
你按照这样修改后可以么？但其实根本上，还是怀疑os有问题
有没有防火墙？以前有没有杀毒？……
有防火墙就关闭
我们这曾经有kv3000的例子，只要安装了该防火墙
机器永远无法运行oracle，卸掉防火墙也一样
只能重新安装操作系统
可能的话，建议格掉机器！！！

TNS-01103 Protocol specific component of the address is incorrectly specifiedCause: The ADDRESS used to contact the listener is not correctly specified. This error occurs because the address fails to specify the destination of the listener. The address is well formed (for example, there are no missing parentheses) but it is missing a protocol specific component. For example, this is the error returned when the HOST component is missing from a TCP/IP address string.Action: Edit the ADDRESS in LISTENER.ORA to include the required protocol-specific keywords. For more information about the keywords required by different protocol adapters, see the Oracle operating system specific-documentation for your platform. biti_rainy(biti_rainy) 怀疑的有道理，按照帮助文件上的说法，说你的listener.ora的地址配置的有问题。
我也觉得你可以按 biti_rainy(biti_rainy) 的配置文件修改一下自己的文件，试试吧。

biti_rainy(biti_rainy) 怀疑的有道理，我也觉得是你的listener.ora配置的有问题，你试着按 biti_rainy(biti_rainy) 的改一下吧，也许有用。
附：
TNS-01103 Protocol specific component of the address is incorrectly specifiedCause: The ADDRESS used to contact the listener is not correctly specified. This error occurs because the address fails to specify the destination of the listener. The address is well formed (for example, there are no missing parentheses) but it is missing a protocol specific component. For example, this is the error returned when the HOST component is missing from a TCP/IP address string.Action: Edit the ADDRESS in LISTENER.ORA to include the required protocol-specific keywords. For more information about the keywords required by different protocol adapters, see the Oracle operating system specific-documentation for your platform.

应该是listener.ora配置有问题.
应该加上对SID的监听，即
(SID_DESC =
      (GLOBAL_DBNAME = GCT)
      (ORACLE_HOME = D:\oracle\ora81)
      (SID_NAME = GCT)
    )其中:GCT就是你的数据库服务器配置的SID和GLOBAL_NAME。

多谢各位热心帮助上问题已经搞定了, 可是又有另外一个神奇的错误,我快崩溃了,^_^过程是这样的,我卸装了一遍oracle, 然后重新安装了一遍,什么都没改,重启后用system登陆不进去, 怀疑是例程没起来,在服务下看一切正常,都是自动启动,监听也起来了,但是数据库却不能用system登上去,于是我在svrmgrl 下用internal登陆,没问题,然后shutdown abort,然后再startup, 搞笑的是又可以用所有用户正常登陆并且监听也没有问题了,什么都没有改过,但是要先shutdown然后再startup才能正常使用,那不是意味着我每次都要这么麻烦的启动????
哪位高手再指点一二, 有个工程师跟我说是电脑中过招后会出现这种问题, 可是我的电脑好像没中过招,只是用了个norton的防火墙而已,会不会是这个问题?

另外,我再贴一下现在正常的listener.ora,按照这个看估计是原来我的listener.ora出问题了,可能如果按照biti_rainy兄以及后来几位大虾的做法就不需要我重新装这么一道了, 请大家帮忙再帮忙解决一下上面出现的新问题,我会重新开贴谢各位的,thx a lot!

现在正常的listener.ora如下:LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = into_the_sky)(PORT = 1521))
      )
    )
    (DESCRIPTION =
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = into_the_sky)(PORT = 2481))
    )
  )SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\Oracle\Ora81)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = GTC)
      (ORACLE_HOME = F:\Oracle\Ora81)
      (SID_NAME = GTC)
    )
  )

system 登陆的时候的错误信息是什么？防火墙也许是有关系的吧conn system/manager@net_service_name 不可以
conn system/manager 能登陆么？数据库是启动状态还是已启动？

norton?应该没问题吧。mcafee可能会出现问题
有一次给客户维护数据库，那机上装了macfee,由于服务器移位，关过机，结果服务器重启总是报错，差点急死我们几个工程师了，最后突然想到关mcafee试试，一关，oracle就能不抱错正常起来，再开mcafee就没事了

conn system/manager也不可以, 数据库已经启动...
谢谢各位,有个朋友已经告诉我解决方法了,的确是防火墙或者病毒原因,
用一个系统修复工具修复一下,然后重起就可以了,他和我的情况是一样的,
呵呵,几位朋友来领分吧,^_^

调试易

连续请了3个高手都无法搞定的问题!(在线等待)

解决方案 »