plsql能不能连接mysql_我的sqlplus能联接数据库,但是plsql不能

方法：将文件emoms.properties

#Tue Nov 02 22:52:27 CST 2010

oracle.sysman.emSDK.svlt.ConsoleServerName=localhost_Management_Service

oracle.sysman.eml.mntr.emdRepPwd=f19268fb7db265af

emdrep.ping.pingCommand=ping

oracle.sysman.eml.mntr.emdRepPort=1521

oracle.sysman.eml.mntr.emdRepDBName=orcl

oracle.sysman.eml.mntr.emdRepPwdSeed=1192292953497935708

oracle.sysman.emSDK.svlt.ConsoleMode=standalone

oracle.sysman.emRep.dbConn.statementCacheSize=30

oracle.sysman.db.isqlplusUrl=http\://localhost\:5560/isqlplus/dynamic

oracle.sysman.emSDK.svlt.ConsoleServerPort=1158

oracle.sysman.eml.mntr.emdRepRAC=FALSE

oracle.sysman.emSDK.emd.rt.useMonitoringCred=true

oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE

oracle.sysman.db.isqlplusWebDBAUrl=http\://localhost\:5560/isqlplus/dba/dynamic

oracle.sysman.emSDK.svlt.ConsoleServerHost=zhouyaooracle.sysman.eml.mntr.emdRepDBID=1261830988

oracle.sysman.emSDK.svlt.ConsoleServerHTTPSPort=1158

oracle.sysman.eml.mntr.emdRepServer=zhouyaooracle.sysman.eml.mntr.emdRepSID=orcl

oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=zhouyao)(PORT\=1521)))(CONNECT_DATA\=

(SERVICE_NAME\=orcl)))

oracle.sysman.emSDK.sec.ReuseLogonPassword=true

oracle.sysman.eml.mntr.emdRepUser=SYSMAN

oracle.sysman.db.adm.conn.statementCacheSize=2

oracle.sysman.db.perf.conn.statementCacheSize=30

改成和tnsnames.ora以及listener.ora中的一样

# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)

(PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = zhouyao)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

)

取消

评论