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

$ su oracle

∗ ∗ s q l p l u s / n o l o g ∗ ∗ E r r o r 6 i n i t i a l i z i n g S Q L ∗ P l u s S P 2 − 0667 : M e s s a g e f i l e s p 1 &lt; l a n g &gt; . m s b n o t f o u n d S P 2 − 0750 : Y o u m a y n e e d t o s e t O R A C L E H O M E t o y o u r O r a c l e s o f t w a r e d i r e c t o r y [ o r a c l e @ l i n u x 6   ] **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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值