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 ......
¶ÔÓÚÓ²¼þ£¬ÓеÄÐÂÊÖµÜÐÖ¿ÉÄÜ»¹ÊDz»Ì«Ã÷°×ÔÚLinuxÏÂÇý¶¯Ó²¼þ£¬ÓÈÆäÔÚ¸Õ½Ó´¥Linuxʱ£¬Çý¶¯µÄ°²×°ÍùÍùÊÇ×îÁîÈËÍ·Í´µÄÒ»¼þÊÂÁË¡£
Ò»¡¢ ¶ÔϵͳÇý¶¯°²×°µÄÒ»µã³£Ê¶¡£
1£® ¿ª·¢¹¤¾ßÊDZØÐë°²×°£º
Èç¹ûÄúÊÇÐÂÊÖ£¬ÎÒ»¹Êǽ¨ÒéÄú°ÑϵͳÍêÈ«°²×°£¬ÒòΪÔÚ°²×°ÆäËüµÄÈí¼þ»áÓõ½Ò»Ð©£¬ÎÒÃDz»Ì«Ã÷°×µÄ¿âÎļþÒÔ¼°¿ª·¢¹¤¾ß¡£±ÈÈçmake gcc au ......
´ÓÓû§´ò¿ªµçÔ´µ½Óû§¿ÉÒԵǼµÄÕâ¶Ì¶ÌµÄÒ»¶Îʱ¼äÄÚ£¬Red Hat Enterprise Linuxµ½µ×¶¼×÷ÁËÄÄЩÊÂÇ飬ֻÓÐÖªµÀÁËÕâЩÊÂÇ飬Óû§ÔÚÒÔºóµÄʹÓùý³ÌÖУ¬Èç¹û³öÏÖÁËһЩÎÊÌ⣬ÎÒÃÇ¿ÉÒÔ½èÖúÕâЩ¹ý³ÌÀ´ÎªÎÒÃÇÅųýһЩ¹ÊÕÏ¡£
Red Hat Enterprise LinuxÔÚµçÄÔµÄÆô¶¯½×¶Î£¬Ò»¹²¾ÀúÒÔÏÂÁ½¸ö½×¶Î£¬Èçͼ1£º
BIOS×Ô¼ì
µ±µçÄÔ¿ª»úµÄʱº ......
/*
* linux/kernel/floppy.c
*
* (C) 1991 Linus Torvalds
*/
/*
* 02.12.91 - Changed to static variables to indicate need for reset
* and recalibrate. This makes some things easier (output_byte reset
* checking etc), and means less i ......