startup restrict

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup restrict;
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 2062264 bytes
Variable Size 264243272 bytes
Database Buffers 801112064 bytes
Redo Buffers 6324224 bytes
Database mounted.
Database opened.


SQL> alter user orara identified by sds123;

User altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64 bit Production
With the Partitioning, OLAP and Data Mining options
radev01:*:VCDRT2:/software/orara> sqlplus orara@vcdrt2

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 14 10:38:20 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64 bit Production
With the Partitioning, OLAP and Data Mining options


radev01:*:VCDRT2:/software/orara> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 14 10:41:15 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> revoke dba from orara;

Revoke succeeded.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64 bit Production
With the Partitioning, OLAP and Data Mining options
radev01:*:VCDRT2:/software/orara> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 14 10:41:53 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> show user;
USER is "SYS"
SQL> alter system enable restricted session;

System altered.

liqy@mp4is_liqy ~
$ sqlplus orara/sds123@VCDRT2

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 4月 14 10:43:23 2008

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

ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege


Enter user-name:

SQL> alter system disable restricted session;

System altered.

$ sqlplus orara/sds123@VCDRT2

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 4月 14 10:43:38 2008

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> exit