Standby Database ORA16191 Error



The below is what is displayed in the alert log:

 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

 if you see this message in alert log oracle primary database,

 something is wrong,

 this message appears if you change sys password on a any node.

 Solution 1: Copy orapwd(SID).ora file to your standby database location ( oracle_home>database)

 Solution 2: use orapwd ,
orapwd file=$ORACLE_HOME/dbs/orapwSID password=newpassword;

Comments

Post a Comment

Popular posts from this blog

Hana XS Engine Troubleshooting

Overview:  HANA 2.0 is having XSA as base for many application like HANA cockpit, WEB IDE, Big Data Hub to name a few. You are lucky if you get it through for installation but sometimes you are stuck with few issues which you keep trying to solve , you don find solution. This Blog identifies and help you solve few of them. Getting a guide is very easy. But troubleshooting in real world might make your head spin. So sharing my experience. XX will represent the instance no. used in this blog. Error:  Adding role ‘xs_worker’ failed: Check /var/tmp latest update folder and it will mention the file name which contains more details. It should be with name like hdbmodify_addlocalroles.log. and Reason :  FAIL: process hdbxscontroller HDB XS Controller not running Sub Reason:   Could not startup the controller components: SAP WebDispatcher failed to bind application port (already occupied). Route to application will be unavailable. Restarting the...
Read more

Check Users Locked or deactivated in Hana or Hana Studio

Check Users; select * from users where user_deactivated= ‘TRUE’; Deactive hana user We can use the following SQL query to DEACTIVATE HANA DB user ; ALTER USER DEACTIVATE USER NOW; Example ; alter user HanaUser deactivate user now; To activate the user again we can use the below SQL query ; ALTER USER ACTIVATE USER NOW; Example ; alter user Hanauser activate user now;
Read more

Hana ini file location

The ini files are stored at the following default location on the server: /hana/shared/$SID/global/hdb/custom/config. File Details /usr/sap/ /HDB /exe/config Default values (not to be adjusted) /usr/sap/ /SYS/global/hdb/custom/config/ .ini Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on all hosts /usr/sap/ /SYS/global/hdb/custom/config/global.ini Valid for all services on all hosts /usr/sap/ /HDB / / .ini Valid for a specific service (e.g. indexserver) or component (e.g. multidb) on a specific host /usr/sap/ /HDB / /global.ini Valid for all services on a specific host
Read more