Oracle Articles

RMAN: Use CROSSCHECK command to fix status — by Mark Allen — last modified 2010-02-09 08:58

What to do when an obsolete rman object can't be found.

ORA-01654: unable to extend index — by Mark Allen — last modified 2008-09-17 23:50

Database can't extent an index.

ORA-19809: limit exceeded for recovery files — by Mark Allen — last modified 2008-09-11 08:26

Unable to startup the database due to ORA-19809: limit exceeded for recovery files

Oracle Backup and Recovery Scenarios — by Mark Allen — last modified 2008-05-26 14:37

Some standard recovery scenarios

Oracle XE Recovery — by Mark Allen — last modified 2008-05-26 09:03

How to recover an Oracle XE Backup

Oracle XE Backup — by Mark Allen — last modified 2008-05-25 21:58

After installing Oracle XE you should setup backups.

Oracle Enterprise Linux Virtual Machine Setup — by Mark Allen — last modified 2008-05-25 10:59

How to create a VMware virtual machine to run Oracle Enterprise Linux using VMware Workstation 6.

Setup Oracle XE Account on Linux — by Mark Allen — last modified 2008-05-25 01:31

The oracle account that is created by the Oracle XE installer isn't very helpful.

OID Query to get Portal Password — by Mark Allen — last modified 2008-04-15 23:47

 

OCS Content Services - ORA-12705: invalid or unknown NLS parameter value specified — by Mark Allen — last modified 2008-04-15 23:46

Unable to access Oracle Collaboration Suite Content Services due to a ORA-12705: invalid or unknown NLS parameter value specified

Oracle XE Client Connection String — by Mark Allen — last modified 2008-02-16 19:52

Oracle XE Client does not come with sqlnet therefore you need to connect to the database using a connection string.

ORA-20603: Updating timezone region of a target is not supported. — by Mark Allen — last modified 2008-02-16 19:52

Enterprise manager does not start after updating the database. The emdb.nohup has an ORA-20603: Updating timezone region of a target is not supported error message in it.

Viewing Oracle Application Server JMS Queues — by Mark Allen — last modified 2008-02-16 19:51

When developing BPEL and ESB applications it is necessary to see if the message you sent actually made it on the queue. Using Hermes is an excellent way to view an application server queues and topics.

Oracle ESB Web Service Returns a java.security.PrivilegedActionException — by Mark Allen — last modified 2008-02-16 19:51

When sending information to a ESB Web Service a java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection refused is returned.

ORA-19809: limit exceeded for recovery files — by Mark Allen — last modified 2008-02-16 19:51

How to increase the amount of space for backups and archive log files.

Starting Oracle Enterprise Manager — by Mark Allen — last modified 2008-02-16 19:50

For the oracle database Enterprise Manager (EM) runs on port 1158. But it needs to be started by itself.

Changing JMS Connection Password in Oracle SOA Suite — by Mark Allen — last modified 2008-02-16 19:50

By default the the password for eis/Jms/TopicConnectionFactory JMS Connection is welcome1. This needs to be changed if the oc4jadmin password is not set to this.

Oracle XE Tuning — by Mark Allen — last modified 2008-02-16 19:50

Oracle XE is an excellent starter database, but under normal loads the out of the box parameters need to be increased.

Checking for a User in OID — by Mark Allen — last modified 2008-02-16 19:49

Test to see if a user is already in OID

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor — by Mark Allen — last modified 2008-02-16 19:49

The database trying to be connected to is not running. Ensure the Oracle database is running and that the TNS entry you are using is correct.