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

linux»·¾³Ï°²×°oracle 11g database·½·¨Ö¸µ¼(Èý)

±¸×¢£º¾­¹ýÇ°ÆÚµÄlinuxϵͳ»·¾³µÄÅäÖôÍê³É£¬ÏÂÃæ¾Í¿ªÊ¼°²×°oracleÊý¾Ý¿â¡£oralceÊý¾Ý´ó¼ÒÈ¥oracle¹Ù·½ÍøÕ¾ÉÏÏÂÔØlinux»·¾³Ïµİ汾¡£ºÜÒź¶½ØͼÉÏ´«²»ÁË¡£
 
Èý£®Oracle database°²×°¾ßÌå°²×°²½Öè
 
<1>´´½¨°²×°oracleĿ¼¼°Ö÷Êôµ÷Õû
[root@mylinux oracle]# mv database/ /u01
[root@mylinux u01]# chown -R oracle:oinstall database/
[root@mylinux u01]# ls -l
total 16
drwxr-xr-x  5 oracle oinstall 4096 Oct  7  2008 database
drwxr-xr-x  2 oracle oinstall 4096 Apr 30 10:33 oracle
[root@mylinux u01]#su - oracle
 
½øÈë°²×°³ÌÐòĿ¼Æô¶¯°²×°³ÌÐò£º
[oracle@mylinux u01]#./runinstallar
 
ÈçÏÂÄÚÈÝÓÉÓÚ½ØͼÉÏÔز»ÁË£¬¾ßÌå²»ÔÚ˵Ã÷ÁË£¬°²×°·½·¨¸ú
windowsÏ°²×°ÀàËÆ£¬½øÐÐÏàÓ¦µÄÉèÖü´¿É£º
 £­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­
½øÈëlinuxϵͳͼÐνçÃæ°²×°oracle database ÈçϽØͼ²Ù×÷
 
ÉèÖ÷¾¶
  
ÕâÒ»²½¼ì²é¹¤×÷£¬Óб¨swap½»»»¿Õ¼ä²»¹»£¬ÐèÒªÔö¼Ó½»»»¿Õ¼ä¡£
 
DHCPÐèÒªÔö¼ÓÈçÏÂÉèÖãº
 
[root@mylinux etc]# vi hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain localhost
 
192.168.0.88    mylinux
~
 
-------------------------------------------------------------------------------------
 
 
Ö»°²×°Êý¾Ý¿â²»´´½¨Êý¾Ý¿âʵÀý
 
  
ÅäÖà netca ¼àÌýÆ÷£º
  
 
Ö´ÐÐdbca´´½¨Êý¾Ý¿â
  
 
Òª¸ú»·¾³±äÁ¿ÉèÖÃÏà·û£º
  
 
ÉèÖÃÓû§×éµÄ¿ÚÁΪoracle:
 
  
ÉèÖÃ×Ö·û¼¯£¬ÒÔÃâ³öÏÖÂÒÂ룺
 
 £­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­£­
 
ËÄ£®Æô¶¯Êý¾Ý¿âʵÀý
 
 [oracle@mylinux ~]$ sqlplus "/ as sysdba"
 
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 30 14:18:04 2010
 
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORACLE instance started.
&nb


Ïà¹ØÎĵµ£º

Linux µÄ¶àÏ̱߳à³ÌµÄ¸ßЧ¿ª·¢¾­Ñé

2009 Äê 4 ÔÂ 23 ÈÕ
±¾ÎÄÖÐÎÒÃÇÕë¶Ô Linux É϶àÏ̱߳à³ÌµÄÖ÷ÒªÌØÐÔ×ܽá³ö 5 Ìõ¾­Ñ飬ÓÃÒÔ¸ÄÉÆ Linux ¶àÏ̱߳à³ÌµÄÏ°¹ßºÍ±ÜÃâÆäÖеĿª·¢ÏÝÚå¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃÇ´©²åһЩ Windows µÄ±à³ÌÓÃÀýÓÃÒÔ¶Ô±È Linux ÌØÐÔ£¬ÒÔ¼ÓÉî¶ÁÕßÓ¡Ïó¡£
±³¾°
Linux ƽ̨ÉϵĶàÏ̳߳ÌÐò¿ª·¢Ïà¶ÔÓ¦ÆäËûƽ̨£¨±ÈÈç Windows£©µÄ¶àÏß³Ì API ÓÐһЩϸ΢ ......

Oracle ×ÔÔö³¤×Ö¶Î

½¨SEQUENCEÐòÁР
CREATE SEQUENCE  ÐòÁÐÃû×Ö£¨ÀýÈ磺"URLIMAGE_SEQ"£©  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 101 CACHE 10 NOORDER  NOCYCLE ;
 
½¨trigger ´¥·¢Æ÷
create or replace trigger ´¥·¢Æ÷Ãû×Ö£¨ÀýÈ磺URLIMAGE_TRI £©
  before ins ......

oracleÖ´Ðмƻ®


oracleÖ´Ðмƻ®Ïà¹Ø¸ÅÄî http://blog.csdn.net/wh62592855/archive/2009/11/06/4778343.aspx
 
1.     Ê²Ã´ÊÇÖ´Ðмƻ®£¿ÎªÊ²Ã´ÒªÁ˽âÖ´Ðмƻ®£¿
ΪÁËÖ´ÐÐÒ»ÌõsqlÓï¾ä£¬oracle¿ÉÄܱØÐëÒªÖ´ÐÐijЩ²½ÖèµÄ²Ù×÷£¬Ã¿Ò»²½Öè¿ÉÄÜÊÇ´ÓÊý¾Ý¿âÖÐÎïÀí¼ìË÷Êý¾ÝÐУ¬»òÕßÓÃijÖÖ·½·¨×¼±¸Êý¾ÝÐУ¬¹© ......

´ÓÓ²ÅÌÒýµ¼Linux°²×°³ÌÐò[ÊÕ¼¯]

ÓÉÓÚÎÒÔÚÍøÉÏÏÂÔØÁËUbuntu LinuxÀ´°²×°·¢ÏÖÊÖͷû¿Õ°×¹âÅ̼̿cd,ËùÓÐgoogleÁËÏÂÕÒµ½ÁËÈçÏÂÎÄÕ½øÐÐʵ¼ù. ===================½Ì³Ì1========================== ˵µ½°²×°²Ù×÷ϵͳ£¬´ó¶àÊýÈËÊìϤµÄÊÇ´Ó¹âÅÌÒýµ¼£¬Æäʵ´ÓºÜ¶à´æ´¢É豸¶¼¿ÉÒÔʵÏÖϵͳÒýµ¼µÄ¡£ÓÉÓÚLinux²Ù×÷ϵͳµÄ·¢²¼ºÜ¶à£¬¶ø¶àÊýÈ˶¼ÊÇͨ¹ýÍøÂçÏÂÔزÙ×÷ϵͳµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ