ÓÃradiusºÍoracle×öÈÏÖ¤¼Æ·Ñϵͳ
Redhat
as4 + oracle 10g(10.2.0)
+ freeradius1.1.2+ tomcat5.5
*****************************
±¾ÎÄĿ¼
********************************
Ò»¡¢°²×°
redhat as4
¶þ¡¢°²×°
oracle 10g
£¨
10201_database_linux32.zip
£©
£¨Ò»£©¼ì²é
oracle 10g
ËùÐèµÄ°ü×é¼þ£º
£¨¶þ£©ÉèÖÃϵͳ²ÎÊý
£¨Èý£©Ìí¼ÓÓû§ºÍ×é¼°´´½¨Ä¿Â¼£º
£¨ËÄ£©ÐÞ¸Ä
oracle
Óû§µÄ»·¾³±äÁ¿£º
£¨Î壩°²×°
oracle
£º
£¨Áù£©²âÊÔ
oracle
ÊÇ·ñ°²×°³É¹¦£º
£¨Æß£©ÉèÖÃ
oracle
ËæÏµÍ³¿ª»úÆô¶¯
Èý¡¢°²×°
freeradius-1.1.2
£¨Ò»£©°²×°
£¨¶þ£©ÐÞ¸ÄÅäÖÃ
£¨Èý£©²âÊÔ°²×°ÊÇ·ñ³É¹¦
£¨ËÄ£©ÉèÖÃ
radius
Ëæ¿ª»úÆô
ËÄ¡¢°²×°
tomcat-5.5
£¨Ò»£©
°²×°
jdk1.6
£¨¶þ£©´´½¨Óû§ºÍĿ¼
£¨Èý£©Ð޸Ļ·¾³±äÁ¿
£¨ËÄ£©½âѹ
tomcat.jar
£¨Î壩²âÊÔ
tomcat
ÊÇ·ñ°²×°³É¹¦
£º
£¨Áù£©ÉèÖÃ
tomcat
ËæÏµÍ³¿ª»úÆô¶¯£º
*******************************************************************************
Ò»
°²×°
redhat
as4
***********************************************************
£¨
¾µÏñÏÂÔØµØÖ·
£º
ftp://ftp.netat.net/RHEL4U4/RHEL4-U4-i386-AS-DVD.iso
£©
¾ßÌå²½ÖèÇë×Ô¼ºµ½ÍøÉϲéÕÒ
,
°²×°µÄʱºò°Ñ“¿ª·¢¹¤¾ß”Èí¼þ°üÑ¡ÉÏ
¶þ
°²×°
oracle 10g
£¨
10201_database_linux32.zip
£©
***********************************************************
ÏÂÔØµØÖ·
£º
£¨
http://download.oracle.com/otn/linux/oracle10g/10201/10201_database_linux32.zip
£©
ËùÓа汾£º
http://www.oracle.com/technology/software/products/database/index.html
£¨Ò»£©¼ì²é
oracle 10g
ËùÐèµÄ°ü×é¼þ£º
rpm -q
binutils
compat-db
control-center
gcc
gcc-c++
glibc-common
gnome-
libs
libstdc++ libstdc++-devel
make
pdksh
xscreensaver
libaio openmotif21 sysstat
Èç¹ûÒÔÉÏÓÐδ°²×°µÄ°ü£¬ÇëÏȰ²×°¡£¿ÉÒÔÓÃ
yum -y install packets_name
Ö±½ÓÍøÉϰ²×°¡£
£¨
ps
£º´ó¶àÇé¿ö¶¼»áÌáʾ
sysstat
ûÓа²×°£¬µ«¸ù¾Ý¾Ñ飬ûÓÐËüÒ²²
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
¶ÔÏó³Ö¾Ã»¯£¬Ò²¾ÍÊÇ¿ÉÒÔ°ÑÕâ¸ö¶ÔÏóÓÀÔ¶µÄ±£´æÆðÀ´£¬ÕâÀïµÄ±£´æ²»½öÊǶÔÏó±¾Éí£¬»¹°üÀ¨ËûµÄÊôÐÔºÍËùÒÀÀµµÄÆäËûÀࡣͨ³££¬¶ÔÏó¿ÉÒԳ־û¯µ½Îļþ»òÕßÊÇÊý¾Ý¿âÖС£ÎÒÕâÀïÖ»½éÉÜÈçºÎ½«¶ÔÏó´æ´¢µ½Êý¾Ý¿âÖС£Ç¡ÇÉOracleÊý¾Ý¿âΪÎÒÃÇÌṩÁËÕâÑùµÄ·½±ã¡£
ÔÚOracleÖУ¬ÓÐÒ»ÖÖblogµÄ×Ö¶ÎÀàÐÍ£¬ËüÊÇÓÃÀ´´æ´¢´óÁ¿µÄ¶ ......
--½¨Á¢²âÊÔÊý¾Ý
create table a(id number);
create table b(id number);
insert into a values(1);
insert into a values(2);
insert into a values(3);
insert into b values(1);
insert into b values(2);
insert into b values(4);
commit;
--×ó:
--Ö÷Á÷Êý¾Ý¿âͨÓõķ½·¨
select * from a left ......
EXP/IMP×¢Ò⣺´ÓÈ«¿âÂß¼±¸·Ý°´Óû§µ¼Èëʱ£¬OracleûÓе¼ÈëJOB£¬²»ÖªµÀÕâ¸öÊÇOracleµÄbug£¬»¹ÊǹÊÒâÕâÑùʵÏֵġ£Õâ¸öÎÊÌâÔÚµ¼ÈëµÄÓû§ÃûºÍµ¼³öµÄÓû§Ãû²»Í¬Ê±³öÏÖ£¬Èç¹ûµ¼ÈëµÄÓû§ÃûºÍµ¼³öµÄÓû§ÃûÒ»Ö£¬Ôò²»»á³öÏÖÕâ¸öÎÊÌâ¡£»³ÒÉÊÇOracleµ÷ÓÃDBMS_IJOB°üʱ³öÏÖµÄÎÊÌâ¡£
×ÜÖ®£¬EXP/IMPµÄʱºòÐèÒª¿¼ÂÇJOB£¬²¢ÔÚ²Ù×÷½áÊøºó¼ì ......
ÔÚInternetÉÏÔË×÷Êý¾Ý¿â¾³£»áÓÐÕâÑùµÄÐèÇ󣺰ѱ鲼ȫ¹ú¸÷³ÇÊÐÏàËÆµÄÊý¾Ý¿âÓ¦ÓÃͳһÆðÀ´£¬Ò»¸ö½ÚµãµÄÊý¾Ý¸Ä±ä²»½öÌåÏÖÔÚ±¾µØ£¬»¹·´Ó³µ½Ô¶¶Ë¡£¸´ÖƼ¼Êõ¸øÓû§ÌṩÁËÒ»ÖÖ¿ìËÙ·ÃÎʹ²ÏíÊý¾ÝµÄ°ì·¨¡£
Ò»¡¢ÊµÏÖÊý¾Ý¿â¸´ÖƵÄǰÌáÌõ¼þ
1¡¢Êý¾Ý¿âÖ§³Ö¸ß¼¶¸´Öƹ¦ÄÜ
Äú¿ÉÒÔÓÃsystemÉí·ÝµÇ¼Êý¾Ý¿â£¬²é¿´v$optionÊÓͼ£¬Èç¹ûÆäÖÐAdv ......