-
1. Re: RPD Connection TNS when multiple environments
Christian Berg Feb 27, 2019 7:38 AM (in response to Rai Qaiser Hussain)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:
-
2. Re: RPD Connection TNS when multiple environments
Rai Qaiser Hussain Feb 27, 2019 2:35 PM (in response to Christian Berg)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
-
3. Re: RPD Connection TNS when multiple environments
Christian Berg Feb 27, 2019 6:03 PM (in response to Rai Qaiser Hussain)1 person found this helpfulYou 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.
Done.
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.
-
4. Re: RPD Connection TNS when multiple environments
Christian Berg Feb 28, 2019 2:56 PM (in response to Rai Qaiser Hussain)So is your question answered? Or is it still open?
-
5. Re: RPD Connection TNS when multiple environments
Rai Qaiser Hussain Mar 1, 2019 6:37 AM (in response to Christian Berg)Hopefully, I shall update you till monday, currently working
-
6. Re: RPD Connection TNS when multiple environments
Rai Qaiser Hussain Mar 6, 2019 1:03 PM (in response to Rai Qaiser Hussain)Still working, I shall write the complete steps once completed
-
7. Re: RPD Connection TNS when multiple environments
Christian Berg Mar 6, 2019 2:26 PM (in response to Rai Qaiser Hussain)