Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Need to Log on 2000 users

RE: Need to Log on 2000 users

From: QuijadaReina, Julio C <>
Date: Fri, 30 May 2003 06:24:40 -0800
Message-ID: <>

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,
-----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
Munish Bajaj


Please see the official ORACLE-L FAQ:

Author: QuijadaReina, Julio C

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message to: (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). Received on Fri May 30 2003 - 09:24:40 CDT

Original text of this message