远程链接oracle11g报 ora 28547 ORA-28547:connection to server...

plsqldev\u767b\u9646\u65f6\u51fa\u73b0ora-28547:\u8fde\u63a5\u670d\u52a1\u5668\u5931\u8d25 \u53ef\u80fd\u662foracle net\u7ba1\u7406\u9519\u8bef\u600e\u4e48\u89e3\u51b3

\u4f60\u597d\uff01
plsqldev
\u5de5\u5177-\u300b\u8bbe\u7f6e-\u300b\u52a0\u8f7d\u4f60\u8981\u8fde\u63a5\u7684oracle\u5b89\u88c5\u76ee\u5f55\u4e0b\u7684oci.dll
\u4ec5\u4ee3\u8868\u4e2a\u4eba\u89c2\u70b9\uff0c\u4e0d\u559c\u52ff\u55b7\uff0c\u8c22\u8c22\u3002

\u4f60\u7684listener.ora\u6587\u4ef6\u5462\uff0c\u4fee\u6539\u4e86\u76d1\u542c\u9700\u8981\u91cd\u542f\u6216\u8005reload\u7684\u5440
lsnrctl status\uff0c\u770b\u770b\u4ec0\u4e48\u9519\u8bef\u3002
\u4fee\u6539\u597d\u4e86\u91cd\u542f\u76d1\u542c\u7a0b\u5e8f lsnrctl stop\uff0c lsntctl start
\u7136\u540e\u8d34\u51falsnrctl status\u7684\u7ed3\u679c

本想在本地上还原错误信息,没还原成功。按照你的配置我在虚拟机和本机之间测试一小下。连接上了。附上官方说明,希望对你有帮助
Check Oracle Net administration in the following ways: -- When using TNSNAMES.ORA or an Oracle Names server, make sure that the client
connection to the Oracle server uses the correct service name or SID. -- Check
LISTENER.ORA on the connection end point's host machine to assure that this
service name or SID refers to the correct server. -- Confirm in TNSNAMES.ORA or
the equivalent service definition that the connect string does not contain
(HS=). -- Set SQLNET.AUTHENTICATION_SERVICES to NONE when using DRCP on
Windows.

你这个ping 能通么?
如果能要开启oracle监听 才能连接,并且要启动数据库

扩展阅读:安装oracle11g客户端步骤 ... 安装完oracle11g怎么启动 ... oracle11g配置文件 ... oracle11g服务器安装教程 ... oracle11g安装后怎么打开 ... oracle11g搭建rac步骤 ... oracle11g下载 ... 安装32位oracle11g步骤 ... 安装oracle11g显示找不到文件 ...

本站交流只代表网友个人观点,与本站立场无关
欢迎反馈与建议,请联系电邮
2024© 车视网