Sp2-0750:you need to set Oracle_home to your ORACLE software directory

Log in to a server today with Roote users logged in, switch to the Oracle user, perform Sqlplus sys/as sysdba into the database prompted the following error:

Sp2-0750:you need to set Oracle_home to your ORACLE software directory

View files under the/home/oracle directory. Bash_profile, it is a hidden file.

$ cat. Bash_profile #. bash_profile# Get the aliases and Functionsif [-f ~/.BASHRC]; Then. ~/.bashrcfi# User specific environment and startup Programspath= $PATH: $HOME/binexport pathexport oracle_base=/u01/app/ Oracle Export oracle_home=/u01/app/oracle/product/11.1.0/db_1 Export oracle_sid=orclexport path= $ORACLE _home/bin:$ PATH export ld_library_path= $ORACLE _home/liblang=zh_cn. UTF-8; Export langnls_lang= ' simplified Chinese_china. Al32utf8 '; Export Nls_lang

[Email protected] ~]$ CD $ORACLE _home

-BASH:CD:/u01/app/oracle/product/11.1.0/db_1: No file or directory

The home directory where the Oracle installation definition is found is the root user's u01 directory in the/u01/app/oracle/product/11.1.0/db_1 directory, and the following command is executed when the root user is cut back:[[email  protected] ~]# cd  $ORACLE _home[[email protected] dbhome_1]# pwd/u01/app/oracle/ Product/11.2.0/dbhome_1[[email protected] dbhome_1]# sqlplus / as sysdba or [[ Email protected] dbhome_1]# cd bin[[email protected] dbhome_1]# pwd/u01/app /oracle/product/11.2.0/dbhome_1/bin[[email protected] bin]# ./sqlplus / as  sysdbasql*plus: release 11.2.0.4.0 production on thu oct 12 17:20:48  2017Copyright  (c)  1982, 2013, oracle.  all rights reserved. enter password: connected to:oracle database 11g enterprise edition  Release 11.2.0.4.0 - 64bit productionwith the partitioning, olap, data  mining and real&nbsP Application testing optionssql>

Problem Solving!

This article is from "Operation and maintenance record Mei Ling" blog, please be sure to keep this source http://meiling.blog.51cto.com/6220221/1971801

Sp2-0750:you need to set Oracle_home to your ORACLE software directory