quarta-feira, 25 de agosto de 2010

Find the top 10 larger files in the Directory

$ls -lrt | awk '{print $5,$9}' | sort -nr head | xargs ls -lrt

Check if the installed Oracle Software is 32/64

Go to ORACLE_HOME/bin
$ file oracle
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

Or

select metadata from sys.kopm$ ;

If the output has 'B023' string then the database is 32 bit else if it is B047 then it is 64 bit

quinta-feira, 12 de agosto de 2010

pam_limits.so setting for 64-bit Linux

Removing the hardcoded path allows the OS to choose the correct pam_limits.so

/etc/pam.d/login
session required pam_limits.so


DOC ID 301665.1

terça-feira, 10 de agosto de 2010

Problem with Oracle Web Services Manager login

Change default password admin OWSM

cd $ORACLE_HOME/owsm/bin

vi manageUserGroups.properties

user_id=admin
user_name=admin user
user_password={PASSWORD}
user_email=wsmadmin@xxxx.xxx


group_id=su1-grp
group_desc=super user group


./wsmadmin.sh manageUserGroups deleteUserGroup

./wsmadmin.sh manageUserGroups deleteUser

./wsmadmin.sh manageUserGroups addUser

./wsmadmin.sh manageUserGroups addUserGroup



see the $ORACLE_HOME/j2ee/oc4j_soa/log/ccore.log

segunda-feira, 9 de agosto de 2010

Oracle APEX Listener

http://www.oracle.com/technology/products/database/application_express/apex_listener/apex_listener.html