14 C
Vancouver
Wednesday, April 17, 2024

RMAN: Use CROSSCHECK command to fix status

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...

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...

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...

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...

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...

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...

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...

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...

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 is...

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...

Latest news