Category: howto

Hidden parameter checking script for Oracle

Hidden parameter checking script for Oracle

October 1, 2010 | By | Add a Comment

Hi friends, So many times we need to check hidden parameters of Oracle. Sometime we forgot script of data dictionary views for writing sql script. Here I am providing you SQL script for check hidden parameters of Oracle. For executing this script you should need to login as SYSDBA. Because only X$ tables are providing […]

Read More

srvctl command utility of Oracle RAC

srvctl command utility of Oracle RAC

February 12, 2010 | By | Add a Comment

Hi Friends, Server Control utility is available for Oracle RAC management. We are using srvctl utility to perform configuration on cluster environment for storing configuration data in the server management configuration repository. SRVCTL uses SQL*Plus to perform stop and start activities on each node. Server Management configuration repository stores all components like SRVCTL,GSD (Global Services […]

Read More

OSAUTH_PREFIX_DOMAIN for Oracle

OSAUTH_PREFIX_DOMAIN for Oracle

February 8, 2010 | By | Add a Comment

Hi friends, How to set OSAUTH_PREFIX_DOMAIN in Oracle database for windows security of Oracle databases. Yes, we can set OSAUTH_PREFIX_DOMAIN parameter in windows registry as follows. Go to following windows registry of Oracle software HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME# And add entry of OSAUTH_PREFIX_DOMAIN=true This entry forces external user to use domain name in login. After enabling this entry […]

Read More

Oracle version number detail explaination

Oracle version number detail explaination

December 22, 2009 | By | Add a Comment

Article explains detail of How to check installed Oracle version? and How to understand Oracle version numbers?

Read More

Oracle one-off patch or interim patch using opatch utility

Oracle one-off patch or interim patch using opatch utility

December 22, 2009 | By | Add a Comment

Oracle’s interim patch and one-off patch is being applied by Opatch utility. Article explains how to apply opatch with one-off interim patch of oracle.

Read More

New Oracle DBA forums

New Oracle DBA forums

October 21, 2009 | By | 2 Comments

Hi friends, Great news from Dbametrix that, new Oracle DBA Forum has been initiated as follows. It is totally FREE. http://oracledba.forumotion.net/ For sharing knowledge,news,tips,scripts,problems for Oracle DBA you can take benefit of same Oracle DBA forums. http://oracledba.forumotion.net/ This Oracle DBA forums is helping you to download OCP exam preparation study materials, Searching for Oracle DBA […]

Read More