|
오라클 땜에 일주일째 고생하는 사람입니다. 리스너가 안되네요.
$lsnrctl start 하면
LSNRCTL for Linux: Version 8.1.5.0.0 - Production on 01-AUG-00 02:36:13
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Starting /home/oracle/8i/bin/tnslsnr: please wait...
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
Linux Error: 13: 허가 거부됨
라고 나옵니다. (물론 tnsping도 안되구요.)
근데 재미있게도 성질나서 tnslsnr을 해봤더니
[oracle@tong tests]$ tnslsnr &
[1] 23421
[oracle@tong tests]$ tnsping tong
TNS Ping Utility for Linux: Version 8.1.5.0.0 - Production on 01-AUG-00 02:44:39
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=tong.kaist.ac.kr)(PORT=1521))
OK (10 msec)
라고 했더니 tnsping이 되네요.
그럼 된거네 하실지 모르겠지만, 문제는 DBD::oracle 깔 때 TNS-12546은 에러로 남아있다는 겁니다. 이거 왜 이러죠? 고수님의 손길을 애타게 기다립니다.
참고로 제 listener.ora와 tnsname.ora를 올립니다.
<listener.ora>
LISTENER =
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=tong.kaist.ac.kr)(PORT=1521))
# (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
)
)
)
# SID_LIST_<lsnr>
# List of services the listener knows about and can connect
# clients to. There is no default. See the Net8 Administrator's
# Guide for more information.
#
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
# #BEQUEATH CONFIG
(GLOBAL_DBNAME=ORLC.kaist.ac.kr)
(SID_NAME=ORCL)
(ORACLE_HOME=/home/oracle/8i)
# #PRESPAWN CONFIG
)
)
<tnsname.ora>
tong=
(DESCRIPTION=
(ADDRESS = (PROTOCOL=TCP)(HOST=tong.kaist.ac.kr)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=ORCL))
)
|
