$ 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
<
l
a
n
g
>
.
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<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory [oracle@linux6 ~]
∗∗sqlplus/nolog∗∗Error6initializingSQL∗PlusSP2−0667:Messagefilesp1<lang>.msbnotfoundSP2−0750: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