Take the 2-minute tour ×

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
add comment

1 Answer

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... –  ndefontenay 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 –  ndefontenay Sep 11 '12 at 15:06
add comment

Your Answer


