Ora-20001 : Node name not found in repository

[daniesh]

Hi Erman,

I am trying to configure shared appl top. I created a pairsfile and made changes in pairsfile.

addnode command also ran successfully. When try to run autoconfig on node 2. autoconfg is getting failed.

with below error.

select ad_zd_adop.get_node_type(nodename) from dual;

Ora-20001 : Node name nodename not found in repository tables.

As per Doc ID 2268532.1 , I followed the steps. still the error is there.

I followed the Doc ID 2064223.1, Still error exists.

Please assist on this.

[ErmanArslansOracleBlog]

Were there any errors produced during your addnode-run? Check EBSProvisioner.log for this.
Also send me the document id that you followed for building your shared appl top.. (the MOS document id + the steps that you have taken)

[daniesh]

Hi Erman,

Thanks....

Were there any errors produced during your addnode-run? Check EBSProvisioner.log for this.
got message that node add successfully.

I followed the 1375769.1 and 1383621.1

1 ran adpreclone on run filesystem --Node 1
2 ran adpreclone on patch filesystem --Node 2
3 created pairsfile and updated it.
ran perl adclonectx.pl addnode

After that when i run autoconfig on apps tier node 2 .

I am getting error.

[ErmanArslansOracleBlog]

What is your AD-TXK level?
I m asking it because there is a bug ->

21960922 AUTOCONFIG ORA-20001: NODE NAME  NOT FOUND IN ADOP REPOSITORY TABLES

This bug seems fixed in AD-TXK Level 8 and higher.

If your version is lower, I will suggest you to update your AD-TXK level and retry your failing operation after that.

[daniesh]

we are on AD-TXK Level 10. when i upgraded it. It was working. Now i am cloning from PROD. It is giving problem. 1st node does not have any problem.

[ErmanArslansOracleBlog]

What do you have in your ADOP_VALID_NODES;

select * from APPLSYS.ADOP_VALID_NODES;

Do you have the relevant node recorded there?

[daniesh]

It is showing only one node 1 entry. I tried to add another node using below
http://appsdbauniverse.blogspot.com/2016/02/in-12.html

Still no luck.

after that i raised it here.

[ErmanArslansOracleBlog]

What do you mean?
Are saying that, although you insert your node info (for the missing one) into APPLSYS.ADOP_VALID_NODES manually, you are still failing with the same error?

[daniesh]

I tried but it is not allowing as per the link mentioned in the last update. but failed.

On Thu, Jun 27, 2019 at 1:10 PM ErmanArslansOracleBlog [via Erman Arslan's Oracle Forum] <[hidden email]> wrote:

What do you mean?
Are saying that, although you insert your node info (for the missing one) into APPLSYS.ADOP_VALID_NODES manually, you are still failing with the same error?

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Ora-20001-Node-name-not-found-in-repository-tp7425p7476.html

To unsubscribe from Ora-20001 : Node name not found in repository, click here.
NAML

[ErmanArslansOracleBlog]

What do you mean by "it is not allowing".

Send me a screenshot of this. Or you can send me the error message that you are getting while trying to insert the record.

[daniesh]

I inserted entry of node 2 in adop_valid nodes manually.
autoconfig got completed successfully.
I will follow the remaining process to add a node and keep you updated.

My question why autoconfig is not updating the entry of node 2  in adop_valid_nodes.

This is some bug.

[ErmanArslansOracleBlog]

In order to answer this question, we need to review the ad_zd_adop.get_node_type.
Probably, it expects something but couldn't find it and probably that's why your autoconfig doesn't insert into the adop_valid_nodes automatically..

[daniesh]

Hi Ermaan,

Autoconfig is failing at txkGenADOPValidNodes.sql INSTE8_PRF

[ErmanArslansOracleBlog]

Did you check this note ? -> Executing AutoConfig Failed in adgendbc.sh on a Cloned Environment With Load Balancer (Doc ID 2197277.1)

[daniesh]

As per Doc ID 2197277.1, below 2 parameters are properly configured,
s_webentryurlprotocol

s_login_page

[ErmanArslansOracleBlog]

Send me the actual autoconfig logfile. I need to see all the failing scripts behind. (the failing .sh scripts I mean..)