thewellington

/* Set Oracle to prevent password form expiring */
alter profile default limit password_life_time unlimited;

thewellington

/* shows the account status of every user */
select username, account_status, expiry_date, sysdate, profile from dba_users;

/* shows the account status of a specific user */
select username, account_status, expiry_date, sysdate, profile from dba_users where username='username'

thewellington

#!/bin/bash
#
# Change Linux kernel parameters prior to installing Oracle 11g R2 on RHEL 6.3
# v2.0 by bwellington@fulcrum.net 2012.11.20
#


f='/etc/sysctl.conf'

# Get Total Memory in KB

thewellington

binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5

thewellington

#!/bin/bash
#
# wlsndm startup script for node manager
#
# chkconfig: - 75 15
# description: weblogic
# processname: WLSADMIN

# Source function library
. /etc/rc.d/init.d/functions

thewellington

select 'orcl', sample_hour, (rps+wps) IOPS
from ( 
with snaps as (
select hiof1.snap_id, sum(hiof1.value) reads, sum(hiof2.value) writes
from sys.WRH$_SYSSTAT HIOF1, sys.WRH$_SYSSTAT HIOF2
where HIOF1.stat_id in (select stat_id from v$statname where name like '%physical read total IO%')
  and HIOF2.stat_id in (select stat_id from v$statname where name like '%physical write total IO%')
  and HIOF1.snap_id=hiof2.snap_id
group by hiof1.snap_id
),

thewellington

## .screenrc  ##

startup_message off

sorendition 00 07


# Tab bar

hardstatus off

thewellington

`/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/XProtect.meta.plist`

thewellington

# inittab is only used by upstart for the default runlevel.
#
# ADDING OTHER CONFIGURATION HERE WILL HAVE NO EFFECT ON YOUR SYSTEM.
#
# System initialization is started by /etc/init/rcS.conf
#
# Individual runlevels are started by /etc/init/rc.conf
#
# Ctrl-Alt-Delete is handled by /etc/init/control-alt-delete.conf
#

thewellington

alter user USERNAME account unlock;