|
>>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로 정의 하여 사용해 보시기를 바랍니다.
그럼이만
|
