ÓÃsqlplus »òÕß su - oracle µÇ½ºó ÈçºÎ²é¿´µ±Ç°ÔÚÏßµÄÓû§£¿£¿£¿¾´Çë¸÷λָµ¼Ò»Ï£¡£¡£¡Íò·Ö¸Ðл
select username from v$session
select username from v$session
V$SESSION
ÒýÓÃ
V$SESSION
²»´í¡£²»¹ý£¬Èç¹û¿Í»§¶ËÊÇÒì³£¶ÏÍø£¬ÕâÀïÒ²ÊDzéµÄ³öÀ´µÄÓ´¡£
ÔÚÃüÁîÐÐÊäÈë
SQL code:
SQL> ......
×î½üͬʱʹÓÃoracle 10gºÍtomcat£¬ÔÚʹÓùý³ÌÖз¢ÏÖÁËЩÎÊÌ⣺
1¡¢tomcatºÍoracle¼àÌý³ÌÐòͬʱÆô¶¯Ê±£¬tomcat±¨´í£¨tomcatÆô¶¯Ê±Í¨¹ýeclipseÆô¶¯µÄ£©
2¡¢ÍøÉÏ˵oracle¼àÌý³ÌÐòÕ¼ÓÃÁË8080¶Ë¿Ú£¬µ«ÊÇÎÒÔÚ.net assistantÀïÃæ¿´ÁËÏ£¬
ÎÒ¼àÌý³ÌÐòʹÓõĶ˿ÚÊÇ1521£¬²¢²»ÊÇ8080¶Ë¿Ú£¬ÎªÊ²Ã´¶Ë¿Ú»¹»á³öÏÖ³åÍ»ÄØ£¿
3¡¢ ......
½ñÌìÓöµ½Ò»¸öÆæ¹ÖµÄÎÊÌ⣬OralceÊý¾Ý¿â£¬Öظ´»ñÈ¡jdbcÁ¬½Ó¡¢ÔÙÁ¢¿Ì¹Ø±Õ£¬Ñ»·200´Î×óÓÒ£¬¼´Å׳öÒì³£:
Exception in thread "main" java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descrip ......
±íÊý¾Ý±È½Ï´ó£¬×öÒ»¸ödelete²Ù×÷£ºdelete from mac_ppre_asset_bill_a where bill_month ='200911'
ToadÓÐûÓÐÀïÓÐûÓÐÕâÑùµÄ¹¦ÄÜ£¬
Unix·þÎñÆ÷£¬
ϰàÒª»Ø¼ÒÁË£¬ÈÃËû×Ô¼ºÅÜ¡£¡£¡£¡£
Çë˵µÄ¾ßÌåÒ»µã лл
¿ÉÒÔÓÃSecureCRTµÇ¼unix·þÎñÆ÷£¬ÔÚ·þÎñÆ÷ÀïÃæÁ¬½Ó½øÈ¥£¬Óúǫ́·½Ê½½ø³ÌÁ¬½Ósqlplus²¢Ö´ÐÐsql,È ......
¸÷λ´óÏÀÃÇ£¬Ð¡µÜÎÒJAVAÓóÌÐòÁ¬½ÓoracleÊý¾Ý¿âµÃµ½Á¬½ÓûÎÊÌ⣬ÎÒ°ÑËû·ÅÔÚInstall4jµÄ°²×°¹ý³ÌÖоÍÓÐÎÊÌâÁË £¬ÔÚ°²×°¹ý³ÌÖÐÈç¹ûÎÒÑ¡ÔñÁËORACLEÊý¾Ý¿âÁ¬½Ó£¬ÅäÖúòÎÊýºó±¨Õâ¸ö´í
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: invalid or unknown NLS parameter value spe ......
Õ÷¼¯´ó¼ÒÒâ¼û£º
OracleÈÏÖ¤ÔõôÑù£¿Ë¼¿ÆÈÏ֤Ĩ£¿
¿ÉÒÔ̸̸×Ô¼ºµÄÏë·¨Âð£¿
²»Í¬ÁìÓòµÄÈÏÖ¤,ûÓÐʲô¿É±ÈÐÔ
ÎÒÒ²ÏëÖªµÀOracleÈÏÖ¤ÔõôÑù£¿
ÒýÓÃ
Õ÷¼¯´ó¼ÒÒâ¼û£º
OracleÈÏÖ¤ÔõôÑù£¿Ë¼¿ÆÈÏ֤Ĩ£¿
¿ÉÒÔ̸̸×Ô¼ºµÄÏë·¨Âð£¿
²»Í¬ÁìÓò£¬Ã»ÓпɱÈÐÔ£¬µ«ÊÇÓÐÒ»µã£¬ÏÖÔÚ¶þÕßµÄÈÏÖ¤¶¼Ã»ÓÐÔÀ´µÄº¬ ......