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

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

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

ORA-19809: limit exceeded for recovery files

Unable to startup the database due to ORA-19809: limit exceeded for recovery files Problem The 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. ORA-16038: log 3 sequence# 1933 […]