Database can't extent an index. ProblemORA-01654: unable to extend index SYS.I_FILE#_BLOCK# by 128 in tablespace SYSTEM SolutionCheck 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'

Some standard recovery scenarios Deleted or Corrupted DatafileIf 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

The oracle account that is created by the Oracle XE installer isn't very helpful. Setup BashLog 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_

Unable to access Oracle Collaboration Suite Content Services due to a ORA-12705: invalid or unknown NLS parameter value specified ProblemWhen 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

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

When sending information to a ESB Web Service a java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection refused is returned. ProblemIf 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

Oracle XE Client does not come with sqlnet therefore you need to connect to the database using a connection string. Oracle XE Connection Stringusername/password@[//]host[:port][/service_name] * port is required if the port number is not 1521. * service_name defaults to XE.

Unable to startup the database due to ORA-19809: limit exceeded for recovery files ProblemThe database will not mount when started SQL> startup ORACLE instance started. Total System Global Area  608174080 bytes Fixed Size                  1263200 bytes Variable Size             406849952 bytes Database Buffers          192937984 bytes Redo Buffers                7122944 bytes Database mounted.

When sending information to a ESB Web Service a java.security.PrivilegedActionException: javax.xml.soap.SOAPException: Message send failed: Connection refused is returned. ProblemIf 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

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. The problemThe timezones have been updated within the database. SolutionAs Oracle run: $ORACLE_HOME/bin/emctl resetTZ agent and follow the instructions.

Oracle XE Client does not come with sqlnet therefore you need to connect to the database using a connection string. Oracle XE Connection Stringusername/password@[//]host[:port][/service_name] * port is required if the port number is not 1521. * service_name defaults to XE.

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. ProblemNeed to view messages on a JMS Queue or Topic that you have published

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. ProblemAfter creating an ESB process you are unable to write to a JMS topic.  The following error message is displayed in the ESB

The Oracle database is in the process of initializing or shutting down. Typically this occurs when the database service is in the process of starting or stopping. ResolutionWait for the database service to start.  If it does not start check the database alert.log to see what the underlying issue

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. Resolution Start the Oracle Database Windows start the OracleServiceXE service. Linux login as oracle and run dbstart. Test TNSTo test TNS run tnsping on

Oracle XE is an excellent starter database, but under normal loads the out of the box parameters need to be increased. Database SessionsIncrease the number of sessions that the database can handle at one time.  This will allow for more users to access the database. sqlplus /nolog SQL> show

For the oracle database Enterprise Manager (EM) runs on port 1158. But it needs to be started by itself. LinuxLogin as oracle and run: $ORACLE_HOME/bin/emctl start dbconsole On some systems a xserver session needs to be running for the graphs to be created correctly.  The best solution

After installing Oracle XE you should setup backups. Backups for XEFor Oracle XE there is ready a backup script that uses Oracle's RMAN. Setup Archive Log ModeAfter installing the database change it to archivelog mode: [oracle@localhost ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 -

Test to see if a user is already in OID The following java code checks to see if there is a user in OID, returning true if they are there. import oracle.ldap.util.*; import oracle.ldap.util.jndi.; import java.io.; import java.util.; import javax.naming.; import javax.

With the production version of Oracle XE the default is to not allow remote access to the web server.  This sometimes causes even local access to not work.  To fix run the following as sys: exec dbms_xdb.setListenerLocalAccess(false); Access to the web server will now be enabled.

How to create a VMware virtual machine to run Oracle Enterprise Linux using VMware Workstation 6. Startup VMware Workstation 6.Go to File -> New -> Virtual MachineClick Next Select Custom Select Workstation 5 * this is required if you are going to run the VM under VMware Server