新建一个连接plcle与oracle,Linux_oracle监听的启动以及连接(自创).docx

Linux oracle监听的启动以及连接

oracle数据库启动的方法

Edracle@l deal heat 门 $ sqlplus /ruolag

SQL^Flus: Release 10. 2. 0.1. 0 - Production an Tue Kay 13 10:4T: 06 2010

Copyright (c) 19823 20053 Oracle. All rights reserved.

SQL〉 conn / ns sysdbs

Connect&d to an idle instance.

conn / as sysdba

SQL> startup

ORACLE instance sta^ted-

Total System Global Area 1241513984bytes

Fixed Size121913&bytes

Variable Size31076SS7&byt巳s

Database Buffers905969664bytes

Redo Buffers15556&0Sbytes

startup

注意，监听的启动必须先把数据库启动起来，因为服务器重启了，数据库服务肯定没起。

、

首先杳看Listener的状态

1运行命令：Isn rctl

[□racleClocalhost 1 $ Isnrctl

LSNRCTL for Linu 求：Version 10, 2, 0. 1. 0 - Pro due timi on 1S-MAY-2010 09:41:37

Copyright (c) 1991』2005j Oracle. All rights reserved-

Welcone to LSNRCTL, type "help" for inforioatian?

2、查看状态：status

|L S SL^t us

Cannecling 10 >DESCRIPTION(ADDRESS=(PROTOCO1-TCPKHOSr^LflcalhDst. goonie) (POftT^1521)J) 7NS-12541: THS mo lisien&r

THS-125601 TNS:protoefll adapl&r error

INS-00511No listener

T.inui Error r 111 ! Conne^lion refused

Cormfeting 10(EESCRIPTION± [ADDRESS=(PROTOCOL=IPC'i(KET=iXTPROC0)))

INS-12541! TWS mo lisltner

TNS-1256H? TNS:protocol ^rlapter pttot

INS-110511 : No listener

Limiy Errnr: 111: Connect:on refuspd

LSHRCTL> start

Slarting Ai01 /nyae^e/oTac]e/pToduct/10. 2. O/db-l .^bin/tnslanr： pleas?阱lit.,-

由上可知，No liste ner

3、启动 listener

运行命令：start

LSWF.CTL^ 51 az*t

Stc_L'ting /uOL/eraclr/jiiiicl.u/prLjdujt/lD.Z-D/ilL—l/'bin/tialisni'： plcasr Moi t...

TtCLSHF. for Limnc： Vc_sion 10. 2.0, 1. 0 - Production

Systerr parameter file is ^Li01/aracle/oracL=/product/]0. 2. O/dh^L/network/adjiinzliEtener, a:a Loe icf baKtb wit ten tL /u0] /□L'iclr/oratl c/pruJutt/lOn 21 O/JL 1./netrL/Ics71 i bt.log LisieniriE 匚ri： (DESCRIPTION(AIOTSS= [PfiO70COL=t

Connecting io (DESCRimON=

Alias

Version

Star: CaTie

Upti