| Title: | Oracle |
| Notice: | For product status see topics: UNIX 1008, OpenVMS 1009, NT 1010 |
| Moderator: | EPS::VANDENHEUVEL |
| Created: | Fri Aug 10 1990 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1574 |
| Total number of notes: | 4428 |
Three questions regarding ORACLE on Digital UNIX 1) the ulimit problem. Is the issue of shell limits documented anywhere ? I was at a site recently where we had to change the oracle user shell to get round a problem with process limits. This was on an OPS/TruCluster system with several tablespaces > 2Gb. If it is documented can someone please let me know as it took oracle support about 4 hours to find the problem. 2) Oracle Shutdown & TNS Listener Does anyone know of a way to stop the problems with shutting down Oracle when there are still listeners running ? It seems that if you shutdown svrmgr manually and there are still listeners running oracle does not go down gracefully. Also does anyone have a shell script that will check for the existance of listeners and stop them before shutting down oracle ? 3) Oracle RDBMS & Developer 2000 Version problems. At the TruCluster Site we were running 7.3.2.1+ Patches. Also we we using Developer2000. This was an older version. We were told by Oracle to install Developer 2000 into a separate directory tree so that we could continue to relink the Server as there were problems with D2000 libraries overwriting the RDBMS ones and making the re-link of the server impossible. Has any reader come upon this before and do they know when/if Oracle will resolve it ? I suspect not until Oracle8. What is the latest version of D2000 for DUNIX ? Regards, Stephen Davies
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 1527.1 | answers to 1) and 2) | ALFAM7::GOSEJACOB | Wed Mar 12 1997 03:46 | 32 | |
re .0
> 1) the ulimit problem.
Operating System Specific documentation; "Oracle7 Installation Guide
for Digital UNIX Release 7.3"; appendix C; page C-5 spells it out in
detail for you.
I can't think of any shell limit that would cause trouble with
data files larger than 2GB. Check the SGA and related buffer (sort area
and stuff) sizes against the shell limits.
>2) Oracle Shutdown & TNS Listener
Hmmm, could you explain in more detail what you mean by: "oracle does
not go down gracefully". How do you shut Oracle down:
shutdown?
shutdown immediate?
shutdown abort?
But even if you just use a plain 'shutdown' running listeners should
not cause any trouble. Different story if you still have users
connected to the database: 'shutdown' will wait 'til they all
disconnect; 'shutdown immediate' will let then finish their current
transaction and than kick them out; use 'shutdown abort' only in case
of emergency.
Hope this helps
Martin
| |||||
| 1527.2 | more info | BROUGH::DAVIES | Hype is a 4 letter word ! | Fri Mar 14 1997 06:48 | 21 |
Martin,
Thanks for the reply.
The SGA was always set to about 100Mb. The docs were at the time of
doing the work stuck in customs. I will get a copy of the info for my
records.
>2) Oracle Shutdown & TNS Listener
Situation is that with NO users connected, the DBA goes into svrmgrl
and issues a shutdown (normal). The site has TWO Listeners (2 Ethernets, 1 per
Interface) and 90% of the time not all the ORACLE Server processes shutdown.
We were finding it difficult to get to a situation whereby we could issue
a unix "shutdown now" and get the system to shutdown properly every time.
If any noter has got this sorted out I am sure that there will be other readers
besides myself that are interested in the methods used.
Stephen Davies
| |||||