데이터베이스 질문과 답변
by 이우진 [2016.12.27 20:53:25]
어떤 부분이 잘못됬는지 알려주세요
몇일째 접속을 못하고 있습니다.
리스너---
# listener.ora Network Configuration File: C:\oracle11\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle11\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\oracle11\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = testdb)(PORT = 1521))
)
)
ADR_BASE_LISTENER = C:\oracle11
tns---
# tnsnames.ora Network Configuration File: C:\oracle11\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
TESTDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = testdb)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testdb)
)
)
host 가 틀린 듯 합니다.
다음 후보군들로 바꿔보세요.
- localhost
- 컴퓨터이름
- 아이피
(ADDRESS = (PROTOCOL = TCP)(HOST = testdb)(PORT = 1521))
이부분에 testdb 부분을 수정 해야 하나요?
컴퓨터 이름이나 임의의 ip로요?
localhost 로 두개다 입력 해볼까요?
알려주신 후보군 으로 모두 해봐도 toad 에서 db를 찾지 못하고 있습니다.
다음과 같은 에러 메세지가 나옵니다 ㅜㅜ
ORA-12514: TNS:리스너가 현재 접속 기술자에 요청된 서비스를 알지 못함
Items Checked
TNS_ADMIN environment variable is not defined
ORACLE_HOME environment variable is defined as "C:\oracle11\product\11.2.0\dbhome_1"
"C:\oracle11\product\11.2.0\dbhome_1\Network\Admin\tnsnames.ora" was located
The following connect descriptor was found for TESTDB in the tnsnames.ora file
TESTDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testdb)
)
)
"C:\oracle11\product\11.2.0\dbhome_1\Network\Admin\sqlnet.ora" was located
NAMES.DIRECTORY_PATH specifies TNSNAMES in the sqlnet.ora file
Steps to Take
If the database was just started wait a few moments and try again as the database may be initializing
Verify that the connect descriptor for TESTDB has the correct SERVICE_NAME or SID component in the tnsnames.ora file
Verify that the listener is properly configured and that the database is registered with the listener
Try to ping localhost using the Ping button on the toolbar
Try to TNSPing TESTDB using the TNS Ping button on the toolbar
sqlplus "/as sysdba"
SQL> select name from v$database; 로 나오는 걸로 SERVICE_NAME = 여기에 기재
접속 다시 해보세요.. 리스너는 다시 시작할 필요 없습니다.
) 버튼을 클릭하여 작성 하시면 됩니다.