restringir bases de datos 0racle

conectarse como as sysdba

SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER SYSTEM ENABLE RESTRICTED SESSION

Perhaps should:
alter system set job_queue_processes=0
alter system set aq_tm_processes=0
ALTER DATABASE OPEN

el listener marca asi cuando esta restringindo

Instance "xxx", status RESTRICTED, has 1 handler(s) for this service...

Service "desa01XDB" has 1 instance(s).

Instance "xxx", status RESTRICTED, has 1 handler(s) for this service...

abrir nuevamente base de datos

oracle@server:~$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 20 11:38:43 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Release 11.2.0.1.0 - Production

SQL> SHUTDOWN IMMEDIATE

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> STARTUP MOUNT

ORACLE instance started.

Total System Global Area 263639040 bytes

Fixed Size 1335892 bytes

Variable Size 213913004 bytes

Database Buffers 41943040 bytes

Redo Buffers 6447104 bytes

Database mounted.

SQL> alter system disable restricted session;

System altered.

SQL> select logins from v$instance;

LOGINS

----------

ALLOWED

SQL> ALTER DATABASE OPEN ;

Database altered.