Q & A

오렌지 DBMS Logon 질문입니다...

Date2008.11.03 / Hit : 8008

안녕하세요??

현재 오라클 10G 설치후 오렌지를 설치를 했는데요...

DBMS Logon 에 서버리스트가 나오지 않아서 문의 드립니다.

hosts 에 내용을 등록을 했는데도 Service Name 에 해당 DB List 가 나오지 않네요..

hosts 내용 입니다.

 

# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host

127.0.0.1       localhost
203.233.72.44  xmanager.payzone.co.kr

위에 보시면 203.233.72.44 <- 이거 DB IP이거든요...

아래는 tnsnames.ora 파일내용 입니다.

# This file contains the syntax information for
# the entries to be put in any tnsnames.ora file
# The entries in this file are need based.
# There are no defaults for entries in this file
# that Sqlnet/Net3 use that need to be overridden
#
# Typically you could have two tnsnames.ora files
# in the system, one that is set for the entire system
# and is called the system tnsnames.ora file, and a
# second file that is used by each user locally so that
# he can override the definitions dictated by the system
# tnsnames.ora file.

# The entries in tnsnames.ora are an alternative to using
# the names server with the onames adapter.
# They are a collection of aliases for the addresses that
# the listener(s) is(are) listening for a database or
# several databases.

# The following is the general syntax for any entry in
# a tnsnames.ora file. There could be several such entries
# tailored to the user's needs.

= [ (DESCRIPTION_LIST =  # Optional depending on whether u have
    # one or more descriptions
    # If there is just one description, unnecessary ]
   (DESCRIPTION=
     [ (SDU=2048) ] # Optional, defaults to 2048
    # Can take values between 512 and 32K
     [ (ADDRESS_LIST=    # Optional depending on whether u have
    # one or more addresses
    # If there is just one address, unnecessary ]
       (ADDRESS=
  [ (COMMUNITY=) ]
  (PROTOCOL=tcp)
  (HOST=)
  (PORT=)
       )
       [ (ADDRESS=
    (PROTOCOL=ipc)
    (KEY=
  )
       ]
       [ (ADDRESS=
    [ (COMMUNITY=) ]
    (PROTOCOL=decnet)
    (NODE=)
    (OBJECT=)
  )
       ]
              ... # More addresses
  &n

  • 대표전화
    1660-1675

  • 기술 문의
    02-6931-1734

  • 오렌지 문의
    070-8666-8175

  • 라이선스 문의
    02-6931-1728