Subscribe

Subscribe

Vladstudio

Changeing an Oracle database character set

  1. Check what character set you are using at the moment.
    SQL> select value from v$nls_parameters where parameter='NLS_CHARACTERSET';
  2. Shutdown the database.
    SQL> shutdown immediate;
  3. Startup in mount mode.
    SQL> startup mount;
  4. Restrict the database.
    SQL> alter system enable restricted session;
  5. Check the current job_queue_processes setting.
    SQL> show parameter job_queue_processes;
  6. Set it to 0 for now.
    SQL> alter system set job_queue_processes=0;
  7. Open the database.
    SQL> alter database open;
  8. Change the character set
    SQL> alter database character set WE8MSWIN1252;
  9. Restart the database.
    SQL> shutdown immediate;
    SQL> startup;
  10. Check the job_queue_processes setting.
    SQL> show parameter job_queue_processes;
  11. Check the character setting is the new value.
    SQL> select value from v$nls_parameters where parameter='NLS_CHARACTERSET';
  12. If necessary, change the job_queue_processes back to what it was.
    SQL> alter system set job_queue_processes=10;
  13. Restart the database.
    SQL> shutdown immediate;
    SQL> startup;
Bookmark and Share

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
Bookmark and Share

Prtdiag is Not working in Solaris

Try running it as root.
If this works then check the permisions on /var/run/picld_door

The permisions should be set to 444
ie:

ls -l /var/run/picld_door
Dr--r--r--   1 root     root           0 Aug 27 07:40 /var/run/picld_door

This is the fix:

shell> chmod 444 /var/run/picld_door
Bookmark and Share

Batch Picture Resize

A good program to resize a bunch of photos all at once.

How you set the options is a bit odd, you rename the execuatable file, but otherwise a good program.

Batch Picture Resize

There is a “Renaming Wizard” of the site to show you how to rename the file to get different outputs.

Bookmark and Share

Recording from TV to watch later

Here’s a few Q&As on time-shifting: recording from TV to watch later from the Australian Copyright Council. Its an interesting read, if you’re concerned about copyright law. Which we all should be.

Bookmark and Share