linuxÏÂoracleÆô¶¯¹ý³Ì
ÔÚlinuxÏÂÆô¶¯oracle ºÍÔÚwindowsÊÇÓвî±ðµÄ£¬¶ÔÓÚÒ»°ãÔÚwindowsϲÙ×÷ϰ¹ßÈËÓкܶ಻ÊÊÓ¦£¬ËùÒÔÎÒÌØ±ðдÕâÑùÎÄÕ£¬ÒÔ·½±ãÐÂÊÖ½øÐвÙ×÷£¬ÏÂÃæ¾ÍÒ»²½Ò»²½½²½âÆô¶¯¹ý³Ì¡£
1.ͨ¹ýÖÕ¶ËÁ¬½Óµ½linux·þÎñÆ÷,µ±È»ÕâÑùµÄÈí¼þºÜ¶àÀýÈçputty,SecureCRT,²¢ÒÔoracleÓû§½øÐеǼ£¬·ñÔòÆô¶¯oracleʱ»á´íµÄ£¬Ã»ÓÐȨÏÞÆô¶¯.(Ò²¿ÉÓû§root µÇ¼£¬È»ºó½øÐÐ su - oracle )
2.Óû§sysÁ¬½ÓÊý¾Ý¿â,°´ÒÔÏÂÃüÁîÖ´ÐС£
a.sqlplus /nolog ;
b.conn sys/passwd as sysdba;
3.Æô¶¯Êý¾Ý¿â,ÒòΪÆô¶¯·½Ê½ÓкܶàÖÖ±ÈÈçÓÃpfile,spfile£¬ÕâÀïÎҾͲ»Ïêϸ½²½â¾ßÌåµÄÆô¶¯·½Ê½ÁË£¬ÒÔ×î¼òµ¥µÄΪÀý½øÐн²½â£¬startup½øÐÐÆô¶¯£¨Êµ¼ÊÊÇÒÔspfile ½øÐÐÆô¶¯),ÔÚÌáʾÏÂÔËÐÐ.
startup
(×¢Ã÷£¬Ò»°ãÆô¶¯»áÓÐÈý²½¶ÔÓ¦Êý¾Ý¿âÒª×öµÄÈý¼þÊÂ.
a.startup nomount ´ò¿ªÊµÀý
b.alter database mount ×°ÔØÊý¾ÝÎļþ
c.alter database open ´ò¿ªÊý¾ÝÎļþ
)
4.Æô¶¯ÍêÊý¾Ý¿âÒ»°ãÇé¿öÏ¿ͻ§¶Ë»¹²»ÄÜÁ¬½Óµ½·þÎñÆ÷£¬ÎÒÃÇÒªÆô¶¯¼àÌý³ÌÐò¡£½«µÚ3²½Í˳ösqlplus µ½ÃüÁîÌáʾ·û£¬½øÐÐÆô¶¯¼àÌý£¬Ö´ÐÐÃüÁîÈçÏÂ.
a.lsnrctl (´òÁÙÌý³ÌÐò)
b.status ( ²é¿´¼àÌý״̬)
c.start (Æô¶¯¼àÌý)
d.stop (¹Ø±Õ¼àÌý)
Èç¹ûÉÏÊöûÓÐÎÊÌ⣬ÎÒÃǾͿÉÒÔ¸ùÆô¶¯µÄÏÔʾÐÅÏ¢ÅäÖÃÎÒÃǵĿͻ§¶ËµÄtnsÎļþÁË¡£
5. tnsnames.¸ñʽÎļþÈçÏÂ(SERVICE_NAMEÒªÓë·þÎñÆ÷µÄ¼àÌýʵÀýÃû±£³ÖÒ»ÖÂ)
# tnsnames.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.98)(PORT = 1566))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
ORACLE11 =
(DESCRIPTION =
(ADDRESS_LIST =
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
1. HCI²ãÐÒé¸ÅÊö£º
HCIÌṩһÌ×ͳһµÄ·½·¨À´·ÃÎÊBluetoothµ×²ã¡£ÈçͼËùʾ£º
´ÓͼÉÏ¿ÉÒÔ¿´³ö£¬Host Controller Interface(HCI) ¾ÍÊÇÓÃÀ´¹µÍ¨HostºÍModule¡£Hostͨ³£¾ÍÊÇPC£¬ ModuleÔòÊÇÒÔ¸÷ÖÖÎïÀíÁ¬½ÓÐÎʽ£¨USB,serial,pc-cardµÈ£©Á¬½Óµ½PCÉϵÄbluetooth Dongle¡£
ÔÚHostÕâÒ»¶Ë£ºapplication,SDP,L2capµÈÐÒé ......
1¡¢ÔÚftpÓû§×éÖÐÌí¼ÓÓû§£¬ÇÒÖ¸¶¨Óû§µÄĿ¼
#useradd -G ftp
-d Ŀ¼
-M Óû§Ãû
2¡¢¸øÓû§Ìí¼ÓÃÜÂë
#passwd Óû§
3¡¢ÏÞ¶¨Óû§µÄȨÏÞ£¬½«Óû§Ö¸¶¨µ½Äܹ»²Ù×÷µÄĿ¼
#chown Óû§Ãû
.ftp Ŀ¼
-R
4¡¢ ¸øÄ¿Â¼¸ ......
/lib/
— °üº¬Ðí¶à±» /bin/ ºÍ /sbin/ ÖеijÌÐòʹÓõĿâÎļþ¡£Ä¿Â¼ /usr/lib/ Öк¬Óиü¶àÓÃÓÚÓû§³ÌÐòµÄ¿âÎļþ¡£
/libĿ¼Ï·ÅÖõÄÊÇ/binºÍ/sbinĿ¼Ï³ÌÐòËùÐèµÄ¿âÎļþ¡£/libĿ¼ÏµÄÎļþµÄÃû³Æ×ñÑÏÂÃæµÄ¸ñʽ£º
libc.so.*
ld*
½ö½ö±»/usrĿ¼ÏµijÌÐòËùʹÓõĹ²Ïí¿â²»±Ø·Åµ½/libĿ¼Ï¡£Ö»ÓÐ/binºÍ/sbin ......
KscopeÊÇLinuxϵÄÒ»¿îÀàËÆÓÚSourceInsight¹¤¾ß£¬ÏÂÃæ½«Æä°²×°¹ý³Ì×ܽáÈçÏ£º
1.ÏÈÏÂÔØkscope
kscope×îа²×°°æ±¾kscope-1.6.2.tar.gz
http://download.chinaunix.net/download/0006000/5469.shtml
°´ÕÕ˵Ã÷#./configure
#make
&nb ......