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 3076 게시물 읽기
No. 3076
Re: 이게 리스너문제인가요????도와주셔요...ㅠㅠ
작성자
bugermaker
작성일
2001-02-19 10:13
조회수
18,103

>>joohun 님께서 쓰시길<<

 

:: 안녕하세요..^^

:: 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)(US

:: ER=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

:: #############################################################

::

 

리스너 에러군요

실은 리스너는 정상입니다.

그러나 서비스할 명이 없군요. 리스터에 서비스명을 추가 해야합니다.

서비스할 ORCL에 관한 리스너를 작성해 주셔야합니다..

여기서는 서비스명을 ORCL로 정의 하여 사용해 보시기를 바랍니다.

그럼이만

[Top]
No.
제목
작성자
작성일
조회
74oas407for linux 있는데 아시는분 좀 알려 주세요!!!
신대윤
1999-12-03
18575
91┕>Re: oas407for linux 있는데 아시는분 좀 알려 주세요!!!
tachyon
1999-12-10 13:15:25
17531
69에구 아래랑 비슷한 질문인데... 미칠지경입니다.
황성모
1999-12-02
15433
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
15198
67이게 리스너문제인가요????도와주셔요...ㅠㅠ
joohun
1999-12-02
16719
71┕>Re: 이게 리스너문제인가요????도와주셔요...ㅠㅠ
조용일
1999-12-03 10:51:59
15237
3076┕>Re: 이게 리스너문제인가요????도와주셔요...ㅠㅠ
bugermaker
2001-02-19 10:13:58
18103
66리눅스에서의 오라클과 비쥬얼베이직과 연동방법
이원희
1999-12-01
14171
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.049초, 이곳 서비스는
	PostgreSQL v13.1으로 자료를 관리합니다