Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle Êý¾Ý¿âÄêµ×¼ì²é


oracle Êý¾Ý¿âµÄά»¤
¿ì¹ýÄêÁË£¬¸÷¼Ò¹«Ë¾¶¼Òª×¼±¸·Å¼ÙÁË£¬¸ø×Ô¼ºµÄÊý¾Ý¿â×ö¸öÌå¼ì°É£¬Ð´¸ö±¨¸æÖ®ÀàµÄ£¬ºÇºÇ¡£
¿´Á˸ö±ðÈËдµÄ ÏÈÄÃÀ´´æ×Å ÓпÕ×Ô¼º±à¸ö¡£
 
 
ÔØ×ÔoracleÖÐÎļ¼ÊõÂÛ̳¡£´ÓÕûÌåÉϽéÉÜÁËÒ»¸ödbaµÄÖ°ÔðºÍÈÎÎñµÈµÈ¡£¡¡¡¡ 
ORACLEÊý¾Ý¿â¹ÜÀíÔ±Ó¦°´ÈçÏ·½Ê½¶ÔORACLEÊý¾Ý¿âϵͳ×ö¶¨ÆÚ¼à¿Ø£º  
(1). Ã¿Ìì¶ÔORACLEÊý¾Ý¿âµÄÔËÐÐ״̬,ÈÕÖ¾Îļþ,±¸·ÝÇé¿ö,Êý¾Ý  
¿âµÄ¿Õ¼äʹÓÃÇé¿ö,ϵͳ×ÊÔ´µÄʹÓÃÇé¿ö½øÐмì²é,·¢ÏÖ²¢½â¾ö  
ÎÊÌâ¡£  
(2). Ã¿ÖܶÔÊý¾Ý¿â¶ÔÏóµÄ¿Õ¼äÀ©Õ¹Çé¿ö,Êý¾ÝµÄÔö³¤Çé¿ö½øÐÐ¼à¿Ø,¶ÔÊý¾Ý¿â×ö½¡¿µ¼ì²é,¶ÔÊý¾Ý¿â¶ÔÏóµÄ״̬×ö¼ì²é¡£  
(3). Ã¿Ô¶ԱíºÍË÷ÒýµÈ½øÐÐAnalyze,¼ì²é±í¿Õ¼äË鯬,ѰÕÒÊý¾Ý¿â  
ÐÔÄܵ÷ÕûµÄ»ú»á,½øÐÐÊý¾Ý¿âÐÔÄܵ÷Õû,Ìá³öÏÂÒ»²½¿Õ¼ä¹ÜÀí  
¼Æ»®¡£¶ÔORACLEÊý¾Ý¿â״̬½øÐÐÒ»´ÎÈ«Ãæ¼ì²é¡£  
ÿÌìµÄ¹¤×÷  
(1).È·ÈÏËùÓеÄINSTANCE״̬Õý³£  
µÇ½µ½ËùÓÐÊý¾Ý¿â»òÀý³Ì,¼ì²âORACLEºǫ́½ø³Ì:  
$ps –ef|grep ora  
(2). ¼ì²éÎļþϵͳµÄʹÓã¨Ê£Óà¿Õ¼ä£©¡£Èç¹ûÎļþϵͳµÄÊ£Óà¿Õ¼äСÓÚ20%£¬Ðèɾ³ý²»ÓõÄÎļþÒÔÊͷſռ䡣  
$df –k  
(3). ¼ì²éÈÕÖ¾ÎļþºÍtraceÎļþ¼Ç¼alertºÍtraceÎļþÖеĴíÎó¡£  
Á¬½Óµ½Ã¿¸öÐè¹ÜÀíµÄϵͳ  
? Ê¹ÓÃ’telnet’  
? ¶Ôÿ¸öÊý¾Ý¿â,cd µ½bdumpĿ¼,ͨ³£ÊÇ$ORACLE_BASE/<SID>;/bdump  
? Ê¹ÓàUnix ‘tail’ÃüÁîÀ´²é¿´alert_<SID>;.logÎļþ  
? Èç¹û·¢ÏÖÈκÎеÄORA- ´íÎó,¼Ç¼²¢½â¾ö  
(4). ¼ì²éÊý¾Ý¿âµ±ÈÕ±¸·ÝµÄÓÐЧÐÔ¡£  
¶ÔRMAN±¸·Ý·½Ê½:  
¼ì²éµÚÈý·½±¸·Ý¹¤¾ßµÄ±¸·ÝÈÕÖ¾ÒÔÈ·¶¨±¸·ÝÊÇ·ñ³É¹¦  
¶ÔEXPORT±¸·Ý·½Ê½:  
¼ì²éexpÈÕÖ¾ÎļþÒÔÈ·¶¨±¸·ÝÊÇ·ñ³É¹¦  
¶ÔÆäËû±¸·Ý·½Ê½:  
¼ì²éÏàÓ¦µÄÈÕÖ¾Îļþ  
(5). ¼ì²éÊý¾ÝÎļþµÄ״̬¼Ç¼״̬²»ÊÇ“online”µÄÊý¾ÝÎļþ£¬²¢×ö»Ö¸´¡£  
Select file_name from dba_data_files where status


Ïà¹ØÎĵµ£º

ÓÃradiusºÍoracle×öÈÏÖ¤¼Æ·Ñϵͳ


Redhat
as4 + oracle 10g(10.2.0)
+ freeradius1.1.2+ tomcat5.5
*****************************
±¾ÎÄĿ¼
********************************
Ò»¡¢°²×°
redhat as4
¶þ¡¢°²×°
oracle 10g
£¨
10201_database_linux32.zip
£©
   
£¨Ò»£©¼ì²é
oracle 10g
ËùÐèµÄ°ü×é¼þ£º
£¨¶þ£©ÉèÖÃϵͳ²ÎÊ ......

oracle ·ÖÇø²ð·Ö ²»ÄܲåÈëÊý¾Ý 01502 Ë÷ÒýʧЧ

Êý¾Ý±íday_energyµ±Ç°ÎªÔ·ÖÇø±í£¬·ÖÇøÐÅÏ¢ÈçÏ£ºDE_200912,DE_201001,DE_201002.....,Ô·ÖÇø±í³öÏÖËٶȲéѯÂý£¬Òò´Ëͨ¹ý½¨Á¢ÈÕ·ÖÇø±í½øÐиÄÉÆ¡£
²ð·ÖÔ·ÖÇø±íµÄÓï¾äΪ£º
alter table day_energy split partition de_201001 at('20100102') into (partition de_20100101,partition de_20100102)
·ÖÎö£º
alter table ±íà ......

SQL ServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

---------Êýѧº¯Êý
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as int) v ......

¹ØÓÚOracle to_char()º¯ÊýÖеÄIW,WW ÖܱðÏÔʾ

1£©wwµÄË㷨ΪÿÄê1ÔÂ1ÈÕΪµÚÒ»ÖÜ¿ªÊ¼£¬date+6ΪÿһÖܽáβ
¡¡¡¡ÀýÈç20050101ΪµÚÒ»ÖܵĵÚÒ»Ì죬¶øµÚÒ»ÖܵÄ×îºóÒ»ÌìΪ20050101+6=20050107
¡¡¡¡¹«Ê½ ÿÖܵÚÒ»Ìì £ºdate + ÖÜ * 7 - 7
¡¡¡¡Ã¿ÖÜ×îºóÒ»Ì죺date + ÖÜ * 7 - 1
2£©iwµÄË㷨ΪÐÇÆÚÒ»ÖÁÐÇÆÚÈÕËãÒ»ÖÜ£¬ÇÒÿÄêµÄµÚÒ»¸öÐÇÆÚһΪµÚÒ»ÖÜ£¬
¡¡¡¡ ÀýÈç20050101Î ......

LEI Á¬½ÓORACLE °æ±¾ÎÊÌâ

Can you connect to an Oracle database with a 64-bit Oracle client?
 Technote (FAQ)
 
 
 
Question
You are unable to connect to an Oracle database with a 64-bit Oracle client. Does Lotus Enterprise Integrator (LEI), Lotus Domino Enterprise Connection Services (DECS), or LSX ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ