oracle 10g °²×°¹ý³Ì
ÔڵǼemµÄʱºò¡£
²é¿´Ò»Ï emctl status dbconsole
ÕÒµ½urlµØÖ·
ÔÚÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿âµÄʱºò³öÏÖ
oracle 10g remoteoperationexception error wrong password for user
¿ÉÒÔÔÚ
×é²ßÂÔ -- >±¾µØ²ßÂÔ -->Óû§È¨ÀûÖ¸. -- >×÷ΪÅú´¦Àí×÷ÒµµÇ¼ÖмÓÈëÕâ¸öÓû§
¼´¿É.
Ïà¹ØÎĵµ£º
1.2 ¹ÜÀíJobs
1.2.1 ÆôÓÃJobs
¡¡¡¡Ç°Ãæ´´½¨JOBʱ£¬ÓÉÓÚδÏÔʽµÄÖ¸¶¨ENABLED²ÎÊý£¬Òò´Ë¼´Ê¹Ö¸¶¨ÁËSTART_DATE£¬²»¹ýĬÈÏÇé¿öÏÂJOB²»»á×Ô¶¯Ö´ÐС£¶ÔÓÚÕâÖÖÇé¿ö£¬DBMS_SCHEDULER°üÖÐÌṩÁËÒ»¸ö¹ý³ÌENABLE£¬¿ÉÒÔÓÃÀ´ÐÞ¸ÄJOBµÄÆôÓÃ״̬£¬µ÷Ó÷½Ê½·Ç³£¼òµ¥£¬ÀýÈ磺
SQL> exec dbms_scheduler.enable(¨INSERT_TEST_TBL& ......
Èý¡¢Ê¹ÓÃSchedules
¡¡¡¡10g ÖÐÐÂÍƳöµÄSCHEDULER¿ÉÄÜȷʵ»áÈúܶà³õ½Ó´¥µÄÅóÓѸоõÔÎÍ·ÔÎÄÔ£¬Ïà±È֮ǰµÄjobs£¬SCHEDULERÖÐÐÂÔöµÄ¸ÅÄîÌ«¶à¡£±ÈÈç˵jobs£¬ÈÔÈ»¿ÉÒÔÀí½â³É֮ǰ°æ±¾ÖеÄjobs£¬²»¹ý¹¦Äܸü¼ÓÇ¿´ó(×¢Òâ10gÖÐÒ²ÈÔÈ»¿ÉÒÔʹÓÃÆÕͨjobs£¬ÕâÊÇ·Ï»°£¬ÏàÐÅ¿´±¾ÆªÎÄÕµÄÅóÓÑÄ¿Ç°Ó¦¸Ã»¹ÊÇÕâÑùÔÚÓÃ)£¬±ÈÈç˵program£¬Ö¸µÄÊÇÔ ......
ÔÚ/etc/rc.d/init.d/ ´´½¨oracle10gÎļþ
touch oracle10g
chmod a+x oracle10g
[root@test~]# vi /etc/rc.d/init.d/oracle10g
#!/bin/bash
#chkconfig:345 51 49
#description:starts the oracle database deamons
#
ORACLE_HOME=/oracle/product/10.2.0/db_1
ORACLE_OWNER=oracle
case "$1" in
start)
echo ......
¾ßÌåʵÏÖÈçÏ£º
SQL> select count(*) from v$session #Á¬½ÓÊý
SQL> Select count(*) from v$session where status='ACTIVE'¡¡#²¢·¢Á¬½ÓÊý
SQL> show parameter processes #×î´óÁ¬½Ó
SQL> alter system set processes = value scope = spfile;ÖØÆôÊý¾Ý¿â #ÐÞ¸ÄÁ¬½Ó ......
¼×¹ÇÎÄÒѾÍê³ÉÁ˶ÔSUN¹«Ë¾µÄÊÕ¹º£¬ÓÚ1ÔÂ27ÈÕ·¢²¼Á˶ÔSun¸÷ÏîÒµÎñµÄÕûºÏ¹æ»®¡£×ÜÌåÉÏ˵£¬OracleÒª³ÉΪÈíÓ²¼þÒ»Ì廯µÄÕûÌå½â¾ö·½°¸µÄ³§ÉÌ¡£ ÒÔϾÍÆä¶Ô±¸ÊܹØ×¢µÄJava·½ÃæµÄ²ßÂÔ×ö¸ö½éÉÜ¡£
Java SE:
1£©ÍƳöJDK SE 7£¬ Ëü½«°üÀ¨¶à¸öÐµĹ¦ÄÜ£¬ÈçÌá¸ß¿ª·¢ÈËÔ±µÄЧÂÊ£¬Ìṩ¸ßÐÔÄÜ£¬¶Ô¶àºËоƬµÄÖ§³ÖµÈ¡£
2£©SunµÄHotSpot ......