Recently I started getting ORA-00600 error, while I was trying to connect to SQLPlus sqlplus sys as sysdba SQL*Plus:Release 11.2.0.3.0 Production on Tue Jan 17 06:13:16 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter password: ERROR: ORA-00600: internal error code, arguments: [kzsrgpw], [], [], [], [], [], [], [], [], [], [], [] […]
All posts by Skant Gupta
Master Node in Oracle RAC
In this post, I will demonstrate three methods to identify the oracle clusterware’s master node. Please note that clusterware master is different from Resource master in oracle database instance. To know about how to find the resource master, Oracle ClusterWare Master’s Node information can be found By scanning ocssd logs from various nodes By scanning crsd […]
Upgrading the Grid Infrastructure from 11.2.0.4 to 12.1.0.2 on the command line
Currently I have two node Grid Infrastructure on 11.2.0.4. The node names are node1 and node2: [grid@node1 ~]$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [11.2.0.4.0] [grid@node1 ~]$ crsctl query crs softwareversion Oracle Clusterware version on node [node1] is [11.2.0.4.0] [grid@node1 ~]$ crsctl query crs softwareversion node2 Oracle Clusterware version […]
HugePages for Oracle
If you run a Oracle Database on a Linux Server with more than 16 GB physical memory and your System Global Area (SGA) is greater than 8 GB, you should configure HugePages. For large SGA sizes, HugePages can give substantial benefits in virtual memory management. Without HugePages, the memory of the SGA is divided into […]
Delete a node from RAC
To remove a node from a which is part of a RAC involves several steps Stop the database and ASM on particular instance Remove the database and ASM Remove the Oracle Database Software Remove the Clustware Update the oracle inventory Current Scenario [oracle@rac1 ~]$ olsnodes -s -t rac1 Active Unpinned rac2 Active Unpinned rac3 Active […]
Adding a Database home to a 12c RAC Cluster
In previous article we added the grid home in third home (i.e rac3): Click Here Now we are going to extend the database home in 3rd home. From an existing node i.e rac1 – as the database software owner – run the following command to extend the Oracle database software to the new node “rac3” […]
Adding a Grid node to a 12c RAC Cluster
The generic steps to follow when adding the new node to the cluster are: Install Operating System Install required software Add/modify users and groups required for the installation Configure network Configure kernel parameters Configure services required such as NTP Configure storage (multipathing, zoning, storage discovery, ASMLib?) We assume that our OS,storage and network is already […]
Patching Oracle GoldenGate 12c
For the latest patchset you’ll need access to MOS. At the time of writing the latest patchset is 12.1.2.1.12 and can be downloaded from here: Oracle GoldenGate 12.1.2.1.12 Patch Set Availability (Doc ID 1645495.1). we need to make sure that no processes are running out of the home that will be patched: [oracle@host01 ~]$ /u01/app/oracle/product/12.1.0/gg_12121/ggsci […]
Oracle GoldenGate 12c: Silent Install
As we know installation of Oracle Goldengate is very easy with GUI mode. In this article we will look at Oracle GoldenGate 12c silent install. Preparing the Response File we can create our response file and save it with ggs.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2 INSTALL_OPTION=ORA12c SOFTWARE_LOCATION=/u01/app/oracle/ggs START_MANAGER=true MANAGER_PORT=7809 DATABASE_LOCATION=/u01/app/oracle/product/12.1.0/dbhome_1 INVENTORY_LOCATION=/u01/app/oraInventory UNIX_GROUP_NAME=oinstall Installing GoldenGate After creating the response the […]
Installing Oracle GoldenGate for Oracle 12c
Oracle GoldenGate features can be demonstrated using a single computer and a single database instance. In this case, Oracle GoldenGate replication occurs between two different database schemas running on the same database instance. To make this arrangement possible, the Oracle GoldenGate software must be installed twice on the same computer/VM, in different directories, one dedicated […]