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
$ 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
/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
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