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
Ïà¹ØÎĵµ£º
2009 Äê 4 ÔÂ 23 ÈÕ
±¾ÎÄÖÐÎÒÃÇÕë¶Ô Linux É϶àÏ̱߳à³ÌµÄÖ÷ÒªÌØÐÔ×ܽá³ö 5 Ìõ¾Ñ飬ÓÃÒÔ¸ÄÉÆ Linux ¶àÏ̱߳à³ÌµÄÏ°¹ßºÍ±ÜÃâÆäÖеĿª·¢ÏÝÚå¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃÇ´©²åһЩ Windows µÄ±à³ÌÓÃÀýÓÃÒÔ¶Ô±È Linux ÌØÐÔ£¬ÒÔ¼ÓÉî¶ÁÕßÓ¡Ïó¡£
±³¾°
Linux ƽ̨ÉϵĶàÏ̳߳ÌÐò¿ª·¢Ïà¶ÔÓ¦ÆäËûƽ̨£¨±ÈÈç Windows£©µÄ¶àÏß³Ì API ÓÐһЩϸ΢ ......
½¨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Ö´Ðмƻ®Ïà¹Ø¸ÅÄî http://blog.csdn.net/wh62592855/archive/2009/11/06/4778343.aspx
1. ʲôÊÇÖ´Ðмƻ®£¿ÎªÊ²Ã´ÒªÁ˽âÖ´Ðмƻ®£¿
ΪÁËÖ´ÐÐÒ»ÌõsqlÓï¾ä£¬oracle¿ÉÄܱØÐëÒªÖ´ÐÐijЩ²½ÖèµÄ²Ù×÷£¬Ã¿Ò»²½Öè¿ÉÄÜÊÇ´ÓÊý¾Ý¿âÖÐÎïÀí¼ìË÷Êý¾ÝÐУ¬»òÕßÓÃijÖÖ·½·¨×¼±¸Êý¾ÝÐУ¬¹© ......
ÓÉÓÚÎÒÔÚÍøÉÏÏÂÔØÁËUbuntu LinuxÀ´°²×°·¢ÏÖÊÖͷû¿Õ°×¹âÅ̼̿cd,ËùÓÐgoogleÁËÏÂÕÒµ½ÁËÈçÏÂÎÄÕ½øÐÐʵ¼ù. ===================½Ì³Ì1========================== ˵µ½°²×°²Ù×÷ϵͳ£¬´ó¶àÊýÈËÊìϤµÄÊÇ´Ó¹âÅÌÒýµ¼£¬Æäʵ´ÓºÜ¶à´æ´¢É豸¶¼¿ÉÒÔʵÏÖϵͳÒýµ¼µÄ¡£ÓÉÓÚLinux²Ù×÷ϵͳµÄ·¢²¼ºÜ¶à£¬¶ø¶àÊýÈ˶¼ÊÇͨ¹ýÍøÂçÏÂÔزÙ×÷ϵͳµ ......