Error 1031 Received Logging On To The Standby Insufficient Privileges
Contents |
ourselves. Always be positive and keep smiling..have a great day friends :) Source: heartbeat failed to connect to standby error is 1033. Internet March 05, 2013 Error 1031 received logging on to
Ping Arc2 Heartbeat Failed To Connect To Standby Error Is 1031
the standby ISSUE Error 1031 received logging on to the standby ORA-01031: insufficient privileges PING[ARC0]: Heartbeat v$pwd_file_users failed to connect to standby 'dgp'. Error is 1031. PRIMARY======= Primary database Alert log error:-------------------------------- Error 1031 received logging on to the standby ORA-01031: insufficient error 1034 received logging on to the standby privileges PING[ARC0]: Heartbeat failed to connect to standby 'dgp'. Error is 1031. Chech DR sync and see the difference. THREAD PR-ARCHIVED STBY-ARCHIVED STBY-APPLIED SHIPPING GAP(PR -> STBY) APPLIED GAP(STBY -> STBY) ------ ----------- ------------- ------------ ------------------------ ------------------------- set pages 999 lines 999 col MESSAGE for a100 select to_char(timestamp,'YYYY-MON-DD HH24:MI:SS')||' '||message||severity from gv$dataguard_status
Error 1033 Received Logging On To The Standby
where severity in ('Error','Fatal') order by timestamp; show parameter log_archive_dest_state_2; LISTNER VERIFICATION FROM PRIMATY DB ------------------------------------ select dest_id,status,error from v$archive_dest where dest_name='LOG_ARCHIVE_DEST_2'; FIND GAP -------- select thread#,low_sequence#,high_sequence# from gv$archive_log; ps -ef |grep tns lsnrctl status DR== DR database Alert log error: ---------------------------- Error 1031 received logging on to the standby set pages 999 lines 999 col MESSAGE for a100 select to_char(timestamp,'YYYY-MON-DD HH24:MI:SS')||' '||message||severity from gv$dataguard_status where severity in ('Error','Fatal') order by timestamp; select inst_id,process,status,thread#,sequence#,block#,blocks from gv$managed_standby; PROCESS STATUS ------- ------------ RFS IDLE RFS IDLE RFS IDLE MRP0 WAIT_FOR_LOG checking log transfer and apply ------------------------------- SELECT SEQUENCE#,FIRST_TIME,NEXT_TIME,APPLIED FROM gV$ARCHIVED_LOG ORDER BY SEQUENCE#; select count(*) from GV$ARCHIVED_LOG where applied='NO'; Redo transfer was not happening. When we checked in the v$managed_process data dictionary view, we could see that RFS was not starting. Here, ora-01031 usually appears when some sysdba session failes to authenticate Check that the primary and standby are using a password file and
Post #1 Advanced Member error 1017 received logging on to the standby Group: Members Posts: 229 Joined: 15-November 06 Member No.: 5,636 arch: fal archive failed. archiver continuing Hi, i am making a standby in a Oracle 10gR2 in Windows 2003 Server R1.I
Error 12154 Received Logging On To The Standby
am getting the following error in the alert of primary database:Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host*** 2008-09-14 20:33:04.359 60680 kcrr.cError 1031 received logging http://select-star-from.blogspot.com/2013/03/error-1031-received-logging-on-to.html on to the standbyError 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'ORCLSTBY'Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'ORCLSTBY'ORA-01031: insufficient privileges*** 2008-09-14 20:33:04.359 60680 kcrr.cPING[ARC0]: Heartbeat failed to connect to standby 'ORCLSTBY'. Error is 1031.*** 2008-09-14 20:33:04.359 58942 kcrr.ckcrrfail: dest:2 err:1031 force:0 blast:1kcrrwkx: nothing to do (end)*** 2008-09-14 20:34:04.406kcrrwkx: nothing http://dbaforums.org/oracle/index.php?showtopic=15677 to do (end)I can do tnsping and connect since primary to standby and of standby to primary.Too i see that my process of archiving in the standby is good:SQL> select process,status,thread#,sequence# from v$managed_standby;PROCESS STATUS THREAD# SEQUENCE#--------- ------------ ---------- ----------ARCH CONNECTED 0 0ARCH CONNECTED 0 0MRP0 WAIT_FOR_LOG 1 52I read in metalink that is for password file, but i have a passwordfile in each node and the password is the same that sys user.So i don't know where is the problem?.Regards. SteveC View Member Profile Sep 14 2008, 09:25 PM Post #2 Advanced Member Group: Members Posts: 2,836 Joined: 11-March 08 Member No.: 18,933 What about DB_ALLOWED_LOGON_VERSION? Francisco Riccio View Member Profile Sep 15 2008, 11:32 AM Post #3 Advanced Member Group: Members Posts: 229 Joined: 15-November 06 Member No.: 5,636 QUOTE (SteveC @ Sep 14 2008, 09:26 PM) What about DB_ALLOWED_LOGON_VERSION?It is set up in the sqlnet.ora in
Testing Data Guard [message #558524] Sat, 23 June 2012 09:38 patb Messages: 4Registered: June 2012 Junior Member I have http://www.orafaq.com/forum/t/182259/ been trying to setup a test data guard environment to become more familiar with it, but so far I have been unsuccessful. I have been using the guide located at docs.oracle.com/cd/B19306_01/server.102/b14239/create_ps.htm for the steps I am following. Right now, I'm just trying to get a non-production physical standby configured and working. I have received logging kept kind of a running summary of the commands I have run so far, and would like to paste them below and see if I am missing anything obvious. If necessary, I can post a pfile from both servers to see if maybe I am missing something in the parameters. I have verified that received logging on both instances can be connected to via sqlplus from the opposite server. Any help or guidance is appreciated. -------- ALTER DATABASE FORCE LOGGING; ALTER DATABASE ADD STANDBY LOGFILE GROUP 10 ('c:\app\pbbesadmin\oradata\primary\standby01.log') SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE GROUP 11 ('c:\app\pbbesadmin\oradata\primary\standby02.log') SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE GROUP 12 ('c:\app\pbbesadmin\oradata\primary\standby03.log') SIZE 50M; ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,standby)'; ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=c:\app\pbbesadmin\oradata\primary\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary'; ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=standby LGWR ASYNC VALID_FOR=(ONlINE_LOGFILES,PRIMARY_ROLES) DB_UNIQUE_NAME=standby'; ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%r.arc' SCOPE=SPFILE; ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=7; ALTER SYSTEM SET FAL_SERVER=standby; ALTER SYSTEM SET FAL_CLIENT=primary; ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO; SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN; Backup the database: rman target primary BACKUP DATABASE PLUS ARCHIVELOG; SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'c:\download\backup\standby.ctl'; ALTER DATABASE OPEN; create pfile='c:\download\backup\initprimary.ora' from spfile; On Standby: Create instance Configure net service names and tested from both servers modify pfile from primary to suit the standby (if you set the convert params, do