http://www.dbasupport.com/forums Oracle Database Administration, Systems Management, Oracle Application Server, Oracle Portal and Advanced Topics related to Oracle en Tue, 07 Sep 2010 17:30:09 GMT vBulletin 60 http://www.dbasupport.com/forums/images/misc/rss.jpg http://www.dbasupport.com/forums http://www.dbasupport.com/forums/showthread.php?t=61386&goto=newpost Tue, 07 Sep 2010 12:00:17 GMT All.

Considering the fact that I do not have Oracle Tuning Pack licenses (which eliminates use of SQL Tuning Sets), what would be possible methods to use to ensure that execution plans are "locked".

Kind regards,
Trond ]]> Oracle Database Administration TrondSpain http://www.dbasupport.com/forums/showthread.php?t=61386 http://www.dbasupport.com/forums/showthread.php?t=61385&goto=newpost Mon, 06 Sep 2010 17:13:22 GMT ] DATABASE TO [BEFORE] SCN = TO [BEFORE] SEQUENCE = [THREAD = ] TO [BEFORE] TIME = '' 1) If I don't have auditing enabled and I am not sure the time the deletion was done, is there a way for me to find any value needed to flashback to the correct state before the deleted transaction were commited? 2) I defined my flashback area as /oracle/data/aux/fra but when I drill down I see this layout /oracle/data/aux/fra/AUX/archivelog/YYYY_MM_DD with .arc file in it. Nothing was happening in this DB, yet .arc files were created, can somebody explain why and what is the correct method of removing the .arc files? Can they just be deleted from the file system with a find and rm command after a day. Since there is only a day's worth of retention defined in my init.ora file *.db_flashback_retention_target=1440 is that why I am getting a new YYYY_MM_DD everyday? Thanks in advance to all that answer]]> I am starting to play around with flash back recovery and have a few questions, which hopefully somebody can answer for me.

I see this is the syntax to retreived deleted rows:

FLASHBACK [DEVICE TYPE = ] DATABASE
TO [BEFORE] SCN =
TO [BEFORE] SEQUENCE = [THREAD = ]
TO [BEFORE] TIME = ''


1) If I don't have auditing enabled and I am not sure the time the deletion
was done, is there a way for me to find any value needed to flashback to the
correct state before the deleted transaction were commited?


2) I defined my flashback area as /oracle/data/aux/fra but when I
drill down I see this layout /oracle/data/aux/fra/AUX/archivelog/YYYY_MM_DD
with .arc file in it.

Nothing was happening in this DB, yet .arc files were created, can somebody
explain why and what is the correct method of removing the .arc files? Can they just be deleted from the file system with a find and rm command after a day.

Since there is only a day's worth of retention defined in my init.ora file
*.db_flashback_retention_target=1440 is that why I am getting a new YYYY_MM_DD everyday?

Thanks in advance to all that answer ]]> Oracle Database Administration BeefStu http://www.dbasupport.com/forums/showthread.php?t=61385 http://www.dbasupport.com/forums/showthread.php?t=61384&goto=newpost Sun, 05 Sep 2010 18:33:20 GMT We have quarterly and yearly processes that deletes, archives millions of rows from different tables. To make room on the file system I would either like to shrink back down the datafiles (because auto extend is on) or coalesce them. Is there a rule of thumb I should follow when shrinking or coalescing? Can somebody provide provide a query that would show me the free and used extents in a TS, and when I should coalesce or a query to show me how much free space is in a datafile so I can shrink it. THanks in advance to all who answer. We have quarterly and yearly processes that deletes, archives millions of rows
from different tables. To make room on the file system I would either like
to shrink back down the datafiles (because auto extend is on) or coalesce them.

Is there a rule of thumb I should follow when shrinking or coalescing? Can somebody provide provide a query that would show me the free and used
extents in a TS, and when I should coalesce or a query to show me how much free space is in a datafile so I can shrink it.

THanks in advance to all who answer. ]]> Oracle Database Administration BeefStu http://www.dbasupport.com/forums/showthread.php?t=61384 http://www.dbasupport.com/forums/showthread.php?t=61383&goto=newpost Sun, 05 Sep 2010 09:51:21 GMT Hi, I am upgrading oracle 10.2.0.2 to 10.2.0.4 in MSCS cluster. before upgradation when i stop oracle10P01102TNSlisteneroracleP01 service, it is not allowing to stop. then i disabled this service and started upgradation. all resources moved to other node. in the middle of upgradation it throws another error that, ORACLE_HOME\database is not accessible. anybody please help me to upgrade oracle 10g in MSCS cluster environment? Thanks in advance Irfan Hi,

I am upgrading oracle 10.2.0.2 to 10.2.0.4 in MSCS cluster. before upgradation when i stop oracle10P01102TNSlisteneroracleP01 service, it is not allowing to stop. then i disabled this service and started upgradation. all resources moved to other node. in the middle of upgradation it throws another error that, ORACLE_HOME\database is not accessible.

anybody please help me to upgrade oracle 10g in MSCS cluster environment?

Thanks in advance

Irfan ]]> Oracle Database Administration rashadyell http://www.dbasupport.com/forums/showthread.php?t=61383 http://www.dbasupport.com/forums/showthread.php?t=61379&goto=newpost Wed, 01 Sep 2010 14:32:46 GMT I am currently working on a project whereby I am linking in MS Access the data in the "MTL_SYSTEM_ITEMS_B" Table, "BOM_OPERATIONAL_ROUTING" Table, "BOM_OPERATION_SEQUENCE" Table and "BOM_OPERATION_RESOURCES" Table. As for the link between the "MTL_SYSTEM_ITEMS_B" table and the "BOM_OPERATIONAL_ROUTING" table, there is a one to one relationship. Though for the link between "BOM_OPERATIONAL_ROUTING" (link from) and "BOM_OPERATION_SEQUENCE" (link to), this link is not so straight forward. The BOM Technical Manual shows that these tables are linked by way of the field "ROUTING_SEQUENCE_ID".

What makes things complex is that there is a "COMMON_ROUTING_SEQUENCE_ID" field for parts that have similar routings. For parts that have similar routings, the valid routing is the "COMMON_ROUTING_SEQUENCE_ID". The question I have is what type of database structure should exist as there are two fields that are possible candiates for linking. When looking at the data in the "BOM_OPERATIONAL_ROUTING" (link from) table in Discoverer, the data in the "ROUTING_SEQUENCE_ID" field is unique, though the data in the "COMMON_ROUTING_SEQUENCE_ID" field is not unique. The field "ROUTING_SEQUENCE_ID" does not contain data in the "BOM_OPERATION_SEQUENCE" (link to) table where data exists in the "COMMON_ROUTING_SEQUENCE_ID" field for the part in "BOM_OPERATIONAL_ROUTING" (link from) table. In other words if you simply link the field "ROUTING_SEQUENCE_ID" that exists between "BOM_OPERATIONAL_ROUTING" and "BOM_OPERATION_SEQUENCE" you will not get operation sequence records for parts that have common routings.

It is confusing as the Oracle Technical Manual does not spell out this issue in the Diagram 9:Routings or I do not understand how to interpret the relationships.

Any help in defining the relationship between "BOM_OPERATIONAL_ROUTING" table and "BOM_OPERATION_RESOURCES" table would be greatly appreciated. ]]> Oracle Database Administration mcertini http://www.dbasupport.com/forums/showthread.php?t=61379 http://www.dbasupport.com/forums/showthread.php?t=61372&goto=newpost Mon, 30 Aug 2010 14:22:27 GMT In our EBS, we have planned to rebuild the indexes. We got a script from metalink, which identfies the indexes which needed to be rebuild. My query is how to capture performence benifits after rebuilding of indexes?? Plz help me guyz.... In our EBS,
we have planned to rebuild the indexes.
We got a script from metalink, which identfies the indexes which needed to be rebuild.
My query is how to capture performence benifits after rebuilding of indexes??

Plz help me guyz.... ]]> Oracle Database Administration karthikg http://www.dbasupport.com/forums/showthread.php?t=61372 http://www.dbasupport.com/forums/showthread.php?t=61371&goto=newpost Sat, 28 Aug 2010 09:45:39 GMT Hi, How to perform incremental backups using datapump in 10g? Hi, How to perform incremental backups using datapump in 10g? ]]> Oracle Database Administration iris http://www.dbasupport.com/forums/showthread.php?t=61371 http://www.dbasupport.com/forums/showthread.php?t=61369&goto=newpost Fri, 27 Aug 2010 22:31:50 GMT alter database open RESETLOGS; alter database open RESETLOGS * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/oracle/data/aux/system01.dbf' Can somebody explain what is missing in the above example for this work. Thanks]]> I am looking at the following link

http://download.oracle.com/docs/cd/B...1.htm#RCMRF149

And see this example (see below). If your restoring a control file from a backup dont you need to open the DB with resetlogs option since you will be out of sync. Is this documentation wrong or am I missing something?


RUN
{ # SET DBID is not necessary when connected to a recovery catalog
STARTUP FORCE NOMOUNT;
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
}

When I issue this statement after the control files are restored I get the
following error:

SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/data/aux/system01.dbf'


Can somebody explain what is missing in the above example for this work.

Thanks ]]> Oracle Database Administration BeefStu http://www.dbasupport.com/forums/showthread.php?t=61369 http://www.dbasupport.com/forums/showthread.php?t=61368&goto=newpost Fri, 27 Aug 2010 09:08:30 GMT Hi, what are the requirements prior to creating a database for production environment? thanks, Hi, what are the requirements prior to creating a database for production environment?


thanks, ]]> Oracle Database Administration iris http://www.dbasupport.com/forums/showthread.php?t=61368 http://www.dbasupport.com/forums/showthread.php?t=61367&goto=newpost Fri, 27 Aug 2010 08:15:32 GMT which RC table stores the backup location information? I need to find out the location of a backup file taken through RMAN using catalog. Rgds which RC table stores the backup location information? I need to find out the location of a backup file taken through RMAN using catalog.

Rgds ]]> Oracle Database Administration sumit http://www.dbasupport.com/forums/showthread.php?t=61367 http://www.dbasupport.com/forums/showthread.php?t=61366&goto=newpost Thu, 26 Aug 2010 16:10:30 GMT I have a question regarding this article in the link below:

http://www.databasejournal.com/featu...am-Capture.htm

The author says to configure log_archive_dest_2 as folllows:

log_archive_dest_2 service=sfdb.world noregister template=/u01/app/oracle/srcdb/arch/ladb/ladb_%t_%s_%r.arc'

1) What does this entry exactly mean, does it infer the location where
the archive files will be placed or where they will be taken from?

2) Should log_archive_dest_1 be configured? if so to what?, any location
you want the archive files to go too from the source database.

3) What should my log_archive_dest look like on my desintation machine?

If somebody can provide an example of the init.ora for both the target
and source machines defined in this article it would be greatly appreciated.

Thanks ]]> Oracle Database Administration BeefStu http://www.dbasupport.com/forums/showthread.php?t=61366 http://www.dbasupport.com/forums/showthread.php?t=61365&goto=newpost Thu, 26 Aug 2010 14:10:21 GMT I Changed the listener port on one of the servers by editing the listener.ora file. I changed the tnsnames.ora file on the server and the clients. everyone can connect, however oem is showing the listener down and it shows the old port number. I edited the emoms.properties file putting in the new port number, I looked in the emd.properties file, but can't find any references to a port number. I retarted OEM. Can some one point me in the right direction as to what I am missing, please? Thank you. ]]> Oracle Database Administration jayjabour http://www.dbasupport.com/forums/showthread.php?t=61365 http://www.dbasupport.com/forums/showthread.php?t=61363&goto=newpost Thu, 26 Aug 2010 11:52:28 GMT Hi All, We are using version 10.2.0.4.0 on Windows here. My question is, if your database is up and running using a pfile, but you would like to create an spfile using the following command: create spfile from pfile; Can the database be up when you execute that command, or does it have to be shut down? Thanks..... Hi All,

We are using version 10.2.0.4.0 on Windows here. My question is, if your database is up and running using a pfile, but you would like to create an spfile using the following command:

create spfile from pfile;

Can the database be up when you execute that command, or does it have to be shut down?

Thanks..... ]]> Oracle Database Administration oraclegirl http://www.dbasupport.com/forums/showthread.php?t=61363 http://www.dbasupport.com/forums/showthread.php?t=61359&goto=newpost Wed, 25 Aug 2010 16:57:48 GMT )*] cat db_install.rsp ## Since I only want to install the software I left the ## rest of the values below as the defaults. #################################################################### ## Copyright(c) Oracle Corporation 1998,2008. All rights reserved.## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## can help to populate the variables with the appropriate ## ## values. ## ## ## ## IMPORTANT NOTE: This file contains plain text passwords and ## ## should be secured to have read permission only by oracle user ## ## or db administrator who owns this installation. ## ## ## #################################################################### #------------------------------------------------------------------------------ # Do not change the following system generated value. #------------------------------------------------------------------------------ oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 #------------------------------------------------------------------------------ # Specify the installation option. # It can be one of the following: # 1. INSTALL_DB_SWONLY # 2. INSTALL_DB_AND_CONFIG # 3. UPGRADE_DB #------------------------------------------------------------------------------- oracle.install.option=INSTALL_DB_SWONLY #------------------------------------------------------------------------------- # Specify the hostname of the system as set during the install. It can be used # to force the installation to use an alternative hostname rather than using the # first hostname found on the system. (e.g., for systems with multiple hostnames # and network interfaces) #------------------------------------------------------------------------------- ORACLE_HOSTNAME=diamond_lab #------------------------------------------------------------------------------- # Specify the Unix group to be set for the inventory directory. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=dba #------------------------------------------------------------------------------- # Specify the location which holds the inventory files. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/oracle/product/11.2.0.1.0/oraInventory #------------------------------------------------------------------------------- # Specify the languages in which the components will be installed. # # en : English ja : Japanese # fr : French ko : Korean # ar : Arabic es : Latin American Spanish # bn : Bengali lv : Latvian # pt_BR: Brazilian Portuguese lt : Lithuanian # bg : Bulgarian ms : Malay # fr_CA: Canadian French es_MX: Mexican Spanish # ca : Catalan no : Norwegian # hr : Croatian pl : Polish # cs : Czech pt : Portuguese # da : Danish ro : Romanian # nl : Dutch ru : Russian # ar_EG: Egyptian zh_CN: Simplified Chinese # en_GB: English (Great Britain) sk : Slovak # et : Estonian sl : Slovenian # fi : Finnish es_ES: Spanish # de : German sv : Swedish # el : Greek th : Thai # iw : Hebrew zh_TW: Traditional Chinese # hu : Hungarian tr : Turkish # is : Icelandic uk : Ukrainian # in : Indonesian vi : Vietnamese # it : Italian # # Example : SELECTED_LANGUAGES=en,fr,ja #------------------------------------------------------------------------------ SELECTED_LANGUAGES=en #------------------------------------------------------------------------------ # Specify the complete path of the Oracle Home. #------------------------------------------------------------------------------ ORACLE_HOME=/oracle/product/11.2.0.1.0 #------------------------------------------------------------------------------ # Specify the complete path of the Oracle Base. #------------------------------------------------------------------------------ ORACLE_BASE=/oracle/product #------------------------------------------------------------------------------ # Specify the installation edition of the component. # # The value should contain only one of these choices. # EE : Enterprise Edition # SE : Standard Edition # SEONE : Standard Edition One # PE : Personal Edition (WINDOWS ONLY) #------------------------------------------------------------------------------ oracle.install.db.InstallEdition=EE #------------------------------------------------------------------------------ # This variable is used to enable or disable custom install. # # true : Components mentioned as part of 'customComponents' property # are considered for install. # false : Value for 'customComponents' is not considered. #------------------------------------------------------------------------------ oracle.install.db.isCustomInstall=false #------------------------------------------------------------------------------ # This variable is considered only if 'IsCustomInstall' is set to true. # # Description: List of Enterprise Edition Options you would like to install. # # The following choices are available. You may specify any # combination of these choices. The components you choose should # be specified in the form "internal-component-name:version" # Below is a list of components you may specify to install. # # oracle.rdbms.partitioning:11.2.0.1.0 - Oracle Partitioning # oracle.rdbms.dm:11.2.0.1.0 - Oracle Data Mining # oracle.rdbms.dv:11.2.0.1.0 - Oracle Database Vault # oracle.rdbms.lbac:11.2.0.1.0 - Oracle Label Security # oracle.rdbms.rat:11.2.0.1.0 - Oracle Real Application Testing # oracle.oraolap:11.2.0.1.0 - Oracle OLAP #------------------------------------------------------------------------------ oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0 ############################################################################### # # # PRIVILEGED OPERATING SYSTEM GROUPS # # ------------------------------------------ # # Provide values for the OS groups to which OSDBA and OSOPER privileges # # needs to be granted. If the install is being performed as a member of the # # group "dba", then that will be used unless specified otherwise below. # # # ############################################################################### #------------------------------------------------------------------------------ # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. #------------------------------------------------------------------------------ oracle.install.db.DBA_GROUP=dba #------------------------------------------------------------------------------ # The OPER_GROUP is the OS group which is to be granted OSOPER privileges. #------------------------------------------------------------------------------ oracle.install.db.OPER_GROUP=dba #------------------------------------------------------------------------------]]> Has anybody every installed Oracle software without using the OUI?

I use this command and it still tries to launch the OUI, how come.

./runInstaller -silent -noconfig -responsefile `pwd`/db_install.rsp


********************************************************************************
Your platform requires the root user to perform certain pre-installation
OS preparation. The root user should run the shell script 'rootpre.sh' before
you proceed with Oracle installation. rootpre.sh can be found at the top level
of the CD or the stage area.
Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.
********************************************************************************
Has 'rootpre.sh' been run by root? [y/n] (n)
y
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 190 MB. Actual 509 MB Passed
Checking swap space: must be greater than 150 MB. Actual 512 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-08-25_02-45-41PM. Please wait ...$ [INS-10103] Response file is not specified for this session.
Usage:
runInstaller [-options] [()*]


cat db_install.rsp ## Since I only want to install the software I left the
## rest of the values below as the defaults.

####################################################################
## Copyright(c) Oracle Corporation 1998,2008. All rights reserved.##
## ##
## Specify values for the variables listed below to customize ##
## your installation. ##
## ##
## Each variable is associated with a comment. The comment ##
## can help to populate the variables with the appropriate ##
## values. ##
## ##
## IMPORTANT NOTE: This file contains plain text passwords and ##
## should be secured to have read permission only by oracle user ##
## or db administrator who owns this installation. ##
## ##
####################################################################
#------------------------------------------------------------------------------
# Do not change the following system generated value.
#------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
#------------------------------------------------------------------------------
# Specify the installation option.
# It can be one of the following:
# 1. INSTALL_DB_SWONLY
# 2. INSTALL_DB_AND_CONFIG
# 3. UPGRADE_DB
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY
#-------------------------------------------------------------------------------
# Specify the hostname of the system as set during the install. It can be used
# to force the installation to use an alternative hostname rather than using the
# first hostname found on the system. (e.g., for systems with multiple hostnames
# and network interfaces)
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME=diamond_lab
#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=dba
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/oracle/product/11.2.0.1.0/oraInventory

#-------------------------------------------------------------------------------
# Specify the languages in which the components will be installed.
#
# en : English ja : Japanese
# fr : French ko : Korean
# ar : Arabic es : Latin American Spanish
# bn : Bengali lv : Latvian
# pt_BR: Brazilian Portuguese lt : Lithuanian
# bg : Bulgarian ms : Malay
# fr_CA: Canadian French es_MX: Mexican Spanish
# ca : Catalan no : Norwegian
# hr : Croatian pl : Polish
# cs : Czech pt : Portuguese
# da : Danish ro : Romanian
# nl : Dutch ru : Russian
# ar_EG: Egyptian zh_CN: Simplified Chinese
# en_GB: English (Great Britain) sk : Slovak
# et : Estonian sl : Slovenian
# fi : Finnish es_ES: Spanish
# de : German sv : Swedish
# el : Greek th : Thai
# iw : Hebrew zh_TW: Traditional Chinese
# hu : Hungarian tr : Turkish
# is : Icelandic uk : Ukrainian
# in : Indonesian vi : Vietnamese
# it : Italian
#
# Example : SELECTED_LANGUAGES=en,fr,ja
#------------------------------------------------------------------------------
SELECTED_LANGUAGES=en
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#------------------------------------------------------------------------------
ORACLE_HOME=/oracle/product/11.2.0.1.0
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#------------------------------------------------------------------------------
ORACLE_BASE=/oracle/product
#------------------------------------------------------------------------------
# Specify the installation edition of the component.
#
# The value should contain only one of these choices.
# EE : Enterprise Edition
# SE : Standard Edition
# SEONE : Standard Edition One
# PE : Personal Edition (WINDOWS ONLY)
#------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE
#------------------------------------------------------------------------------
# This variable is used to enable or disable custom install.
#
# true : Components mentioned as part of 'customComponents' property
# are considered for install.
# false : Value for 'customComponents' is not considered.
#------------------------------------------------------------------------------
oracle.install.db.isCustomInstall=false
#------------------------------------------------------------------------------
# This variable is considered only if 'IsCustomInstall' is set to true.
#
# Description: List of Enterprise Edition Options you would like to install.
#
# The following choices are available. You may specify any
# combination of these choices. The components you choose should
# be specified in the form "internal-component-name:version"
# Below is a list of components you may specify to install.
#
# oracle.rdbms.partitioning:11.2.0.1.0 - Oracle Partitioning
# oracle.rdbms.dm:11.2.0.1.0 - Oracle Data Mining
# oracle.rdbms.dv:11.2.0.1.0 - Oracle Database Vault
# oracle.rdbms.lbac:11.2.0.1.0 - Oracle Label Security
# oracle.rdbms.rat:11.2.0.1.0 - Oracle Real Application Testing
# oracle.oraolap:11.2.0.1.0 - Oracle OLAP
#------------------------------------------------------------------------------
oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk: 11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0, oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraola p:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracl e.rdbms.rat:11.2.0.1.0
###############################################################################
# #
# PRIVILEGED OPERATING SYSTEM GROUPS #
# ------------------------------------------ #
# Provide values for the OS groups to which OSDBA and OSOPER privileges #
# needs to be granted. If the install is being performed as a member of the #
# group "dba", then that will be used unless specified otherwise below. #
# #
###############################################################################
#------------------------------------------------------------------------------
# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.DBA_GROUP=dba
#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
#------------------------------------------------------------------------------
oracle.install.db.OPER_GROUP=dba
#------------------------------------------------------------------------------ ]]> Oracle Database Administration BeefStu http://www.dbasupport.com/forums/showthread.php?t=61359 http://www.dbasupport.com/forums/showthread.php?t=61354&goto=newpost Tue, 24 Aug 2010 10:01:29 GMT Hi,

When I query the view dba_users, the expiry_date column shows empty for few users.
Also, for few users the account_status shows "open" but the expiry_date is of 2008/2009.

Could someone please explain the reasons for the above two observations?

Thanks in advance, ]]> Oracle Database Administration getnami http://www.dbasupport.com/forums/showthread.php?t=61354