Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Yeon>sqlplus sys/oracle@TAF as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Aug 10 02:58:32 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
============================================================================================================
원인 - sqlnet.ora 파일 설정이 잘 못 되있을 경우
--> ex)
SQLNET.AUTHENTICATION_SERVICES=( NTS)
NAMES.DIRECTORY_PATH=(TNSNAMES, EZCONNECT) ->자세히 보면 공백이 존재한다.
--> 어처구니 없지만 이러한 이유로도 접속이 안될 수도 있다
해결 -
SQLNET.AUTHENTICATION_SERVICES=(NTS)
NAMES.DIRECTORY_PATH=(TNSNAMES,EZCONNECT)
'Oracle > Error' 카테고리의 다른 글
| RMAN-06004: ORACLE error from recovery catalog database: (0) | 2011.10.10 |
|---|---|
| [ERROR] ORA-01123 : cannot start online backup; media recovery not enabled (0) | 2011.10.06 |
| 모든 Oracle error 해결 (0) | 2011.10.04 |
| [error] dbassist error message 없이 실행이 안될 때 (0) | 2011.09.26 |
| [error] ORA-12705 error (0) | 2011.09.23 |