Sponsored Content
Operating Systems AIX AIX SP update and Oracle interaction Post 302914082 by allenhibbert on Thursday 21st of August 2014 07:03:24 PM
Old 08-21-2014
Thank you both for the information. I understand the concept, the procedure sounds straight forward. Knowing what is done behind the scenes is always desired, thanks for that.
Most of my background is with AIX, then some years with RHEL as well. My AIX background was mostly in a small shop, 3 stand alone systems. I am now in a sizeable shop, 2,000+ systems, with exposure to greater depth of the technology.
I'll try out the alternate disk update on one of the next test systems up for SP9. I'll post back how it went.
Thanks again
 

4 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

update a oracle table using shell script

Hi, I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure) While the command is running,I am able to view the log file created in the Unix machine.After the command... (2 Replies)
Discussion started by: ann_124
2 Replies

2. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

Hi, I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies

3. UNIX for Advanced & Expert Users

oracle update not working

Hi, I have a oracle source with a field my_date =06/02/2009 I am trying to update the table to SYSDATE with a myscript.sql where I have UPDATE table set my_date=to_DATE(SYSDATE,'MM/DD/YYYY'); Now I try to run it with myupdate.SH script where I have sqlplus nolog @myscript.sql ... (4 Replies)
Discussion started by: RubinPat
4 Replies

4. Shell Programming and Scripting

How to update a Oracle table through shell scripting?

My Code is get_week_date() { `sqlplus -s ${DQM_SQL_LOGON}@${DQM_SID} << EOF SET ECHO OFF SET FEEDBACK OFF SET PAGES 0 SET SERVEROUTPUT ON SET VERIFY OFF SET TRIMSPOOL ON (update file_level_qc fq set FQ.DATA_FILE_NAME='Hyvee_Pharmacy_Solutions_201304_v1.txt'... (2 Replies)
Discussion started by: karthick.cho
2 Replies
quotacheck(1M)						  System Administration Commands					    quotacheck(1M)

NAME
quotacheck - ufs file system quota consistency checker SYNOPSIS
quotacheck [-fp] [-v] filesystem... quotacheck -a [-fpv] DESCRIPTION
quotacheck examines each mounted ufs file system, builds a table of current disk usage, and compares this table against the information stored in the file system's disk quota file. If any inconsistencies are detected, both the quota file and the current system copy of the incorrect quotas are updated. filesystem is either a file system mount point or the block device on which the file system resides. quotacheck expects each file system to be checked to have a quota file named quotas in the root directory. If none is present, quotacheck will not check the file system. quotacheck accesses the character special device in calculating the actual disk usage for each user. Thus, the file systems that are checked should be quiescent while quotacheck is running. OPTIONS
The following options are supported: -a Check the file systems which /etc/mnttab indicates are ufs file systems. These file systems must be read-write mounted with disk quotas enabled, and have an rq entry in the mntopts field in /etc/vfstab. -f Force check on file systems with logging enabled. Use in combination with the -p option. -p Check quotas of file systems in parallel. For file systems with logging enabled, no check is performed unless the -f option is also specified. -v Indicate the calculated disk quotas for each user on a particular file system. quotacheck normally reports only those quotas modi- fied. USAGE
See largefile(5) for the description of the behavior of quotacheck when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes). FILES
/etc/mnttab Mounted file systems /etc/vfstab List of default parameters for each file system ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ SEE ALSO
edquota(1M), quota(1M), quotaon(1M), repquota(1M), attributes(5), largefile(5), quotactl(7I), mount_ufs(1M) SunOS 5.10 31 Jul 1998 quotacheck(1M)
All times are GMT -4. The time now is 05:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy