Posts

Showing posts from January, 2011

mamange RPM

1> Remove multiple same rpm packages rpm -e --allmatches

ORA-01950: no privileges on tablespace

When imp the DB data, we might get error message: ORA-01950: no privileges on tablespace To sovle it: GRANT UNLIMITED TABLESPACE TO

Oracle EM Could be started

Check the hostname or IP address Check /etc/hosts & /etc/nsswitch.conf

Create Oracle tablespace

CREATE BIGFILE TABLESPACE "YFS" DATAFILE '+ASM_DATA' SIZE 200G AUTOEXTEND ON NEXT 10G MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

Recreate Oracle ASM password

Oracle ASM password must use pure alphanumerics. It will cuase some problems (i.e. emctl could not start) if not follow this rule. Here are steps to make emctl work: 1> Remove the old ASM password cd $GRID_HOME mv orapw+ASM orapw+ASM.orig 2> Create a new password orapwd file=orapw+ASM password= 3> Setup Env export ORACLE_SID=+ASM export ORACLE_HOME=$GRID_HOME 4> Create ASM User sqlplus / as sysasm create user asmsnmp identified by grant sysdba to asmsnmp; 5> Drop EMCA emca -deconfig dbcontrol db -repos drop 6> Create EMCA emca -config dbcontrol db -repos recreate /u01/app/grid/product/11.2.0/dbhome_1/dbs >emca -config dbcontrol db -repos recreate STARTED EMCA at Jan 11, 2011 4:18:47 PMEM Configuration Assistant, Version 11.2.0.0.2 ProductionCopyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information:Database SID: HPUX03 Listener port number: 1521 Listener ORACLE_HOME [ /u01/app/

Install SSL Certification

1> Create Private Key openssl genrsa -des3 -out server .key 2048 (make a note, the 1024 is no longer be used) 2> Create CSR (Certification Signing Request) openssl req -new -key server .key -out server .csr 3> Remove the passphase openssl rsa -in server.key -out server.key.insecure mv server.key server.key.secure mv server.key.insecure server.key 4> Request the SSL certification 5> Receive the SSL certification 6> Modify the mod_SSL to point the SSL private key, Intermdiate, and Certificate 7> Restart the apache example of san.cnf [root@wordpressord tls]# cat san.cnf [ req ] default_bits       = 2048 distinguished_name = req_distinguished_name req_extensions     = req_ext prompt = no [ req_distinguished_name ] countryName                 = US stateOrProvinceName         = <STATE> localityName               = <CITY> organizationName           = <COMPANY> commonName                 = <WEB NAME> [ req_ext ] subjectAltName =