启动虚拟机上的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 )
)
)
监听器=
(DESCRIPTION_LIST=
(描述=
(地址=(协议=IPC )密钥=ext proc1) )
)
(描述=
(地址=(协议=TCP );主机=192.168.58.128 );端口=1521 ) )
)
)
;
重新启动监听程序,然后单击lsnrctl stop; lsnrctl start; 可以登录
---原始listener.ora备份
#版权(c ) 1997 by the Oracle Corporation
#
# NAME
# listener.ora
#功能
# networklistenerstartupparameterfileexample
# NOTES
# thisfilecontainsalltheparametersforlistener.ora,
# andcouldbeusedtoconfigurethelistenerbyuncommenting
# andchangingvalues.multiplelistenerscanbeconfigured
# in one listener.ora,so listener.oraparameterstaketheform
# of SID_LIST_,where is the name of the listener
# thisparameterrefersto.allparametersandvaluesare
#情况不敏感。
# thisparameterspecifiesboththenameofthelistener,和
#itlisteningaddress(es ).Other parameters for this listener
# usthisnameinplaceof.whennotspecified,
# the name for defaults to 'LISTENER ',with the default
#地址值as shown below。
#
#监听器=
# (地址_ list=
# (地址=(协议=TCP )主机=localhost ) (端口=1521 ) ) ) ) ) )。
# (地址=(协议=IPC ) KEY=PNPKEY ) )
# sid _ list _ # listofservicesthelistenerknowsaboutandcanconnect
# clients to.there is no default.see then et8管理员' s
# guide for more信息。
#
# SID_LIST_LISTENER=
#(sid_list=
#(sid_desc=
##BEQUEATH CONFIG
# (global _ dbname=salesdb.my company ) ) )
#(sid_name=sid1) ) ) ) )
# (Oracle _ home=/private/app/Oracle/product/8.0.3 )
# #预喷配置
(# (PRESPAWN_MAX=20 ) ) ) ) ) )。
#(prespawn_list=
#(prespawn_desc=(protocol=TCP ) POOL_SIZE=2) (TIMEOUT=1) )
# )
# )
# )
# passwords _ # specifiesapasswordtoauthenticatestoppingthelistener。
# bothencryptedandplain-textvaluescanbeset.encrypted passwords
# can be set and stored using lsnrctl。
# LSNRCTL change_password
# willpromptforoldandnewpasswords,and use加密both
# tomatchtheoldpasswordandtosetthenewone。
# LSNRCTL set password
#Will prompt for the new password,for authentication with
# the listener.thepasswordmustbesetbeforerunningthenext
# command
# LSNRCTL save_config
# willsavethechangedpasswordtolistener.ora.theselasttwo
# stepsarenotnecessaryifsave _ config _ on _ stop _ ison。
# See below。
#
#默认: none
#
# passwords _ listener=20a 22647832 FB 454 # ' foobar '
# save _ config _ on _ stop _ # tellsthelistenertosaveconfigurationchangestolistener.ora when
# itshutsdown.changedparametervalueswillbewrittentothefile,
# whilepreservingformattingandcomments。
#默认:关闭
# values :开/关
#
# save _ config _ on _ stop _ listener=on
# use _ plug _ and _ play _ # tellsthelistenertocontactanonamesserverandregisteritself
# and its服务with onames。
# values :开/关
#默认:关闭
#
# USE_PLUG_AND_PLAY_LISTENER=ON
# log _ file _ # setsthenameofthelistener ' slog file.the.log extension
# is添加自动automatically。
# Default=#
# LOG_FILE_LISTENER=lsnr
# log _ directory _ # setsthedirectoryforthelistener ' slog文件。
#默认:/network/log
#
# log _ directory _ listener=/private/app/Oracle/product/8.0.3/network/log
# trace _ level _ # specifiesdesiredtracinglevel。
#默认:关闭
# values :关闭/用户/管理员/支持/0- 16
#
# TRACE_LEVEL_LISTENER=SUPPORT
# trace _ file _ # setsthenameofthelistener ' strace file.the.TRC extension
# is添加自动automatically。
#默认: #
# TRACE_FILE_LISTENER=lsnr
# trace _ directory _ # setsthedirectoryforthelistener ' strace文件。
# default : /网络/跟踪
#
# trace _ directory _ listener=/private/app/Oracle/product/8.0.3 /网络/trace
# connect _ time out _ # setsthenumberofsecondsthatthelistenerwaitstogeta
# validdatabasequeryafterithasbeenstarted。
#默认: 10
#
# CONNECT_TIMEOUT_LISTENER=10