Skip to Main Content
  • Questions
  • DB context is disappearing after a DB restart

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Dennis.

Asked: February 03, 2017 - 3:42 pm UTC

Last updated: February 03, 2017 - 8:30 pm UTC

Version: 11.2.0.3

Viewed 1000+ times

You Asked

I have DB user "test" that has create any context privilege.

I create a context using the command below

CREATE OR REPLACE CONTEXT apex_ctx using kvs_apex_ctx accessed globally

I created the package kvs_apex_ctx and context works fine.

If my DB restarted the context is gone and I have to manually run the create context again.

I use select * from dba_context and its not there.

I execute the create context and I can see it again.

I know its supposed to be consistent but its not, is there any other way to check why its not being save?

Thanks


and Connor said...

I'd like to see some output, ie, being

a) your create context command being created
b) shutdown/startup command output
c) a query showing your context has disappeared.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library