오라클 8.1.6을 설치하고 내부에서는 잘 동작하는데(알짜6.1)
외부에서 접속이 안되고 있는데
lisener.ora
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 211.xxx.x.xxx)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl.chanhei)
(ORACLE_HOME = /u01/oracle/8i)
(SID_NAME = orcl)
)
(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /u01/oracle/8i)
(PROGRAM = extproc)
)
)
client tnsnames.ora
orcl.chanhei =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 211.xxx.x.xxx)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))
)
이렇게 설정했는데
toad를 이용해서 접속하면 ORA-01034: ORACLE not available에러가뜨고
상세설명에서는
*** First assume we have a valid install and registry
***
Oracle home is set to C:\orawin95
Bin path is set to C:\orawin95\bin\
Using: C:\ORAWIN95\BIN\ORA805.DLL
2) Oracle Home Key is SOFTWARE\ORACLE\HOME0
Looking for TNS_ADMIN environmental variable
TNS_ADMIN environmental variable doesnt exist,
looking for TNS_ADMIN reg key using home key: >SOFTWARE\ORACLE\HOME0<
TNS_ADMIN does not exist in SOFTWARE\ORACLE\HOME0
looking for TNS_ADMIN reg key in \Oracl
다시 깔아도 똑같이 에러가 납니다 왜그러는지
|