oracleÖÐ ÕýÔÚÁ¬½Ó...ORA 12541: TNS: ûÓмàÌý³ÌÐò
¶ÔÓÚ×°ºÃÁ˸ÃÈí¼þºó,ÀûÓÃsystemÊÇÄܵǽøÈ¥µÄ,»ú×ÓÖØÆôºó,³öÏֵĸÃÎÊÌ⣺
¿ÉÄÜÄú ÔËÐÐ--sqlplusw ÊÇÄܵÇÉÏÈ¥µÄ ¶ø»»³ÉPL/SQL Developer È´Á¬²»ÉÏ ·þÎñÆ÷,Èç¹ûÄúÈ·¶¨ÄãµÄ·þÎñ¿ªÆôÁË
ËÑË÷ÕÒµ½tnsnames.oraºÍlistener.oraÎļþ, °ÑÆäÖеÄHOST=ºóµÄÖ÷»úÃû»òip¸ÄΪµ±Ç°µÄÖ÷»úÃû»òip£¬²¢ÖØÐÂÆô¶¯¼àÌý·þÎñ¡£Ö®ºóˢпØÖÆ̨ҳÃ棬»á¿´µ½¼àÌý³ÌÐòÒѾÆô¶¯£¬µ«¿ÉÄÜ»á³öÏÖÏÂÃæµÄÌáʾ“ORA-12505: TNS: ¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐËù¸ø³öµÄ SID (DBD ERROR: OCIServerAttach)”£¬Ã»¹Øϵ£¬¶àˢм¸´Î¼´¿É¿´µ½µ½ÊµÀýµÄ´úÀíÁ¬½Ó³É¹¦µÄÐÅÏ¢¡£
Ïà¹ØÎĵµ£º
ÔÚoracleÖУ¬ÓÐ4¸ö´ó¶ÔÏó£¨lobs£©ÀàÐÍ¿ÉÓ㬷ֱðÊÇblob,clob,bfile,nclob¡£
¡¡¡¡ÏÂÃæÊǶÔlobÊý¾ÝÀàÐ͵ļòµ¥½éÉÜ¡£
¡¡¡¡ blob:¶þ½øÖÆlob£¬Îª¶þ½øÖÆÊý¾Ý£¬×¿É´ï4GB£¬´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ clob:×Ö·ûlob,×Ö·ûÊý¾Ý,×¿ÉÒÔ´ïµ½4GB,´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ bfile:¶þ½øÖÆÎļþ;´æÖüÔÚÊý¾Ý¿âÖ®ÍâµÄÖ»¶ÁÐͶþ½øÖÆÊý¾Ý£¬×î´ó³¤ ......
oracleÌṩÈýÖָ߼¶±¸·Ý¹¦ÄÜ
¸ß¼¶¸´ÖÆ£¨Advanced Replication£©
Á÷¸´ÖÆ£¨Streams Replication£©
±¸¿â£¨Dataguard£©
Ò» dataguard£º
dataguardÔڸ߿ÉÓü°ÈÝÔÖ·½ÃæÒ»°ãÊÇdbaµÄÊ×Ñ¡£¬²»¹ÜÊÇÎïÀí±¸Óÿ⣨physical standby database£©»¹ÊÇÂß¼±¸Óÿ⣨logical standby database£©£¬ËüÃǶ¼¾ßÓÐһЩ¹²Í¬µÄ´ýÕ÷¡£
ÅäÖú͹ÜÀí· ......
--ËøµÄ¸ÅÄî
Ëø³öÏÖÔÚÊý¾Ý¹²ÏíµÄ³¡ºÏ£¬ÓÃÀ´±£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔ¡£µ±¶à¸ö»á»°Í¬Ê±ÐÞ¸ÄÒ»¸ö±íʱ£¬ÐèÒª¶ÔÊý¾Ý½øÐÐÏàÓ¦µÄËø¶¨¡£
-- ËøµÄģʽ£¬ÓÐÒÔϼ¸ÖÖģʽ
0£ºnone
1£ºnull ¿Õ
2£ºRow-S Ðй²Ïí(RS)£º¹²Ïí±íËø£¬sub share
3£ºRow-X ÐжÀÕ¼(RX)£ºÓÃÓÚÐеÄÐ޸ģ¬sub ex ......
package test;
import java.text.SimpleDateFormat;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;
import po.Stu;
public class Insert1 {
/**
* @param args
*/
public ......
CREATE OR REPLACE FUNCTION OFFICE.fbill_getbalance (billid NUMBER, total NUMBER)
RETURN NUMBER
IS
paid NUMBER;
balance NUMBER;
BEGIN
balance := total;
--get total paid
SELECT SUM (n_paidamount)
&nb ......