ÓÃ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
ûÓа²×°£¬µ«¸ù¾Ý¾Ñ飬ûÓÐËüÒ²²
Ïà¹ØÎĵµ£º
-- Create the user
create user SMCQUERY
identified by SMCQUERY;
-- Grant/Revoke role privileges
grant connect to SMCQUERY;
-- Grant/Revoke system privileges
grant select any table to SMCQUERY;
grant debug any procedure to SMCQUERY;
grant debug connect session to SMCQUERY;
grant cr ......
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ2)
......
Èç¹ûÊý¾ÝÎļþË𻵣¬»áÓöµ½1157 ºÍ 1110µÄ´íÎó¡£ÕâʱºòÐèÒª½éÖʻָ´Êý¾Ý¿â¡£
»Ö¸´Êý¾Ý¿âÐèÒªÓÐÏàÓ¦µÄ±¸·ÝºÍ±¸·ÝÒÔÀ´²úÉúµÄËùÓеĹ鵵ÈÕÖ¾ÎļþºÍÁª»úÈÕÖ¾Îļþ¡£
Èç¹ûÔÚmountµ½openµÄʱºò·¢ÏÖÆÕͨµÄÊý¾ÝÎļþË𻵣¬Êý¾Ý¿â»áÍ£ÁôÔÚmount״̬Ï£¬Õâʱºò¿ÉÒÔÖ´ÐÐalter database datafile x offline drop ºÍalter database open à ......
ÎÒÓõÄÊÇCentos5.4 DVD¹âÅÌ°²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄÜ°²×°oracle10g£¬ÏÂÃæ°ÑÖ÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10gµÄʱºòÐèÒªÓõ½£¬Ã»Óа²×°µÄ°üÓÐ:
libXp-1.0.0-8.i386.rp ......
ÔÚInternetÉÏÔË×÷Êý¾Ý¿â¾³£»áÓÐÕâÑùµÄÐèÇ󣺰ѱ鲼ȫ¹ú¸÷³ÇÊÐÏàËƵÄÊý¾Ý¿âÓ¦ÓÃͳһÆðÀ´£¬Ò»¸ö½ÚµãµÄÊý¾Ý¸Ä±ä²»½öÌåÏÖÔÚ±¾µØ£¬»¹·´Ó³µ½Ô¶¶Ë¡£¸´ÖƼ¼Êõ¸øÓû§ÌṩÁËÒ»ÖÖ¿ìËÙ·ÃÎʹ²ÏíÊý¾ÝµÄ°ì·¨¡£
Ò»¡¢ÊµÏÖÊý¾Ý¿â¸´ÖƵÄÇ°ÌáÌõ¼þ
1¡¢Êý¾Ý¿âÖ§³Ö¸ß¼¶¸´Öƹ¦ÄÜ
Äú¿ÉÒÔÓÃsystemÉí·ÝµÇ¼Êý¾Ý¿â£¬²é¿´v$optionÊÓͼ£¬Èç¹ûÆäÖÐAdv ......