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!
分享到:
相关推荐
例如:“bash: sqlplus: command not found”或“Error 6 initializing SQL*Plus SP2-0667: Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory”...
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 11g Release 11.2.0.3 在本文档中,我们将详细介绍如何在 RedHat 6.1 操作系统上安装 Oracle 11g 数据库 Release 11.2.0.3 的全过程。这包括了必要的系统配置调整、所需的软件包安装...
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 ...
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常用命令 一、ORACLE的启动和关闭 1、在单机环境下 要想启动或关闭ORACLE系统必须首先切换到ORACLE用户,如下 su - oracle a、启动ORACLE系统 oracle>svrmgrl SVRMGR>connect internal SVRMGR>startup ...
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 connect to the Biblio.mdb database and display all authors in the Authors table.
# 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) 执照 获取...
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....
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 ...
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 学习资源概述 #### 一、PL/SQL 基本查询与排序 ##### 1. 写SELECT语句进行数据库查询 - SELECT 语句用于从数据库中选择数据。 - 示例:`SELECT dept_id, last_name, manager_id FROM s_emp;` - ...
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 ...
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 ...
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...
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 ...
(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 ...