:::
比较oracle的tnsping与tcp/ip的ping命令
当客户端连接window上的数æ®åº“,或以共享连接的模å¼è¿žæŽ¥åœ¨unix上的数æ®åº“时, å› ä¸ºtnsnames.oraä¸ä¸ºæœåŠ¡å™¨çš„ip地å€ï¼Œæ‰€ä»¥ä¸å˜åœ¨åå—è§£æžçš„问题,客户端的连接请求会 到达listener,这也就是tnsping æµ‹è¯•ç¨‹åºæµ‹è¯•网络æœåŠ¡åå¯ä»¥é€šè¿‡çš„åŽŸå› ï¼Œå› ä¸ºtnsping测试
:::
listeners et connexions à une base oracle /*+ba-b
"rien" peut être une autre forme d'adressage si les variables two_task (unix & linux) ou que microsoft, novell ou unix et que vous voulez déléguer la gestion de tnsping alias (ou alias est le nom de l'alias tns que vous testez)
:::
在oracle网络结构ä¸è§£å†³è¿žæŽ¥é—®é¢˜
tnsnames.ora------这个文件类似于unix çš„hosts文件,æä¾›çš„tnsnameåˆ°ä¸»æœºåæˆ–者ip的对应, åªæœ‰å½“sqlnet.oraä¸ lsnrctl> status 2.tnsping 查看客户端sqlnet.oraå’Œtnsname.ora文件 çš„é…ç½®æ£ç¡®ä¸Žå¦ï¼ŒåŠå¯¹åº”çš„æœåŠ¡å™¨çš„listener进程的状æ€ã€‚ c:\>tnsping
:::
转载:ç†è§£oracle的网络结构
tnsnames.ora------这个文件类似于unix çš„hosts文件,æä¾›çš„tnsname到主机å 2.tnsping 查看客户端sqlnet.oraå’Œtnsname.ora文件的é…ç½®æ£ç¡®ä¸Žå¦ï¼ŒåŠå¯¹åº”çš„ tns ping utility for 32-bit windows: version 10.1.0.2.0 - production on 16-8月 -
:::
aix如何打开1521端å£
我的æ“作系统是aix5.3,在上é¢è£…了一个数æ®åº“,å‘现从客户端ä¸èƒ½è¿žæŽ¥ï¼Œè¿žtelnet也 ä¸è¡Œï¼Œå¦‚下: c:\documents and settings\jsssb>tnsping test tns ping utility for 32-bit windows: version 9.2.0.1.0 - production on 28-8月-2006 16:07:04
:::
copy - paste an oracle database quickly
tnsping ile db kontrol edilir:. oracle@zerg_shp01> tnsping shp05. tns ping utility for compaq tru64 unix: version 10.1.0.2.0 - production on 31-jul-2006 17:07:45. copyright (c) 1997, 2003, oracle. all rights reserved.
:::
《gfi安全和信æ¯è½¯ä»¶å…åˆä¸€ã€‹fax maker,lan guard nss,mail essential
它å¯ä»¥å¯¹ä½ çš„æœåС噍--包括unix/linuxæœåС噍ã€å·¥ä½œç«™å’Œè®¾å¤‡--如路由器ç‰è¿›è¡Œè¯¦ç»†ç›‘控, 利用tns ping检查和logon/logoffæ¥ç›‘控oracleæœåŠ¡å™¨ã€‚åˆ©ç”¨odbc也å¯ä»¥ç›‘控其他 gfi network server monitorå¯ä»¥åŒæ—¶ç›‘控多个平å°ï¼ŒåŒ…括unix/linuxå’Œnovell。
:::
unix下oracleæ•°æ®åº“的导出与导入
显示当å‰å®žä½“:. echo $oracle_sid(表示oracle_sid是一个å˜é‡å,所以å‰é¢åŠ $符å·). 测试实体连接与å¦ï¼š. tnsping 实体åç§°. 从实体ä¸å¯¼å‡ºæ•°æ®åº“:. 在完æˆä»¥ä¸Šæ¥éª¤ åŽï¼Œoracle用户登录unixæœåŠ¡å™¨ï¼Œå‘½ä»¤ï¼š. exp 用户å/密ç tables=table1,( table2, .
:::
é¢å‘ dba çš„ linux shell 脚本简介
如果您以å‰ä»Žæœªä½¿ç”¨è¿‡unix 或类似unix 的系统,那么å¯èƒ½ä¼šå¯¹å¤§é‡å«ä¹‰æ™¦æ¶©çš„命令感到 一æ„莫展。 å¯ä»¥ä½¿ç”¨tnsping å®žç”¨ç¨‹åºæŸ¥çœ‹ç»™å®šoracle è¿žæŽ¥æ ‡è¯†ç¬¦èƒ½å¦è¿žæŽ¥ç›‘å¬å™¨ã€‚ tnsping ptch04 |grep tns- æ•°æ®åº“å¯¼å‡ºå’Œå¯¼å…¥ï¼ˆä¼ ç»Ÿçš„å’Œæ•°æ®æ³µï¼‰æ¯”较适åˆäºŽ
:::
oracle tips
3ã€unix下oracleæ•°æ®åº“的导出与导入. 首先è¦è¿›å…¥instance(数æ®åº“实体),具体命令:. export oracle_sid=实体åç§°. 显示当å‰å®žä½“:. echo $oracle_sid(表示oracle_sid是一个 å˜é‡å,所以å‰é¢åŠ $符å·). 测试实体连接与å¦ï¼š. tnsping 实体åç§°
:::
9i client tnsping error
I have just installed oracle client 9.2.0.1.0 on one unix box (called curly$ tnsping NPD TNS Ping Utility for Solaris: Version 9.2.0.1.0 - Production on
:::
Oracle Product Info: TNSPING Error Message 3511 not found
Title: TNSPING Error Message 3511 not found Unix Windows 2000 Windows NT Windows ME Windows XP Windows 98 Windows 95 & 3.x Open BSD Windows Server 2003
:::
Oracle FAQ: Oracle Networking Services (SQL*Net/ Net9)
Directory pointed to by the TNS_ADMIN parameter ($TNS_ADMIN on Unix); /etc (Unix only) Sometimes it is useful to only trace TNSPING packets.
:::
在UNIXæœåŠ¡å™¨ä¸Šè®¾ç½®Oracle8i全文检索- atmospheric-SDB - ä¿¡æ¯èµ„讯
在UNIXæœåŠ¡å™¨ä¸Šè®¾ç½®Oracle8i全文检索- atmospheric-SDB - ä¿¡æ¯èµ„讯- 关系 æ•°æ®åº“|SupSite|PHP|SITE|FORUM|bbs|board. tnsping extproc_connection_data 或者tnsping
:::
UNIX 4 DBA (Part II)
Using UNIX commands. To see the name of a user from his unix id (Provided your UNIX admin keeps them!) tnsping SIDNAME
Oracle FAQ: Oracle Networking Services (SQL*Net/ Net9)
Directory pointed to by the TNS_ADMIN parameter ($TNS_ADMIN on Unix); /etc (Unix only) Sometimes it is useful to only trace TNSPING packets.
:::
OraFAQ Forum: OS/390 & AS/400 => How can I verify TNS(OS/390) is up
How can we verify (from a PC or a Unix box) that the TNS address space is up on the I thought that TNSPING checked for the DB not the TNS address space?
在UNIXæœåŠ¡å™¨ä¸Šè®¾ç½®Oracle8i全文检索- atmospheric-SDB - ä¿¡æ¯èµ„讯
在UNIXæœåŠ¡å™¨ä¸Šè®¾ç½®Oracle8i全文检索- atmospheric-SDB - ä¿¡æ¯èµ„讯- 关系 æ•°æ®åº“|SupSite|PHP|SITE|FORUM|bbs|board. tnsping extproc_connection_data 或者tnsping
UNIX 4 DBA (Part II)
Using UNIX commands. To see the name of a user from his unix id (Provided your UNIX admin keeps them!) tnsping SIDNAME
:::
The Oracle trcroute utility ( UNIX only) enables DBAs to identify
Unlike tnsping, trcroute stops at each network "hop" and gathers certain information trcroute and traceroute are only available on UNIX platforms.
:::
下载第14 ç« UNIX 上的Oracle è”网技术
N e t 8的连通性软件的一部分æä¾›çš„。 Net8 Assistant包å«ä¸€ä¸ªè¿žæŽ¥æµ‹è¯•部件,它执行 与t n s p i n g. 相åŒçš„功能。 第14ç« U N I X上的O r a c l eè”网技术
:::
Cisco - Troubleshooting Cisco Secure ACS for UNIX
Also check the timezone (TZ) variable in the env output on the UNIX station. Issue the tnsping command to check if the address and port information in
:::
Exzilla.net -- Startup and shutdown Oracle Database with unix
tnsping viper. TNS Ping Utility for DEC OSF/1 AXP: Version 8.1.6.0.0 The owner for each unix shell file must be oracle owner and have right to execute.