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

Install Oracle 10g on SuSE 10

Õâ´ÎµÄ¾­ÀúÊÇ×Ô¼ºÕÒÀ´µÄ£¬ÔÚ°²×°ÁË10gµÄÄÇ̨»úÉÏÉý¼¶ÏÂÄÚ´æÒ²±ãÄܺöÓÆÄÇȺÓÑ£¬²»¹ýÏëÏ뻹ÊÇÕÛÌÚÏ°ɣ¬¸øÒƵ½ÅäÖúõãµÄServerÉÏÃ棬ËûÃÇÓÃÆðÀ´Ë³ÐÄ£¬ÎÒ×Ô¼ºÒ²ÄÜÕÛÌڵ㾭Ñé¡£
132µÄϵͳÊÇSuSE10.2µÄ£¬Ö®Ç°ÒѾ­°²×°ÁËOracle 9i£¬Õâ¾ÍÒâζ×űØÐëÏÈжÔصô9i£¬±¾ÒÔΪ°²×°10gµÄrunInstallerÄܹ»Ð¶Ôصô9i£¬¿É³¢ÊÔÁ˺þö¼ÊdzöÏÖexception£º
An unexpected exception has been detected in native code outside the VM.
Unexpected Signal : 11 occurred at PC=0xB7F22591
Function=(null)
Library=/lib/ld-linux.so.2
NOTE: We are unable to locate the function name symbol for the error
      just occurred. Please refer to release documentation for possible
      reason and solutions.
Current Java thread:
 at java.lang.ClassLoader$NativeLibrary.find(Native Method)
 at java.lang.ClassLoader.findNative(Unknown Source)
 - locked <0xa6fe1b20> (a java.util.Vector)
 at ssOiGenClassux22.deleteLink(Native Method)
 at sscreateLinkux.deinstallAction(sscreateLinkux.java:127)
 at oracle.sysman.oii.oiif.oiifw.OiifwDeinstallPhaseWCCE.doComponentDeinstalls(OiifwDeinstallPhaseWCCE.java:2046)
 at oracle.sysman.oii.oiif.oiifw.OiifwDeinstallPhaseWCCE.doOperation(OiifwDeinstallPhaseWCCE.java:405)
 at oracle.sysman.oii.oiif.oiifb.OiifbCondIterator.iterate(OiifbCondIterator.java:171)
 at oracle.sysman.oii.oiif.oiifw.OiifwActionsPhaseWCDE.doOperation(OiifwActionsPhaseWCDE.java:606)
 at oracle.sysman.oii.oiic.OiicDeinstallSession$OiicActionsThread.run(OiicDeinstallSession.java:2431)
Dynamic libraries:
08048000-08056000 r-xp 00000000 08:03 11228596   /tmp/OraInstall2010-03-01_05-17-06PM/jre/1.4.2/bin/java
......
Heap at VM Abort:
Heap
 def new generation   total 768K, used 567K [0xa6450000, 0xa6520000, 0xa6fd0000)
  eden space 704K,  71% used [0xa6450000, 0xa64cde70, 0xa6500000)
  from space 64K,  99% used [0xa6510000, 0xa651fff8, 0xa6520000)
  to  


Ïà¹ØÎĵµ£º

oracle link

Á©Ì¨²»Í¬µÄÊý¾Ý¿â·þÎñÆ÷£¬´Óһ̨Êý¾Ý¿â·þÎñÆ÷µÄÒ»¸öÓû§¶ÁÈ¡Áíһ̨Êý¾Ý¿â·þÎñÆ÷ϵÄij¸öÓû§µÄÊý¾Ý£¬Õâ¸öʱºò¿ÉÒÔʹÓÃdblink¡£
     ÆäʵdblinkºÍÊý¾Ý¿âÖеÄview²î²»¶à£¬½¨dblinkµÄʱºòÐèÒªÖªµÀ´ý¶ÁÈ¡Êý¾Ý¿âµÄipµØÖ·£¬ssidÒÔ¼°Êý¾Ý¿âÓû§ÃûºÍÃÜÂë¡£
       ´´½¨¿ÉÒÔ ......

¡¾×ª¡¿ ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ

ORACLE±í·ÖÇøÒÔ¼°ÐÅÏ¢²éÕÒ
http://www.sysab.cn/a/db/oracle/2009/1020/2433.html
·ÖÇø¸ÅÊö ΪÁ˼ò»¯Êý¾Ý¿â´ó±íµÄ¹ÜÀí,ÀýÈçÔÚÊý¾Ý²Ö¿âÖÐÒ»°ã¶¼ÊÇTB¼¶µÄÊýÁ¿¼¶.ORACLE8ÒÔºóÍƳöÁË·ÖÇøÑ¡Ïî.·ÖÇø½«±í·ÖÀëÔÚÈôÓÚ²»Í¬µÄ±í¿Õ¼äÉÏ,Ó÷ֶøÖÎÖ®µÄ·½·¨À´Ö§³ÅÔªÏÞÅòÕ͵Ĵó±í,×é´ó±íÔÚÎïÀíÒ»¼¶µÄ¿É¹ÜÀíÐÔ.½«´ó±í·Ö¸î³É½ÏСµÄ·ÖÇø¿ÉÒÔ¸ ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç23 24

×Ó³ÌÐò ÃüÃûµÄpl/sql¿é
create procedure ¹ý³ÌÃû [²ÎÊý1 in|out|in out¡­]
    ¾Ö²¿±äÁ¿ÉùÃ÷
    Ö´ÐÐÓï¾ä
in
out
in out
    ¹ý³ÌÃû(²ÎÊýÀï±í); create or replace
procedure add123 as
i integer;
j integer;
begin
i:=1;
j:=2;
dbms_output.put_l ......

LinuxÏÂÆô¶¯oracle10gµÄemºÍisqlplus

LinuxÏÂÆô¶¯oracle10gµÄemºÍisqlplusµÄ·½·¨:
×¢:$ORACLE_HOMEΪoracleµÄ°²×°Â·¾¶
1,ʹÓÃEM(enterprise managment)
1.1Æô¶¯EM
$ORACLE_HOME/bin/emctl start dbconsole
Èç¹û³öÏÖÏÂÃæÏà¹ØÐÅÏ¢,˵Ã÷·þÎñÆô¶¯
Z set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.1.0.3.0
Copyright (c) 1996, 200 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ