This generally indicates that your $ORACLE_HOME environment variable is not set so the sqlplus executable cannot...
be found. What you need to do before you create a new database is the following:
Edit /etc/oratab with the SID of the database you are going to create
Either run oraenv interactively to set your environment, or set it to run in your .profile when you log in. If you have more than one database on this server, it is preferable to run oraenv interactively.
The oraenv file gets copied to /usr/local/bin during an installation or Oracle software. This is so it can be executed without $ORACLE_HOME being set. To run oraenv …
It will ask you for a SID which you type in. Oraenv will then use the information in /etc/oratab to set the appropriate $ORACLE_HOME variable for that SID. After oraenv is run successfully, you should be able to see $ORACLE_HOME set:
For more information on how to set up your environment refer to the Oracle Database 10g Release 2 (10.2) Administrator's Reference for UNIX-Based Operating Systems.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
How many database instances can be created on an Oracle server with an installation drive containing 15 GB free space? Continue Reading