RE: Need to Log on 2000 users

Sat, 31 May 2003 00:05:14 -0700

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-----
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

Reply via email to