Concepts and Effect of O7_DICTIONARY_ACCESSIBILITY

[Lachlann]

Hello guys !

I am having a problem regrading database management when I am going perform some operation on database, it occur some error like " You are no longer connected to ORACLE " and operation is being damaged due to this error.Which type of error is this ? Is it from instance level,parameter setting or any physical configuration changes error.

Your help would be appreciated !!!!

[Reegan]

O7_DICTIONARY_ACCESSIBILITY:

The O7_DICTIONARY_ACCESSIBILITY controls on the system privileges. It contains some components which is described below:

Parameter type- Boolean
Default value- false
Modifiable- No
Range of values- true | false

It is configured with the dynamic parameter which is dependent no configured Boolean values.It restrict the sys schema to when the parameter is set to false.

[opaper]

Make sure your database is running with O7_DICTIONARY_ACCESSIBILITY parameter value with FALSE using

SQL> show parameter O7_

If it is already set with FALSE value, you need to enter the next command to see the effect on sys schema.

SQL> conn sys/sys

It will through some error like
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
Warning: You are no longer connected to ORACLE.

[MindSpace]

If you configured the O7_DICTIONARY_ACCESSIBILITY parameter as a TRUE value. then you can log in into sys schema of database.

To change the value of O7_DICTIONARY_ACCESSIBILITY parameter to false, do the following :

SQL> conn sys/sys as sysdba

SQL> Alter system set O7_dictionary_accessibility=TRUE scope=spfile;

SQL> Startup 

SQL> conn sys/sys

The above statement would be execute successfully and you can access sys schema not sysdba schema

[Modifier]

You are getting error when you fire up any command to access the database. As a DBA when you export your database and after that you make a connection with database using name of any schema.

You get some error,Just make sure your database it properly started . After that it occur error, check the O7_DICTIONARY_ACCESSIBILITY parameter value to TRUE.