Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

Your Answer

 
discard

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.