Listener Subscription To ONS For Cluster Events

Just three quick updates…

First of all, yesterday we re-ran rconfig a few times and confirmed – for sure – that the PRKP-1001 and CRS-0215 errors tuesday were from the listener/ONS problem.

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 (11.5.10.2) 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