ÖØ°õÍÆ³ö£ºOracle¿Í»§¶Ë¾«¼òÂÌÉ«°æ
´óÐÍÏîÄ¿¿ª·¢ÖУ¬³£ÓõÄÊý¾Ý¿â£¬µ±ÊôOracle¡£µ«Oracle
¿Í»§¶Ë°²×°¾ÍÒªÒ»ÕŹâÅÌ£¬Ìå»ýºÜ´ó¡£¶øÇÒ°²×°ºó£¬»ù±¾ÉϾÍÓÃ2¸ö¹¦ÄÜ£ºTNSÅäÖ÷þÎñÃû£¬SqlPlus¡£ÔÚ¿ª·¢¹ý³ÌÖУ¬´óÁ¿Ê¹ÓÃToadºÍPL/SQL
Developer¡£Òò´Ë£¬Oracle¿Í»§¶Ë°²×°ÅÌ£¬½ö½öÊDZ»×÷Ϊһ¸öÇý¶¯¶øÐèÒª£¬¸ù±¾Ã»±ØÒª×°ÄÇô´óµÄ¿Õ¼ä¡£Òò´Ë£¬±¾Îĸø³öÁËÈçºÎʹÓþ«¼òµÄ
Oracle¿Í»§¶Ë¡£
ÎÒʹÓÃÁ½ÖÖ¾«¼òµÄOracle¿Í»§¶Ë£¬´ó¼Ò¿ÉÒÔÈÎÑ¡ÆäÒ»£º
Ò»¡¢Oracle 9i (°æ±¾: 9.0.1.0.1)¾«¼ò¿Í»§¶Ë ÂÌÉ«°æ
Õ¼ÓÃ35M¿Õ¼ä, ´øSqlPlus¹¤¾ß¡£ÂÌÉ«°æ£¬³¬¼¶ÍƼö£¡£¡£¡
ʹÓ÷½·¨£º
1. È·¶¨OracleHomeĿ¼£º±ÈÈçÎÒ×¼±¸°ÑOracle ¿Í»§¶Ë·ÅÔÚ d:\program files\Oracle ÏÂ
2. °Ñora90Ŀ¼¸´ÖƵ½d:\program files\Oracle Ŀ¼ÏÂ
3. Èç¹ûÄãµÄOracleHomeĿ¼ÓëÎҵIJ»Í¬£¬ÇëÓüÆÊ±¾´ò¿ªinstall_oracle9i.reg Îļþ£¬Ìæ»»d:\\progra~1\\Oracle£¬±£´æ¡£
4. Ë«»÷install_oracle9i.reg, µ¼Èë×¢²á±í¡£
5.
ÓüÆÊ±¾´ò¿ªD:\Program Files\Oracle\ora90\network\ADMIN\tnsnames.ora
Îļþ£¬Ôö¼ÓÒ»¸ö×Ô¼ºµÄÊý¾Ý¿â±ðÃûÅäÖÃ,±£´æ¡£ ¿ÉÒÔ¸´ÖÆÆäÖеÄÒ»¸ö£¬È»ºó½øÐÐÐ޸ģ¬Ö÷Òª¸Ä=Ç°ÃæµÄ±ðÃû£¬HostΪIPµØÖ·,
SERVICE_NAMEΪÊý¾Ý¿â·þÎñÆ÷µÄʵÀýÃû¡£
6. È»ºóÔËÐÐD:\Program Files\Oracle\ora90\BIN\sqlplusw.exe,ÊäÈëÓû§Ãû/ÃÜÂë@±ðÃû£¬¼´¿É¡£
Ð¶ÔØ·½·¨£º
1. Ë«»÷uninstall_oracle9i.reg, µ¼Èë×¢²á±í¡£
2. ɾ³ýd:\program files\Oracle Ŀ¼¡£
ÏÂÔØµØÖ·£º
[url]http://www.fs2you.com/zh-cn/files/fda64a07-0705-11dd-85d4-00142218fc6e/[/url]
¶þ¡¢Oracle 10g Instant Client
Oracle Instant Client ÊÇOracle ¹«Ë¾ÍƳöµÄ¾«¼ò°æ¿Í»§¶Ë£¬²»ÐèÒª°²×°£¬µ«ÐèÒª¼òµ¥ÅäÖÃһϡ£
ÏÂÔØµØÖ·£º
[url]http://www.oracle.com/technology/software/tech/oci/instantclient/index.html[/url]
ÎÒÏÂÔØµÄÊÇWin32ƽ̨ϵÄ10.2.0.3 Basic°æ±¾¡£Instant client ÓÐ2¸ö°æ±¾£ºBasicºÍBasic Lite¡£
Basic°æ±¾°üÀ¨ÁËËùÓеÄÖ§³ÖÔËÐÐOCI¡¢OCCI¡¢JDBC¡¢JDBC-OCIµÄÎļþ£¬Ö§³Ö¶àÖÖÓïÑÔ¡£
Basic LiteÊÇBasic°æ±¾µÄ¾«¼ò°æ£¬Ö»°üÀ¨ÁËÓ¢ÎĵĴíÎóÃèÊö£¬Ò²Ö»Ö§³ÖUnicode¡¢ASCIIºÍÅ·ÖÞ×Ö·û¼¯¡£
Òò´Ë£¬Èç¹ûÊý¾Ý¿â·þÎñÆ÷ÊÇÖÐÎÄ×Ö·û¼¯(Èç SIMPLIFIED CHINESE_CHINA.ZHS16GBK),Ôò±ØÐëÏÂÔØBasic°æ±¾¡£
Basic Lite Õ¼ÓÃ25M¿Õ¼ä£¬Basic Õ¼ÓÃ93M¿Õ¼ä¡
Ïà¹ØÎĵµ£º
¡¶oracle,db2,mysqlÀà±È¡·×÷ΪÈýÖÖÊý¾Ý¿âÒ»¸öÀà±È£¬Ä¿µÄÔÚÓÚͨ¹ýÀà±È£¬Á˽âÏÖÔÚÊý¾Ý¿âÏàËÆµãÓëÒìͬµã£¬Í¬Ê±¿ÉÒÔ°ïÖú´ó¼ÒÔÚÁ˽âÒ»ÖÖÊý¾Ý¿â£¬Äܹ»Ñ¸ËÙµØÑ§»áÆäËûÊý¾Ý¿â¡£³õ²½¶¨ÒåΪoracle,db2,mysqlÈýÖÖÊý¾Ý¿â£¬ÒÔºó¿ÉÄÜ»¹ÊÇ×·¼Óinformix,sysbase,sql serverµÈÊý¾Ý¿â¡£
±¾Æª×÷ΪÊׯª£¬Ä¿µÄÊÇÈôó¼Ò¶ÔÕâÈýÖÖÊý¾Ý¿â³£ÓõÄÖªÊ ......
http://inthirties.com:90/thread-1233-1-1.html
ºÃûÓÐÅöSolarisÁË£¬ÊÖÓÐЩÉúÁË£¬¿´À´ÕæÒª×°¸ösolaris£¬Æ½Ê±¶àÍæÍæ¡£
ÔÚsolarisÉÏ×°Oracle 10gÏÈ¡£
1. ¼ì²é°²×°ÒÀÀµ°ü
¹Ù·½ÒªÇóµÄ°ü
SUNWarc
SUNWbtool
SUNWhea
SUNWlibm
SUNWlibms
SUNWsprot
SUNWtoo
SUNWi1of
SUNWi1cs
SUNWi15cs
SUNWxwfnt
Ö´ÐÐÃüÁî
# p ......
ÎÒдµÄ½Å±¾£¬ÓеãÂý£¬½«¾Í×ÅÓðÉ
--kill sessionÓï¾ä
alter system kill session'50,492';
--ÒÔϼ¸¸öΪÏà¹Ø±í
SELECT * from v$lock;
SELECT * from v$sqlarea;
SELECT * from v$session;
SELECT * from v$process ;
SELECT * from v$locked_object;
SELECT * from all_ ......
ÉîÈëÁ˽âOracle SCN (1)
--------------------------------------------------------------------------------
£Û˵Ã÷£Ý±¾À´ÔÚÑо¿Backup and Recovery£¬¿ÉÊÇÔÚ×öʵÑéµÄʱºòÓöµ½Ò»Ð©ÎÊÌâ²»ÊǺÜÀí½â£¬½ø¶ø×·¸ùÇóÔ´£¬Ïë¸ãÇå³þ£¬ÓÚÊDZØÐë¸ãÇå³þSCNºÍRecoveryÖ®¼äµÄ¹ØÏµ¡£ÓÚÊǺõת¶øÑо¿SCN£¬ÕâÁ½Ìì¿´Á˺ܶàÎÄÕ£¬°üÀ¨EygleÍ ......
* start Oracle *
set noexec_user_stack=1
set msgsys:msginfo_msgmax=65535
set msgsys:msginfo_msgmnb=65535
set msgsys:msginfo_msgmap=258
set msgsys:msginfo_msgmni=1792
set msgsys:msginfo_msgssz=32
set msgsys:msginfo_msgtql=1792
set msgsys:msginfo_msgseg=32767
set shmsys:shminfo_shmmax=4294967 ......