Wednesday, December 10, 2008
Oracle 11gR2 Installation on RHEL 4
Oracle released 11g Release 2 and I was just waiting to get my fingers on it…!!! So downloaded the software from OTN and installed it on Linux. As of now, the software is available only on Linux.[...]
Continue Reading...
Wednesday, December 10, 2008
Dataguard Adventures - Part I...!!!!!
So, I started working on Phase-I of DR implementation....!!!! [...]
Continue Reading...
Wednesday, December 10, 2008
Dataguard Adventures - Part II...!!!!!…
In my last post,we eneded up with primary shipping archivelogs to standby that are being applied to standby.The next steps would be to setup DG BROKER for this setup to automate switchover and failover.[...]
Continue Reading...
Wednesday, December 10, 2008
When ASM rebalancing stops...!!!!
Was adding disks to ASM diskgroups few days back as a part of weekly space addition. Added one disk to each of the ASM diskgorup (CDBP and CDBP2). The disk space got reflected in both the diskgroups, but lot of interesting things were waiting for me. I was able to use space the space in CDBP2 diskgroup for tablespaces but CDBP diskgroup space got jammed…., [...]
Continue Reading...
Monday, December 8, 2008
Reducing Downtime during database movement and migrations
There are lot of strategies possible for moving a database from one server to another. The things are to be planned in a much better way when we have to do multiple things in a single window. This is what I did some time back for a database and server migration with a minimum downtime and pretty good backout plan. [...]
Continue Reading...
Adding Listener to OCR in 10g RAC
Till oracle 10gR2, we dont' have option to add listener to clusterware via SRVCTL utility. So how can we add the listener in case we re-installed the clusterware after volting disk/ocr loss. As per oracle, we can use only NETCA to add the listener to OCR in case CRS is re-installed.
After CRS installation, this is what i had.
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
[oracle@rac1 ~]$
Since the listeners were already there before clusterware re-install, so remove/move the old listener.ora and tnsnames.ora files.
Node-1
[oracle@rac1 admin]$ mv tnsnames.ora tnsnames.ora.old
[oracle@rac1 admin]$ mv listener.ora listener.ora.old
Node-2
[oracle@rac2 admin]$ mv tnsnames.ora tnsnames.ora.old
[oracle@rac2 admin]$ mv listener.ora listener.ora.old
Run NETCA to create the new listener. NETCA will sometimes popup an error saying the listener with name LISTENER already exists. So, delete the existing listener (with name LISTENER) and create a new listener again.
[oracle@rac1 admin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
Note:- After deleting the old listener, when you try to create the new listener (with name LISTENER), NETCA will agin popup the same error that listener exists. In that case, close NETCA and invoke it again to create the listener. It will work this time.
Cheers ...!!!
-- Rishi
After CRS installation, this is what i had.
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
[oracle@rac1 ~]$
Since the listeners were already there before clusterware re-install, so remove/move the old listener.ora and tnsnames.ora files.
Node-1
[oracle@rac1 admin]$ mv tnsnames.ora tnsnames.ora.old
[oracle@rac1 admin]$ mv listener.ora listener.ora.old
Node-2
[oracle@rac2 admin]$ mv tnsnames.ora tnsnames.ora.old
[oracle@rac2 admin]$ mv listener.ora listener.ora.old
Run NETCA to create the new listener. NETCA will sometimes popup an error saying the listener with name LISTENER already exists. So, delete the existing listener (with name LISTENER) and create a new listener again.
[oracle@rac1 admin]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
Note:- After deleting the old listener, when you try to create the new listener (with name LISTENER), NETCA will agin popup the same error that listener exists. In that case, close NETCA and invoke it again to create the listener. It will work this time.
Cheers ...!!!
-- Rishi
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment