Just three quick updates…
Secondly, just an observation – I noticed yesterday that somehow a few of the listeners are still registering with ONS even with the ons.config file pointing to a different port. If you look at the output I posted Thursday you can even see that the listener from our ASM home is connected to ONS – but the ASM ons.config file points to local port 6102. This begs the question, how do the listeners know what port ONS is running on? And why did the ASM listener connect but the other 10g listeners on the box didn’t? Furthermore, on Friday we configured a listener with no ons.config file at all (renamed it to fix the crazy connection problem) – and then that listener connected to ONS as normal without causing any problems! Yet the third listener on the box still doesn’t connect to ONS. If anyone has any ideas then please leave a comment…
Lastly I just thought I’d post the input and output of a successful rconfig run for reference. FYI, we were moving an Oracle Apps 11i (18.104.22.168) database from filesystem to ASM and from single instance to RAC. The whole run took about 20 minutes (it is still a relatively empty Apps database).
Rconfig is very obviously NOT designed to be used at the command line… it takes XML input and output. Works well with OEM I’m sure. :) Anyway, here’s the XML input file we used with rconfig:
[oracle@lab01 ~]$ cd $ORACLE_HOME/assistants/rconfig/sampleXMLs/ [oracle@lab01 sampleXMLs]$ cat dbtest.xml /opt/oracle/app/dbtest/10.2.0 /opt/oracle/app/db/10.2.0 sys our_secret_sys_password sysdba sys our_secret_asm_password sysdba dbtest +DATA +DATA
This is a handy command to run in a second window to monitor the progress of the rconfig process. Rconfig doesn’t really tell you much about what’s going on behind the scenes so the best way to watch it is to keep an eye on what processes are running and tail the log file. Before running this command find out the terminal where you’re going to actually run rconfig (pts/#) and use that when you type this command.
[oracle@lab01 ~]$ cd $ORACLE_HOME/cfgtoollogs/rconfig/ [oracle@lab01 rconfig]$ watch -n 1 'ps f -t pts/5 --width 80; echo; echo; tail -10 rconfig.log'
And here’s the output from an actual rconfig run.
[oracle@lab01 sampleXMLs]$ rconfig dbtest.xml Converting Database dbtest to Cluster Database. Target Oracle Home : /opt/oracle/app/db/10.2.0. Setting Data Files and Control Files Adding Database Instances Adding Redo Logs Enabling threads for all Database Instances Setting TEMP tablespace Adding UNDO tablespaces Adding Trace files Setting Flash Recovery Area Updating Oratab Creating Password file(s) Configuring Listeners Configuring related CRS resources Adding NetService entries Starting Cluster Database Starting Listeners Operation Succeeded /opt/oracle/app/db/10.2.0 dbtest1 dbtest2