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

Oracle²Ù×÷ϵͳÈÏÖ¤

ĬÈÏÇé¿öÏ£¬ÔÚOracleµÄÖ÷»úÉÏ£¨linuxϵͳ£©µÄOracle²Ù×÷ϵͳÓû§Ï£¬ÒÔsysÓû§µÇ½Êý¾Ý¿âʱ¿ÉÒÔ²»ÓÃÊäÈëÃÜÂëÖ±½ÓµÇ¼¡£Êµ¼ÊÉÏ£¬Ö»ÒªÊÇÊôÓÚdba×飨linux£©»òosdba×飨windows£©Ï£¬¶¼¿ÉÒÔ²»ÓÃÃÜÂë½øÐеǼ¡£ÕâÊÇÈÏÖ¤·½Ê½³ÆÎªOSÈÏÖ¤¡£
ÕâÖֵǼ·½Ê½µÄ¿ØÖÆ£¬ÊÇͨ¹ý$ORACLE_HOME/network/admin/sqlnet.oraÖеģº
SQLNET.AUTHENTICATION_SERVICES
²ÎÊýÀ´¿ØÖƵġ£ÓÐÈý¸öÖµ¿ÉÈ¡£º
1¡¢NTS¡£Õâ¸ö²ÎÊýÊÇÖ÷»ú²Ù×÷ϵͳÊÇwindowsµÄʱºòרÓõġ£µ±ÔÚwindowsÉÏÉèÖøòÎ
Êýºó£¬¼´¿É½øÐÐOSÈÏÖ¤¡£ÐèҪעÒâµÄÊÇ£¬¸Ã²ÎÊýÊÇwindowsרÓõġ£Èç¹ûoracleÊÇ
×°ÔÚunixÀàϵͳÉÏ£¬OSÈÏÖ¤¶¼»áʧ°ÜµÄ¡£
2¡¢NONE¡£±íʾ²»×ö²Ù×÷ϵͳÈÏÖ¤£¬¼´ÒªÇóÊäÈëÃÜÂë¡£
3¡¢ALL¡£¼´ËùÓÐÈÏÖ¤·½Ê½¶¼¿ÉÒÔ¡£
ËùÒÔÒªÔÚÖ÷»úÉϽøÐÐosÈÏÖ¤Ö±½ÓµÇ¼sys as sysdba£¬Ö»ÒªÉ趨ΪALL»òÕß²»É趨¸Ã²ÎÊý£¨
¼´×¢Ê͵ô¸ÃÐУ©¾ÍÐÐÁË¡£
Èç¹ûÒª½ûÖ¹OSÈÏÖ¤£¬ÔòÖ»ÒªÉèÖÃΪNONE¼´¿É¡£
 
ÌâÍâ»°£º
¹ØÓÚOSÈÏÖ¤µÄ£¬Æäʵһ¿ªÊ¼Óëremote_login_passwordfile»ìÏýÆðÀ´ÁË¡£
1¡¢OSÈÏÖ¤ÊÇÖ¸Ö÷»úÉϰ²×°OracleµÄÓû§µÄ¹ÜÀíÔ±µÇ¼ÈÏÖ¤·½Ê½¡£
2¡¢µ±Õâ¸ö¹ÜÀíÔ±³¢ÊÔͨ¹ýÍøÂçÀ´µÇ¼Oracle DBʱ£¬½«»áʧ°Ü¡££¨ÒÔÍøÂ緽ʽµÇ¼Êý¾Ý¿â£¬¼´Ê¹Í¨¹ý½«·Ç³£²»°²È«µÄ²ÎÊýremote_os_authentÉèÖÃΪtrue£¬²Ù×÷ϵͳÈÏÖ¤Ò²²»»áÉúЧ¡££©
ÒªÔÊÐíÔ¶³Ì¹ÜÀíÔ±sysµÇ¼Êý¾Ý¿â£¬ÔòÒªÇóÉèÖÃ
remote_login_passwordfile = exclusive
È»ºó´´½¨passowrd file£º
orapwd file=orapw$ORACLE_SID passwd=passwd entries=10 force=y
ÐèҪעÒâµÄÊÇÕâÀïµÄpassword fileÎļþÃüÃûÐèÒª·ûºÏÌØ¶¨µÄÕâ¸ö¸ñʽ£¬Èç¹ûÃüÃû²»¶Ô£¬ÏµÍ³½«»áÕÒ²»µ½Õâ¸öÃÜÂëÎļþ£¬¶ø²úÉú£º
08:38:36 idle> grant sysdba to sys;
grant sysdba to sys
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
ÉÏÃæÕâ¸ö´íÎó¡£Ò²¾Íµ¼ÖÂÁËsysdba»òÕß¹ÜÀíÔ±Óû§²»ÄÜÔ¶³ÌµÇ¼Êý¾Ý¿â¡£
Òª¼ì²éÊÇ·ñÒѾ­½«sysÓû§·ÅÈëÃÜÂëÎļþ£¬¿ÉÒÔ²éѯ£º
08:49:04 idle> select * from v$pwfile_users;
USERNAME     SYSDBA          SYSOPER
---------------       ---------------   -------------------
SYS                    TRUE  &


Ïà¹ØÎĵµ£º

Oracle 11g 10g ÎÞ·¨Æô¶¯EmµÄ½â¾ö°ì·¨¡£

½â¾öOracle EMÎÞ·¨Æô¶¯
ORACLE 11g, EM ÎÞ·¨Æô¶¯µÄÎÊÌ⣬¿ÉÄÜÊÇIP¸ü¸ÄÁ˵ÄÔ­Òò£¬ËùÒÔÎÒʹÓÃÁËEMCAÃüÁîÖØÐÂÅäÖÃÁËÒ»ÏÂORACLE EM£¬¾ßÌå¹ý³ÌÈçÏ£º
I:\Documents and Settings\geshaoqing>emca -config dbcontrol db -repos recreate
EMCA ¿ªÊ¼ÓÚ 2007-10-12 11:16:40
EM Configuration Assistant 10.2.0.1.0 Õýʽ ......

oracle ½ø³Ì »á»°£¬Óα꣬ÊÂÎñµÄ¹ØÏµ

oracle ½ø³Ì »á»°£¬Óα꣬ÊÂÎñµÄ¹ØÏµ
Èç¹ûÔÚLINUX Ï ÊÇÓÃTOP ¿ÉÒÔ¿´µ½ÕýÔÚÅܵÄORACLE ½ø³Ì¡£ORACLE ³ýÁ˺ǫ́½ø³ÌÍ⻹ÓÐÓû§½ø³Ì¡£
¼ÈÊÇ¿ªÆôÁ˲¢ÐУ¬Ò²Êǵ¥¶ÀµÄ½ø³Ì¡£
PL/SQL DEVELOPER ÀïµÄ¶à¸ö²éѯ´°¿Úʵ¼ÊÉÏÊǽø³Ì¡£
Ò»¸ö½ø³Ì¿ÉÒÔ°üº¬¶à¸ö»á»°£¬µ±ËüÃÇÖ»ÄÜ´®ÐÐÔËÐС£±ÈÈçÔÚÒ»¸ö²éѯ´°¿ÚÖÐÖ´ÐÐÈý¸öSELECT²éѯ¡£
ÏÂÃæ ......

Oracle ³£ÓÃÃæÊÔÌâ

1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄ
Êý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ÉÒÔ½«Êý¾Ý¿â»Ö¸´µ½ÈÎÒâÒ»¸öʱ¼äµã¡£À䱸·ÝµÄÓŵãÔÚÓÚËüµÄ±¸·ÝºÍ»Ö¸´
²Ù×÷Ïൠ......

oracle jobºÅʹÓÃ

µ±ÓÃsubmit½¨JOBʱ£¬JOBIDÓÉϵͳ×Ô´øSEQUENCE£ºsys.JOBSEQÉú³É¡£
Èç¹ûÒ»¶Îʱ¼äºóJOBID¹ý´ó£¬¿ÉÒÔDROP SEQUENCE sys.JOBSEQ;ÔÙÖØ½¨
create sequence JOBSEQ
minvalue 1
maxvalue 999999999999
start with 1
increment by 1
cache 20;
À´ÖØÐ¿ªÊ¼JOBID¡£
¿ÉÒÔÓÃÏÂÃæÓï¾ä¸üÐÂÒѾ­½¨Á¢µÄJOBID£º
UPDATE sys.Job$
SE ......

ÉîÈë·ÖÎöOracle×Ö·û¼¯(zt£©

1¡¢×Ö·û¼¯µÄһЩ»ù±¾ÖªÊ¶
    ×Ö·û¼¯ÓкܶàÖÖ£¬×î³õµÄ×Ö·û¼¯ÊÇASCII£¬ÓÉÓÚASCIIÖ§³ÖµÄ×Ö·ûºÜÓÐÏÞ£¬Òò´ËËæºóÓÖ³öÏÖÁ˺ܶàµÄ±àÂë·½°¸£¬ÕâЩ±àÂë·½°¸´ó²¿·Ö¶¼ÊǰüÀ¨ÁËASCIIµÄ¡£EBCDIC±àÂëÊÇÁíÒ»¸ö±È½Ï»ù±¾µÄ±àÂ룬ËüµÄ²¿·Ö×Ö·û²ÉÓÃÁ˺ÍASCII²»Í¬µÄ±àÂëÖµ£¬Òò´ËÁ½ÕßÊDz»¼æÈݵĻù±¾±àÂë·½°¸¡£²ÉÓÃEBCDIC±àÂëµÄ±È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ