Looking for ISOs for Windows. Used the Windows 7 x64 Professional without a problem. http://www.heidoc.net/joomla/technology-science/microsoft/14-windows-7-direct-download-links
Author Archives: markcallen
RMAN: Use CROSSCHECK command to fix status
What to do when an obsolete rman object can’t be found. Environment Make sure ORACLE_HOME, ORACLE_SID and PATH are set correctly – rman also comes with X11R6 so make sure that ORACLE_HOME/bin is first in your PATH Log Into RMAN rman target / Find the mismatched objects RMAN> delete noprompt obsolete; RMAN retention policy will […]
ORA-01654: unable to extend index
Database can’t extent an index. Problem ORA-01654: unable to extend index SYS.I_FILE#_BLOCK# by 128 in tablespace SYSTEM Solution Check the size and maxsize of the data files in the SYSTEM tablespace select file_name, bytes, autoextensible, maxbytes from dba_data_files where tablespace_name=’SYSTEM’; Increase the size of the data file; alter database datafile ‘<Path to data file>’ resize […]
Fixing SELinux Content in a HTML directory
Unable to access web files in a directory under the /var/www/html becuase of a 403 forbidden might be a context problem. Problem Getting a 403 forbidden error message when accessing a new file or directory in /var/www/html. Check /var/log/messages to see if there are any: Sep 13 13:11:28 fserver02 kernel: audit(1221336688.892:14): avc: denied { getattr […]
Oracle XE Recovery
How to recover an Oracle XE Backup First make sure the database is in archive log mode and running backups on a daily basis. See Oracle XE Backup for instructions on how to do this. Reverting to a Previous Backup If something has gone wrong with the database, such as deleting or corrupting a database file, and […]
Oracle Backup and Recovery Scenarios
Some standard recovery scenarios Deleted or Corrupted Datafile If a database datafile in the $ORACLE_HOME/oradata/XE is deleted then the database will no longer open. It is not possible to recover just the datafile from a backup since it will be out of sync with the other datafiles and data will have been lost. If the […]
Setting up VNCServer
How to setup vncserver on a linux machine to run gnome or kde. Initialize Startup vncserver for the first time on port 5910 (:10) and set the password. [root@localhost ~]# vncserver :10 You will require a password to access your desktops. Password: Verify: xauth: creating new authority file /root/.Xauthority New ‘localhost.localdomain:10 (root)’ desktop is localhost.localdomain:10 […]
Setup Oracle XE Account on Linux
The oracle account that is created by the Oracle XE installer isn’t very helpful. Setup Bash Log into the system as root and su to oracle #su – oracle Copy over the bash files from the /etc/skel directory cp /etc/skel/.bash* . Edit .bash_profile and add ORACLE_HOME, ORACLE_SID and add $ORACLE_HOME/bin to PATH vi .bash_profile export […]
Sending all requests from http to https
Add the following lines to the VirtualHost directive: RewriteEngine on # Redirect any traffic to https RewriteRule ^/(.*)$ https://%{HTTP_HOST}/$1 [L,R]
OCS Content Services – ORA-12705: invalid or unknown NLS parameter value specified
Unable to access Oracle Collaboration Suite Content Services due to a ORA-12705: invalid or unknown NLS parameter value specified Problem When going to http://servername:port/content/app you get a http 503 error. The log file <mid-tier>/j2ee/OC4J_Content/application-deployments/content/OC4J_Content_default_island_1 has the following error message: java.sql.SQLException: ORA-12705: invalid or unknown NLS parameter value specified Solution Change the IFS.SERVICE.JDBC.DriveType to thin for […]