`
java_true
  • 浏览: 110732 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

You may need to set ORACLE_HOME to your Oracle software directory

阅读更多
Linux下安装好Oracle 10g后运行sqlplus出现故障如下:

[oracle@localhost oracle]$ ./sqlplusError 6 initializing SQL*PlusMessage file sp1<lang>.msb not foundSP2-0750: You may need to set ORACLE_HOME to your Oracle software directory解决方法:第一,用oracle用户名登录linux系统。而不是root登录后su oracle。第二,用oracle用户名登录linux系统后,vi .bash_profile,其中,文件.bash_profile在/home/oracle目录下,它是隐藏文件,可以ls -a 显示所有文件(包含隐藏文件)。第三,编辑.bash_profile文件,内容如下:——————————————————————————————————————————————————————————————————# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then        . ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$ORACLE_HOME/binunset USERNAMEexport ORACLE_SID=orclexport ORACLE_BASE=/home/oracle/oracleexport ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1export PATH~——————————————————————————————————————————————————————————————————————————
重新启动系统,用oracle用户名登录。
[oracle@localhost ~]$ cd $ORACLE_HOME
[oracle@localhost db_1]$ pwd
/home/oracle/oracle/product/10.2.0/db_1
[oracle@localhost db_1]$ cd bin
[oracle@localhost bin]$ pwd
/home/oracle/oracle/product/10.2.0/db_1/bin
[oracle@localhost bin]$

然后
[oracle@localhost bin]$ ./sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 17 10:43:41 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL>
——————————————————————————————————————————
问题解决!!
我们发现Connected to an idle instance.
只要
SQL>startup
就ok!
分享到:
评论

相关推荐

    java调用shell脚本执行sqlldr与存储过程

    3、0750: You may need to set ORACLE_HOME to your Oracle software directory 4、Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=...

    误删除$ORACLE_HOME/dbs下的参数文件、密码文件快速重建的方法

    误删除$ORACLE_HOME/dbs下的参数文件、密码文件如何快速重建呢?其实方法很简单的,下面小编给大家分享下实现代码,具体内容如下: [oracle@11g dbs]$ pwd ... 1 oracle oinstall 2851 May 15 2009 init.ora -rw-r----

    Adapting_to_Endure_May_2022.pdf

    Adapting_to_Endure_May_2022

    2018陕旅版英语六年级(下册)Unit_1_May_I_Speak_to_Kitty单元测试卷.doc

    2018陕旅版英语六年级(下册)Unit_1_May_I_Speak_to_Kitty单元测试卷.doc

    Oracle SQL Tuning with Oracle SQLTXPLAIN: Oracle Database 12c Edition

    Best of all, the book is updated to cover the very latest feature set in Oracle Database 12c. Covers AWR report integration Helps with SQL Monitor Report Interpretation Provides a reliable method ...

    Profit From Your Forecasting Software Guide for Sales Forecasters

    You may be new to forecasting, or you may have mastered the statistical theory behind the software’s predictions, and even more advanced “power user” techniques for the software itself—but your ...

    最全的oracle常用命令大全.txt

    ORACLE常用命令 一、ORACLE的启动和关闭 1、在单机环境下 要想启动或关闭ORACLE系统必须首先切换到ORACLE用户,如下 su - oracle a、启动ORACLE系统 oracle&gt;svrmgrl SVRMGR&gt;connect internal SVRMGR&gt;startup ...

    Oracle sqldeveloper without jdk (win+linux)

    You need to reload $ORACLE_HOME/rdbms/admin/catmeta.sql 2.3 If Snippets are not accessible You may have not done a clean install. SQL Developer needs to be installed into a clean directory, not over ...

    Simple application that shows how to use the Data Control to

    Simple application that shows how to use the Data Control to connect to the Biblio.mdb database and display all authors in the Authors table.

    label-recognition-ocr

    # Find OpenCV, you may need to set OpenCV_DIR variable # to the absolute path to the directory containing OpenCVConfig.cmake file # via the command line or GUI find_package(OpenCV REQUIRED) 执照 获取...

    利用 Oracle 和 PHP 管理分布式跟踪文件

    You will need to specify a password and you may also want to assign alternative default and temporary tablespaces. create the external library call Windows - see extWindows.sql Linux - see extLinux....

    nginx使用ageip 实现地区负载均衡

    You may need to install a 解决办法: root@ubuntu:/usr/src/GeoIP-1.4.8# apt-get install zlib1g-dev 再次编译,顺利通过 make make install 2. 安装nginx 在重新安装nginx之前我们需要安装一下有关nginx的...

    Oracle Access in delphi

    You may only reproduce, install and use the software product for use with only one developer. If you have multiple validly licensed copies of the software product, you may reproduce, install and use ...

    Easy Lan Folder Share

    You just select the "Share Mode" to "Easy Share" only once, our software will save your setting until next change, you may need to restart your computer to take effect. the last thing you need to do ...

    Oracle OPC认证教程3.0.rar

    You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes "fair use" under ...

    Oracle Essbase

    This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for ...

    2012英语资料

    A:No, I don't need your help. B:Yes. I'd like to withdraw some money. C:Well, leave me alone. D:Don't bother me! 19、- Where is the Loan Department, please? - _________ A:Who are you? B:This ...

    红杉:Adapting to Endure_2022_05.pdf

    红杉:Adapting to Endure_2022_05

    Oracle Developer Tools for VS 2017 MSI Installer

    Important: Before you install this package please make sure there is no ODAC/Oracle Universal Installer (OUI) version of Oracle Developer Tools for Visual Studio installed on the machine. If there is ...

    无人永生源代码 v1.003

    (c) Using the Editor and/or Source Code, you may create modifications or enhancements to the Software, including the construction of new levels (collectively referred to as "Variations"), subject to ...

Global site tag (gtag.js) - Google Analytics