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 […]
Author Archives: markcallen
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 […]
OID Query to get Portal Password
To query OID you can use ldapsearch that comes with oracle. If you want to get the Portal password for you Oracle Portal installation you can issues the following from the command line: ldapsearch -v -D “cn=orcladmin” -w “orcladminpassword” -h host -p 389 -s sub -b “cn=IAS Infrastructure Databases, cn=IAS, cn=Products, cn=OracleContext” “orclresourcename=PORTAL” orclpasswordattribute
Oracle ESB Web Service Returns a java.security.PrivilegedActionException
When sending information to a ESB Web Service a java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection refused is returned. Problem If you try and access a ESB webservice on a webserver other than localhost and port 8888 the following error message is returned and the ESB flow is not run: java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection […]
Oracle XE Client Connection String
Oracle XE Client does not come with sqlnet therefore you need to connect to the database using a connection string. Oracle XE Connection String username/password@[//]host[:port][/service_name] port is required if the port number is not 1521. service_name defaults to XE.