ORA-01034 when configuring Oracle database on Linux


Friday
18 April, 2014
2300 Hits

ORA-01034 when configuring Oracle database on Linux

Oracle Technology

As we all know Oracle database is the most popular and widely used Relational Database Management System (RDBMS) in the world. This post describes few steps that can assist a user having issue configuring Oracle Database 11g on Linux.

After installation, when you try to run

/etc/init.d/oracle-xe configure

it throws an error Database configuration failed and you are advised to check the logs but logs just shows ORA-01034: ORACLE not available

If you have the above error while configuring your Oracle database, it might be due to the information in the hosts file (/etc/hosts).

You need to login as the root user or you use sudo/su to switch account to root and make changes to the file to add the servers name and/or IP to the /etc/hosts file

127.0.0.1 localhost <fully qualified hostname> localhost4.localdomain4
::1 localhost <fully qualified hostname> localhost6.localdomain6

Now you need to restart networking on the server to make sure that changes will be persistent on reboot.

[root@oracle]# /etc/init.d/network restart

After restarting, run the command to configure you database... Yeepi!!!

Database configured and ready to accept request.

  

This blog's content is intended solely for informational purposes. While every effort is made to ensure accuracy, completeness, and relevance, the information may not be current or applicable in all situations. The opinions expressed are solely those of the author and do not reflect the views of any organization they may be affiliated with.