日本免费全黄少妇一区二区三区-高清无码一区二区三区四区-欧美中文字幕日韩在线观看-国产福利诱惑在线网站-国产中文字幕一区在线-亚洲欧美精品日韩一区-久久国产精品国产精品国产-国产精久久久久久一区二区三区-欧美亚洲国产精品久久久久

  1. 首頁 > 云知道 > >

oracle 11g安裝圖解教程，如何安裝oracle11g數(shù)據(jù)庫詳細過程( 七 )

云知道


lsnrctl startLSNRCTL for HPUX: Version 10.1.0.4.0 - Production on 01-JUL-2005 10:16:59 Copyright (c) 1991, 2004, Oracle. All rights reserved.Starting /db02/product/10.1/bin/tnslsnr: please wait...TNS-12537: TNS:connection closedTNS-12560: TNS:proto adapter errorTNS-00507: Connection closed HPUX Error: 29: Illegal seek解決方式：檢查該用戶是否有/etc/hosts文件的訪問權(quán)限，檢查/etc/hosts文件下是否包含
127.0.0.1 localhost.localdomain localhost9.ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was:192.168.1.1:1521:bbcd這個問題一般發(fā)生在利用JDBC連接數(shù)據(jù)庫時，這里需要注意，上面的bbcd的位置應(yīng)該填寫sid_name,一般JDBC的配置格式為
jdbc:oracle:thin:@IP/HOSTNAME:PORT:SID例如jdbc:oracle:thin:@145.**.**.**:1521:z***db210.Ora-12514：TNS：監(jiān)聽程序當(dāng)前無法識別鏈接描述符中請求的服務(wù)該問題是由于缺少監(jiān)聽器的SID_LIST描述項引起的，采用netca進行配置的時候經(jīng)常會遇到該問題，listener.ora示例如下
SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = /opt/oracle/product/9.2.0.4)(PROGRAM = extproc))(SID_DESC =(GLOBAL_DBNAME = SAMPLE.COM)(ORACLE_HOME = /opt/oracle/product/9.2.0.4)(SID_NAME = SAMPLE))) LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = tcy.com)(PORT = 1521)))(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)))))11.ORA-12528: TNS:listener: all appropriate instances are blocking new connectionsORA-12528:監(jiān)聽中的服務(wù)使用了動態(tài)服務(wù),系統(tǒng)啟動后,數(shù)據(jù)庫沒有正常的MOUNT,因此在動態(tài)模式下,就會出現(xiàn)這個問題，用靜態(tài)的就不會有這個問題,因此上面的方法就是把監(jiān)聽設(shè)置為靜態(tài),或者在tnsnames.ora中追加(UR=A) 。lisnter.ora增加如下內(nèi)容
(SID_DESC =(GLOBAL_DBNAME = ammicly)(ORACLE_HOME = c:\oracle\product\10.1.0\db_1)(SID_NAME = ammicly))或者在tnsnames.ora增加如下內(nèi)容: (UR=A)12.ORA-01034:ORACLEnot available和ORA-27101: shared memory realm does not exist檢查tnsping是否能正常工作，檢查lsnrctl status是否正常 。檢查local_listener參數(shù)(pmon只會動態(tài)注冊port等于1521的監(jiān)聽，否則pmon不能動態(tài)注冊listener，要想讓pmon動態(tài)注冊listener，需要設(shè)置local_listener參數(shù))，通過如下方式設(shè)置
alter system set local_listener='(ADDRESS =(PROTOCOL=TCP)(HOST=10.201.1.134)(PORT=1521)(SID=siebtest))';13.ORA-12520 TNS:Listener count not find available handler for requested type of server有以下3種可能1、檢查數(shù)據(jù)庫是否是專用服務(wù)器,但是在tnsname.ora配置中設(shè)置了連接方式為shared,這種情況下
打開tnsname.ora, 把(server = shared) 改成 (server = dedicate)；2、是由于process不夠引起的:
ｓｅｌｅｃｔ count(*) from v$session;show parameter processesshow parameter sessions調(diào)大processes參數(shù)即可3、local_listener設(shè)置不當(dāng)，設(shè)置方式參見上文 。
14.TNS-12542: TNS:address already in useTNS-12560: TNS:protocol adapter errorTNS-00512: Address already in use檢查/etc/hosts的配置，是否有多個ip指向同一主機名的情況參考至：http://lzysystem.iteye.com/blog/424569http://blogold.chinaunix.net/u2/82873/showart_1830733.htmlhttp://gggwfn1982.blog.163.com/blog/static/15000427201041192213787/http://guolr.iteye.com/blog/549692http://blog.sina.com.cn/s/blog_4cd0d3a701000a6j.htmlhttp://pengxianfeng.i.sohu.com/blog/view/84726397.htmhttp://blog.sina.com.cn/s/blog_517cae3c01015dwu.htmlhttp://luoping.blog.51cto.com/534596/1062670http://xiekeli.blogbus.com/logs/93619549.htmlhttp://www.linuxidc.com/Linux/2012-11/73694.htm
15. Windows下啟動監(jiān)聽服務(wù)提示找不到路徑用命令或在服務(wù)窗口中啟動監(jiān)聽提示找不到路徑，或監(jiān)聽服務(wù)啟動異常 。打開注冊表，進入

推薦閱讀