Now, assume that we have the master tnsnames. In each database server, our client has 3 database homes for: Sorry, your blog cannot share posts by email. First, we need to setup user equivalence for the celladmin user to all cells. Alternatively raise an Support Request with Oracle Support. Also, this command enable you to find out any outdated entries that reference severs or databases that are no longer exist. The —vmstat switch lets us vmstat all the cells with one command:. 
| Uploader: | Grojinn |
| Date Added: | 14 December 2009 |
| File Size: | 60.62 Mb |
| Operating Systems: | Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X |
| Downloads: | 63911 |
| Price: | Free* [*Free Regsitration Required] |
Doing this manually for about entry takes time, so, we wrote the following shell script command to do it for us:.
The cells are referenced by their domain name or ip address. Enter passphrase empty for no passphrase: Cell cell1 successfully altered cell2: The -r switch suppresses output lines with regular expressions. Also, if you want to partially distribute the new master file to subset of the above nodes, you can simply scli the un-wanted servers, like: For some odd reason, we need to make it OS executable in both cases:.
About Oracle Developer Community. As we have three different environment.
Posts Tagged dcli
Please note that in the current situation, each database home has its own tnsnames. First, we need to setup user equivalence for the celladmin user to all cells. Otherwise it is assumed that it contains OS commands. Note that you will need to setup a trust ssh link between the server that contains the master tnsnames. This is due to the vast amount of additional checks carried out by the tool. Cell cell2 successfully altered We can suppress those normal messages because we may only want to see if something is not normal.
Google by Uwe Hesse.
That does the -n switch:. Disclaimer The views expressed here are my own and do oacle necessarily reflect the views of Exasol or any former employer. This script accepts only one parameter which is the name of the new master file.
Options allow this command output to be abbreviated. The -k option should be used initially to perform key exchange with cells. You can see my previous post here: By continuing to use this website, you agree to their use. More info on Exadata can be found here on the latest datasheet at time of writing: Due to this, you may also notice you get timeout issues reported in the report: Search inside this Blog.
Use this procedure at your own risk!. Two Exaxdata machines and oarcle standalone DR server, the question was where we should locate our master file?.
dcli – Ahmed AbdelFattah Blog !
Now, assume that we have the master tnsnames. So as you can imagine, executing commands on 3 servers is tidiuos enough, let alone 18, hence the power and usefulness of dcli!
The Cell Administration can be done on the command line as user celladmin with CellCLI, as shown in previous postings already, but it would be an annoying task to do all commands 14 times. This will produce the following output: Actually, this step is a little bit manual.
Due to this, you may also notice you get timeout issues reported in the report:. Each database home contains its own tnsnames.
Комментариев нет:
Отправить комментарий