Month: February 2010

Changeing an Oracle database character set

Check what character set you are using at the moment. SQL> select value from v$nls_parameters where parameter=’NLS_CHARACTERSET’; Shutdown the database. SQL> shutdown immediate; Startup in mount mode. SQL> startup mount; Restrict the database. SQL> alter system enable restricted session; Check the current job_queue_processes setting. SQL> show parameter job_queue_processes; Set it to 0 for now. SQL> […]

Using cpio

Some files that you get from Oracle download come in cpio format. Here’s what to do with them. First unzip the files: gunzip lnx_920_disk1.cpio.gz gunzip lnx_920_disk2.cpio.gz gunzip lnx_920_disk3.cpio.gz Next unpack the contents of the files: cpio -idmv < lnx_920_disk1.cpio cpio -idmv < lnx_920_disk2.cpio cpio -idmv < lnx_920_disk3.cpio