{"id":1054,"date":"2013-02-03T23:54:39","date_gmt":"2013-02-03T14:54:39","guid":{"rendered":"http:\/\/www.climb.co.jp\/blog_dbmoto\/?p=1054"},"modified":"2013-12-25T21:33:18","modified_gmt":"2013-12-25T12:33:18","slug":"windows%e3%81%aeoracle%e3%81%a7ora-01031%e3%82%a8%e3%83%a9%e3%83%bc%e3%81%8c%e7%99%ba%e7%94%9f%e3%81%97%e3%81%9f%e5%a0%b4%e5%90%88%e3%81%ae%e5%af%be%e5%87%a6%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/1054","title":{"rendered":"Windows\u306eOracle\u3067ORA-01031\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u5834\u5408\u306e\u5bfe\u51e6\u6cd5"},"content":{"rendered":"

SQL> connect \/as sysdba
\nERROR:
\nORA-01031: \u6a29\u9650\u304c\u4e0d\u8db3\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u3053\u306e\u30d1\u30bf\u30fc\u30f3\u306b\u306a\u3063\u3066\u3057\u307e\u3063\u305f\u3068\u304d\u306e\u5bfe\u51e6\u6cd5\u306b\u3064\u3044\u3066\u3067\u3059\u3002
\nSYSDBA\u63a5\u7d9a\u306fOS\u8a8d\u8a3c\u3092\u5229\u7528\u3057\u3066\u3044\u308b\u306e\u3067\u3001Windows\u5074\u3067OS\u8a8d\u8a3c\u304c\u6b63\u3057\u304f\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u306a\u3044\u30b1\u30fc\u30b9\u304c\u307b\u3068\u3093\u3069\u3067\u3059\u3002<\/p>\n

\u25cf\u78ba\u8a8d\u4e8b\u98051\uff1asqlnet.ora<\/p>\n

sqlnet.ora\u306b\u4e0b\u8a18\u304c\u8a18\u8ff0\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002SQLNET.AUTHENTICATION_SERVICES= (NTS)
\n\"\"<\/a><\/p>\n

sqlnet.ora\u306e\u5834\u6240\u306f\u3001$ORACLE_HOME\\NETWORK\\ADMIN \u3067\u3059\u3002
\n\u203b\u79c1\u306e\u74b0\u5883\u3067\u306f\u4e0b\u8a18\u306e\u5834\u6240\u3067\u3057\u305f\u3002
\nC:\\app\\furutty\\product\\11.2.0\\dbhome_1\\NETWORK\\ADMIN<\/p>\n

 <\/p>\n

\u25cf\u78ba\u8a8d\u4e8b\u98052\uff1aORA_DBA\u30b0\u30eb\u30fc\u30d7\u306e\u30e6\u30fc\u30b6<\/p>\n

\u901a\u5e38\u306fOracle\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u306f\u81ea\u52d5\u3067\u8ffd\u52a0\u3055\u308c\u308b\u306f\u305a\u306a\u306e\u3067\u3059\u304c\u3001\u3082\u3057\u8ffd\u52a0\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u8ffd\u52a0\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

\u30b3\u30f3\u30c8\u30fc\u30ed\u30fc\u30eb\u30d1\u30cd\u30eb\u21d2\u30b7\u30b9\u30c6\u30e0\u3068\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u21d2\u7ba1\u7406\u30c4\u30fc\u30eb\u21d2\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u30fc\u306e\u7ba1\u7406\u3092\u958b\u304d\u3001\u300c\u30ed\u30fc\u30ab\u30eb\u30e6\u30fc\u30b6\u30fc\u3068\u30b0\u30eb\u30fc\u30d7\u300d\u21d2\u300c\u30b0\u30eb\u30fc\u30d7\u300d\u21d2\u300cora_dba\u300d\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002
\n\"\"<\/a><\/p>\n

OS\u30e6\u30fc\u30b6\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u306f\u8ffd\u52a0\u3057\u307e\u3057\u3087\u3046\u3002
\n\"\"<\/a><\/p>\n

\u3053\u308c\u3067OK\u3067\u3059\u3002
\n\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

SQL> connect \/as sysdba ERROR: ORA-01031: \u6a29\u9650\u304c\u4e0d\u8db3\u3057\u3066\u3044\u307e\u3059\u3002 \u3053\u306e\u30d1\u30bf\u30fc\u30f3\u306b\u306a\u3063\u3066\u3057\u307e\u3063\u305f\u3068\u304d\u306e\u5bfe\u51e6\u6cd5\u306b\u3064\u3044\u3066\u3067\u3059\u3002 SYSDBA\u63a5\u7d9a\u306fOS\u8a8d\u8a3c\u3092\u5229\u7528\u3057\u3066\u3044\u308b\u306e\u3067\u3001Wi … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[34],"class_list":["post-1054","post","type-post","status-publish","format-standard","hentry","category-syniti","tag-oracle"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/1054","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=1054"}],"version-history":[{"count":3,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/1054\/revisions"}],"predecessor-version":[{"id":1484,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/1054\/revisions\/1484"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=1054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=1054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=1054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}