WindowsÏÂÃüÁîÐÐÆô¶¯Oracle 10g/Database Control
1.Æô¶¯TNS¼àÌý
C:\Documents and Settings\Administrator>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-7ÔÂ -2008 12:0
3:55
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Æô¶¯tnslsnr: ÇëÉÔºò...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
ϵͳ²ÎÊýÎļþΪE:\oracle\product\10.2.0\db_1\network\admin\listener.ora
дÈëE:\oracle\product\10.2.0\db_1\network\log\listener.logµÄÈÕÖ¾ÐÅÏ¢
¼àÌý: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
¼àÌý: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=1521)))
ÕýÔÚÁ¬½Óµ½ (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER µÄ STATUS
------------------------
±ðÃû LISTENER
°æ±¾ TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Æô¶¯ÈÕÆÚ 13-7Ô -2008 12:03:56
Õý³£ÔËÐÐʱ¼ä 0 Ìì 0 Сʱ 0 ·Ö 1 Ãë
¸ú×Ù¼¶±ð off
°²È«ÐÔ ON: Local OS Authentication
SNMP OFF
¼àÌý³ÌÐò²ÎÊýÎļþ E:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
¼àÌý³ÌÐòÈÕÖ¾Îļþ E:\oracle\product\10.2.0\db_1\network\log\listener.log
¼àÌý¶Ëµã¸ÅÒª...
(DESCRIPTION=(ADDRESS=(P
Ïà¹ØÎĵµ£º
±¾ÎĽéÉÜÁËÈçºÎÀûÓÃsqlplus copy ÃüÁîÔÚÁ½¸öÊý¾Ý¿â¼äתÒÆÊý¾Ý
ÎÞÐèÓõ½dblink, Á½¸öÊý¾Ý¿â¼ä²»ÐèÖ±½ÓͨѶ£¬µ±È»£¬ÐèÒªÓÐÒ»¸öclient¶ÎÄÜͬʱÒÔsqlplusÁ¬½Óµ½Á½¸öÊý¾Ý¿â
ÎÊÌâµÄÌá³ö
ÂÛ̳ÉÏÓÐÈËÌá³öÕâÑùµÄÎÊÌ⣺
¼ÙÉèÓÐÁ½¸öÊý¾Ý¿â,·Ö±ð´¦ÓÚÁ½¸ö²»Í¬µÄÍøµ«ÓÐÒ»¸ö¿Í»§»ú°²ÁËÁ½¿éÍø¿¨¿ÉÒÔͬʱÁ¬µ½Á½¸öÊý¾Ý¿âÇëÎÊÈç¹û²»Í¨¹ýÔÚ¿ ......
×¢£ºÏÂÃæÖ»ÊÇÎÒ´ÖÁӵļǼһÏ£¬×Ô¼ºÔÚ¿ª·¢ÖÐËùѧµÄÒ»²¿·Ö×ÊÁÏ£¡
1£® µÚÒ»¡¢ÊÇÏÂÔØÒ»¸ö“Oracle9i¿Í»§¶Ë¾«¼ò°æ.exe”¿Í»§¶Ë£¬È»ºó°ÑËü°²×°µ½CÅÌÏÂÃæ¡£
È»ºó°ÑÎÒÃÇ×Ô¼ºÅäÖúõĔ tnsnames.ora”Îļþ£¬¸´¸ÇC:\oracle\ora90\network\adminÏÂÃæµÄtnsnames.oraÎļþ¡£
2£® ÔÚVS2005¿ª·¢¹¤¾ßÖ ......
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.5.0
This problem can occur on any platform.
Symptoms:
The issue is that the following error was raised :
ORA-00600: internal error code, arguments: [kesutlGetBindValue-2], [], [], [], [], [], [], []
The recent changes ......
3oracleÊý¾Ý¿âµÄ×Ö·û¼¯¸ü¸Ä
A¡¢oracle server ¶Ë ×Ö·û¼¯²éѯ
select userenv(‘language’) from dual
ÆäÖÐNLS_CHARACTERSET Ϊserver¶Ë×Ö·û¼¯
NLS_LANGUAGE Ϊ server¶Ë×Ö·ûÏÔʾÐÎʽ
B¡¢²éѯoracle client¶ËµÄ×Ö·û¼¯
$echo $NLS_LANG
Èç¹û·¢ÏÖÄãselect ³öÀ´µÄÊý¾ÝÊÇÂÒÂ룬Çë°Ñclient¶ËµÄ×Ö· ......