No question at this time
DBA Top 10
1 M. Cadot 11600
2 B. Vroman 6400
3 A. Kavsek 6000
4 P. Wisse 3400
5 J. Schnackenberg 3200
6 J. PĂ©ran 1800
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48560
Total active users1401
Act. users last 24h3
Act. users last hour0
Registered user hits last week152
Registered user hits last month875
Go up

RFS process is not able to start on newly created physical standby database 12cr2
Next thread: Recover big table
Prev thread: Explain Plan and Statistics

Message Score Author Date
Hi Team, I have created the physical standby data...... Aks Na Nov 11, 2020, 07:59
From primary :- [oracle@AHM-D-DG1 arch]$ tnsp...... Aks Na Nov 11, 2020, 08:09
[oracle@AHM-D-DG1 arch]$ ps -ef|grep tns root ...... Aks Na Nov 11, 2020, 08:11

Follow up by mail Click here


Subject: RFS process is not able to start on newly created physical standby database 12cr2
Author: Aks Na, India
Date: Nov 11, 2020, 07:59, 18 days ago
Os info: Centos Linux 7
Oracle info: 12.2.0.1
Message: Hi Team,
I have created the physical standby database but facing issue about RFS process. Please assist.

Primary DB:-

DB name:- clrnadm
DB_unique name:- clrnadc
service name:- clrnadc
standby DB:-

DB name:- clrnadm
DB_unique name:- clrnadg
service name:- clrnadg
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RFS process is not able to start on newly created physical standby database 12cr2
Author: Aks Na, India
Date: Nov 11, 2020, 08:09, 18 days ago
Message: From primary :-

[oracle@AHM-D-DG1 arch]$ tnsping clrnadm

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 11-NOV-2020 12:40:47

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/12.2.0.1/db_home/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.121.21.200)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = clrnadc)))
OK (0 msec)
[oracle@AHM-D-DG1 arch]$


From standby :-

[oracle@localhost arch]$ tnsping clrnadm

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 11-NOV-2020 12:39:24

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.121.21.200)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = clrnadc)))
OK (0 msec)
[oracle@localhost arch]$ tnsping clrnadg

TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 11-NOV-2020 12:39:28

Copyright (c) 1997, 2016, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.121.21.226)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = clrnadg)))
OK (0 msec)
[oracle@localhost arch]$
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: RFS process is not able to start on newly created physical standby database 12cr2
Author: Aks Na, India
Date: Nov 11, 2020, 08:11, 18 days ago
Message: [oracle@AHM-D-DG1 arch]$ ps -ef|grep tns
root 38 2 0 Oct08 ? 00:00:00 [netns]
oracle 6463 30656 0 12:42 pts/0 00:00:00 grep --color=auto tns
oracle 22350 1 0 Nov10 ? 00:00:04 /u01/app/oracle/product/12.2.0.1/db_home/bin/tnslsnr LISTENER_PRI -inherit
[oracle@AHM-D-DG1 arch]$
[oracle@AHM-D-DG1 arch]$ lsnrctl status LISTENER_PRI

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 11-NOV-2020 12:42:46

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=AHM-D-DG1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER_PRI
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 10-NOV-2020 15:14:07
Uptime 0 days 21 hr. 28 min. 38 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_home/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/AHM-D-DG1/listener_pri/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=AHM-D-DG1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=AHM-D-DG1)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.2.0.1/db_home/admin/CLRNADC/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "CLRNADC" has 1 instance(s).
Instance "clrnadm", status READY, has 1 handler(s) for this service...
Service "b371c36a1d706cb6e0556eccf0ffc32c" has 1 instance(s).
Instance "clrnadm", status READY, has 1 handler(s) for this service...
Service "clrnadm" has 1 instance(s).
Instance "clrnadm", status UNKNOWN, has 1 handler(s) for this service...
Service "clrnadmXDB" has 1 instance(s).
Instance "clrnadm", status READY, has 1 handler(s) for this service...
Service "clrnadmpdb" has 1 instance(s).
Instance "clrnadm", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@AHM-D-DG1 arch]$






From standby side :-


[oracle@localhost arch]$ ps -ef|grep tns
root 38 2 0 Oct21 ? 00:00:00 [netns]
oracle 13884 1 0 Nov10 ? 00:00:07 /u01/app/oracle/product/12.2.0.1/db_home/bin/tnslsnr LISTENER_STD -inherit
oracle 28505 27116 0 12:40 pts/1 00:00:00 grep --color=auto tns
[oracle@localhost arch]$
[oracle@localhost arch]$
[oracle@localhost arch]$ lsnrctl status LISTENER_STD

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 11-NOV-2020 12:40:46

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.121.21.226)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER_STD
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 10-NOV-2020 15:36:16
Uptime 0 days 21 hr. 4 min. 30 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_home/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener_std/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.121.21.226)(PORT=1521)))
Services Summary...
Service "clrnadg" has 1 instance(s).
Instance "clrnadg", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here