WIN7ÏÂORACLE°²×°Á¬½ÓµÄÎÊÌâ
ÎÒÓÐÒ»¸öVBA³ÌÐò£¬ÔÚXPÏÂÔËÐÐÕý³££¬µ«ÔÚWIN7ÔËÐÐÊý¾Ý¿âÁ¬½ÓÄǶδúÂë¾Í±¨´í£º"TNS:ÎÞ·¨½âÎöÖ¸¶¨µÄÁ¬½Ó±êʶ·û"
ÎÊÌâÀ´ÁË£º
1 ÎÒÔÚWIN7ϵͳÀïnet configuration assistantµã»÷ÁËû·´Ó¦
2 ¸ù¾ÝÒÔÍù¾Ñ飬ÎÒÅжÏtnsnames.oraÎļþÓÐÎÊÌ⣬µ«¼ì²éÏÂÀ´Ó¦¸ÃÕýÈ·µÄ
3 ÎÒÓÃPL/SQL¹¤¾ßÈ¥Á¬Êý¾Ý¿â£¬È´ÊÇÄÜÕý³£Á¬½ÓÉϵÄ
4 ´úÂëÈçÏ£ºSet Osess = CreateObject("OracleInProcServer.XOrasession")
Set Odb = Osess.OpenDatabase("JVRPT", "RPTOWN/RPTOWN0", 0&)
ÄÄλ¸ßÊÖ°ïæ½â¾öÏ ÒѾÀ§ÈÅÁËÎÒ2ÌìÁË Ð»Ð»~
¼àÌýÓÐÎÊÌâ.
ÔÚÃüÁîÐÐÀïÔËÐÐnetca¿´¿´¿ÉÐÐ..
ÔËÐÐÁËÖ®ºóÏÔʾÈçÏ£º
java.io.FileNotFoundException: F:\oracle\pr
ca\netca-1002228ÉÏÎç5840.log (¾Ü¾ø·ÃÎÊ¡£)
at java.io.FileOutputStream.open(Na
at java.io.FileOutputStream.<init>(
at java.io.FileOutputStream.<init>(
at oracle.net.ca.NetCA.main(Unknown
Oracle Net Services ÅäÖÃʧ°Ü¡£Í˳ö´úÂëÊÇ-1
Êý¾Ý¿â°²×°Ã»ÓÐÎÊÌâ°É£¿
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
PL/SQL¹¤¾ßÁ¬½ÓûÎÊÌâ..¾Í¿Ï¶
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......