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 […]
Monthly Archives: August 2017
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 […]
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: […]
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 […]
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 => […]
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. […]
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], [], [], [], [], [], [], [], [], [], [], [] […]
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 […]