OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » check connection

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

check connection [message #131320]

Fri, 05 August 2005 05:55

chara
Messages: 81
Registered: April 2005
Location: th

Member

Dear anybody,

If i have tmpdb database and i want to know
the most of user that can login to tmpdb.
How ? and Could i change the amount of user ?

Thanks for advance
Chara

Report message to a moderator

Re: check connection [message #131326 is a reply to message #131320]

Fri, 05 August 2005 06:47

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

hi,

u can view existing users by logging in as sys and run

SQL> select username from dba_users;

U can do everything -- u can add a user, drop a user.

Exactly what do u want to do? pls make it more clear.

Report message to a moderator

Re: check connection [message #131347 is a reply to message #131320]

Fri, 05 August 2005 08:01

dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore

Member

Hi

If you want to restrict user sessions to one only then the answer is:

alter system set resource_limit=true

create profile sessrestrict limit
sessions_per_user 1;

alter user <username1> profile sessrestrict;

now try to login from one terminal: conn <username1>/<password>
and from second terminal : conn <username1>/<password>

while logging into the second terminal it will not allow u

Regards,
Praveen

Report message to a moderator

Re: check connection [message #131517 is a reply to message #131320]

Mon, 08 August 2005 00:15

chara
Messages: 81
Registered: April 2005
Location: th

Member

Hello,

I 'm sorry my question migth be not clear.
I mean i want to know where i can set the number of
user that can login to my tmpdb ?

Regards,

Chara

Report message to a moderator

Re: check connection [message #131518 is a reply to message #131517]

Mon, 08 August 2005 00:22

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Hi Chara,

The scenario is still not clear. Pls explain what exactly u want to do. What is ur requirement so that we give u a specific answer.

rgrds,
tarun

Report message to a moderator

Re: check connection [message #131530 is a reply to message #131518]

Mon, 08 August 2005 01:53

chara
Messages: 81
Registered: April 2005
Location: th

Member

Hello,

Opp !... Sorry again .

I want to know how many the limit of users can login to tmpdb ?
Where i can see? and Can i change ?

Regards,

Chara

Report message to a moderator

Re: check connection [message #131626 is a reply to message #131530]

Mon, 08 August 2005 12:44

Barbara Boehmer
Messages: 9102
Registered: November 2002
Location: California, USA

Senior Member

scott@ORA92> show parameter license_max_users

NAME TYPE VALUE
------------------------------------ ----------- -----------
license_max_users integer 0
scott@ORA92> ALTER SYSTEM SET LICENSE_MAX_USERS = 200;

System altered.

scott@ORA92>
scott@ORA92> show parameter license_max_users

NAME TYPE VALUE
------------------------------------ ----------- -----------
license_max_users integer 200

Report message to a moderator

Re: check connection [message #131668 is a reply to message #131626]

Mon, 08 August 2005 20:58

chara
Messages: 81
Registered: April 2005
Location: th

Member

Thanks a lot

Report message to a moderator

Previous Topic:	changing date on oracle db...?
Next Topic:	Error in connecting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 08:59:24 CST 2025