oracleʵ¼ù
1.
´íÎóÌáʾ£ºORA-12545:ÒòÄ¿±êÖ÷»ú»ò¶ÔÏó²»´æÔÚ,Á¬½Óʧ°Ü.
´íÎóÖ¢×´£ºÐ½¨µÄÊý¾Ý¿âÔÚOEM¿ØÖÆ̨ÎÞ·¨ÏÔʾ£¨sysmanÓû§µÇ½£©£¬¶ÀÁ¢Æô¶¯Ä£Ê½¿ÉÒÔÕÒµ½£¬µ«ÎÞ·¨µÇ½£¬³öÏÖÈçÉÏ´íÎó¡£
½â¾ö°ì·¨£ºÐÞ¸Äoracle°²×°Ä¿Â¼Ï£¨oracle\ora90\network\ADMIN£©µÄtnsnames.oraÎļþ£¬½«µ±Ç°Êý¾Ý¿âÌí¼Óµ½¼àÌý¶ÔÏóÖС£ÐÞ¸ÄÖ®ºó£¬¿ÉÒÔÔÚ¶ÀÁ¢Ä£Ê½ÏÂͨ¹ý"SYSTEM"Õʺŵǽ¡£×¢Òâ°ÑHOST¸ÄΪÄãµÄÖ÷»úÃû¡£
ÔÒò£ºÎ´Öª
2.
´íÎóÌáʾ£ºÔÚµ¼ÈëÊý¾Ýʱ£¬³öÏÖ”ÐèÒªÉèÖÃÊ×Ñ¡ÏîÖ¤Ã÷“µÄÒ»¸öÀàËÆ´íÎóÌáʾ£¬µ±Ç°Îªsys@oemµÇ½״̬¡£
´íÎóÖ¢×´£º²»ÄܽøÐе¼Èë
½â¾ö°ì·¨£º1£©.ÅäÖ×—Ê×Ñ¡Ïî——Ê×Ñ¡Éí·ÝÖ¤Ã÷£º²»½öÒªÅä“Êý¾Ý¿â”»¹ÒªÅ䓽ڵ㔣¬°ÑÊý¾Ý¿âÅäΪ"sys"µÇ½£¬½ÚµãÒ²ÒªÅäΪ"sys"(±¾µØ²Ù×÷ϵͳora_dba×éµÄ³ÉÔ±,ȱʡadministrator);2£©.¸Ä±¾µØ²ßÂÔ£º±¾µØÓû§ÖÐÌí¼ÓsysÓû§£¬²¢ÇÒÁ¥ÊôÓÚora_dba×é¡£ÕâÑù¾Í¿ÉÒÔµ¼ÈëÊý¾ÝÁË¡£
Ìáʾ£ºoracle9i,xpsp3²Ù×÷ϵͳ
3.
´íÎóÌáʾ£ºvni-4009£¬ËƺõÊÇÎÞ·¨ÁªÏµ½ÚµãÉϵĴúÀíµÄÒ»¸ö´íÎó¡£
´íÎóÖ¢×´£ºÔÚOEM¿ØÖÆ̨ÎÞ·¨ÕÒµ½Ð½¨µÄÊý¾Ý¿â£¬ÇÒͨ¹ý²éÕÒ½ÚµãÒ²²»ÄÜÕÒµ½¡£
½â¾ö°ì·¨£ºÉ¾³ýËùÓнڵ㣬ÖØДËÑË÷½Úµã“£¬Êý¾ÝµÄ½ÚµãÃûΪ»úÆ÷Ãû£¬ÇÒÈ·ÈÏlistener.oraºÍtnsnames.oraÁ½¸öÎļþµÄhostÉèÖÃÕýÈ·¡£
Ïà¹ØÎĵµ£º
Ò»¡¢ORACLEµÄÆô¶¯ºÍ¹Ø±Õ
1¡¢ÔÚµ¥»ú»·¾³ÏÂ
ÒªÏëÆô¶¯»ò¹Ø±ÕORACLEϵͳ±ØÐëÊ×ÏÈÇл»µ½ORACLEÓû§£¬ÈçÏÂ
su - oracle
a¡¢Æô¶¯ORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit
b¡¢¹Ø±ÕORACLEϵͳ
oracle>svrmgrl
SVRMGR>connect internal
SVR ......
תÔØ×Ô http://hi.baidu.com/libinichen/blog/item/9e13ac31175877a95edf0e0b.html
×¢£ºSID - Êý¾Ý¿â±êʶ
HOME_NAME - Oracle HomeÃû³Æ£¬ÈçOraHome92¡¢OraHome81
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁËÒ»¸öÊý¾Ý¿â£¬ËüµÄȱʡÆô¶¯ÀàÐÍΪ×Ô¶¯¡£·þÎñ½ø³ÌΪORACLE.EXE£¬²ÎÊýÎļþ ......
ÎÄÕÂÌáµ½£¬ÓÃCache hit ratioµÄ·½·¨À´¼ì²éORACLEÐÔÄÜÎÊÌâ¹ýʱÁË£¬ÀïÃæÓоä·Ç³£ÐÎÏóµÄ»°£ºÕâÎÞÒìÓÚÒ»¸öÒ½ÉúÖ»ÖªµÀ¸ù¾ÝѪѹµÄÀ´ÖÎÁƲ¡ÈË£¬¶ø²¡ÈËÓÉÓÚÌÛÍ´£¬Éñ¾ÐË·Ü£¬ÑªÑ¹ÔÚÒ»¸öºÏÀíµÄ·¶Î§ÄÚ£¬Ò½ÉúÈ´¸æËß»¼Õߣ¬Äãû²¡£¬µÈÄãѪѹµÍµÄʱºòÔÙÀ´¡£Í¬ÑùµÄ£¬ÎÒÃDz»Äܽö½ö¸ù¾ÝCache hit ratioÀ´ÅжÏORACLEÊ ......
in µÄ»°£¬ Èç¹ûÊÇnull ¾Í²»±È½ÏÁË£¬¼È²»ÊÇin Ò²²»ÊÇ not in
existsµÄ»° ÒòΪÓà = ¼ÓÔÚÌõ¼þÀï±È½ÏÁË£¬ËùÒÔ null ÊÇ not exists
select *
from pricetemp
where cast(ÉÌÆ·¥³ー¥É as varchar(10))not in(
select shohin_cd
&nbs ......
·½·¨Ò»£¬Ê¹ÓÃSQL*Loader
Õâ¸öÊÇÓõĽ϶àµÄ·½·¨£¬Ç°Ìá±ØÐëoracleÊý¾ÝÖÐÄ¿µÄ±íÒѾ´æÔÚ¡£
´óÌå²½ÖèÈçÏ£º
1 ½«excleÎļþÁí´æΪһ¸öÐÂÎļþ±ÈÈçÎļþÃûΪtext.txt£¬ÎļþÀàÐÍÑ¡Îı¾Îļþ£¨ÖƱí·û·Ö¸ô£©£¬ÕâÀïÑ¡ÔñÀàÐÍΪcsv£¨¶ººÅ·Ö¸ô£©Ò²ÐУ¬µ«ÊÇÔÚдºóÃæµÄcontrol. ......