`
java_true
  • 浏览: 112716 次
  • 性别: 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!
分享到:
评论

相关推荐

    oracle 数据库用户被锁定在linux下操作

    例如:“bash: sqlplus: command not found”或“Error 6 initializing SQL*Plus SP2-0667: Message file sp1&lt;lang&gt;.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory”...

    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=...

    RedHat_6.1安装Oracle_11

    ### RedHat 6.1 安装 Oracle 11g Release 11.2.0.3 在本文档中,我们将详细介绍如何在 RedHat 6.1 操作系统上安装 Oracle 11g 数据库 Release 11.2.0.3 的全过程。这包括了必要的系统配置调整、所需的软件包安装...

    Instruction Set Reference_intel 64

    The Intel® 64 and IA-32 Architectures Software Developer’s Manual Volume 2A covers the instruction set reference from A to M. This comprehensive manual is part of a larger series of documents that ...

    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 ...

    最全的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....

    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_PLSQL

    ### Oracle_PLSQL 学习资源概述 #### 一、PL/SQL 基本查询与排序 ##### 1. 写SELECT语句进行数据库查询 - SELECT 语句用于从数据库中选择数据。 - 示例:`SELECT dept_id, last_name, manager_id FROM s_emp;` - ...

    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 ...

    ORACLE ODBC驱动

    you may now download this software. Oracle ODBC Driver Downloads NOTE: The following ODBC Drivers are ODBC Version 3.52, Level 2 compatible drivers. Oracle ODBC Drivers for Oracle 10.2 Version...

    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