Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 02-02-2010
Member
 
Join Date: Jan 2010
Posts: 49
Concepts and Effect of O7_DICTIONARY_ACCESSIBILITY

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 !!!!
Reply With Quote
  #2  
Old 02-02-2010
Member
 
Join Date: Oct 2005
Posts: 2,389
Concepts and Effect of O7_DICTIONARY_ACCESSIBILITY

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.

Last edited by Reegan : 02-02-2010 at 08:11 PM.
Reply With Quote
  #3  
Old 02-02-2010
Member
 
Join Date: May 2008
Posts: 2,383
Effect on database schema after setting FALSE parameter

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.
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
  #4  
Old 02-02-2010
Member
 
Join Date: Feb 2008
Posts: 1,848
Effect after setting TRUE parameter

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 :

Code:
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
Reply With Quote
  #5  
Old 02-02-2010
Member
 
Join Date: Jan 2008
Posts: 1,515
No longer connected to ORACLE error

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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Concepts and Effect of O7_DICTIONARY_ACCESSIBILITY"
Thread Thread Starter Forum Replies Last Post
Operating Systems concepts? piyush123 Operating Systems 1 20-04-2011 03:24 PM
Some Mockups and Concepts of iSlate Jensen Ackles Portable Devices 6 27-05-2010 02:16 PM
What does OOPS concepts comprises? abigial_i Software Development 3 08-12-2009 09:24 AM
Concepts and types of networks Jakub Networking & Security 1 19-01-2009 11:06 AM
OOPS Concepts suneel_g Software Development 3 22-12-2008 12:42 PM


All times are GMT +5.5. The time now is 07:39 PM.