28. September 2011

Oracle 11G XE Installation error: Database Configuration failed

While running the oracle configuration after installation:

/etc/init.d/oracle-xe configure

 the following error specified:

Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

After looking inside the log file /u01/app/oracle/product/11.2.0/xe/config/log/CloneRmanRestore.log you can see an error which looks like:

 ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=oralinux)(PORT=1521))'

The hostname "oralinux" cannot be found because it is not registered inside the dns-server. You can simply add an /etc/hosts file:

127.0.0.1 oralinux

After saving the file, rerun "/etc/init.d/oracle-xe configure" and everything should be fine.

10. September 2011

Oracle - Error - ORA-00257: archiver error. Connect internal only, until freed.

The problem was that the harddisk space ist full and oracle has no space to create new archivelogs. I am removing the obsolete archive logs to regain the space.

First of all I remove all the archive-logs from harddisk:

cd /u01/app/oracle/ORCL/archivelog/
rm -rf 2011_09_08 2011_09_09


Now the system utilities would tell you that all was great but the connect to oracle still tells you the same error. We have to remove the files from the oracle internal storage management. We need to connect via rman to our database:

rman
RMAN> connect target user/password

And now we instruct rman to check internal storage against the filesystem:

RMAN> crosscheck archivelog all;

He will flag all the archivelogs as "expired". Now we remove all the obsolete files from storage:

delete expired archivelog all;

Now the connect to oracle works fine.