안녕하세요..^^
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
#############################################################
감사합니다...
|