you may need to set oracle home,[转]sqlplus /nolog 出错解决 SP2-0667: Message file sp1<lang>.msb not foun...

Resolving SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

If you set up Oracle Database XE 11G in Linux and you encounter the following error when starting up SQL Plus:

$ sqlplus

SP2-0667: Message file sp1.msb not found

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

To resolve it try the following. It's assumed Oracle XE 11G is installed at:

/u01/app/oracle/product/11.2.0/xe/

If you have a different set up, adjust your directory path accordingly.

1) Find out the path to sqlplus

bash-3.2$ which sqlplus

/u01/app/oracle/product/11.2.0/xe/bin/sqlplus

2) Set your Oracle_HOME (upto xe directory)

bash-3.2$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe/

3) Set the path to the directory where sqlplus is located to your PATH variable:

bash-3.2$ export PATH=/u01/app/oracle/product/11.2.0/xe/bin:$PATH

You should now be able to use sqlplus.

4) Now you need to edit you bash_profile so all these takes effect everytime you log in.

bash-3.2$ cd ~/

bash-3.2$ vim .bash_profile

5) In the .bash_profile you will need to add those export lines so every time you log in the same settings take effect.

bash-3.2$ vim .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

ORACLE_SID=XE

export ORACLE_SID

ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe

export ORACLE_HOME

PATH=$ORACLE_HOME/bin:$PATH

export PATH

unset USERNAME

6) Run the following:

bash-3.2$ . .bash_profile

After following these 6 steps you should be able to connect to sqlplus any time.

Oracle11g - dos 命令 sqlplus&sol;nolog 提示 不是内部命令解决办法

继安装Oracle 11g后,解锁SCOtt时发现 dos 命令 sqlplus/nolog 提示 不是内部命令解决办法   通过实际验证现整理有效方法步骤如下: 步骤一:开始>>找到Or ...

RHEL6&period;5安装成功ORACLE11GR2之后，编写PROC程序出错解决方法

1.  proc: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: N ...

make menuconfig出错解决方法

make menuconfig出错解决方法 2011-06-11 22:22:49 分类: 系统运维 错误现象: make menuconfig In file included from scri ...

vs连接mysql出错解决方法

vs连接mysql出错解决方法 先按以下的步骤配置一下: **- (1)打开VC6.0 工具栏Tools菜单下的Options选项.在Directories的标签页中右边的"Show dir ...

paip&period;vs2010 或&period;net 4&period;0安装出错解决大法&period;

paip.vs2010 或.net 4.0安装出错解决大法. 作者Attilax ,  EMAIL:1466519819@qq.com  来源:attilax的专栏 地址:http://blog.cs ...

黄聪：C&num;使用Application&period;Restart重启程序出错解决办法

调用 Application.Restart重启程序出错 解决办法,就是给程序的.exe文件,加上下面的设置

&dollar; sudo python -m pip install pylint 出错解决方法

问题:在unbuntu执行$ sudo python -m pip install pylint出错解决方法支行以下命令sudo pip install pylint==1.9.3这样roboware ...

npm中npm install 始终出错解决办法

npm中npm install 始终出错解决办法 错误信息: C:\Windows\System32>npm install -g gulp npm ERR! Windows_NT 6.1.76 ...

&dollar; gulp watch 运行出错解决方法

$ gulp watch 运行出错解决方法   $ gulp watch     如果你出现了如下报错信息: gulp-notify: [Laravel Elixir] Browserify Fail ...

随机推荐

java 四舍五入 保留俩位小数

public static void main(String[] args) {              String str="0";              BigDeci ...

请不要用SECONDS&lowbar;BEHIND&lowbar;MASTER来衡量MYSQL主备的延迟时间

链接:http://www.woqutech.com/?p=1116 MySQL 本身通过 show slave status 提供了 Seconds_Behind_Master ,用于衡量主备之间的 ...

拦截API 注入进程

本文详细的介绍了在Visual Studio(以下简称VS)下实现API钩子的编程方法,阅读本文需要基础:有操作系统的基本知识(进程管理,内存管理),会在VS下编写和调试Win32应用程序和动态链接库 ...

Numpy入门 - 数组基本运算

本节主要讲解numpy数组的基本运算,包括两数组相加.相减.相乘和相除. 一.两数组相加add import numpy as np arr1 = np.array([[1, 2, 3], [4, 5 ...

vue enter事件无效，加入native

python Django 中间件介绍

我们一直都在使用中间件,只是没有注意到而已,打开Django项目的Settings.py文件,看到下面的MIDDLEWARE配置项,django默认自带的一些中间件: MIDDLEWARE = [ ' ...

E - Reachability from the Capital

E - Reachability from the Capital  CodeForces - 999E 题目链接:https://vjudge.net/contest/236513#problem/ ...

selenium 获取input输入框中的值的方法

方法一:获取input的文本值