RedHat Linux6.2에서 oracle(8.1.5)를 아주 어렵게 설치 했습니다. 이제는 모두 잘 작동 합니다. PowerBulider에서 잘 됩니다. (SqlNet7.3) 그러나 Web에서 ora-12545 error가 납니다. explore에서 뿌리는 내용은 다음과 같습니다.
Warning: oci8_open_server: Error while trying to retrieve text for error ORA-12545 in /usr/local/apache/htdocs/index.html on line 4
그리고 source는
<html>
<body>
<?
$conn=OCIPLogon("system","manager");
print "server Version:". OCIServerVersion($conn);
OCILogoff($conn);
?>
</body>
</html>
sqlplus나 svrmgrl, lsnrctl 등은 모두 잘동이 정상적입니다. 그러나 Wen에서만
이러한 상태가 발생합니다.
lsnrctl은 아래와 같이 잘 작동합니다.
[root@emmanuel htdocs]# lsnrctl
LSNRCTL for Linux: Version 8.1.5.0.0 - Production on 29-APR-00 11:47:52
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LINUX)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 8.1.5.0.0 - Production
Start Date 29-APR-00 11:09:04
Uptime 0 days 0 hr. 38 min. 49 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/app/815/network/admin/listener.ora
Listener Log File /oracle/app/815/network/log/listener.log
Services Summary...
LINUX has 2 service handler(s)
LINUX has 1 service handler(s)
extproc has 1 service handler(s)
The command completed successfully
LSNRCTL>
그리고 listener.ora의 내용입니다.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=LINUX))
(ADDRESS= (PROTOCOL= TCP)(Host=emmanuel.pe.kr )(Port= 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= LINUX.emmanuel.pe.kr)
(ORACLE_HOME = /oracle/app/815)
(SID_NAME = LINUX)
)
(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /oracle/app/815)
(PROGRAM = extproc)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
그리고 client 쪽의 tnsnames.ora입니다.
#This is a SQL*Net Configuration file generated by SQL*Net Easy Configuration.
#Attention: Do not modify this file yourself.
#If you do, your SQL*Net Easy Configuration may not function properly.
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Beq-Local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
oracle.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 211.41.105.60)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 211.41.105.60)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = LINUX)
)
)
초보자를 위해서 꼭 해결 부탁 드림니다. 그럼 즐거운 시간 되십시요.
|