Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-16191: Primary log shipping client not logged on standby

kkrm333Oct 19 2011 — edited Oct 20 2011

Hi,

I have configured a new standby database.
But getting below error.

ORA-01017: invalid username/password; logon denied
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'prdr'. Error is 16191.

Thanks,

sb92075

kkrm333 wrote:
Hi,

I have configured a new standby database.
But getting below error.

ORA-01017: invalid username/password; logon denied
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'prdr'. Error is 16191.

Thanks,

OS name & version?

copy external password file from Primary to Standby

kkrm333

I copied the password file to standby. Still same error message.

My db is running on 11g. OS is OEL 5.
sec_case_sensitive_logon is set to FALSE.

Thanks,

sb92075

kkrm333 wrote:
I copied the password file to standby. Still same error message.

My db is running on 11g. OS is OEL 5.
sec_case_sensitive_logon is set to FALSE.

Thanks,

what clues exist in both Primary & Standby "alert_SID.log" file

when was last time archived log file were successfully shipped & applied?
What has changed since then?

kkrm333

This is a new standby. I used the rman backup of prod to create stndby.
After that no logs were applied.

Error in standby alert log
===============

FAL[client, USER]: Error 16191 connecting to prod for fetching gap sequence
Errors in file /ap01/u01/oracle/proddb/diag/rdbms/prdr/prdr/trace/prdr_pr00_898.trc:
ORA-16191: Primary log shipping client not logged on standby
Errors in file /ap01/u01/oracle/proddb/diag/rdbms/prdr/prdr/trace/prdr_pr00_898.trc:
ORA-16191: Primary log shipping client not logged on standby
Wed Oct 19 06:04:23 2011
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 1211599-1211604
DBID 58714568 branch 646876238
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.

Error in Primary Database alert log
=====================

Errors in file /ap01/u01/oracle/proddb/diag/rdbms/prod/prod/trace/prod_arc1_6044.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'prdr'. Error is 16191.
Wed Oct 19 21:13:55 2011
Errors in file /ap01/u01/oracle/proddb/diag/rdbms/prod/prod/trace/prod_arc1_6044.trc:
ORA-01017: invalid username/password; logon denied
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
Errors in file /ap01/u01/oracle/proddb/diag/rdbms/prod/prod/trace/prod_arc1_6044.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC1]: Heartbeat failed to connect to standby 'prdr'. Error is 16191.

Thanks,

CKPT

post from standby:-

SQL> show parameter remote_login_passwordfile

I copied the password file to standby. Still same error message.

You have copied thats fine, Did you renamed that file?

it should be with SID name of standby, name as orapw$ORALCE_SID

Edited by: CKPT on Oct 20, 2011 6:52 AM

kkrm333

From standby

SQL> show parameter remote_login_passwordfile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>

CKPT

You have copied thats fine, Did you renamed that file?

it should be with SID name of standby, name as orapw$ORALCE_SID

if you renamed, then i suggest to create a new password file in primary and then copy&rename it.

Edited by: CKPT on Oct 20, 2011 6:54 AM

sb92075

It works when done correctly.

can you successfully using sqlplus log into the Standby from the Primary as SYS?

kkrm333

No..

sqlplus sys/dbu1@prdr as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 19 21:39:44 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Please give me detailed steps to create password file.

I did like this

From primary: orapwd file=orapwprod

Copied it to stndby and renamed as orapwprdr

Thanks,

sb92075

can you successfully using sqlplus log into the Primary via SQL*Net from the Primary as SYS?

sqlplus sys/dbu1@prod as sysdba

kkrm333

No.

sqlplus sys/dbu1@prod as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 19 21:54:54 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

============================

sqlplus sys/dbu1 as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 19 21:55:12 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

================================================
After creating password file do i need to restart primary?

Thanks,

sb92075

post results from following OS command on primary

env | sort

bcm@bcm-laptop:~$ orapwd
Usage: orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n> nosysdba=<y/n>

  where
    file - name of password file (required),
    password - password for SYS will be prompted if not specified at command line,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    ignorecase - passwords are case-insensitive (optional),
    nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).
    
  There must be no spaces around the equal-to (=) character.

kkrm333

env|sort
ADJREOPTS=-Xms128M -Xmx512M
ADJVAPRG=/ap01/u01/oracle/proddb/11.2/jdk/bin/java
ADPERLPRG=/usr/bin/perl
CONTEXT_FILE=/ap01/u01/oracle/proddb/11.2/appsutil/prod_dbclsr01.xml
CONTEXT_NAME=prod_dbclsr01
CVS_RSH=ssh
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/oraprod
HOSTNAME=sflxdb01.donerus.com
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/ap01/u01/oracle/proddb/11.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/ap01/u01/oracle/proddb/11.2/ctx/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LIBPATH=/ap01/u01/oracle/proddb/11.2/lib:/usr/X11R6/lib:/usr/openwin/lib:/ap01/u01/oracle/proddb/11.2/ctx/lib
LINK_CNTRL=
LOGNAME=oraprod
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oraprod
NLS_DATE_FORMAT=DD-MON-RR
NLS_LANG=American_America.UTF8
NLS_NUMERIC_CHARACTERS=.,
NLS_SORT=binary
ORACLE_HOME=/ap01/u01/oracle/proddb/11.2
ORACLE_SID=prod
ORA_NLS10=/ap01/u01/oracle/proddb/11.2/nls/data/9idata
ORA_TZFILE=
PATH=/usr/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oraprod/bin:/ap01/u01/oracle/proddb/11.2/bin:/ap01/u01/oracle/proddb/11.2/OPatch:.:/ap01/u01/oracle/proddb/11.2/OPatch
PERL5LIB=/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi:/usr/lib/perl5/site_perl/5.8.8:/usr/lib/perl5/site_perl:/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi:/usr/lib/perl5/vendor_perl/5.8.8:/usr/lib/perl5/vendor_perl:/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi:/usr/lib/perl5/5.8.8:.:/ap01/u01/oracle/proddb/11.2/appsutil/perl:/ap01/u01/oracle/proddb/11.2/appsutil/perl
PWD=/home/oraprod
SHELL=/bin/bash
SHLIB_PATH=/ap01/u01/oracle/proddb/11.2/lib:/usr/lib:/ap01/u01/oracle/proddb/11.2/ctx/lib
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=xterm
TNS_ADMIN=/ap01/u01/oracle/proddb/11.2/network/admin/prod_dbclsr01
USER=oraprod
_=/usr/bin/env

CKPT

Hi,

What is the value in SQLNET.AUTHENTICATION_SERVICES? in sqlnet.ora

sb92075

orapwd file=orapwprod entries=8 force=y

issue command above & enter password when prompted

It works for me

oracle@bcm-laptop:~$ sqlplus sys/Ate2much@v112 as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 19 19:22:47 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

kkrm333

No value specified in sqlnet.ora.

kkrm333

Not working for me.

Please see below output.

orapwd file=orapwprod entries=8 force=y

Enter password for SYS:
$ sqlplus sys/dbu1@prod as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 19 22:28:26 2011

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Thanks,

CKPT

orapwd file=orapwprod entries=8 force=y

where is the password?

orapwd file=orapwprod entries=8 force=y password=******

sb92075

UNIX: Checklist for Resolving Connect AS SYSDBA Issues NOTE: 69642.1.

kkrm333

By mistake i was creating the password file on ORACLE_HOME location.
After moving it to ORACLE_HOME/dbs the issue was solved.

Thanks,

1 - 20

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2011

Added on Oct 19 2011

#general-database-discussions

20 comments

19,498 views

Oracle Database Discussions

ORA-16191: Primary log shipping client not logged on standby

Comments

Post Details