我听说有可能是listener.ora文件被改了,还有listener.ora有两个文件,一个是大写字母的,一个是小写字母的 我贴出来,大家帮我看一下好吗?这个是小写的 # LISTENER.ORA Network Configuration File: D:\oracle\ora90\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = stmxzys599)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = stmxzys599)(PORT = 1522)) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\ora90) (PROGRAM = extproc0) ) (SID_DESC = (GLOBAL_DBNAME = test) (ORACLE_HOME = D:\oracle\ora90) (SID_NAME = test) ) ) 这个是大写的: # copyright (c) 1997 by the Oracle Corporation # # NAME # listener.ora # FUNCTION # Network Listener startup parameter file example # NOTES # This file contains all the parameters for listener.ora, # and could be used to configure the listener by uncommenting # and changing values. Multiple listeners can be configured # in one listener.ora, so listener.ora parameters take the form # of SID_LIST_<lsnr>, where <lsnr> is the name of the listener # this parameter refers to. All parameters and values are # case-insensitive.# <lsnr> # This parameter specifies both the name of the listener, and # it listening address(es). Other parameters for this listener # us this name in place of <lsnr>. When not specified, # the name for <lsnr> defaults to "LISTENER", with the default # address value as shown below. # # LISTENER = # (ADDRESS_LIST= # (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)) # (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))) # SID_LIST_<lsnr> # List of services the listener knows about and can connect # clients to. There is no default. See the Net8 Administrator's # Guide for more information. # # SID_LIST_LISTENER= # (SID_LIST= # (SID_DESC= # #BEQUEATH CONFIG # (GLOBAL_DBNAME=salesdb.mycompany) # (SID_NAME=sid1) # (ORACLE_HOME=/private/app/oracle/product/8.0.3) # #PRESPAWN CONFIG # (PRESPAWN_MAX=20) # (PRESPAWN_LIST= # (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1)) # ) # ) # )
# PASSWORDS_<lsnr> # Specifies a password to authenticate stopping the listener. # Both encrypted and plain-text values can be set. Encrypted passwords # can be set and stored using lsnrctl. # LSNRCTL> change_password # Will prompt for old and new passwords, and use encryption both # to match the old password and to set the new one. # LSNRCTL> set password # Will prompt for the new password, for authentication with # the listener. The password must be set before running the next # command. # LSNRCTL> save_config # Will save the changed password to listener.ora. These last two # steps are not necessary if SAVE_CONFIG_ON_STOP_<lsnr> is ON. # See below. # # Default: NONE # # PASSWORDS_LISTENER = 20A22647832FB454 # "foobar"# SAVE_CONFIG_ON_STOP_<lsnr> # Tells the listener to save configuration changes to listener.ora when # it shuts down. Changed parameter values will be written to the file, # while preserving formatting and comments. # Default: OFF # Values: ON/OFF # # SAVE_CONFIG_ON_STOP_LISTENER = ON# USE_PLUG_AND_PLAY_<lsnr> # Tells the listener to contact an Onames server and register itself # and its services with Onames. # Values: ON/OFF # Default: OFF # # USE_PLUG_AND_PLAY_LISTENER = ON# LOG_FILE_<lsnr> # Sets the name of the listener's log file. The .log extension # is added automatically. # Default=<lsnr> # # LOG_FILE_LISTENER = lsnr# LOG_DIRECTORY_<lsnr> # Sets the directory for the listener's log file. # Default: <oracle_home>/network/log # # LOG_DIRECTORY_LISTENER = /private/app/oracle/product/8.0.3/network/log# TRACE_LEVEL_<lsnr> # Specifies desired tracing level. # Default: OFF # Values: OFF/USER/ADMIN/SUPPORT/0-16 # # TRACE_LEVEL_LISTENER = SUPPORT# TRACE_FILE_<lsnr> # Sets the name of the listener's trace file. The .trc extension # is added automatically. # Default: <lsnr> # # TRACE_FILE_LISTENER = lsnr# TRACE_DIRECTORY_<lsnr> # Sets the directory for the listener's trace file. # Default: <oracle_home>/network/trace # # TRACE_DIRECTORY_LISTENER=/private/app/oracle/product/8.0.3/network/trace # CONNECT_TIMEOUT_<lsnr> # Sets the number of seconds that the listener waits to get a # valid database query after it has been started. # Default: 10 # # CONNECT_TIMEOUT_LISTENER=10
你需要修改注册表,添加TNS 服务,然后启动它
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraHome92TNSListener下
添加ImagePath 其值是TNSLSNR.exe的 绝对路径+TNSLSNR
你是oracle是不是到网上下的呀,网上下载的往往会有问题。
我贴出来,大家帮我看一下好吗?这个是小写的
# LISTENER.ORA Network Configuration File: D:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stmxzys599)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = stmxzys599)(PORT = 1522))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora90)
(PROGRAM = extproc0)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = D:\oracle\ora90)
(SID_NAME = test)
)
)
这个是大写的:
# copyright (c) 1997 by the Oracle Corporation
#
# NAME
# listener.ora
# FUNCTION
# Network Listener startup parameter file example
# NOTES
# This file contains all the parameters for listener.ora,
# and could be used to configure the listener by uncommenting
# and changing values. Multiple listeners can be configured
# in one listener.ora, so listener.ora parameters take the form
# of SID_LIST_<lsnr>, where <lsnr> is the name of the listener
# this parameter refers to. All parameters and values are
# case-insensitive.# <lsnr>
# This parameter specifies both the name of the listener, and
# it listening address(es). Other parameters for this listener
# us this name in place of <lsnr>. When not specified,
# the name for <lsnr> defaults to "LISTENER", with the default
# address value as shown below.
#
# LISTENER =
# (ADDRESS_LIST=
# (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
# (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))) # SID_LIST_<lsnr>
# List of services the listener knows about and can connect
# clients to. There is no default. See the Net8 Administrator's
# Guide for more information.
#
# SID_LIST_LISTENER=
# (SID_LIST=
# (SID_DESC=
# #BEQUEATH CONFIG
# (GLOBAL_DBNAME=salesdb.mycompany)
# (SID_NAME=sid1)
# (ORACLE_HOME=/private/app/oracle/product/8.0.3)
# #PRESPAWN CONFIG
# (PRESPAWN_MAX=20)
# (PRESPAWN_LIST=
# (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
# )
# )
# )
# PASSWORDS_<lsnr>
# Specifies a password to authenticate stopping the listener.
# Both encrypted and plain-text values can be set. Encrypted passwords
# can be set and stored using lsnrctl.
# LSNRCTL> change_password
# Will prompt for old and new passwords, and use encryption both
# to match the old password and to set the new one.
# LSNRCTL> set password
# Will prompt for the new password, for authentication with
# the listener. The password must be set before running the next
# command.
# LSNRCTL> save_config
# Will save the changed password to listener.ora. These last two
# steps are not necessary if SAVE_CONFIG_ON_STOP_<lsnr> is ON.
# See below.
#
# Default: NONE
#
# PASSWORDS_LISTENER = 20A22647832FB454 # "foobar"# SAVE_CONFIG_ON_STOP_<lsnr>
# Tells the listener to save configuration changes to listener.ora when
# it shuts down. Changed parameter values will be written to the file,
# while preserving formatting and comments.
# Default: OFF
# Values: ON/OFF
#
# SAVE_CONFIG_ON_STOP_LISTENER = ON# USE_PLUG_AND_PLAY_<lsnr>
# Tells the listener to contact an Onames server and register itself
# and its services with Onames.
# Values: ON/OFF
# Default: OFF
#
# USE_PLUG_AND_PLAY_LISTENER = ON# LOG_FILE_<lsnr>
# Sets the name of the listener's log file. The .log extension
# is added automatically.
# Default=<lsnr>
#
# LOG_FILE_LISTENER = lsnr# LOG_DIRECTORY_<lsnr>
# Sets the directory for the listener's log file.
# Default: <oracle_home>/network/log
#
# LOG_DIRECTORY_LISTENER = /private/app/oracle/product/8.0.3/network/log# TRACE_LEVEL_<lsnr>
# Specifies desired tracing level.
# Default: OFF
# Values: OFF/USER/ADMIN/SUPPORT/0-16
#
# TRACE_LEVEL_LISTENER = SUPPORT# TRACE_FILE_<lsnr>
# Sets the name of the listener's trace file. The .trc extension
# is added automatically.
# Default: <lsnr>
#
# TRACE_FILE_LISTENER = lsnr# TRACE_DIRECTORY_<lsnr>
# Sets the directory for the listener's trace file.
# Default: <oracle_home>/network/trace
#
# TRACE_DIRECTORY_LISTENER=/private/app/oracle/product/8.0.3/network/trace
# CONNECT_TIMEOUT_<lsnr>
# Sets the number of seconds that the listener waits to get a
# valid database query after it has been started.
# Default: 10
#
# CONNECT_TIMEOUT_LISTENER=10
不知道会不会是我的WINDOWS 2000 SERVER打上SP4的补丁了,
不知道ORACLE和那些软件有冲突(我的机子只装了ORACLE而已,没有装别的软件),重装的很多次都一样,所以我正在怀疑SP4的问题,不过记得以前装WINDOWS 2003 SERVER也是一样(我的安装光盘没有问题,因为借同学装了很多次,都没有事)
是不是安装ORACLE后还要配置什么的~~~我第一次就能启动,重启后就不能了
也可以试试重新配置listener (不要说你不知道怎么配置):)
进入HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\OracleOraHome81TNSListener
(如果是9i就是HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\OracleOraHome91TNSListener)
然后添加个ImagePath数值,值为d:\oracle\ora81/bin/TNSLSNR.EXE 类型:REG_EXPAND_SZ这样就可以手动去启动了
重装之前到注册表中把oracle相关的东西全部删光 重启后重新安装我以前帮一个同学搞过这个问题
她装了两次oracle
因为前一次的没有装好也没删就重装了 结果后来装好的oracle使用的是前面的监听器 我删掉上一个监听器 把新的启动 修改注册表 重启