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!
分享到:
相关推荐
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@11g dbs]$ pwd ... 1 oracle oinstall 2851 May 15 2009 init.ora -rw-r----
Adapting_to_Endure_May_2022
2018陕旅版英语六年级(下册)Unit_1_May_I_Speak_to_Kitty单元测试卷.doc
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 ...
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常用命令 一、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 need to install a 解决办法: root@ubuntu:/usr/src/GeoIP-1.4.8# apt-get install zlib1g-dev 再次编译,顺利通过 make make install 2. 安装nginx 在重新安装nginx之前我们需要安装一下有关nginx的...
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 ...
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 ...
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
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 ...