http://rami.info Whatever goes... AtWork, AtHome, or just AtWherever... Wed, 02 Jul 2008 09:23:32 +0000 http://backend.userland.com/rss092 en Change the new user's default tablespace to the new tablespace: alter user scott default tablespace newspace; Revoke the unlimited tablespace and change the new user's quota to have space only on the new tablespace: revoke unlimited tablespace from scott; alter user scott quota unlimited on newspace quota 0 on oldspace; Do the import. http://rami.info/2007/03/18/importing-an-oracle-schema-into-a-different-tablespace/ Generate the CA key: openssl genrsa -des3 -out ca.key 1024 Generate the CA certificate: openssl req -new -key ca.key -x509 -days 1095 -out ca.crt Generate the IIS certificate by using the CSR generated from IIS: openssl x509 -req -days 1095 -in certreq.txt -CA ca.crt -CAkey ca.key -CAcreateserial -out cer.crt Export the CA certificate to DER encoded ... http://rami.info/2007/03/09/generating-a-self-signed-certificate-for-iis/ When getting an error like: In file included from /usr/include/sys/signal.h:34, from /usr/include/signal.h:26, from /usr/local/lib/perl5/5.8.7/sun4-solaris/CORE/unixish.h:106, from /usr/local/lib/perl5/5.8.7/sun4-solaris/CORE/perl.h:2220, from u32align.c:10: /usr/include/sys/siginfo.h:259: error: parse error before "ctid_t" /usr/include/sys/siginfo.h:292: error: parse error before '}' token /usr/include/sys/siginfo.h:294: error: parse error before '}' token /usr/include/sys/siginfo.h:390: error: parse error before "ctid_t" /usr/include/sys/siginfo.h:392: error: conflicting types for `__proc' /usr/include/sys/siginfo.h:261: error: previous declaration of `__proc' /usr/include/sys/siginfo.h:398: error: conflicting types for `__fault' /usr/include/sys/siginfo.h:267: ... http://rami.info/2006/08/09/solving-system-headers-problems-when-using-sunfreewarecoms-gcc/ To install Oracle 10g on Solaris 10 do the following: Add the SUNWi15cs and the SUNWi1cs packages. Create the needed groups: groupadd -g 100 oinstall groupadd -g 101 dba Create the oracle user: useradd -u 100 -g 100 -G 101 -d /data/oracle -m -s /bin/tcsh oracle Create the oracle project: projadd oracle Edit /etc/user_attr and add the ... http://rami.info/2006/08/07/10-on-10/ 1. Find the device names of the source and destination drives: format < /dev/null 2. run the following sh script: SRC=c0t0d0 DEST=c0t1d0 MOUNTDIR=/clone SLICES="s0 s1 s2 s3 s4" mkdir ${MOUNTDIR} prtvtoc /dev/rdsk/${SRC}s2 > /tmp/vtoc fmthard -s /tmp/vtoc /dev/rdsk/${DEST}s2 installboot /usr/platform/`uname -i`/lib/fs/ufs/bootblk /dev/rdsk/${DEST}s2 # OR installboot /usr/platform/`uname -i`/lib/fs/ufs/bootblk /dev/rdsk/${DEST}s0 for i in $SLICES; do newfs /dev/dsk/${DEST}${i} ... http://rami.info/2006/05/15/cloning-a-drive-under-solaris/ In order to update Solaris 10 with the latest OS updates the following is needed to be done: 1. Create a file /tmp/registration.properties with the following: userName=sunusername password=sunpassword hostName= subscriptionKey= portalEnabled=false proxyHostName= proxyPort= proxyUserName= proxyPassword= 2. Run the following command: sconadm register -a -r /tmp/registration.properties 3. To perform the update do the following: smpatch update http://rami.info/2006/05/15/updating-solaris-10/ To run java code from oracle do the following: 1. Create the java code on the server: CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "hello" AS public class hello { public static String world() { return "Hello World"; } } / 2. Create the oracle function on the server: CREATE OR REPLACE FUNCTION hellofunction RETURN VARCHAR2 AS LANGUAGE JAVA NAME ... http://rami.info/2006/03/19/calling-java-code-from-oracle/ Update root.cache or named.ca files for DNS servers using the following command: dig @a.root-servers.net. . ns UPDATE: a better command: dig +bufsize=1200 +norec NS . @a.root-servers.net > /var/named/named.root [Link] http://rami.info/2006/03/15/rootcache-update/   And it's from my wife :o) http://rami.info/2006/03/08/look-at-what-ive-got/ PHP has builtin functions for urlencode and urldecode functions but for perl I've found the following from HERE that does the same thing: sub URLDecode { my $theURL = $_[0]; $theURL =~ tr/+/ /; $theURL =~ s/%([a-fA-F0-9]{2,2})/chr(hex($1))/eg; $theURL =~ ... http://rami.info/2005/11/19/urlencode-and-urldecode-for-perl/