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

Oracle±¸·ÝÎÊÌâ

ÎÒÓõÄÊÇOracle9i£¬ÓÃsysmanµÇ¼µ½OEM¡£
Ê×Ñ¡Éí·ÝÖ¤Ã÷ÖеÄpc½ÚµãÉí·ÝÖ¤Ã÷ºÍÊý¾Ý¿âÉí·ÝÖ¤Ã÷ÎÒ¶¼ÌîÁË£¬
²¢ÇÒpcÓû§¼ÓÈëµ½ÁË¡°×÷ΪÅú´¦Àí×÷ÒµµÇ¼¡±ÖУ¬
Êý¾Ý¿âÉí·ÝÖ¤Ã÷ÖеĽÇÉ«ÊÇDBA¡£
ÊÔͼ¶ÔÊý¾Ý¿â½øÐб¸·Ý£¬×ÜÊÇÌáʾ£ºÊ¹ÓÃÊ×Ñ¡Éí·ÝÖ¤Ã÷ʱ³öÏÖÈçÏ´íÎó£ºORA-01031:insufficient privileges¡£
Ö±½ÓÓÃrman»òexp°É£¬Ì׸ö¿Ç×ÓÓÃʲôoemÂé·³¡£

µÇ¼·½Ê½ÄØ
ÊÇnormal»¹ÊÇsysdba

ÒýÓÃ
µÇ¼·½Ê½ÄØ
ÊÇnormal»¹ÊÇsysdba

Á¬½ÓÊý¾Ý¿âʱ£¬
Á¬½ÓÉí·ÝΪsysdbaµÄʱºò£¬ÌáʾȨÏÞ²»×ã¡££¨ÊÂʵÉÏÓû§µÄ½ÇɫΪdba£©
½«Á¬½ÓÉí·Ý¸ÄΪnormal¾Í¿ÉÒÔÁ¬½ÓÁË¡£

ÓÃsqlplus °É¡£

SYSDBAÓëDBA²»ÊÇͬһ¸ÅÄî¡£

SYSDBAÊÇȨÏÞ£¬DBAÊǽÇÉ«¡£
SYSDBA¿ÉÒÔ¹ÜÀíʵÀý¼°Êý¾Ý¿â£¬DBAÖ»ÄÜÔÚÊý¾Ý¿â´ò¿ªºóÉúЧ¡£

¸ü¶à¾«²Ê£¬Çë²Î¼ûORACLE¹ÙÎÄ¡£
ËùÒÔ£¬DBAÎÞȨ¶ÔÊý¾Ý¿â½øÐб¸·Ý
ÐèÒªSYSDBA»òÕßSYSOPER¡£


×¢Òâ¶à¸öÊý¾Ý¿âʵÀýʱºò£¬set¡¡ORACLE_SID='',

1¡¢¼ì²ésqlnet.ora£¨WINDOWSÏÂλÓÚ%ORACLE_HOME%NETWORKADMINĿ¼£©ÊÇ·ñ°üº¬Õâ¾ä£ºSQLNET.AUTHENTICATION_SERVICES=(NTS)£¬Ã»Óеϰ¼ÓÉÏ£»

2¡¢¼ì²éµÇ½windowsµÄÓû§(administrator»ò°²×°oracleʱºòʹÓõÄÓû§)ÊDz»ÊÇÔÚ°üº¬ÔÚORA_DBA×éÖУ¬ÓòÓû§Ã»ÓÐÁ¬ÉÏÓò·þÎñÆ÷ʱ¾Í¿ÉÄܳöÏÖÕâÖÖÏÖÏó¡£

3. Òª±£Ö¤ remote_login_passwordfile ²ÎÊý = EXCLUSIVE .

4. ¿´¿´ÊÇ·ñÐèҪʹÓÃorapasswÉú³É¿ÚÁîÎļþ .


ÒýÓÃ
SQL> create user tmp identified by tmp;


Ïà¹ØÎÊ´ð£º

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

eclipseÖÐÁ¬½ÓoracleµÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ