What to do when an obsolete rman object can’t be found. Environment Make sure ORACLE_HOME, ORACLE_SID and PATH are set correctly – rman also comes with X11R6 so make sure that ORACLE_HOME/bin is first in your PATH Log Into RMAN rman target / Find the mismatched objects RMAN> delete noprompt obsolete; RMAN retention policy will […]
Category Archives: Oracle
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 […]
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 […]
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 […]
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.
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 […]