Oracle OSÈÏÖ¤ÒÔ¼°¿ÚÁîÎļþ
1.OSÈÏÖ¤
Oracle°²×°Ö®ºóĬÈÏÇé¿öÏÂÊÇÆôÓÃÁËOSÈÏÖ¤µÄ£¬ÕâÀïÌáµ½µÄosÈÏÖ¤ÊÇÖ¸·þÎñÆ÷¶ËosÈÏÖ¤¡£OSÈÏÖ¤µÄÒâ˼°ÑµÇ¼Êý¾Ý¿âµÄÓû§ºÍ¿ÚÁîУÑé·ÅÔÚÁ˲Ù×÷ϵͳһ¼¶¡£Èç¹ûÒÔ°²×°OracleʱµÄÓû§µÇ¼OS£¬ÄÇô´ËʱÔڵǼOracleÊý¾Ý¿âʱ²»ÐèÒªÈκÎÑéÖ¤£¬È磺
SQL> connect /as sysdba
ÒÑÁ¬½Ó¡£
SQL> connect sys/aaa@test as sysdba
ÒÑÁ¬½Ó¡£
SQL> connect sys/bbb as sysdba
ÒÑÁ¬½Ó¡£
SQL> connect aaa/bbb as sysdba
ÒÑÁ¬½Ó¡£
SQL> show user
SYS
SQL>
²»ÂÛÊäÈëʲôÓû§£¨ÄÄÅÂÕâ¸öÓû§ÈçaaaÔÚÊý¾Ý¿âÖиù±¾²»´æÔÚ£©£¬Ö»ÒªÒÔsysdbaȨÏÞÁ¬½ÓÊý¾Ý¿â£¬¶¼¿ÉÒÔÁ¬½ÓÉÏ£¬²¢ÇÒÁ¬½ÓÓû§ÊÇsys£¬ÕâÑùºÜ·½±ã£¬ÓÐʱºò£¬Èç¹ûÍü¼ÇÁËÊý¾Ý¿âµÄÃÜÂ룬¶øÓÖÏëµÇ¼Êý¾Ý¿â£¬¿ÉÒÔͨ¹ýÕâÖÖ·½Ê½£¬Ç°ÌáÊÇÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ.
µ«ÊÇ·½±ãµÄͬʱҲ´øÀ´ÁËһЩ°²È«Òþ»¼£¬ÓÚÊǺܶàÈËÏëÆÁ±ÎosÈÏÖ¤£¬
ÔÚwinÏÂÖ»Òª°Ñoracle_home/NETWORK/admin/sqlnet.oraÖеÄSQLNET.AUTHENTICATION_SERVICES= (nts)nts¸Ä³Énone»òÕß×¢Ê͵ôÕâ¾ä»°(ÔÚÇ°Ãæ¼ÓÉÏ#)£¬¾Í¿ÉÒÔÆÁ±Îos¹¦ÄÜ£¬ÒªÏëÒÔsysÓû§Á¬ÉÏÊý¾Ý¿â±ØÐëÊäÈëÕýÈ·µÄsys¿ÚÁ»òÕß¿ÉÒÔ°ÑoracleµÄ°²×°Óû§´Ó×éora_dbaÖÐɾ³ýµô£¬µ±È»Ò²¿ÉÒÔÖ±½Ó°Ñora_dbaÕâ¸ö×éҲɾ³ý£¬¶¼¿ÉÒÔÆÁ±Îos¹¦ÄÜ.È磺
SQL> connect /as sysdba
ERROR:
ORA-01031: ȨÏÞ²»×ã
SQL> connect sys/aaa as sysdba
ERROR:
ORA-01017: Óû§Ãû/¿ÚÁîÎÞЧ; µÇ¼±»¾Ü¾ø
SQL> connect aaa/bbb as sysdba
ERROR:
ORA-01031: ȨÏÞ²»×ã
SQL> connect sys/system as sysdba
ÒÑÁ¬½Ó¡£
SQL>
ÔÚunix/linuxÏÂÒ²¿ÉÒÔÔÚÎļþsqlnet.oraÖÐÔö¼ÓSQLNET.AUTHENTICATION_SERVICES=(none)ÒÔ¼°É¾³ýdba(groupdel dba)×é»òÕß°ÑoracleÓû§´Ódba×éÖÐɾ³ý¶¼¿ÉÒÔÆÁ±ÎosÈÏÖ¤¡£ÀûÓÃÕâÁ½ÖÖ·½·¨ÆÁ±Îos¹¦ÄÜËÆºõ×ÜÓÐЩÈÃÈ˲»·ÅÐÄ£¬»òÕß˵²»ÄÜÈÃÈËÍêÈ«ÐÅ·þ£¬ÒòΪ±Ï¾¹ÏµÍ³¹ÜÀíÔ±»¹ÊÇ¿ÉÒÔ´´½¨ora_dba or dba×éÒÔ¼°ÐÞ¸Äsqlnet.oraÎļþ......
2. ¿ÚÁîÎļþ
OracleµÄ¿ÚÁîÎļþµÄ×÷ÓÃÊÇ´æ·ÅËùÓÐÒÔsysdba»òÕßsysoperȨÏÞÁ¬½ÓÊý¾Ý¿âµÄÓû§µÄ¿ÚÁÈç¹ûÏëÒÔsysdbaȨÏÞÔ¶³ÌÁ¬½ÓÊý¾Ý¿â£¬±ØÐëʹÓÿÚÁîÎļþ£¬·ñÔò²»ÄÜÁ¬ÉÏ£¬ÓÉÓÚsysÓû§ÔÚÁ¬½ÓÊý¾Ý¿âʱ±ØÐëÒÔsysdba or sysoper·½Ê½£¬Ò²¾ÍÊÇ˵sysÓû§ÒªÏëÁ¬½ÓÊý¾Ý¿â±ØÐëʹÓÿÚÁîÎļþ£¬Òò´ËÎÒÈÏΪÔÚÊý¾Ý¿âÖдæ·ÅsysÓû§µÄ¿ÚÁîÆäʵûÓÐÈκÎÒâÒ壡ʹÓÿÚÁîÎļþµÄºÃ´¦ÊǼ´Ê¹Êý¾Ý¿â²»´¦ÓÚopen״̬£¬ÒÀÈ»¿ÉÒÔͨ¹ý¿ÚÁîÎļþÑéÖ¤À´Á¬½ÓÊý¾Ý¿â¡£¿ªÊ¼°
Ïà¹ØÎĵµ£º
¹Ø¼ü×Ö: oracle job ¼ä¸ôʱ¼ä trunc
¼ÙÉèÄãµÄ´æ´¢¹ý³ÌÃûΪPROC_RAIN_JM
ÔÙдһ¸ö´æ´¢¹ý³ÌÃûΪPROC_JOB_RAIN_JM
ÄÚÈÝÊÇ£º
Create Or Replace Procedure PROC_JOB_RAIN_JM Is li_jobno Number; &nb ......
ÏÂÎçÈ¥²Î¼ÓÒ»¸öOracleÓйغ£Á¿Êý¾Ý´æ´¢¼¼ÊõµÄÅàѵ½²×ùÁË¡£
µØÖ·ÔÚ¹ãÖÝÊÐÁÖºÍÎ÷·101ºÅÌìºÓÇø¼Æ¾´óÂ¥Î÷²àÈýÂ¥¡£
Åàѵ·¢Æð»ú¹¹Îª£º¹ãÖÝÖÐî£ÐÅÏ¢¼¼ÊõÓÐÏÞ¹«Ë¾¡£
ÏÂÃæ¾Í¼òÒª×ܽáÒ»ÏÂËùÌýµ½µÄһЩ¶«Î÷£¬Ò²ËãÊÇѧµ½µÄÕâЩ¼¼Êõ¡£²»¹ýÓеĶ«Î÷²»ÖªµÀ×ܽáµÄ¶Ô²»¶Ô£¬ÔÝÇÒàñàðÍÌÔæ°É¡£
OracleµÄ´æ´¢¼¼Êõ
´óÌåÉÏ· ......
1.oracle×Ö·û¼¯ÎÊÌ⣺
Êý¾Ý¿â×Ö·û¼¯ÎªZHS16BGK£¬ºº×ÖÔÚÊý¾Ý¿â´æ·ÅµÄʱºòÕ¼ÓÃÁ½¸ö×Ö½Ú
Êý¾Ý¿â×Ö·û¼¯ÎªUTF8£¬ºº×ÖÔÚÊý¾Ý¿âÀï´æ·ÅµÄʱºòÕ¼ÓÃÈý¸ö×Ö½Ú
ÓÉÓÚ×Ö·û¼¯²»Í¬£¬µ¼ÖÂÏÖÔÚÊý¾Ý¿âIMPµÄʱºòÓÐЩ±íµÄ×ֶγ¤¶È²»¹»£¬³öÏÖORA-12899: value too large for columnµÄ´íÎó¡£
ͨ¹ýÐÞ¸Ä×Ö·û¼¯¿ÉÒÔ½â¾öÕâÖÖÎÊÌâ¡£
2.utf-8ºÍunico ......
ËÀËøµÄÔÒò
1¡£Ä£ÄâËÀËø
1¡£1¡£Ö÷±í
-- Create table
create table WDZ1
(
WDZ1ID NUMBER not null,
MEMO VARCHAR2(20)
)
;
alter table WDZ1
add constraint XXXXXX primary key (WDZ1ID);
1¡£2¡£´Ó±í£¨Ã»ÓÐÍ⽡µÄË÷Òý£©
-- Create table
create table WDZ2
(
WDZ2ID NUMBER not null,
WDZ1ID NUMBER,
M ......
--single line method
select ascii('A') Big_A from dual;
select chr(65) A, chr(122) z, chr(223) ch3 from dual;
select concat('sigo','way') from dual;
select initcap('sigoway') from dual;
select instr('ababab','a',-1,2), instr('ababab','a',1,3) from dual;
select instrb('ababab','a',1,3) from dua ......