oracleÀ䱸·Ý »Ö¸´
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨£¨Ð轨¿â£©
±¸·Ý£º
Ö±½Ó¿½±´oracleĿ¼ÏµÄadmin¡¢oradataÁ½¸öÎļþ¼Ð£¬ora92Ŀ¼ÏÂdatabase£¬µ½ÆäËû´æ´¢ÊµÏÖ±¸·Ý¡£
»Ö¸´£º
1.´´½¨Ò»¸öºÍÔÀ´Ò»ÑùµÄÊý¾Ý¿â¡£(°²×°Â·¾¶ºÍÊý¾Ý¿âÃû±ØÐëºÍÔÀ´Ò»ÖÂ)
2.ÓùÜÀíÔ±Á¬ÈëÊý¾Ý¿âºóÍ£Ö¹Êý¾Ý¿â¡£
3.°Ñ°²×°Ä¿Â¼ÏµÄadminºÍoradata¸´ÖƹýÈ¥¸²¸Ç£¨Èç¹û´æÔÚ¶à¸öÊý¾Ý¿â£¬¹À¼ÆÖ»ÐèÒª¸´ÖÆÏÂÃæµÄXJJĿ¼¾ÍÐÐÁË£©¡£
4.¸´ÖÆora92ÏÂÃæµÄdatabaseĿ¼£¨ÃÜÂëÎļþ£©¡£
5.Æô¶¯Êý¾Ý¿â¡£
ÉÏÊö±¸·ÝÁËÊý¾Ý¿âËùÓÐÐÅÏ¢°üÀ¨Êý¾Ý Óû§ ÃÜÂë¡£¡£¡£
Èç¹ûÕë¶Ôij¸öÊý¾Ý¿â Ö±½Ó±¸·ÝoradataϸÃÊý¾Ý¿âÎļþ¼´¿É¡£
·½·¨¶þ£º£¨²»Ð轨¿â£¬ÉÔÂé·³µã£©
À䱸·ÝÊý¾Ý±ØÐëÊÇÊý¾Ý¿â²»ÔÚopen״̬ÏÂ,¶ÔÊý¾Ý¿â½øÓÃÊý¾Ý±¸·Ý¡£ ¾ßÌå²Ù×÷£º
(1)£º ¹Ø±ÕDB £º shutdown immediate£»
(2)£ºcopy oradataĿ¼ÏµÄËùÓÐÎļþ£¬ °üÀ¨Êý¾ÝÎļþ£¬ ¿ØÖÆÎļþ£¬redo£¬µÈ£¬»¹ÐèÒªcopy ÃÜÂëÎļþ ÔÚĿ¼ora92Ï µÄdatabase ÖеÄpwd Îļþ.È«²¿copyµ½Ò»¸ö°²È«Ä¿Â¼ÖС£ÔÚsql Ï¿ÉÒÔÖ±½Ó¼ÓÒ»¸ö host È»ºóʹÓÃdosÃüÁî¡£Èçhost copy .............
(3)£ºÈç¹ûÊDzÙ×÷ϵͳµÄÖØÐ°²×°£¬Ö»ÒªÊÇͬÑùϵͳ£¬Í¬ÑùÊý¾Ý¿â°æ±¾£¬ÊÇ¿ÉÒÔ×öÀ䱸»Ö¸´¡£Ò»ÏÂ̸µÄÊÇϵͳµÄÖØÐ°²×°ºóµÄ²½Öè¡£
(4)£ºÕý³£°²×°oracleÈí¼þ£¨Ö®Ç°ÔÚpubÉÏһλÐÖµÜ˵²»ÐèÒª°²×°oracle¾Í¿ÉÒԸ㶨£¬±íʾ»³ÒÉ£©£¬Ö»ÐèÒª°²×°Èí¼þ£¬¿ÉÒÔ²»Óý¨ÊµÀý£¬½¨ÊµÀýµÄʱ¼äÒ²±È½Ï³¤£¬Ò²Ã»ÓбØÒª¡£ Èí¼þ°²×°ºÃÒԺ󣬿ªÊ¼×¼±¸»Ö¸´¡£
(5)£ºÊý¾Ý¸²¸Ç¹ýÈ¥°üÀ¨pwdÎļþ£¬·ÅÔÚÔÀ´µÄĿ¼£¬Èç¹ûĿ¼ÓÐËù¸Ä±äÔòÐèÒªÁíÍ⽨Á¢¿ØÖÆÎļþ£¬ÐÞ¸Äpfile¡£
(6)£º½¨Á¢·þÎñ£ºÊ¹ÓÃoradim ÃüÁî cmdÏ oradim -new -sid erp ±íʾ½¨Á¢Ò»¸ö·þÎñ£¬sidΪerp¡£¹ØÓÚoradimµÄÃüÁîÁíÍâ¸ø³öרÃŽâÊÍ¡£
(7)£º½¨Á¢¼àÌý£º net configuration assintant À´½¨Á¢£¬»òÓýű¾½¨Á¢²¢ÇÒ¿ªÆô¡£
(8)£º´ò¿ªÊý¾Ý¿â£º ÓÃoemÒ²ÐУ¬cmdÏÂÒ²ÐС£
set oracle_sid=erp;
sqlplus "/as sysdba";
startup;
select * from v$instance;
ÖÁ´Ë£¬À䱸·Ý»Ö¸´³É¹¦¡£¼´Ê¹ÄãÏÖÔÚÓÃoem´ò¿ªÊý¾Ý¿âʱ·¢ÏÖÌáʾÕÒ²»µ½sid £¬µ«Êµ¼ÊÉÏÄãÒѾ³É¹¦ÁË£¬´ËʱֻÐèÒªÖØÆôһϵÄÄãµÄ·þÎñÆ÷¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
ÔÚInternetÉÏÔË×÷Êý¾Ý¿â¾³£»áÓÐÕâÑùµÄÐèÇ󣺰ѱ鲼ȫ¹ú¸÷³ÇÊÐÏàËÆµÄÊý¾Ý¿âÓ¦ÓÃͳһÆðÀ´£¬Ò»¸ö½ÚµãµÄÊý¾Ý¸Ä±ä²»½öÌåÏÖÔÚ±¾µØ£¬»¹·´Ó³µ½Ô¶¶Ë¡£¸´ÖƼ¼Êõ¸øÓû§ÌṩÁËÒ»ÖÖ¿ìËÙ·ÃÎʹ²ÏíÊý¾ÝµÄ°ì·¨¡£
Ò»¡¢ÊµÏÖÊý¾Ý¿â¸´ÖƵÄǰÌáÌõ¼þ
1¡¢Êý¾Ý¿âÖ§³Ö¸ß¼¶¸´Öƹ¦ÄÜ
Äú¿ÉÒÔÓÃsystemÉí·ÝµÇ¼Êý¾Ý¿â£¬²é¿´v$optionÊÓͼ£¬Èç¹ûÆäÖÐAdv ......
---------Êýѧº¯Êý
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 ......
sql serverºÍoracleÐÐתÁеÄÒ»ÖÖµäÐÍ·½·¨
ǰÑÔ£ºÍøÉÏÓв»ÉÙÎÄÕÂÊǽ²ÐÐתÁе쬵«ÊǴ󲿷ֶ¼ÊÇÖ±½ÓÌù´úÂ룬ºöÊÓÁËÖмä¹ý³Ì£¬±¾ÈË×Ô¼ºË¼¿¼ÁËÏÂΪʲôҪÕâÑùʵÏÖ£¬²¢ÇÒ×öÁËÈçϵıʼǣ¬¶ÔÓÐЩ¶®µÄÈËÀ´Ëµ¿ÉÄÜûÓмÛÖµ£¬Ï£Íû¶Ô»¹²»¶®µÄÈËÓÐÒ»µã½è¼øÒâÒå¡£
¶ÔÓÚÓÐЩҵÎñÀ´Ëµ£¬Êý¾ÝÔÚ±íÖеĴ洢ºÍÆä×îÖÕµÄGrid±íÏÖÇ¡ºÃÏ൱ÓÚ°ÑÔ ......
¡¾°¸ÀýÒ»¡¿
ÌâÄ¿£º
--´¥·¢Æ÷£º
--Ìí¼ÓÔ±¹¤ÐÅÏ¢,Á÷Ë®ºÅ×÷Ϊ×Ô¶¯±àºÅ(ͨ¹ýÐòÁÐÉú³É),
--²¢ÇÒÅжÏÈç¹û¹¤×ÊСÓÚ0,Ôò¸ÄΪ0;Èç¹û´óÓÚ10000,Ôò¸ÄΪ10000¡£
CREATE TABLE emp2(
e_id NUMBER,
e_no NUMBER,
e_name VARCHAR2(20),
e_sal NUMBER
)
SELECT * from emp2;
CREATE SEQUENCE seq_trg_id;
INSERT INTO emp2(e_i ......
ÕÒ²»µ½ÔÌûÁË ¾ÍÌùÕâÀï°É£¡
ÔÚÏò´ó¼ÒÏêϸ½éÉÜOracle֮ǰ£¬Ê×ÏÈÈôó¼ÒÁ˽âÏÂOracle xmltypeÊÇʲô£¬Oracle´Ó9i¿ªÊ¼Ö§³ÖÒ»ÖÖеÄÊý¾ÝÀàÐÍ----
xmltype£¬ÓÃÓÚ´æ´¢ºÍ¹ÜÀíxmlÊý¾Ý£¬²¢ÌṩÁ˺ܶàµÄfunctions£¬ÓÃÀ´Ö±½Ó¶ÁÈ¡xmlÎĵµºÍ¹ÜÀí½Úµã¡£ÏÂÃæ½«½éÉÜOracle
xmltypeµÄһЩ»ù±¾Ê¹Óá£
1.½¨Á¢º¬ÓÐOracle xmltypeÊý¾Ý ......