|
||||
|
Convert Single Instance (ASM) to RAC Instance (ASM) to different Server Assuming you have already the following environment setup and ready 1. 11gr2 Clusterware is already installed on your target machine (XYZ) 2. Target xyz is configured with +DATA as diskgroup 2. Source ABC is having single instance in ASM […] Whilst adding a node failing with following errors in the addnode.log INFO: /u01/app/11.2.0.4/grid/oui/bin/../bin/lsnodes: struct size 0 INFO: Vendor clusterware is not detected. INFO: Error ocurred while retrieving node numbers of the existing nodes. Please check if clusterware home is properly configured. SEVERE: Error ocurred while retrieving node numbers of the existing nodes. Please check if […] Hello, I have been reading in other blog citing that what if lost of a data file scenario. Here are the questions. 1) if in case of system/user datafile lost of Pluggable database, what happens to CDB? ANS: Nothing happens to CDB, it will still running, similar case in non-cdb database if a user data […] Hello All, Here are the steps to implement the Standby in RAC and the following is the test environment Production RAC: Geek DBA12cprmy1 Geek DBA12cprmy2 Standby RAC:- Geek DBA12cdr1 Geek DBA12cdr2 1 . Add standby logs on Primary Database alter database add standby logfile thread 1 group 10 (‘+PRMY_DATA’) size 500M; alter database add […] Whilst, was working on a dataguard network performance issue thought should write something on this. The most important aspect of the dataguard is network transport, and if the undersized or improper configuration may lead to the redo transport issue and production may show you the log synch waits etc. The following parameters may be tuned […] Hello All, Long time !!! Its been very busy schedule and could not spend much on the blog at all. Anyways back now, and here this time with gpnp profile. Issue is , the node 2 not starting due to gpnp profile missing/mismatch. Following in the crs alert log in node 2 […] Again, OEL 7 (UEK) and 12c Grid Infrastructure issue. OEL UEK 7 does not shipped or support ACFS yet, but we tried and stumbled :(. Here is the log for root.sh failure. ACFS-9317: No ADVM/ACFS distribution media detected at location: ‘/u02/app/11.2.0.2/grid1/install/usm/EL5/x86_64/2.6.18-8/2.6.18-8.el5-x86_64/bin’ root@ol5-112-rac1 ~]# /u02/app/11.2.0.2/grid1/bin/acfsroot install ACFS-9320: Missing file: ‘advmutil’. ACFS-9320: Missing file: ‘advmutil.bin’. ACFS-9320: Missing […] While running dbca we are receiving the ora-12547 and we could not able to create database using DBCA anymore. After googling and metalink search found many notes which does not resolve the issue, the reasons can be multifold Environments- SID, PATH, LD_LIBRARY_PATH – Not resolved Permission on oracle executable to 6751 – Not resolved Package […] Well, this is fairly an old topic but explored lately by me. Very big post click on read more to scroll down to full page. Ah, I was trying to explore the upgrade from 11gr2 to 12c but not traditional way, and go these two excellent white papers. http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-transientlogicalrollingu-1-131927.pdf http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-upgrades-made-easy-131972.pdf The high level overview of […] In the Previous post we have converted the orcl database to server pool OLTP_SP which is running on three nodes rac01,rac03,rac04 and free server is available in rac02. Okay lets have some discussion before proceeding, 1. Does in pre 11g version , if a instance crashed does it failed over to any node? No. […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!