Oracle Listener ·þÎñ²»ÄÜÆô¶¯µÄÁíÒ»·¢ÏÖ
×î½üʱ¼ä£¬¸ü»»ÁËÏîÄ¿×飬×î½üͻȻ·¢ÏÖOracle Listener²»ÄÜÆô¶¯¡£ÒÔǰ·¢ÏÖ²»ÄÜÆô¶¯µÄÔÒòÊÇ£¬ÖØ×°ÁËOracleºóûÓÐɾ³ýÒÔǰµÄ×¢²á±í£¬ÒÔÖÁÓÚĬÈÏÆô¶¯·þÎñµÄÃüÁîÎļþÖ¸ÏòµÄÒÀÈ»ÊÇÒÔǰµÄλÖã¬ËùÒÔ²»ÄÜÆô¶¯£¬µ«Õą̂µçÄÔµÄOracleÖ»×°ÁËÒ»´Î¡£
×òÌìͻȻ·¢ÏÖ£¬ÔÚlistener.oraÎļþÖеÄHostÅäÖõÄÈÔÈ»ÊÇÒÔǰµÄ¼ÆËã»úÃû³Æ£¬ÓÉÓÚ¸ü»»ÏîÄ¿×éºó£¬Ã»ÓÐÆô¶¯¹ý±¾µØµÄOracle£¬ËùÒÔÕâ´Î²Å²»ÄÜÆô¶¯ÁË¡£°ÑÅäÖÃÖеÄÖ÷»úÃû¸ü»»ºó·¢ÏÖÒ»ÇÐÕý³£ÁË¡£
Oracle¶ÔÓÚ±¾µØµÄÉèÖã¬Ê¹ÓõÄÊÇÖ÷»úÃû£¬¶ø²»ÊÇIP£¬¶ø¶ÔÓÚÔ¶³ÌµÄµØÖ·Ê¹ÓõÄÊÇIP¡£
¾ßÌåλÖãºoracle\product\10.1.0\db_1\NETWORK\ADMIN\listener.ora
------------------------------------------------------------------------------------------------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ¼ÆËã»úÃû³Æ)(PORT = 1521))
)
)
)
Ïà¹ØÎĵµ£º
2010-03-12 21:21:26
sqlplusµÇ½¶ÌÏûÏ¢oracleÊý¾Ý¿âʱÌáʾ“ORA-28000: Õʺű»Ëø¶¨”¡£
תÌù£ºhttp://blog.csdn.net/shongyu/archive/2009/06/01/4233260.aspx
È·¶¨ÊÇÓÉÓÚoracle11gÖÐĬÈÏÔÚdefault¸ÅÒªÎļþÖÐÉèÖÃÁË“FAILED_LOGIN_ATTEMPTS=10´Î”£¬µ±ÊäÈëÃÜÂë´íÎó´ÎÊý´ïµ½ÉèÖÃÖµ½«µ¼Ö´ËÎÊÌâ¡£
° ......
¡¾ÊµÏÖ²½Öè¡¿
1. ´´½¨±íblog_info, ¾ßÓÐIDºÍtitleÁ½¸ö×Ö¶Î, ÆäÖÐID½«ÉèÖÃΪ×Ô¶¯Ôö³¤ÁÐ;
2. ´´½¨ÐòÁÐ:
create sequence sq_blog_info
start with 1
increment by 1
nomaxvalue
nocycle
......
LinuxÏÂÆô¶¯oracle10gµÄemºÍisqlplusµÄ·½·¨:
×¢:$ORACLE_HOMEΪoracleµÄ°²×°Â·¾¶
1,ʹÓÃEM(enterprise managment)
1.1Æô¶¯EM
$ORACLE_HOME/bin/emctl start dbconsole
Èç¹û³öÏÖÏÂÃæÏà¹ØÐÅÏ¢,˵Ã÷·þÎñÆô¶¯
Z set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.1.0.3.0
Copyright (c) 1996, 200 ......
alter table µÄ¹¦ÄÜÊÇÐ޸ıí¸ñ¡£°üÀ¨ÖØÃûÃü£¬¼Ó¼õ×Ö¶Î,ÐÞ¸Ä×Ö¶ÎÀàÐͺʹóС£¬´¦Àí Ô¼ÊøµÈµÈ¡£±¾Àý×ÓÖ®´¦Àí±íÃûºÍ×ֶΣ¬´úÂëÈçÏ£º
create table liu(a varchar2(20),b number(2))
alter table liu rename to jin
rename jin to cai
alter table cai add c varchar2(30)
alter table cai add (d varchar2(3 ......
ʱ¼ä: 2006-06-15 À´×Ô£ºCSDN
< type="text/javascript"><!--
google_ad_client = "pub-0103898066674568";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_type = "text";
google_ad_channel = "";
google_color_ ......