Service Temporarily Unavailable error?
423339Aug 30 2004 — edited Aug 30 2004
Here is my Apache error log file....
[Mon Aug 30 22:48:42 2004] [notice] FastCGI: process manager initialized
[Mon Aug 30 22:49:18 2004] [error] [client 192.168.233.1] [ecid: 1093870150:192.168.233.1:1172:2808:11,0] mod_plsql: /pls/orcl/hello HTTP-503 ORA-12154
[Mon Aug 30 23:18:34 2004] [notice] FastCGI: process manager initialized
[Tue Aug 31 00:49:57 2004] [notice] FastCGI: process manager initialized
[Tue Aug 31 00:57:42 2004] [error] [client 192.168.233.1] [ecid: 1093877854:192.168.233.1:2344:3884:2,0] mod_plsql: /pls/orcl/hello HTTP-503 ORA-12154
[Tue Aug 31 01:09:42 2004] [error] [client 192.168.233.1] [ecid: 1093878582:192.168.233.1:2344:3832:2,0] File does not exist: d:/oracle/product/10.1.0/httpserver/apache/apache/htdocs/isqlplus
[Tue Aug 31 01:10:10 2004] [error] [client 192.168.233.1] [ecid: 1093878603:192.168.233.1:2344:3844:2,0] mod_plsql: /pls/orcl/hello HTTP-503 ORA-12154
[Tue Aug 31 01:10:22 2004] [error] [client 192.168.233.1] [ecid: 1093878615:192.168.233.1:2344:3848:3,0] mod_plsql: /pls/DB_1/hello HTTP-503 ORA-12154
[Tue Aug 31 01:10:34 2004] [error] [client 192.168.233.1] [ecid: 1093878627:192.168.233.1:2344:3856:3,0] mod_plsql: /pls/hello HTTP-503 ORA-12154
[Tue Aug 31 01:10:55 2004] [error] [client 192.168.233.1] [ecid: 1093878649:192.168.233.1:2344:3864:2,0] mod_plsql: /pls/orcl/hello.psp HTTP-503 ORA-12154
And here is my apache access log file....
192.168.233.1 - - [30/Aug/2004:22:48:57 +1000] "GET / HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:57 +1000] "GET /ohs_images/portals.css HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /ohs_images/space.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /ohs_images/9iAShome_banner_2.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/asytlse.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/blue-content.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/asytrsm.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/green-green.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/green-content.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/asytrnse.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/asysrtb.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/asysrt.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /ohs_images/rhshadow.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/asylrhs.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/asylttb.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /Tab_files/asysrb.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:58 +1000] "GET /ohs_images/home.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:59 +1000] "GET /ohs_images/art3.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:59 +1000] "GET /ohs_images/bisspace.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:59 +1000] "GET /Tab_files/upperbox.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:59 +1000] "GET /Tab_files/asybase.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:59 +1000] "GET /ohs_images/tree_document.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:59 +1000] "GET /Tab_files/lowerbox.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:59 +1000] "GET /ohs_images/relatedapps_cctitle.gif HTTP/1.1" 304 -
192.168.233.1 - - [30/Aug/2004:22:48:59 +1000] "GET /ohs_images/slieghright.gif HTTP/1.1" 304 -
192.168.233.1 - "" [30/Aug/2004:22:49:04 +1000] "GET /pls/orcl/hello HTTP/1.1" 401 486
192.168.233.1 - scott [30/Aug/2004:22:49:18 +1000] "GET /pls/orcl/hello HTTP/1.1" 503 405
192.168.233.1 - - [31/Aug/2004:00:57:21 +1000] "GET / HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /ohs_images/portals.css HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /ohs_images/space.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /ohs_images/9iAShome_banner_2.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /Tab_files/asytlse.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /Tab_files/asytrsm.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /Tab_files/green-content.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /Tab_files/green-green.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /Tab_files/asytrnse.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /Tab_files/asysrtb.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /Tab_files/asysrt.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /ohs_images/rhshadow.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:22 +1000] "GET /Tab_files/asylrhs.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /Tab_files/asylttb.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /ohs_images/home.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /Tab_files/asysrb.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /ohs_images/bisspace.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /ohs_images/art3.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /Tab_files/upperbox.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /Tab_files/asybase.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /ohs_images/tree_document.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /Tab_files/lowerbox.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /ohs_images/relatedapps_cctitle.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /ohs_images/slieghright.gif HTTP/1.1" 304 -
192.168.233.1 - - [31/Aug/2004:00:57:23 +1000] "GET /Tab_files/blue-content.gif HTTP/1.1" 304 -
192.168.233.1 - "" [31/Aug/2004:00:57:29 +1000] "GET /pls/orcl/hello HTTP/1.1" 401 486
192.168.233.1 - scott [31/Aug/2004:00:57:42 +1000] "GET /pls/orcl/hello HTTP/1.1" 503 405
192.168.233.1 - - [31/Aug/2004:01:09:42 +1000] "GET /isqlplus HTTP/1.1" 404 291
192.168.233.1 - scott [31/Aug/2004:01:10:10 +1000] "GET /pls/orcl/hello HTTP/1.1" 503 405
192.168.233.1 - "" [31/Aug/2004:01:10:15 +1000] "GET /pls/DB_1/hello HTTP/1.1" 401 486
192.168.233.1 - scott [31/Aug/2004:01:10:22 +1000] "GET /pls/DB_1/hello HTTP/1.1" 503 405
192.168.233.1 - "" [31/Aug/2004:01:10:27 +1000] "GET /pls/hello HTTP/1.1" 401 486
192.168.233.1 - scott [31/Aug/2004:01:10:34 +1000] "GET /pls/hello HTTP/1.1" 503 405
192.168.233.1 - scott [31/Aug/2004:01:10:55 +1000] "GET /pls/orcl/hello.psp HTTP/1.1" 503 405
Yet my listener & tnsnames files are...
D:\oracle\product\10.1.0\Db_1\BIN>
# listener.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = armada.mshome.net)(PORT = 1521))
)
)
)
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = armada.mshome.net)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
What am i doing wrong here?