Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖÐconnect by priorʵÏֵݹé²éѯ

oracleÖÐconnect by priorʵÏֵݹé²éѯ
ÊÕ¼¯µÄ¼¸ÌõÔÚoracleÖÐͨ¹ýconnect by priorÀ´ÊµÏֵݹé²éѯ
Start with...Connect By×Ó¾äµÝ¹é²éѯһ°ãÓÃÓÚÒ»¸ö±íά»¤Ê÷ÐνṹµÄÓ¦Óá£
´´½¨Ê¾Àý±í£º
CREATE TABLE TBL_TEST
(
ID    NUMBER,
NAME VARCHAR2(100 BYTE),
PID   NUMBER    ......

Oracle¹ÜÀíÓëά»¤.ÊÖ¹¤´´½¨Êý¾Ý¿âÒÔ¼°½Å±¾

 Oracle¹ÜÀíÓëά»¤.ÊÖ¹¤´´½¨Êý¾Ý¿âÒÔ¼°½Å±¾
ת×Ô ²Ýľ¹Ï
Ò»¡¢Ç°ÑÔ
 ËµÊµ»°£¬ÔçÒÑÑá¾ëÁËʹÓÃdbcaµÄ´´½¨Êý¾Ý¿â£¬´ó¸Å±È½ÏÓеã×÷ÓõÄÊÇ¿ÉÒÔÉú³É´´½¨½Å±¾°Õ¡£
¡¶Oracle¹ÜÀíÓëά»¤.°²×°´´½¨Æô¶¯¹Ø±ÕÊý¾Ý¿âµÄ³£¼ûÎÊÌâ(Ò»)¡·(Èý¡¢´´½¨Êý¾Ý¿â)Ò»ÎÄÖÐÓÐËùÌá¼°¡£±¾ÎÄÖ÷Òª¾ÍÊÇÏêÊöÊÖ
¹¤Ê¹Óýű¾´´½¨Oracle 10gÊý¾Ý¿â¡£ ......

oracle µÄredoºÍundo

À´×Ôhttp://www.inthirties.com/thread-239-1-1.html
 ÔÚÕâÀï»á½éÉÜUNDO£¬REDOÊÇÈçºÎ²úÉúµÄ£¬¶ÔTRANSACTIONSµÄÓ°Ï죬ÒÔ¼°ËûÃÇÖ®¼äÈçºÎЭͬ¹¤×÷µÄ¡£ 
ʲôÊÇREDO 
REDO¼Ç¼transaction logs£¬·ÖΪonlineºÍarchived¡£ÒÔ»Ö¸´ÎªÄ¿µÄ¡£ 
±ÈÈ磬»úÆ÷Í£µç£¬ÄÇôÔÚÖØÆðÖ®ºóÐèÒªonline redo logsÈ¥»Ö¸´ÏµÍ³µ ......

oracle ÐÞ¸Ä×Ö·û¼¯

 3oracleÊý¾Ý¿âµÄ×Ö·û¼¯¸ü¸Ä
A¡¢oracle server ¶Ë ×Ö·û¼¯²éѯ
select userenv(‘language’) from dual
ÆäÖÐNLS_CHARACTERSET Ϊserver¶Ë×Ö·û¼¯
NLS_LANGUAGE Ϊ server¶Ë×Ö·ûÏÔʾÐÎʽ
B¡¢²éѯoracle client¶ËµÄ×Ö·û¼¯
$echo $NLS_LANG
Èç¹û·¢ÏÖÄãselect ³öÀ´µÄÊý¾ÝÊÇÂÒÂ룬Çë°Ñclient¶ËµÄ×Ö· ......

µ¼³öOracleÊý¾Ý¿â½á¹¹

µ¼³öOracleÊý¾Ý¿â½á¹¹
 
1.·½·¨Ò»£ºÖ±½ÓдsqlÓï¾ä
//»ñÈ¡Ò»¸öSCHEMAϵÄËùÓн¨±íºÍ½¨Ë÷ÒýµÄÓï·¨£¬ÒÔscottΪÀý£º
spool portal_schema.sql
SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
from USER_TABLES u;
SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name)
from USER_INDEXES u;
spool off;
2. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ