RE: Oracle 9i refuses to allow client connection -- I need
v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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
Re: RE: Oracle 9i refuses to allow client connection -- I need
the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 08:11:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 9i refuses to allow client connection -- I need v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538
RE: RE: Oracle 9i refuses to allow client connection -- I need
Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Oracle 9i refuses to allow client connection -- I need the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 08:11:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 9i refuses to allow client connection -- I need v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information
RE: RE: Oracle 9i refuses to allow client connection -- I need
otn.oracle.com its where oracle keeps all its documents and downloads etc. www.oracle.com is the marketing. you have to register but its free. go to that site. On the left will be a link for documentation. Go to the 'database' documentaiton. Both 8i and 9i are there. Click books. There is a 'book' on ORacle for Windows'. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 10:09:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: Oracle 9i refuses to allow client connection -- I need Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Oracle 9i refuses to allow client connection -- I need the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 08:11:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 9i refuses to allow client connection -- I need v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server
RE: RE: Oracle 9i refuses to allow client connection -- I need
Stephen Go to http://technet.oracle.com and register -- it's free. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Oracle 9i refuses to allow client connection -- I need the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 08:11:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 9i refuses to allow client connection -- I need v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB
RE: RE: Oracle 9i refuses to allow client connection -- I need
OTN is shorthand for Oracle Technical Network technet.oracle.com --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Oracle 9i refuses to allow client connection -- I need the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 08:11:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 9i refuses to allow client connection -- I need v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem
RE: RE: Oracle 9i refuses to allow client connection -- I need
Stephen. OTN is the abreviation for Oracle Technology Network http://otn.oracle.com/. It is a source and startup point for documentation, softrare , news, and other Oracle related stuff. I would surf the site to see what is available for the Oracle applications you have and to locate the documentation that you might need. I would also suggest that you get a MetaLink account http://metalink.oracle.com. Metalink is the Oracle site where an Oracle answered forums exist, patches reside, cetrification is listed, ITAR's are created, etc. If you have an Oracle support contract you should have access to the MetaLink site without any problems. Ron [EMAIL PROTECTED] 07/28/03 10:09AM Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Oracle 9i refuses to allow client connection -- I need the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 08:11:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 9i refuses to allow client connection -- I need v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server
RE: RE: Oracle 9i refuses to allow client connection -- I need
Thanks! I'll start perusing the sites right away. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Oracle 9i refuses to allow client connection -- I need Stephen. OTN is the abbreviation for Oracle Technology Network http://otn.oracle.com/. It is a source and startup point for documentation, software , news, and other Oracle related stuff. I would surf the site to see what is available for the Oracle applications you have and to locate the documentation that you might need. I would also suggest that you get a MetaLink account http://metalink.oracle.com. Metalink is the Oracle site where an Oracle answered forums exist, patches reside, certifications is listed, ITAR's are created, etc. If you have an Oracle support contract you should have access to the MetaLink site without any problems. Ron [EMAIL PROTECTED] 07/28/03 10:09AM Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Oracle 9i refuses to allow client connection -- I need the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 08:11:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 9i refuses to allow client connection -- I need v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm
RE: Oracle 9i refuses to allow client connection -- I need
Stephen Technet (aka. otn) is good, but sometimes it helps to have a book help you get started. Consider picking up a copy of Oracle9i DBA 101. http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1059408389/sr=8 -1/ref=sr_8_1/002-8977984-5541669?v=glances=booksn=507846 Don't worry too much about Windows vs. Unix. There is very little with Oracle that is Windows or Unix specific. Most of the differences relate to file naming and starting/stopping the instance. Pretty much any of the books give you the syntax for each system where there is a difference. Actually, you are probably fortunate with your training being delayed for a few months. The class covers so much in a few days that if you are really new to Oracle it is hard to comprehend everything. By messing with it for a few months, the class will make a lot more sense. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 7:12 AM To: Multiple recipients of list ORACLE-L v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client
RE: Oracle 9i refuses to allow client connection -- I need some h
Title: Message What is the error message (if any) Can you connect thru SQL*Plus (/ as sysdba) -Original Message-From: Wolfe Stephen S GS-11 6 MDSS/SGSI [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 1:35 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle 9i refuses to allow client connection -- I need some help. I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974
Re: Oracle 9i refuses to allow client connection -- I need some help.
there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: Oracle 9i refuses to allow client connection -- I need
Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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).