High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Archive log files could not send to standby database sevrer

Dear Oracle,

After upgrde Oracle 11.2.0.3 on primary DB server and physical sdandby DB server, I re-configuration my dataguard.

My problems:
1. Archive log files could not send to standby database sevrer
2. on primary database,
   sys user as sysdba
   sqlplus> select status, error from v_archive_dest where dest_id=2;
   Error: ora-01030 insuffient privileges

3. sqlplus>conn sys/sys_pwd@my_stdDB as sysdba
   ERROR:
   ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
4. on primary database server
   DOS> sqlplus sys/sys_pwd@my_stdDB as sysdba
   I can get in my standby database
5. Oracle alert log on primary database

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center