Hot answers tagged dataguard
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?
There aren't any special considerations that need to be taken into account when setting up a RAC->No RAC Primary->Standby configuration. In fact, there's a White Paper written by Oracle which explains the setup. The Oracle documentation is here.
It is recommended to leave exactly the same path to database on standby (the same directory tree). I think you've changed it, so you would need to rename everything that is stored in the init.ora and controlfile. In the latter, Oracle records logfile names and datafile names. This is nicely covered here ...
Only top voted, non community-wiki answers of a minimum length are eligible