{"id":297,"date":"2011-11-17T23:53:42","date_gmt":"2011-11-17T15:53:42","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=297"},"modified":"2011-11-18T09:59:42","modified_gmt":"2011-11-18T01:59:42","slug":"sqlplus%e6%9c%ac%e5%9c%b0%e7%99%bb%e5%bd%95%e6%8a%a5%e9%94%99ora-12545","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=297","title":{"rendered":"sqlplus\u672c\u5730\u767b\u5f55\u62a5\u9519ORA-12545"},"content":{"rendered":"

\u5728\u5ba2\u6237\u670d\u52a1\u5668\u4e0a\u5c1d\u8bd5\u767b\u5f55\u6570\u636e\u5e93\u662f\u78b0\u5230\u9519\u8bef\u3002
\n\u6b65\u9aa4\u5982\u4e0b\uff1a<\/p>\n

> sqlplus \/nolog\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 17 17:24:16 2011\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\nSQL> conn \/ as sysdba\r\nERROR:\r\nORA-12545: Connect failed because target host or object does not exist\r\nSQL> conn user\/password\r\nERROR:\r\nORA-12545: Connect failed because target host or object does not exist\r\nSQL> conn user\/password@100.300.100.200\/db\r\nConnected.<\/pre>\n
\u5c1d\u8bd5\u8fde\u63a5\u672c\u5730\u7684\u6570\u636e\u5e93\uff0c\u7ed3\u679c\u51fa\u73b0\u4e86ORA-12545\u9519\u8bef\uff0c\u5c1d\u8bd5\u901a\u8fc7\u7f51\u7edc\u65b9\u5f0f\u8fde\u63a5\uff0c\u53cd\u800c\u6ca1\u6709\u78b0\u5230\u95ee\u9898\u3002\u8fd9\u8bf4\u660e\u6570\u636e\u5e93\u672c\u8eab\u662f\u6b63\u5e38\u7684\uff0c\u800c\u672c\u5730\u65e0\u6cd5\u8fde\u63a5\uff0c\u663e\u793a\u662f\u672c\u5730\u8bbe\u7f6e\u51fa\u73b0\u4e86\u95ee\u9898\u3002
\n\u68c0\u67e5\u4e86\u73af\u5883\u53d8\u91cf\u7684\u8bbe\u7f6e\uff0c\u5305\u62ecORACLE_SID\u3001ORACLE_HOME\u548cPATH\uff0c\u90fd\u672a\u53d1\u73b0\u4efb\u4f55\u5f02\u5e38\uff0c\u518d\u6b21\u5c1d\u8bd5\u8fde\u63a5\u6570\u636e\u5e93\uff1a<\/p>\n
> sqlplus user\/password@100.300.100.200\/db\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 17 17:26:54 2011\r\nCopyright (c) 1982, 2005, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP and Oracle Data Mining options\r\nJServer Release 9.2.0.4.0 - Production\r\nSQL> exit \r\nDisconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP and Oracle Data Mining options\r\nJServer Release 9.2.0.4.0 - Production<\/pre>\n
\u8fd9\u6b21\u540c\u6837\u8fde\u63a5\u5230\u6570\u636e\u5e93\uff0c\u4f46\u662f\u7531\u4e8e\u8fde\u63a5\u65b9\u5f0f\u548c\u7b2c\u4e00\u6b21\u7684\u4e0d\u540c\uff0c\u901a\u8fc7Oracle\u63d0\u793a\u7684\u4fe1\u606f\u627e\u5230\u4e86\u9519\u8bef\u7684\u539f\u56e0\u3002
\n\u9996\u5148\u5c1d\u8bd5\u7684\u7b80\u6613\u8fde\u63a5\u65b9\u5f0f\u662f10g\u7684\u65b0\u7279\u6027\uff0c\u800c\u4e14\u4ecesqlplus\u7684\u5de5\u5177\u7248\u672c\u4fe1\u606f\u4e5f\u53ef\u4ee5\u770b\u5f97\u51fa\uff0csqlplus\u662f10.2.0.1\u7248\u672c\u7684\u3002\u800c\u8fde\u63a5\u5230\u6570\u636e\u5e93\u540e\u663e\u793a\u7684\u6570\u636e\u5e93\u670d\u52a1\u5668\u7248\u672c\u4fe1\u606f\u5374\u662f9.2.0.4\u3002
\n\u663e\u7136\u5f53\u524d\u662f\u901a\u8fc7\u4e00\u4e2a10.2\u7684sqlplus\u5ba2\u6237\u7aef\uff0c\u8fde\u63a5\u52309.2\u7684\u6570\u636e\u5e93\u3002\u90a3\u4e48\u65e0\u8bbaORACLE_HOME\u8fd8\u662fPATH\u90fd\u662f\u6307\u541110.2\u7684\u5ba2\u6237\u7aef\u7684\uff0c\u8fd9\u5c31\u662f\u4e3a\u4ec0\u4e48\u51fa\u73b0ORA-12545\u9519\u8bef\u7684\u539f\u56e0\uff1a<\/p>\n
[DEV]dev:\/app\/oracle\/product\r\n> export ORACLE_HOME=\/app\/oracle\/product\/920\r\n[DEV]dev:\/app\/oracle\/product\r\n> export PATH=$ORACLE_HOME\/bin:$PATH\r\n[DEV]dev:\/app\/oracle\/product\r\n> sqlplus '\/ as sysdba'\r\nSQL*Plus: Release 9.2.0.4.0 - Production on Thu Nov 17 17:28:41 2011\r\nCopyright (c) 1982, 2002, Oracle Corporation. All rights reserved.\r\n\r\nConnected to:\r\nOracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP and Oracle Data Mining options\r\nJServer Release 9.2.0.4.0 - Production\r\nSQL> <\/pre>\n
\u5b9a\u4f4d\u95ee\u9898\u7684\u539f\u56e0\uff0c\u89e3\u51b3\u5c31\u5f88\u7b80\u5355\u4e86\uff0c\u8bbe\u7f6eORACLE_HOME\u548cPATH\u52309.2\u5bf9\u5e94\u7684\u76ee\u5f55\u540e\uff0c\u5728\u672c\u5730sqlplus\u6210\u529f\u8fde\u63a5\u6570\u636e\u5e93\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728\u5ba2\u6237\u670d\u52a1\u5668\u4e0a\u5c1d\u8bd5\u767b\u5f55\u6570\u636e\u5e93\u662f\u78b0\u5230\u9519\u8bef\u3002 \u6b65\u9aa4\u5982\u4e0b\uff1a > sqlplus \/nolog SQL*Plus: Release 10.2.0.1.0 – Production on Thu Nov 17 17:24:16 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn \/ as sysdba ERROR: ORA-12545: Connect failed because target host or object does not … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[218,219],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-4N","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/297"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=297"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/297\/revisions"}],"predecessor-version":[{"id":299,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/297\/revisions\/299"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}