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 […]

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 […]