linuxÏ oracleµÄ°²×°
°²×°×¼±¸£º
ÏÂÔØÎļþ
l Oracle Database 10g Release 2(10.2.0.1) Software
½âѹÎļþ
½âѹÎļþÃüÁ
unzip 10201_database_linux32.zip
½âѹºóµÄÎļþ¼Ð¿ÉÄÜ“database”»ò“db/Disk1”
HostsÎļþ
ÔÚ/etc/hosts ÎļþÖаüº¬Ò»¸öÍêÕûºÏ·¨µÄ·þÎñÆ÷Ãû
<IP-address> <fully-qualified-machine-name> <machine-name>
ÉèÖÃÄں˲ÎÊý
ÔÚ/etc/sysctl.confÖÐÌí¼ÓÒÔÏÂÐУº
#kernel.shmall = 2097152
#kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
#fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmen_max=262144
ÔËÐÐÏÂÃæµÄÃüÁîÓ¦ÓÃÒÔÉÏOS²ÎÊý
/sbin/sysctl -p
Ìí¼ÓÒÔÏÂÐе½/ect/security/limits.confÎļþÖÐ
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
Èç¹û/etc/pam.d/loginÎļþÖÐûÓÐÒÔÏÂÐУ¬ÔòÌí¼ÓÒÔÏÂÄÚÈÝ£º
session required /lib/security/pam_limits.so
ÐÞ¸Ä/etc/selinux/configÎļþÀ´¹Ø±Õlinux·À»ðǽ£¬È·±£SELINUXÉèÖÃÈçÏ£º
SELINUX=disabled
¼ì²é°²×°°ü
¼ì²éÊÇ·ñ¾ß±¸ÒÔϰ²×°°ü£º
make-3.79.1
gcc-3.2.3-34
glibc-2.3.2-95.20
compat-db-4.0.14-5
compat-gcc-7.3-2.96.128
compat-gcc-c++-7.3-2.96.128
compat-libstdc++-7.3-2.96.128
compat-libstdc++-devel-7.3-2.96.128
libXp
openmotif21-2.1.30-8
setarch-1.3-1
²éѯËùÐè°²×°°üÊÇ·ñÍêÕû(ȱÉÙ²¹É¶)
rpm -q gcc make binutils openmotif setarch compat-db compat-gcc compat-gcc
Ïà¹ØÎĵµ£º
Oracle ´æ´¢¹ý³Ì·µ»Ø½á¹û¼¯Óà ref cursor ʵÏÖ¡£
ÊÔÑé²½ÖèÈçÏ£º
1. ½¨Á¢ ref cursor ÀàÐͺ͹ý³Ì
CREATE OR REPLACE PACKAGE types
AS
TYPE ref_cursor IS REF CURSOR;
END;
/
CREATE TABLE STOCK_PRICES(
RIC VARCHAR(6) PRIMARY KEY,
PRICE NUMBER(7 ......
1.È·ÈÏVNCÊÇ·ñ°²×°
ĬÈÏÇé¿öÏ£¬Red Hat Enterprise Linux°²×°³ÌÐò»á½«VNC·þÎñ°²×°ÔÚϵͳÉÏ¡£
È·ÈÏÊÇ·ñÒѾ°²×°VNC·þÎñ¼°²é¿´°²×°µÄVNC°æ±¾
[root@testdb ~]# rpm -q vnc-server
vnc-server-4.1.2-9.el5
[root@testdb ~]#
ÈôϵͳûÓа²×°,¿ÉÒÔµ½²Ù×÷ϵͳ°²×°Å̵ÄServerĿ¼ÏÂÕÒµ½VNC·þÎñµÄRPM°²×°°üvnc-server- ......
·find path -option [ -print ] [ -exec -ok command ] {} \;
#-print ½«²éÕÒµ½µÄÎļþÊä³öµ½±ê×¼Êä³ö
#-exec command {} \; -----½«²éµ½µÄÎļþÖ´ ......
°²×°Apache·þÎñÆ÷
¡¡¡¡¿ÉÒÔͨ¹ýÒÔÏÂÈýÖÖ·½·¨°²×°Apache·þÎñÆ÷¡£
¡¡¡¡1£©Èç¹û°²×°µÄLinux°æ±¾ÖдøÓÃApacheµÄ»°£¬¾ÍÔÚÑ¡ÔñËùÒª°²×°µÄ·þÎñÆ÷µÄʱºò£¬½«httpdÕâ¸ö·þÎñÑ¡ÉÏ£¬Linux°²×°³ÌÐò½«×Ô¶¯Íê³ÉApacheµÄ°²×°¹¤×÷£¬²¢×öºÃ»ù±¾µÄÅäÖá£
¡¡¡¡2£©Ê¹ÓÿÉÖ´ÐÐÎļþÈí¼þ°ü£¬Õâ±È½ÏÊʺÏÄÇЩ¶Ô±àÒ빤×÷²»ÊÇÌ«ÊìϤµÄ³õ¼¶Óû§£ ......