oracle 11g ORA 12514´íÎó£¬ÎҵĽâ¾ö°ì·¨
Ç°ÑÔ:ÍøÉÏÓкܶà½â¾ö°ì·¨£¬É¾listener.oraÒ²ºÃ£¬»¹ÊÇʲôҲºÃ£¬¶¼½â¾ö²»ÁËÎÒÕâ¸öÎÊÌ⣬ÒÀÈ»±¨12514´íÎó£¬ÒÔÏÂÊÇÎÒÖð¸ö³¢ÊÔºó³É¹¦µÄ¼àÌý×Ö·û´®¡£¡£
listener.oraÎļþ£º
# listener.ora Network Configuration File: d:\app\john\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = cjtfs)
(ORACLE_HOME = d:\app\john\product\11.1.0\db_1)
(PROGRAM = cjtfs)
)
(SID_DESC =
(GLOBAL_DBNAME = cjtfs)
(ORACLE_HOME = d:\app\john\product\11.1.0\db_1)
(SID_NAME = cjtfs)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
)
)
tnsnames.oraÎļþ£º
# tnsnames.ora Network Configuration File: d:\app\john\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
CJTFS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = john-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cjtfs) #ÒªºÍlistener.oraÀïÃæµÄcjtfsλÖõÄÃû×Ö±£³ÖÒ»ÖÂ
)
)
Èç¹û»¹½â¾ö²»ÁË£¬ÄǾÍÁôÑÔ£¬ÎÒÒ»°ã»á³£¿´blogµÄ¡£¡£¡£¡£´ó¼ÒÒ»Æð½â¾ö¡£¡£»¥Ïàѧϰ¡£
Ïà¹ØÎĵµ£º
ÔÚÐéÄâ»úRed Hat Enterprise Linux 4 update 4Öа²×°oracle 10.2.0.1
1)²é¿´ÏµÍ³ÄÚ´æ
[root@linux4 ~]# grep MemTotal /proc/meminfo
2)²é¿´½»»»Çø´óС
[root@linux4 ~]# grep SwapTotal /proc/meminfo
3)
²é¿´/tmpĿ¼´óС
[root@linux4 ~]# df -m /tmp
4)²é¿´²Ù×÷ϵͳ°æ±¾
[root@linux4 ~]# cat /etc/issue
5)¼ ......
ôßÉÏͨ¹ýÔ¤±àÒë²ûÊöµÀ¹²Ïí³Ø×îºóµ½SGA£¬ÕâÀï½øÒ»²½ËµÃ÷Ò»ÏÂSGAÖÐÁíÒ»¸ö´ó¿é£¬Êý¾Ý»º³åÇø£¬Ð¯´øÌá¼°Ò»µãÊý¾ÝÎļþºÍ±í¿Õ¼ä£¬ºóÐøרÃÅ»á˵Ã÷Õâ¿é¡£
Ê×ÏÈÁ˽âÏÂSGAÖÖ´óÖÂÓÐÄÇЩ¶«Î÷£¬ÕâЩ¶«Î÷Ëæ×ÅÊý¾Ý¿â°æ±¾µÄÔö¼Ó»áÓÐËùÔö¼Ó£¬²»¹ý´óÖÂÉÏÓ¦¸ÃÒ»Ö£¬ÕâÒ²ÊÇ»ù±¾ËùÓеÄÌåϵ½á¹¹¶¼»áÃèÊöµÄ¶«Î÷£º
ÔÚÈÏʶÊý¾Ý»º³åÇøÇ°£¬ÏȼÇס¼¸¸ö³ ......
--21.1 Data Pump¹¤¾ß
Data Pump
´Óoracledatabase 10g¿ªÊ¼ÒýÈëÁËdata pump(Êý¾Ý±Ã)¹¤¾ß£¬ËüÌṩÁËÒ»ÖÖ»ùÓÚ·þÎñÆ÷µÄÊý¾Ýµ¼³öµ¼ÈëʹÓóÌÐò¡£
ËùÓеÄdata pump¶¼×÷Ϊһ¸ö·þÎñÆ÷½ø³Ì£¬Êý¾Ý²»ÔÙ±ØÐëÓÉÒ»¸ö¿Í»§³ÌÐò´¦Àí¡£Data Pump¹¤¾ßµÄµ¼³öºÍµ¼ÈëʵÏÖ
OracleÊý¾Ý¿âÖ®¼äÊý¾ÝµÄ´ ......
http://www.builder.com.cn/2007/1027/583048.shtml
ÔÚphp3.0ÒÔÉÏ°æ±¾ÖУ¬phpÄÚÖÃÁ˼¸ºõÄ¿Ç°ËùÓеÄÊý¾Ý¿â´¦Àíº¯Êý£¬°üÀ¨Oracle;ÔÚ±¾ÎÄÖÐÎÒÃÇͨ¹ýÒ»¸öʵÀýÀ´½éÉÜÁËÈçºÎʹÓÃÕâЩº¯ÊýÀ´²Ù×÷OracleÊý¾Ý¿â¡£
PHPÌṩÁË2´óÀàAPI(Ó¦ÓóÌÐò½Ó¿Ú)À´²Ù×÷OracleÊý¾Ý¿â¡£Ò»¸öÊDZê×¼µÄOracle´¦Àíº¯Êý(ORA) ÁíÒ»¸öÊÇOracle 8µ÷Óýӿں¯ ......
Ò»¡¢
´ò¿ª¿ØÖÆ̨£º
´ò¿ª http://localhost
:7001/console
£¬Æô¶¯¹ÜÀí¿ØÖÆ̨¡£ÊäÈë¹ÜÀíÔ±Óû§ÃûºÍÃÜÂ루ĬÈÏ£ºweblogic/weblogic£©¡£
¶þ¡¢´´½¨
JDBCÊý¾ÝÔ´£º
1¡¢
µ¥»÷“Ëø¶¨²¢±à¼
”°´Å¥£»
2¡¢
ÔÚ“Óò½á¹¹
”Ê÷ÖУ¬Õ¹¿ª“·þ
Îñ”>“JDBC”
£¬È»ºóÑ¡Ôñ“Ê ......