Re: oracle sessions from term server
Hello, We have a similar situation with our Win2K terminal server-based sessions and our Win2K database server (8.1.7.4.1) although we have not introduced the use of SQLNET.EXPIRE_TIME in this case. As detailed in Metalink Doc ID 151972.1 (Dead Connection Detection (DCD) Explained), there are limitations in a Windows environment. These limitations are not restircted to a Windows-only environment however, as I have seen the same behaviour with NT4 terminal servers connecting to an AIX database server (8.1.7.2.1). The use of DCD is worth investigating. Other Metalink documents that may be useful are 1018160.6 (Common Questions About Dead Connection Detection (DCD)) and in particular, check out bug 2167389 (THREAD LEAK WITH DCD SET CAUSES NT TO HANG) If you discover that that DCD introduces more problems than it solves, then it is trivial to disable - simple hash out the SQLNET.EXPIRE_TIME parameter in the SQLNET.ORA file - no reboot required. HTH --- nigel. Hi Guys , we have forms/report application installed on windows terminal servers and user access application from these terminal servers . When some session hangs on these term server adminstrator resets those sessions . But the corresponding database session remains alive . Is it s problem with some sql*net setting ?? Any help in this regard is highly appreciated . -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nigel cemm INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: win2k system shutdown scripts--suitable for db shutdown?
Hello, I'm reading that win2k supports shutdown scripts (w/the group policy mmc snap-in). Is anyone using these to shutdown their win2k-hosted oracle databases? Right now our netadmins are running shutdown scripts as a manual step, but if it's susceptible of scripting, we'd like to do it that way instead. Are there any gotchas? I have a TAR open with OSS regarding the shutdown behaviour of 8.1.7.x on Win2K. We have several Win2K servers running 8.1.7.3 or 8.1.7.4 which do not stop the database correctly during a server reboot. Investigation has shown that while a 'net stop oracleserviceDB_NAME' command entered into a command prompt completes successfully, shutting down / rebooting the server without first stopping the database service results in an instance recovery having to be performed during startup. The alert log shows that during a shutdown / reboot, there is *no* attempt made to stop the database. I have configured the servers and databases according to the various Metalink documents and the settings have been verified by OSS. This behaviour only occurs on our Win2K servers that run 8.1.7.3 and 8.1.7.4: other Win2K servers that run 8.1.7.2 and earlier do not exhibit the problem. Interestingly, we do have a single Win2K/8.1.7.4 server that does stop the database correctly during a server shutdown / reboot. OSS have recreated the error using 9iR2 on Win2K and have reported that the database stop during a server shutdown / reboot appears to work more reliably on NT. Investigation by Oracle Development suggests that the problem lies with the Service Control Manager (SCM) in Win2K that handles the starting and stopping of the system services. OSS have advised me to get in touch with Microsoft to persue the matter further. I have (unsuccessfully) attempted to persuade OSS to liase with Microsoft directly but they have so far refused. I digress ... Finally, to answer your question, a workaround provided to me by OSS is to use the Group Policy Editor to have Win2K run a VBS script during a server shutdown. The code provided is: Set WshShell = WScript.CreateObject(WScript.Shell) Return=WshShell.Run(sqlplus shutdownusr/passwordl as sysdba @C:\orashut, 1, true) I received the code only yesterday and as yet haven't tested it. As I would rather not have a password held in a text file on the server, I first plan to test the use of the GP shutdown script with the 'net stop' command (as described above) as this works correctly interactively and obviates the need for a user id and password to stored in a file. Before testing the use of the GP shutdown script, I advise you to investigate if the database(s) on your Win2K server are stopped correctly during a server shutdown / reboot. If the databases are stopped in the correct manner, then it is one less thing for you to worry about :) I'll do some of my own testing with the GP shutdown script and post feedback to the list. Please note that it will take me some weeks to provide the feedback as I am about to start a major installation of a new set of databases and servers for a customer of ours. I just love those night shifts and long hours ;) --- nigel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nigel Cemm INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Win2K Mount Points
Hello, I have been tasked to upgrade an existing Openserver 5 / 7.3.4 installation to a Win2K / 8.1.7 installation. The hardware is an IBM 8500R 8-way with 4GB main memory and 32 mirrored pairs. Under Unix it is simple to mount each filesystem at an appropriate mount point. However, the traditional method of using drive letters in Windows is somewhat limited by the number of available letters. The obvious solution with NTFS5 is to use mount points - which is what I have done. I have a directory located in $ORACLE_BASE under which I have mounted 25 of the mirrored pairs, i.e. all of the filesystems that will be used exclusively by Oracle Currently, the Openserver installation is still live and I am configuring the Win2K installation on identical h/w for a period of testing. Whilst I have had not had any issues with using NTFS5 mount points, I have been scratting around trying to find real-world experience of such a configuration. The official Oracle line (via an iTAR that I filed) is that as the base OS is fully supported, i.e. supported without certain features being excluded, the use of mount points is okay. However, should I observe any issues with such a configuration then any queries should be directed to Microsoft. The response is fair enough, I guess, but it didn't provide what I was asking for. Therefore, I would like to ask the wider audience if they have any experience of such a configuration, i.e. any known issues with NTFS5 mount points in general, the number that is safe to use beneath a base directory, recovery issues etc. I should point out that the application data that is stored in the database is roughly 80% static and 20% hot and in the ideal world the static data could be stored on a smaller number of larger arrays to allow the h/w to do most of the load balancing. However, I have no say in h/w matters so this isn't really an option for me. Finally, as this is my first post to the list, perhaps I should introduce myself as a lurker(!): I have enjoyed following the various discussion threads on a daily basis. The collaboration of people helping each other with common issues and the willingness to share expertise etc makes ORACLE-L a powerful resource. Many thanks. --- nigel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nigel Cemm INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).