Çë½ÌÔõÑùÅäÖÃTTÓëoracleÁ¬½Ó?
ÎÒÔÚTTºÍoracleÁ½¶Ëͬʱ½¨Á¢ºÃÓû§£º
sql>create user myname identified by mypass;
sql>grant dba to myname;
Command>create user myname identified by mypass;
Command>grant admin to myname;
È»ºó
Command>call ttcacheuidpwdset('myname','mypass');
±¨´íÎó£º
5219£ºTemporary Oracle connection failure error in OCIServerAttach(): ORA-12541: TNS:no listener rc = -1
5935 Could not validate Oracle login: uid = myname, pwd = HIDDEN, OracleNetServiceName = ora1.localdomain, TNS_ADMIN = ".........", ORACLE_HOME= "........."
The command failed.
ORA-12541: TNS:no listener rc = -1
¼àÌýÓÐÅäÂ𣿠ÅäºÃ¼àÌýºóÓÃtnsping SID,ÄÜpingͨ¾Í¿ÉÒÔÁË¡£
˳±ãÎÊÏ£ºTT ÊÇʲô£¿
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716
timesten
ûÓмàÌýÎÒÔõôÄÜsqlplus½øÈ¥½¨Óû§ÄØ¡£¡£¡£¡£¡£¡£
Ï൱ÎÞÓï¡£¡£¡£¡£¡£¡£
5219£ºTemporary Oracle connection failure error in OCIServerAttach(): ORA-12541: TNS:no listener rc = -1
5935 Could not validate Oracle login: uid = myname, pwd = HIDDEN,
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
лл
ÎÒÒ²ÊÇÏëÖªµÀ
me too
ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......
¸öÈ˾õµÃÔÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
[color=#FF0000][/color]ÒÔÏÂÊÇÎÒµÄservlet´úÂë[color=#FF0000][/color]package JDBCExample1.demo1;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import ......