11i and R12 Environment Files/Variables Changes Comparison

Introduction:-  Today we are going to learn about environment files/variables in Oracle application.  Before we go a head we must know what is environment variables An environment variable is a vigorous “object” on a computer that reserves a value, which in turn can be referenced by one or more software programs in Windows. Environment variables succor programs know […]

Read More

Oracle Proxy Users

If you have required privileges, it’s possible to connect as a user account without knowing or changing his password. This is called proxy connection. To authorize a user account to connect using a proxy account, use the GRANT CONNECT THROUGH clause of the ALTER USER statement. Consider, we have a Application User called ‘APPUSR‘ and […]

Read More

Steps to change SCAN IP address in RAC

To Change the SCAN IP  address it must be available and need to changes on the DNS by the network admin. So we have SCAN IP address available. Steps: 1. To check the current status SCN IP address on  DNS $nslookup <scan-name> $nslookup testrac-scan.abc.com Server:         160.34.11.20 Address:        160.34.11.21#40 Name:   testrac-scan.abc.com Address: 160.34.11.88 Name:   testrac-scan.abc.com Address: […]

Read More

Change Listener ports RAC with MGMTDB

In this post, you will know how to change the Listener Port In Oracle RAC. We can change some listener ports from 1521 to 1525 on a RAC. 1. Check the listener status [oracle@node1 ~]$ srvctl status listener -l LISTENER Listener LISTENER is enabled Listener LISTENER is running on node(s): node1,node2 2. Modify the listener […]

Read More

ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi]

Recently started seeing this error on few of the RAC environments. Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl01/trace/orcl01_q002_5570998.trc: ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi], [1], [0], [], [], [], [], [], [], [], [], [] As per metalink this is a known Bug 20987661 – Doc ID 20987661.8 DECLARE po dbms_aqadm.aq$_purge_options_t; BEGIN po.block := FALSE; DBMS_AQADM.PURGE_QUEUE_TABLE( queue_table => […]

Read More

ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver]

On an Oracle 11204 restart environment, ASM spfile creation failed with error ora-600 create spfile=’+DATA5′ from pfile=’/u03/asmpfile.ora’ * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver],[0x0A2435D48], [3], [0x7F710EE38000], [512], [], [], [], [], [], [], [] This was caused due to a ASM disk with UNKNOWN HEADER_STATUS. […]

Read More

ORA-00600: internal error code, arguments: [kzsrgpw]

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], [], [], [], [], [], [], [], [], [], [], [] […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More