ITPub博客

首页 > Linux操作系统 > Linux操作系统 > plsql developer 连不上虚拟机上的oracle

plsql developer 连不上虚拟机上的oracle

原创 Linux操作系统 作者:juogkl 时间:2012-04-03 01:33:41 0 删除 编辑
启动虚拟机上的oracle,启动监听,用plsql连接提示无法识别标示符。
--原因服务器listener.ora 中SID设置不对。
 
 
[oracle@localhost ~]$ find / -name "listener.ora";

/u01/app/product/10.2.0/db_1/network/admin/samples/listener.ora
(或者
[oracle@localhost /]$ cd  /u01/app/product/10.2.0/db_1
[oracle@localhost db_1]$ find . -name "listener.ora"
./network/admin/samples/listener.ora
 
将此文件改成类似:
 
SID_LIST_LISTENER =
   (SID_LIST =
   (SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME =  /u01/app/product/10.2.0/db_1)
   (PROGRAM = extproc)
   )
   (SID_DESC =
   (GLOBAL_DBNAME = ccdb)
   (ORACLE_HOME =  /u01/app/product/10.2.0/db_1)
   (SID_NAME = ccdb)
   )
   )
LISTENER =
   (DESCRIPTION_LIST =
   (DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   )
   (DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.58.128)(PORT = 1521))
   )
   )
 
重启监听程序,lsnrctl stop; lsnrctl start;即可登录
 
 
 
----原始listener.ora备份
# 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_, where is the name of the listener
#   this parameter refers to.  All parameters and values are
#   case-insensitive.
#
#   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 .  When not specified,
#   the name for 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_
#   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_
#   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_ is ON.
#       See below.
#
# Default: NONE
#
# PASSWORDS_LISTENER = 20A22647832FB454      # "foobar"
# SAVE_CONFIG_ON_STOP_
#   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_
#   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_
#   Sets the name of the listener's log file.  The .log extension
#   is added automatically.
# Default=
#
# LOG_FILE_LISTENER = lsnr
# LOG_DIRECTORY_
#   Sets the directory for the listener's log file.
# Default: /network/log
#
# LOG_DIRECTORY_LISTENER = /private/app/oracle/product/8.0.3/network/log
# TRACE_LEVEL_
#   Specifies desired tracing level.
# Default: OFF
# Values: OFF/USER/ADMIN/SUPPORT/0-16
#
# TRACE_LEVEL_LISTENER = SUPPORT
# TRACE_FILE_
#   Sets the name of the listener's trace file. The .trc extension
#   is added automatically.
# Default:
#
# TRACE_FILE_LISTENER = lsnr
# TRACE_DIRECTORY_
#   Sets the directory for the listener's trace file.
# Default: /network/trace
#
# TRACE_DIRECTORY_LISTENER=/private/app/oracle/product/8.0.3/network/trace
# CONNECT_TIMEOUT_
#   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
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24156512/viewspace-720230/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-06-27

  • 博文量
    10
  • 访问量
    14684