欢迎访问 生活随笔!

生活随笔

当前位置: 首页 > 编程资源 > 编程问答 >内容正文

编程问答

oralce启动问题You may need to set ORACLE_HOME to your Oracle software directory

发布时间:2023/12/20 编程问答 39 豆豆
生活随笔 收集整理的这篇文章主要介绍了 oralce启动问题You may need to set ORACLE_HOME to your Oracle software directory 小编觉得挺不错的,现在分享给大家,帮大家做个参考.

$ su oracle

∗∗sqlplus/nolog∗∗Error6initializingSQL∗PlusSP2−0667:Messagefilesp1&lt;lang&gt;.msbnotfoundSP2−0750:YoumayneedtosetORACLEHOMEtoyourOraclesoftwaredirectory[oracle@linux6]**sqlplus /nolog** 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 [oracle@linux6 ~]sqlplus/nologError6initializingSQLPlusSP20667:Messagefilesp1<lang>.msbnotfoundSP20750:YoumayneedtosetORACLEHOMEtoyourOraclesoftwaredirectory[oracle@linux6 ]
$echo $ORACLE_HOME

- - 如果为空,则export ORACLE_HOME=$ORACLE_BASE/product

$source /home/oracle/.bash_profile
$sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Mon May 27 09:27:34 2019

Copyright © 1982, 2011, Oracle. All rights reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 784998400 bytes
Fixed Size 2232472 bytes
Variable Size 566234984 bytes
Database Buffers 209715200 bytes
Redo Buffers 6815744 bytes
Database mounted.

Database opened.
SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 27-MAY-2019 09:29:09

Copyright © 1991, 2011, Oracle. All rights reserved.

Starting /db/bin/tnslsnr: please wait…

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 27-MAY-2019 09:29:13
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF

Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux6.3)(PORT=1521)))
The listener supports no services
The command completed successfully

总结

以上是生活随笔为你收集整理的oralce启动问题You may need to set ORACLE_HOME to your Oracle software directory的全部内容,希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错,欢迎将生活随笔推荐给好友。