Category Archives: Oracle

ORA-27121: unable to determine size of shared memory segment

If when you are trying to login to Oracle 10G on linux you get : ORA-01034: ORACLE not available ORA-27121: unable to determine size of shared memory segment Linux Error: 13: Permission denied This is caused by Oracle installer not setting setuid on $ORACLE_HOME/bin/oracle. To fix do: $ cd $ORACLE_HOME/bin $ chmod 6751 oracle via… Read More »

Grid Control access to a Windows server

If you are trying to get Grid Control to access a Windows server and having trouble here’s a few things to check. Check that the host name credentials you are providing are the same as the user who install the database software on the Windows server. Check that the user is a member of the… Read More »

Managing Oracle RMAN backups

Every now and again something will go screwy with my automatic RMAN backups and I’ll to find any that are expired or obsolete and delete them manually.

Show Oracle Database DBID

The database ID or DBID is a unique identification number computed when the database is created. To find out this number, you can either: 1) Login to RMAN,  it will display the DBID upon connection to the target database.     e.g. shell> rman target / or 2) You can obtain the DBID by querying V$DATABASE    eg. … Read More »

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>… Read More »

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