viernes, 20 de enero de 2012

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.