作者: Maclean Liu, post on January 25th, 2012 
以下这个Action Script是我收集的在解决ORA-125XX(如ORA-12560)这类网络链接故障时的一些思路，主要包括 现有的网络配置(client & server side)、监听日志、SQLNET Client trace等信息– How to troubleshooting ORA-125** connection issues：
# CHECK FIREWALL, WINDOWS FIREWALL , ANTI-Virus Software First ! ping hostname tnsping TNS trcroute TNS telnet <hostname> <port>
tracert hostname
client side sqlplus scott/tiger@TNS
& server side sqlplus scott/tiger@TNS
cat /etc/hosts cat /etc/resolv.conf cat /etc/nsswitch.conf ipconfig . . . → Read More: 如何诊断ORA-125XX连接问题
作者: Maclean Liu, post on April 29th, 2011 Advise required on inbound paramters , prespawn servers and db resident connection
Question:
The application does not support persistent connection. currently we find time out errors. In order to fix the issue we seek your advise on the following: currently all of the following are default values SQLNET.INBOUND_CONNECT_TIMEOUT, — can we make it 10 seconds . . . → Read More: Connection pool,sqlnet,listener related issues/questions
作者: Maclean Liu, post on November 5th, 2010 首先是接口SQLnetDef，定义了参数
public interface SQLnetDef { public static final boolean DEBUG = false; public static final boolean ASSERT = false; public static final int NSPTCN = 1; public static final int NSPTAC = 2; public static final int NSPTAK = 3; public static final int NSPTRF = 4; public static final int NSPTRD = 5; public . . . → Read More: Oracle网络TNS协议的几个基础类描述(revised)
作者: Maclean Liu, post on August 5th, 2010 中午休闲时在itpub看到一个关于network buffer占用大量内存的求助帖,帖子原文如下:
各位大侠们，请教个问题。昨天遇到一个solaris10平台下的oracle10g(10.2.0.4)数据库报共享内存不足，发现数据库的sga_target才2512M，而在v$sgastat视图中查到的 shared pool–>NETWORK BUFFER就有1848744416字节，是什么引起network buffer这么大呢，在udmp目录下1分钟产生几个跟 ORA-4031相关的文件。
================== SQL> show parameter sga
NAME TYPE VALUE ———————————— ———– —————————— lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 2512M sga_target big integer 2512M SQL> show parameter share
NAME TYPE VALUE ———————————— ———– —————————— hi_shared_memory_address integer 0 max_shared_servers integer shared_memory_address integer 0 shared_pool_reserved_size big integer 72142028 . . . → Read More: 共享池中的NETWORK BUFFER
作者: Maclean Liu, post on July 26th, 2009 Hdr: 2728394 N/A NET 9.2.0.2 PRODID-115 PORTID-453 Abstract: TNSPING HANGS AND DOES NOT RETURN ERROR WHEN SERVICE NAME IS WRONG Problem: ——– When servie name is defined incorrectly, tnsping hangs and does not return any error though connection using the same service name gets TNS error. Versions: ——— Reproduced in R9.2.0.1 and 9.2.0.2. Not . . . → Read More: TNSPING may Consume unexpected memory in 9i
作者: Maclean Liu, post on July 14th, 2008 From My oracle support
Applies to: Oracle Net Services – Version: 8.1.7.4.0 to 11.1.0.6.0 – Release: 8.1.7 to 11.1 Information in this document applies to any platform. Checked for relevance on 12-DEC-2007 Purpose The purpose of this document is to clarify the use of the SERVICE_NAME parameter in the TNSNAMES.ORA and outline the correct values . . . → Read More: Resloving ORA-12514/12541
作者: Maclean Liu, post on July 10th, 2005 Good network security is accomplished by utilizing port and protocol screening with routers, firewalls, and Intrusion Detection Systems.Port and protocol screening with routers, firewalls, and Intrusion Detection Systems create a bastion against network attacks. A device that routes and translates information between interconnected networks is called a firewall. Firewalls have a different function Routers, not . . . → Read More: Know about Oracle Network Security
作者: Maclean Liu, post on July 10th, 2005 This practice uses common UNIX and NT Oracle utilities to practice enabling AUDIT on a database. You will:
See the procedure to enable and disable Oracle AUDIT on a database. Understand the SQL commands used to audit a specific user schema object. Investigate how to configure Audit to extend auditing into modified or new schema . . . → Read More: Practice:Demonstrating Oracle AUDIT Concepts and Procedures
|
|
最新评论