No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48548 | | Total active users | 1403 | | Act. users last 24h | 3 | | Act. users last hour | 1 | | Registered user hits last week | 214 | | Registered user hits last month | 641 |
|
Go up
oracle data guard windows
| Message |
Score |
Author |
Date |
   Hi,
archives are not getting shipped to the sta...... |
|
Ben Jacobs |
Oct 10, 2020, 14:39 |
| Below is the alert log for standby database
E...... |
|
Ben Jacobs |
Oct 10, 2020, 14:41 |
|
So what's inside the trace file?
... |
|
Michel Cadot |
Oct 10, 2020, 17:34 |
| Hi Michel,
below are the contents of the trace ...... |
|
Ben Jacobs |
Oct 10, 2020, 18:51 |
| Hi Ben,
Where did you copy the password file...... |
|
Joël Péran |
Oct 12, 2020, 07:41 |
| Hi Joel,
I have copied the password file before...... |
|
Ben Jacobs |
Oct 12, 2020, 08:19 |
| Hi again,
COuld you try to recreate password...... |
|
Joël Péran |
Oct 12, 2020, 08:49 |
| Subject: |
oracle data guard windows |
| Author: |
Ben Jacobs, India |
| Date: |
Oct 10, 2020, 14:39, 16 days ago |
| Os info: |
Windows 2012 R2 |
| Oracle info: |
oracle 12.2.0.1 |
| Error info: |
ORA-01033: ORACLE initialization or shutdown in progress
Error 1033 received logging on to the standby |
| Message: |
Hi,
archives are not getting shipped to the standby database.
alert log of standby shows the below error
Error 1033 received logging on to the standby
error from v$archive_dest show this
ORA-01033: ORACLE initialization or shutdown in progress
im able to connect to dr via net service name and the database is mounted
recreated the password file and copied it onto standby
bounced the databases, but still this error is shown.
is there anything that i'm missing? |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: oracle data guard windows |
| Author: |
Ben Jacobs, India |
| Date: |
Oct 10, 2020, 14:41, 16 days ago |
| Message: |
Below is the alert log for standby database
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
------------------------------------------------------------
FAL[client, ARC2]: Error 16191 connecting to sfmsdc for fetching gap sequence
2020-10-10T17:26:31.786128+05:30
Errors in file D:\ORACLE12C\APP\diag\rdbms\sfmsdr\sfmsdr\trace\sfmsdr_arc2_8008.trc:
ORA-16191: Primary log shipping client not logged on standby
2020-10-10T17:29:43.267097+05:30 |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: oracle data guard windows |
| Author: |
Michel Cadot, France |
| Date: |
Oct 10, 2020, 17:34, 15 days ago |
| Message: |
So what's inside the trace file?
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: oracle data guard windows |
| Author: |
Ben Jacobs, India |
| Date: |
Oct 10, 2020, 18:51, 15 days ago |
| Message: |
Hi Michel,
below are the contents of the trace file
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label: RDBMS_12.2.0.1.0WINDBBP_WINDOWS.X64_200617.1
Windows NT Version V6.2
ORACLE_HOME = D:\oracle12c\app\product\12.2.0\dbhome_1
Node name : RTGSDR1
CPU : 16 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:177634M/261922M, Ph
Instance name: sfms
Redo thread mounted by this instance: 1
Oracle process number: 36
Windows thread id: 7472, image: ORACLE.EXE (ARC2)
*** 2020-10-10T22:30:38.193231+05:30
*** SESSION ID:(759.2106) 2020-10-10T22:30:38.193231+05:30
*** CLIENT ID:() 2020-10-10T22:30:38.193231+05:30
*** SERVICE NAME:() 2020-10-10T22:30:38.193231+05:30
*** MODULE NAME:() 2020-10-10T22:30:38.193231+05:30
*** ACTION NAME:() 2020-10-10T22:30:38.193231+05:30
*** CLIENT DRIVER:() 2020-10-10T22:30:38.193231+05:30
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
*** 2020-10-10T22:30:39.755751+05:30
krsu_wallet_pwd_connect: OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
*** 2020-10-10T22:30:40.052630+05:30
OCISessionBegin failed -1
.. Detailed OCI error val is 1005 and errmsg is 'ORA-01005: null password given; logon denied
'
*** 2020-10-10T22:30:41.662025+05:30
krsu_wallet_pwd_connect: OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
*** 2020-10-10 22:30:41.724528 5634 krsh.c
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
------------------------------------------------------------
*** 2020-10-10 22:30:41.818277 5634 krsh.c
FAL[client, ARC2]: Error 16191 connecting to sfmsdc for fetching gap sequence
ORA-16191: Primary log shipping client not logged on standby
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: oracle data guard windows |
| Author: |
Joël Péran, France |
| Date: |
Oct 12, 2020, 07:41, 14 days ago |
| Message: |
Hi Ben,
Where did you copy the password file ? Why didn't you recreate it on both instances with the same password ? What do you have in SQLNET.ORA file on both servers ?
Regards,
Joel |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: oracle data guard windows |
| Author: |
Ben Jacobs, India |
| Date: |
Oct 12, 2020, 08:19, 14 days ago |
| Message: |
Hi Joel,
I have copied the password file before setting up dataguard.
Both the sys users have identical passwords.
I had copied the password files to ORACLE_HOME\DATABASE
and aslo recreated it many times after facing error |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: oracle data guard windows |
| Author: |
Joël Péran, France |
| Date: |
Oct 12, 2020, 08:49, 14 days ago |
| Message: |
Hi again,
COuld you try to recreate passwords on BOTH instances ? And what do you have in your sqlnet.ora file (for the authentication ?) ?
Regards,
Joel |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
|