database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
ㆍOracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
Oracle Q&A 67 게시물 읽기
No. 67
이게 리스너문제인가요????도와주셔요...ㅠㅠ
작성자
joohun
작성일
1999-12-02 16:45
조회수
16,719

안녕하세요..^^

delphi에서 oracle을 사용하고자 리눅스에 oracle을 설치했습니다...

"lsnrctl start"하면 분명 아무 이상없이 이렇게 나오거든요...

 

#############################################################

[oracle@nine7 admin]$ lsnrctl stop

 

LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 02-DEC-99 11:38:06

 

(c) Copyright 1997 Oracle Corporation. All rights reserved.

 

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=192.0.0.8)(Port=1521))

The command completed successfully

[oracle@nine7 log]$ lsnrctl start

 

LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 02-DEC-99 11:38:11

 

(c) Copyright 1997 Oracle Corporation. All rights reserved.

 

Starting /oracle/app/oracle/product/8.0.5/bin/tnslsnr: please wait...

 

TNSLSNR for Linux: Version 8.0.5.0.0 - Production

System parameter file is /oracle/app/oracle/product/8.0.5/network/admin/listener.ora

Log messages written to /oracle/app/oracle/product/8.0.5/network/log/listener.log

Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=192.0.0.8)(PORT=1521))

 

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=192.0.0.8)(Port=1521))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 8.0.5.0.0 - Production

Start Date 02-DEC-99 11:38:14

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security OFF

SNMP ON

Listener Parameter File /oracle/app/oracle/product/8.0.5/network/admin/listener.ora

Listener Log File /oracle/app/oracle/product/8.0.5/network/log/listener.log

Services Summary...

ORCL has 1 service handler(s)

extproc has 1 service handler(s)

The command completed successfully

#############################################################

 

이러면 다 된거 아닌가요??분명 tnsping 하면 "OK"하고 나오는데....

그래서 "sqlplus system/manager@imsi"라고 하면

 

#############################################################

ERROR:

ORA-12500: TNS:listener failed to start a dedicated server process

#############################################################

 

^요런 에러가 나네요...

그리고 windows용 sqlnet cliect도 server의 version과 관계가 있는지요????

예를 들어 버젼이 않맞으면 서로 연결이 않된다던가...기타..

 

참고로 제 listener.ora화일도 같이 올립니다...

잘못된부분이 있는지 여러 고수님의 조언부탁드립니다...

 

################listener.ORA###################################

#

# Installation Generated Net8 Configuration

# Version Date: Jun-17-97

# Filename: Listener.ora

#

LISTENER =

(ADDRESS_LIST =

(ADDRESS= (PROTOCOL= TCP)(Host= 192.0.0.8)(Port= 1521))

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME= 192.0.0.8.)

(ORACLE_HOME= /oracle/app/oracle/product/8.0.5)

(SID_NAME = ORCL)

)

(SID_DESC =

(SID_NAME = extproc)

(ORACLE_HOME = /oracle/app/oracle/product/8.0.5)

(PROGRAM = extproc)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

#############################################################

 

그리고 아래부분은 LISTENER가 시작될때의 로그화일입니다...

저 아래부분에 TNS ERROR는 무슨 ERROR인지도 도와주세요...

 

#############################################################

c) Copyright 1997 Oracle Corporation. All rights reserved.

 

System parameter file is /oracle/app/oracle/product/8.0.5/network/admin/listener.ora

Log messages written to /oracle/app/oracle/product/8.0.5/network/log/listener.log

 

Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=192.0.0.8)(PORT=1521))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

02-DEC-99 11:34:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=nine7.ninedatasystem.co.kr)(USER=oracle))(COMMAND

=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=134238208)) * status * 0

02-DEC-99 11:34:53 * ping * 0

02-DEC-99 11:35:03 * (CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=)(HOST=nine7.ninedatasystem.co.kr)(USER=oracle

))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.0.0.8)(PORT=1097)) * establish * ORCL * 12500

TNS-12500: TNS:listener failed to start a dedicated server process

TNS-12546: TNS:permission denied

TNS-12560: TNS:protocol adapter error

TNS-00516: Permission denied

Linux Error: 13: Permission denied

#############################################################

 

감사합니다...

[Top]
No.
제목
작성자
작성일
조회
74oas407for linux 있는데 아시는분 좀 알려 주세요!!!
신대윤
1999-12-03
18575
91┕>Re: oas407for linux 있는데 아시는분 좀 알려 주세요!!!
tachyon
1999-12-10 13:15:25
17530
69에구 아래랑 비슷한 질문인데... 미칠지경입니다.
황성모
1999-12-02
15432
73┕>Re: 에구 아래랑 비슷한 질문인데... 미칠지경입니다.
조용일
1999-12-03 12:29:01
16207
68mdb와 oracle data의 network transfer..?
cjh0532
1999-12-02
16429
72┕>Re: mdb와 oracle data의 network transfer..?
조용일
1999-12-03 12:19:22
15197
67이게 리스너문제인가요????도와주셔요...ㅠㅠ
joohun
1999-12-02
16719
71┕>Re: 이게 리스너문제인가요????도와주셔요...ㅠㅠ
조용일
1999-12-03 10:51:59
15236
3076┕>Re: 이게 리스너문제인가요????도와주셔요...ㅠㅠ
bugermaker
2001-02-19 10:13:58
18102
66리눅스에서의 오라클과 비쥬얼베이직과 연동방법
이원희
1999-12-01
14170
70┕>Re: 리눅스에서의 오라클과 비쥬얼베이직과 연동방법
조용일
1999-12-03 10:27:39
14379
63oracle 8i 설치 방법 좀 가르켜 주셔요. 급함.
1999-11-30
15510
64┕>Re: oracle 8i 설치 방법 좀 가르켜 주셔요. 급함.
dyst
1999-12-07 07:02:49
15853
62oracle 8i로 upgrade하려면..?
cjh0532
1999-11-30
15325
65┕>Re: oracle 8i로 upgrade하려면..?
조용일
1999-12-01 09:09:48
15383
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2020 DSN, All rights reserved.
작업시간: 0.050초, 이곳 서비스는
	PostgreSQL v13.1으로 자료를 관리합니다