| exclusive and restricted mode [message #60388] |
Wed, 04 February 2004 17:43  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
hi, can anyone pls explain in brief where r we going to use exclusive and restricted modes while opening a database?
and what are the privileges and roles needed to connect to database which is in the above two modes?
thanx in advance
sam.
|
|
|
|
| Re: exclusive and restricted mode [message #60398 is a reply to message #60388] |
Thu, 05 February 2004 14:55  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
exclusive enables the instance to mount the database 'exclusively' in a parallel server environment. this is the default mode in a single instance config. I believe this has been obsoleted.
restrict mode allows the database to be accessed only by users with restricted session privileges(dba role has this privilege).
thiru@9.2.0:SQL>shutdown abort;
ORACLE instance shut down.
thiru@9.2.0:SQL>startup <b>restrict</b>
ORACLE instance started.
Total System Global Area 131144544 bytes
Fixed Size 453472 bytes
Variable Size 92274688 bytes
Database Buffers 37748736 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
thiru@9.2.0:SQL>connect scott/tiger
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Warning: You are no longer connected to ORACLE.
thiru@9.2.0:SQL>connect thiru/*****
Connected.
thiru@9.2.0:SQL>alter system disable restricted session;
System altered.
thiru@9.2.0:SQL>connect scott/tiger;
Connected.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
