HOW to open database in restrict mode


bash-3.2$ sqlplus "/ as sysdba";

SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 5 11:06:43 2016

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

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 2.0583E+10 bytes
Fixed Size 2168240 bytes
Variable Size 5167385168 bytes
Database Buffers 1.5368E+10 bytes
Redo Buffers 45907968 bytes
SQL> 
SQL> 
SQL> show parameter job

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
job_queue_processes
integer 1000
SQL> alter system set job_queue_processes=0 scope=both sid='*';

System altered.

SQL> show parameter AQ

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
aq_tm_processes
integer 1
SQL> 
SQL> 
SQL> alter system set aq_tm_processes=0 scope=both sid='*';

System altered.

SQL> 
SQL> startup force restrict;
ORACLE instance started.

Total System Global Area 2.0583E+10 bytes
Fixed Size 2168240 bytes
Variable Size 5167385168 bytes
Database Buffers 1.5368E+10 bytes
Redo Buffers 45907968 bytes
Database mounted.
Database opened.
SQL> 
SQL> 
SQL> show parameter service

NAME
------------------------------------
TYPE VALUE
-------------------------------------------- ------------------------------
service_names
string ANARDB
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: