Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I get this error from the database when I run the query:

select status, error from v$archive_dest where dest_id=2;

It's a dataguard environment. I have never seen this problem before.

I'm not quite sure what this means or how it can be fixed.

What is generally the cause of this error?

share|improve this question
up vote 2 down vote accepted

Try adding (SERVICE=Dedicated) to your TNS entry on the client computer that you are using and then run your query again.

There could be other causes but this is the most common: you are trying to access data using a shared connection when a dedicated connection is required.

Edit: Are there any other log or trace file entries when this error happens?

share|improve this answer
Thanks. I was trying to find out what in this DG environment is making this happen but it seems to be oracle's internal sauce. The weird part is our install is very standard. Same everywhere and yet this time it decides to show this... – Nicolas de Fontenay Jul 16 '12 at 16:51
You didn't mention on which release you are? – steve Jul 19 '12 at 6:53
it's release – Nicolas de Fontenay Sep 11 '12 at 15:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.