If you look into the documentation you will see that Oracle has specific commands to manage this when moving from one environment to the next:
Thanks for the help, may be I am doing something wrong that's why unable to resolve the issue, After reading documents I did as following --- please highlight where I am wrong and how to use JSON file
- Write the command with datamodel.sh which open the file as shown in Fig.1, saved the file in directory without any modification
- updateconnectionpool again without any modification because there was nothing which I could understand
- I tried datamodel.cmd as shown in Fig.3, maybe this is requirement but I don't know how to use the output file.
Fig.1, listconnectionpool when written comman
Fig.2, write the updateconnection pool, it again opened the file
After fig.2, I am stuck what is the next step
Fig.3, When I write command with datamodel.cmd then below result appear in command prompt--- maybe this is my required file I can put credentials but don't know how to use
1 person found this helpful
You can put your DSN entries into a repository variable called something like "DB_CONNECTION" and set it to "DEV" (or whatever the string is - I don't know your environment).
The you can just use the variables command listrpdvariables.
Then you change the JSON to say "QA" instead of DEV.
Then you run updaterpdvariables and put the new variable value in to the RPD.
That's how the process works.
And for about the 10th time: Get some proper training! It's questionable at best to work your way through things without the proper basics.
So is your question answered? Or is it still open?
Hopefully, I shall update you till monday, currently working
Still working, I shall write the complete steps once completed