Oracle High Availability . This was a manual SQLPLUS command- line method because of issues with using Data. Guard to complete this task without hanging or connection- related issues (that never show up until switchover time). We are ecstatic at this point because we also implemented huge pages on Linux RH 6. SGA, encrypted filesystems , DB.
This is Oracle 1. Life seems normal up to this point.
![Oracle Unix Administration Handbook Oracle Unix Administration Handbook](http://www.redware.com/handbooks/sql_server_handbook/sqlhandbook21_files/image002.gif)
Calling all High Rollers: Hit the Oracle PacktPot! Packt Publishing prepares for COLLABORATE 12 with discounts on Oracle titles all month. As a leading publisher of Oracle books/eBooks, Packt Publishing is inviting. This is a personal blog for non-profit educational purpose only. It has no affiliation with Oracle or any company and any views expressed here are of the author himself only. What is a Cluster; Components of RAC; RAC Storage; ASM; raw device; Cluster File system; Voting Disk and Cluster Registry; What is a raw device? The Practical Handbook on Oracle. This Oracle tuning tip is part of a series on the different aspects of disk I/O performance and optimization for Oracle databases. This segment addresses tuning for the SCSI interface under the AIX operating system.
Building an Inexpensive Oracle RAC 11g R2 on Linux - (RHEL 5) by Jeff Hunter, Sr. Database Administrator Contents. Introduction; Oracle RAC 11g Overview; Shared-Storage Overview; iSCSI Technology; Hardware and Costs; Install. Hello, I wanna wish you all a very Happy New Year 2009 before being discussed on “How Important Having UNIX OS Knowledge for Oracle DBA?” The main reason for discussing this topic is to encourage the novice or.
Oracle’s complete and integrated cloud strategy gives you compatibility, portability, and the best-of-breed selection of SaaS, PaaS, and IaaS applications, platforms, and services. In PROFIT Magazine’s special issue.
![Oracle Unix Administration Handbook Oracle Unix Administration Handbook](http://www.oracle-base.com/articles/linux/images/process_management/02-SystemMonitorPopupMenu.jpg)
![Oracle Unix Administration Handbook Oracle Unix Administration Handbook](http://wyomingcowboysblog.com/wp-content/uploads/2009/12/austyn-carta-samuels.jpg)
August 1. 6 th – As DBA I scan the alertlogs every 1. ORA and/or WARNINGI start getting complaints from endusers that our ERP is slow, freezing, etc. At this point we suspect the switchover to new hardware. So I moved the redo logs to unencrypted filesystem area.
I am spending 1. 0 hours or so trying to figure out what is wrong, my ulcer also kicks into high gear. Oracle Enterprise Graphs are looking unusual.
So now the guessing goes into full swing. There is some functionality for tracing but they only indicated the hanging/freezing sessions were gone from the database after a point in time, but what disconnected them? I surmised the freezing that people experienced with this FORMS app was due to the 3. FORMS configuration. We have been using this parameter for many years which attempts a reconnection for at least 3. People end up closing their browser and that generates the 1. I notice some patterns – these 1.
I finally figured out to find the smallest error number is the important one – 1. Fatal NI connect error 1. VERSION INFORMATION: TNS for Linux: Version 1. Production. Oracle Bequeath NT Protocol Adapter for Linux: Version 1. Production. TCP/IP NT Protocol Adapter for Linux: Version 1.
Production. Time: 2. AUG- 2. 01. 4 1. 8: 1.
Tracing not turned on. Tns error struct: ns main err code: 1. TNS- 1. 25. 35: TNS: operation timed outns secondary err code: 1. TNS- 0. 05. 05: Operation timed outnt secondary err code: 1. OS err code: 0. Client address: (ADDRESS=See MOS Note. Alert Log Errors: 1.
TNS- 1. 25. 35/TNS- 0. Operation Timed Out (Doc ID 1. We are pretty sure this is network- related/OS- related but how do we convince the Network guys something is wrong. Trying to find error numbers that I haven’t seen. Tracing on the database side didn’t really help. And this is where we start heading down the road of too many mods!
Switched back to the 1. GB NIC2. Switched hardware load balancers. Upgraded the database to 1. Oracle bug 1. 00. Waits using DBLINKS & nested loops. We had to install two more patches on top of 1.
CPU) to get rid of some issues associated with that version which produced ORA- 9. Moved to 1. 2. 1. Installed/ran OSWatcher on the database server.
How does one even start to understand what is produced especially for the network stats. Enabled a job to restart services on a different application that was losing its connections as well.
Removed one of the three Oracle Forms/Reports Servers from the load balancer. Ran RDA against the forms server, using it for a contact on this issue. Lots of disconnects showing up in the logs.
Was it a recent JAVA desktop update. Results of traces on the database. Lots of 1. 21. 51 and 3. Recompiled all of the forms, rewrote bad application code.
Reconfigured/rebooted tweaked all settings on the LOAD BALANCER1. Upped it to two hours . Some of our other applications that connected to the same database turned back to normal activity but the FORMS app was still choking.
Well my wonderful boss finally decided to start a SQLPLUS trace session from different vantage points to set what happened to try and determine if any kind of session was affected. SQLPLUS from our desktops. SQLDEVELOPER from our desktops. SQPLUS from a server in the same subnet.
SQLPLUS from other servers in different subnet. SQLPLUS from the app server different subnet not on the load balancer. SQLPLUS from the app servers still on the load balancer. Connected to the database in question and started the wait? This is merely a useful side- effect of the feature.
Therefore, DCD may not work as expected and the firewall / switch may still terminate TCP sockets that are idle for the period monitored, even when DCD is enabled and working. This will cause the OS to send a test packet to the client when the timeout is reached and the client will respond with an ACK. To all intents and purposes this is the same as turning off the firewall inactivity timer for this host.”We had reset the tcp. Applications that only connected for a few seconds weren’t affected but all apps that required a sticky session for more than one hour were.
But at least I have more knowledge that what I started with. So the final conclusion is that the network/switches/router upgrades that happened way back when this started.
Delete all old Oracle trace and audit files more than 1. Oracle Tips by Burleson Consulting.
Delete all old Oracle trace. Here is an example of a UNIX script for keeping the archived redo. As we know, it is important to. Oracle may “lock- up” if he. If you are using Solaris the oratab. HP/UX and AIX have the oratab.