RE: Need to Log on 2000 users
Hi gaurav and fellow DBAs, I ran into the same problem once on a Sun Solaris 5.9 box. The lines on your sqlnet.ora file have a great deal of impact on how authentication works. remote_os_authent=true will allow people remote users to connect to your instance using the credentials on the machine they are logged in. This means that OS credentials used are niether Oracle's nor the local OS's that your insance resides on. I don't know about you but I 'goose bumps' at the thought of allowing users to user THEIR OS authentication credentials. If you are comfortable with they way your authentication works, omit the following lines: If I were you, I would take the SQLNET.AUTHENTICATION_SERVICES = (none) out of my sqlnet.ora file and change your remote_os_authent = false on my ora init instance file. An excelent way to troubleshoot the sqlnet.ora file is to create a copy of it as a backup and try taking out a line at a time. Restart your ora instance every time you delete one of your lines in the file and test your login. Another pointer I think you are missing grant connect and grant resource on your grant statement. Take care, Julio -Original Message- Sent: Monday, June 02, 2003 7:55 AM To: Multiple recipients of list ORACLE-L Hello list , I tried the same thing but to log on an OS user I have to set remote_os_authent=true in parameter file and SQLNET.AUTHENTICATION_SERVICES = (none) in sqlnet.ora Why would I need to set remote_os_authent ? shouldn't it be left at its default value of 'false' ? otherwise wouldn't it be a security problem. But I cannot log in my os users till I set remote_os_authent=true Other details : Oracle 9.2.0.1.0 enterprise edition on win32 OS_AUTHENT_PREFIX='' create user administrator identified externally default tablespace users temporary tablespace temp quota unlimited on users ; grant create session, create table to administrator; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 30, 2003 19:54 Munish Bajaj, If you want your OS users to log into your database, you need to set the OS_AUTHENT_PREFIX parameter in the init ora file for your instance to a string of your like. Oracle's default is OPS$. If your OS user account is JOE. Oracle looks at this account as OPS$JOE. The account is tacked on the OS_AUTHENT_PREFIX. Then, you need to create the ORACLE user account that will correspond to your OS account and make it externally identified. As sys do the following: SQL create user OPS$JOE externally identified; Bear in mind that if you have and OS group called DBA, any member of that group will be able to connect as sysdba, so you need to be careful with the people you put in that group ;-- ) Regards, Julio -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: QuijadaReina, Julio C 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: Need to Log on 2000 users
Hello list , I tried the same thing but to log on an OS user I have to set remote_os_authent=true in parameter file and SQLNET.AUTHENTICATION_SERVICES = (none) in sqlnet.ora Why would I need to set remote_os_authent ? shouldn't it be left at its default value of 'false' ? otherwise wouldn't it be a security problem. But I cannot log in my os users till I set remote_os_authent=true Other details : Oracle 9.2.0.1.0 enterprise edition on win32 OS_AUTHENT_PREFIX='' create user administrator identified externally default tablespace users temporary tablespace temp quota unlimited on users ; grant create session, create table to administrator; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 30, 2003 19:54 Munish Bajaj, If you want your OS users to log into your database, you need to set the OS_AUTHENT_PREFIX parameter in the init ora file for your instance to a string of your like. Oracle's default is OPS$. If your OS user account is JOE. Oracle looks at this account as OPS$JOE. The account is tacked on the OS_AUTHENT_PREFIX. Then, you need to create the ORACLE user account that will correspond to your OS account and make it externally identified. As sys do the following: SQL create user OPS$JOE externally identified; Bear in mind that if you have and OS group called DBA, any member of that group will be able to connect as sysdba, so you need to be careful with the people you put in that group ;-- ) Regards, Julio -Original Message- Sent: Friday, May 30, 2003 2:05 AM To: Multiple recipients of list ORACLE-L Hi Gurus, I am facing a problem. I need to log on 2000 users to my database via dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced server. Please guide me as to what all parameters need to be tuned to achieve the same. The Server is a single CPU server with 3G RAM. I need just to logon 2000 users. This is a load test that I need to perform. Thanks to all Regards Munish Bajaj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Need to Log on 2000 users
Munish Bajaj, If you want your OS users to log into your database, you need to set the OS_AUTHENT_PREFIX parameter in the init ora file for your instance to a string of your like. Oracles default is OPS$. If your OS user account is JOE. Oracle looks at this account as OPS$JOE. The account is tacked on the OS_AUTHENT_PREFIX. Then, you need to create the ORACLE user account that will correspond to your OS account and make it externally identified. As sys do the following: SQL create user OPS$JOE externally identified; Bear in mind that if you have and OS group called DBA, any member of that group will be able to connect as sysdba, so you need to be careful with the people you put in that group ;-- ) Regards, Julio -Original Message- From: Munish Bajaj [mailto:[EMAIL PROTECTED]] Sent: Friday, May 30, 2003 2:05 AM To: Multiple recipients of list ORACLE-L Subject: Need to Log on 2000 users Hi Gurus, I am facing a problem. I need to log on 2000 users to my database via dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced server. Please guide me as to what all parameters need to be tuned to achieve the same. The Server is a single CPU server with 3G RAM. I need just to logon 2000 users. This is a load test that I need to perform. Thanks to all Regards Munish Bajaj
Re: Need to Log on 2000 users
Jeremiah, Where do you get 128Gb? For 2000 users that is ~65M per user, which seems like an excessive estimate. While I probably wouldn't want to run 2k users on a single Windows server, I think you could do it for test purposes. Use orastack to reduce the memory per thread to 500k, set small sort_area_size, etc. Don't see why not. Jared On Friday 30 May 2003 02:14, Jeremiah Wilton wrote: You mean 2000 concurrent sessions? Why do you need to use dedicated server? Normally, you would accomplish this with Shared Server. You will need 128Gb of memory for the PGAs alone. Or you can use swap, but get ready to wait. Even that will probably be so slow that the connections may time out, or background thread IPC will time out, bringing the instance down. This seems like a silly exercise. Whose idea is it? Good luck with all that -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Munish Bajaj wrote: Hi Gurus, I am facing a problem. I need to log on 2000 users to my database via dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced server. Please guide me as to what all parameters need to be tuned to achieve the same. The Server is a single CPU server with 3G RAM. I need just to logon 2000 users. This is a load test that I need to perform. Thanks to all Regards Munish Bajaj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Need to Log on 2000 users
As well as using orastack, go a few steps further and tune the SGA to buggery (make it lean but keen) and set as high a pga_aggregate_target as possible and you might make it (depending on what the 2000 users are doing and depending on how many of them are doing what they're doing concurrently). As previously suggested, shared servers could be a goer but if dedicated is a must, consider the above. Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, May 31, 2003 12:54 AM Jeremiah, Where do you get 128Gb? For 2000 users that is ~65M per user, which seems like an excessive estimate. While I probably wouldn't want to run 2k users on a single Windows server, I think you could do it for test purposes. Use orastack to reduce the memory per thread to 500k, set small sort_area_size, etc. Don't see why not. Jared On Friday 30 May 2003 02:14, Jeremiah Wilton wrote: You mean 2000 concurrent sessions? Why do you need to use dedicated server? Normally, you would accomplish this with Shared Server. You will need 128Gb of memory for the PGAs alone. Or you can use swap, but get ready to wait. Even that will probably be so slow that the connections may time out, or background thread IPC will time out, bringing the instance down. This seems like a silly exercise. Whose idea is it? Good luck with all that -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Munish Bajaj wrote: Hi Gurus, I am facing a problem. I need to log on 2000 users to my database via dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced server. Please guide me as to what all parameters need to be tuned to achieve the same. The Server is a single CPU server with 3G RAM. I need just to logon 2000 users. This is a load test that I need to perform. Thanks to all Regards Munish Bajaj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Richard Foote 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: Need to Log on 2000 users
Sorry Munish, I misinterpreted your question. But Jared's suggestion is a good one. You can use orastack to set parameters to maximize memory use for your test database. And too, 128Gb sounds like a pretty large number for 2000 users! Julio -Original Message- Sent: Friday, May 30, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Jeremiah, Where do you get 128Gb? For 2000 users that is ~65M per user, which seems like an excessive estimate. While I probably wouldn't want to run 2k users on a single Windows server, I think you could do it for test purposes. Use orastack to reduce the memory per thread to 500k, set small sort_area_size, etc. Don't see why not. Jared On Friday 30 May 2003 02:14, Jeremiah Wilton wrote: You mean 2000 concurrent sessions? Why do you need to use dedicated server? Normally, you would accomplish this with Shared Server. You will need 128Gb of memory for the PGAs alone. Or you can use swap, but get ready to wait. Even that will probably be so slow that the connections may time out, or background thread IPC will time out, bringing the instance down. This seems like a silly exercise. Whose idea is it? Good luck with all that -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Munish Bajaj wrote: Hi Gurus, I am facing a problem. I need to log on 2000 users to my database via dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced server. Please guide me as to what all parameters need to be tuned to achieve the same. The Server is a single CPU server with 3G RAM. I need just to logon 2000 users. This is a load test that I need to perform. Thanks to all Regards Munish Bajaj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: QuijadaReina, Julio C 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: Need to Log on 2000 users
Munish - Don't forget to change the init.ora parameter PROCESSES greater than 2000. I didn't see where anyone mentioned that. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 30, 2003 4:15 AM To: Multiple recipients of list ORACLE-L You mean 2000 concurrent sessions? Why do you need to use dedicated server? Normally, you would accomplish this with Shared Server. You will need 128Gb of memory for the PGAs alone. Or you can use swap, but get ready to wait. Even that will probably be so slow that the connections may time out, or background thread IPC will time out, bringing the instance down. This seems like a silly exercise. Whose idea is it? Good luck with all that -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Munish Bajaj wrote: Hi Gurus, I am facing a problem. I need to log on 2000 users to my database via dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced server. Please guide me as to what all parameters need to be tuned to achieve the same. The Server is a single CPU server with 3G RAM. I need just to logon 2000 users. This is a load test that I need to perform. Thanks to all Regards Munish Bajaj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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: DENNIS WILLIAMS 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: Need to Log on 2000 users
D'oh! I was thinking 8i. My mind hasn't really gotten into 9i mode yet. pga_aggregate_target is indeed the way to allocate PGA memory. Jared Richard Foote [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/30/2003 08:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Need to Log on 2000 users As well as using orastack, go a few steps further and tune the SGA to buggery (make it lean but keen) and set as high a pga_aggregate_target as possible and you might make it (depending on what the 2000 users are doing and depending on how many of them are doing what they're doing concurrently). As previously suggested, shared servers could be a goer but if dedicated is a must, consider the above. Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, May 31, 2003 12:54 AM Jeremiah, Where do you get 128Gb? For 2000 users that is ~65M per user, which seems like an excessive estimate. While I probably wouldn't want to run 2k users on a single Windows server, I think you could do it for test purposes. Use orastack to reduce the memory per thread to 500k, set small sort_area_size, etc. Don't see why not. Jared On Friday 30 May 2003 02:14, Jeremiah Wilton wrote: You mean 2000 concurrent sessions? Why do you need to use dedicated server? Normally, you would accomplish this with Shared Server. You will need 128Gb of memory for the PGAs alone. Or you can use swap, but get ready to wait. Even that will probably be so slow that the connections may time out, or background thread IPC will time out, bringing the instance down. This seems like a silly exercise. Whose idea is it? Good luck with all that -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Munish Bajaj wrote: Hi Gurus, I am facing a problem. I need to log on 2000 users to my database via dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced server. Please guide me as to what all parameters need to be tuned to achieve the same. The Server is a single CPU server with 3G RAM. I need just to logon 2000 users. This is a load test that I need to perform. Thanks to all Regards Munish Bajaj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Richard Foote 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: 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: Need to Log on 2000 users
You mean 2000 concurrent sessions? Why do you need to use dedicated server? Normally, you would accomplish this with Shared Server. You will need 128Gb of memory for the PGAs alone. Or you can use swap, but get ready to wait. Even that will probably be so slow that the connections may time out, or background thread IPC will time out, bringing the instance down. This seems like a silly exercise. Whose idea is it? Good luck with all that -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 29 May 2003, Munish Bajaj wrote: Hi Gurus, I am facing a problem. I need to log on 2000 users to my database via dedicated server connection on Oracle 9iR2 running on Windows 2000 Advanced server. Please guide me as to what all parameters need to be tuned to achieve the same. The Server is a single CPU server with 3G RAM. I need just to logon 2000 users. This is a load test that I need to perform. Thanks to all Regards Munish Bajaj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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).