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

ÔÚubuntu ϰ²×°Oracle 11g

root@hardy:~# cd /bin
root@hardy:/bin# ls -l /bin/sh
lrwxrwxrwx 1 root root 4 2008-04-28 19:59 /bin/sh -> dash
root@hardy:/bin# ln -sf bash /bin/sh
root@hardy:/bin# ls -l /bin/sh
lrwxrwxrwx 1 root root 4 2008-05-01 22:51 /bin/sh -> bash
# echo "Red Hat Linux release 4" > /etc/redhat-release
root@hardy:/bin# cd
root@hardy:~# pwd
   /root
root@hardy:~# addgroup oinstall
   Adding group `oinstall' (GID 1001) ...
   Done.
root@hardy:~# addgroup dba
   Adding group `dba' (GID 1002) ...
   Done.
root@hardy:~# addgroup nobody
   Adding group `nobody' (GID 1003) ...
   Done.
root@hardy:~# usermod -g nobody nobody
root@hardy:~# useradd -g oinstall -G dba -p password -d /home/oracle -s /bin/bash oracle
root@hardy:~# passwd -l oracle
   Password changed.
root@hardy:~# mkdir /home/oracle
root@hardy:~# chown -R oracle:dba /home/oracle
root@hardy:~# ln -s /usr/bin/awk /bin/awk
root@hardy:~# ln -s /usr/bin/rpm /bin/rpm
root@hardy:~# ln -s /usr/bin/basename /bin/basename
root@hardy:~# mkdir /etc/rc.d
root@hardy:~# for i in 0 1 2 3 4 5 6 S ; do ln -s /etc/rc$i.d /etc/rc.d/rc$i.d ; done
root@hardy:~# mkdir -p /u01/app/oracle
root@hardy:~# chown -R oracle:dba /u01
root@hardy:~#
ÐÞ¸Äetc/sysctl.confÎļþ,ÔÚĩβÔö¼Ó£º
fs.file-max = 65535
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65535
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
ÐÞ¸Ä/etc/security/limits.confÎļþ,ÔÚĩβÔö¼Ó£º
oracle soft nproc 2047
oracle hard nproc 16383
oracle soft nofile 1023
oracle hard nofile 65535
ΪÁËÇ¿ÖÆÊ¹ÓøղÅÎÒÃÇÔö¼ÓµÄ¶«Î÷£¬ÐÞ¸Ä/etc/pam.d/loginÎļþĩβ£º
session required /lib/security/pam_limits.so
session required pam_limits.so
# sysctl -p
ÏÖÔÚ½«oracle11gµÄ°²×°°ü½âѹµ½/home/oracle/install/Ŀ¼Ï¡£È»ºó½øÈ


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

¡¾Oracle¡¿SQLÓÅ»¯µÄÖØÒª¹¤¾ß AUTOTRACE

¡¾AUTOTRACE¡¿SQLÓÅ»¯µÄÖØÒª¹¤¾ß--AUTOTRACE
Ìáµ½SQLÓÅ»¯£¬²»Äܲ»ÌáAUTOTRACEµÄÇ¿´ó¹¦ÄÜ¡£Ê¹ÓÃÆðÀ´·Ç³£±ã½Ý£¬²»¹ýÔÚÊÇʹÓÃ֮ǰ£¬ÐèÒª×öһЩÅäÖõŤ×÷¡£¼òÒªµÄÃèÊöÒ»ÏÂÕâ¸ö¹ý³Ì£¬¹©Ã»ÓÐʹÓùýµÄÅóÓѲο¼¡£
1.ʹÓÃsysÓû§Ö´ÐÐplustrce½Å±¾
sys@ora10g> @?/sqlplus/admin/plustrce
sys@ora10g> drop role plustrace ......

oracle 10053 trace


10053ʼþÊÇoracleÌṩµÄÓÃÓÚ¸ú×ÙsqlÓï¾ä³É±¾¼ÆËãµÄÄÚ²¿Ê¼þ£¬
ËüÄܼÇÔØCBOģʽÏÂoracleÓÅ»¯Æ÷ÈçºÎ¼ÆËã sql³É±¾£¬Éú³ÉÏàÓ¦µÄÖ´Ðмƻ®¡£
ÈçºÎÉèÖÃ10053ʼþ
ÉèÖñ¾sessionµÄ10053
¿ªÆô£º
Alter session set events’10053 trace name context forever[,level {1/2}]’;
¹Ø±Õ£º
Alter session set events& ......

³£ÓÃSQLÓï¾ä£¨Oracle£©(ת)

ORACLEÖÐ×ֶεÄÊý¾ÝÀàÐÍ
   ×Ö·ûÐÍ    char        ·¶Î§  ×î´ó2000¸ö×Ö½Ú ¶¨³¤
               char(10)   'ÕÅÈý' ºóÌí¿Õ¸ñ6¸ö°Ñ10¸ö×Ö½Ú²¹Âú  'ÕÅÈý &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ