1 2 3 Previous Next 34 Replies Latest reply: Dec 5, 2012 5:05 PM by user12839427 Go to original post RSS
      • 15. Re: 503 Service Temporarily Unavailable
        623269
        Yes it's all local and yes it can connect through sqlplus..
        • 16. Re: 503 Service Temporarily Unavailable
          joelkallman-Oracle
          Change all references from 'localhost' to the actual IP address. Change this in both your SQL*Plus connect test as well as dads.conf. Something obvious is amiss.

          Joel
          • 17. Re: 503 Service Temporarily Unavailable
            Keith Jamieson
            A couple of other things to note:

            1) Do you have tnsnames.ora in your 10gcompanionhome/network/admin directory?

            2) I once had an issue where the shared pool was cluttered and either got page not found, or your error. Can't remember. :(
            I had to bounce the database to resolve problem.
            • 18. Re: 503 Service Temporarily Unavailable
              627297
              Hi Marc,

              Is the issue resolved?. what is the issue...appreciate if you can explain if it is resolved...

              Looks like I too have almost similar issue...
              getting the following error

              [Fri Mar 07 14:20:03 2008] [error] [client 127.0.0.1] [ecid: 1204917597:10.10.10.10:3584:5552:1,0] mod_plsql: /pls/apex/apex_admin HTTP-503 ORA-12154

              [Fri Mar 07 14:20:03 2008] [error] [client 127.0.0.1] [ecid: 1204917603:10.10.10.10:3584:5928:1,0] File does not exist: c:/oracle/product/10.2.0/db/apache/apache/htdocs/favicon.ico

              Appreciate some help..

              thanks in advance
              :Amos
              • 19. Re: 503 Service Temporarily Unavailable
                joelkallman-Oracle
                Amos,

                And what does the entry in your dads.conf look like? Also, what is the output of lsnrctl status for your database listener?

                Joel
                • 20. Re: 503 Service Temporarily Unavailable
                  627297
                  Hi Joe,

                  Thanks for quick response. Please see the following details

                  dad.conf contents
                  ===============
                  Alias /i/ "C:\oracle\product\10.2.0\db\Apache\Apache\images/"
                  AddType text/xml xbl
                  AddType text/x-component htc

                  <Location /pls/apex>
                  Order deny,allow
                  PlsqlDocumentPath docs
                  AllowOverride None
                  PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
                  PlsqlDatabaseConnectString ServiceNameFormat
                  PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
                  PlsqlAuthenticationMode Basic
                  SetHandler pls_handler
                  PlsqlDocumentTablename wwv_flow_file_objects$
                  PlsqlDatabaseUsername APEX_PUBLIC_USER
                  PlsqlDefaultPage apex
                  PlsqlDatabasePassword mannah
                  Allow from all
                  </Location>


                  details from listner log
                  =================
                  07-MAR-2008 14:18:59 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=SYSTEM))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADDRESS=(PROTOCOL=TCP)(HOST=ELITE-PC)(PORT=1521)))(VERSION=169870080)) * status * 0
                  07-MAR-2008 14:19:10 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe)(HOST=ELITE-PC)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.10)(PORT=51330)) * establish * orcl * 0
                  07-MAR-2008 14:23:55 * service_update * orcl * 0
                  07-MAR-2008 14:23:59 * ping * 0

                  I suspect some issue with the listener..but not sure..
                  Please let me know if you need more details..

                  Thanks in advance
                  :Amos
                  • 21. Re: 503 Service Temporarily Unavailable
                    joelkallman-Oracle
                    Amos,

                    1) This line: PlsqlDatabaseConnectString ServiceNameFormat is wrong. Where's the actual connect string?

                    2) You're showing the output of the listener log. "what is the output of lsnrctl status for your database listener?"

                    Joel
                    • 22. Re: 503 Service Temporarily Unavailable
                      627297
                      Hi Joel,

                      I have corrected the DAD.conf file as follows :

                      Alias /i/ "C:\oracle\product\10.2.0\db\Apache\Apache\images/"
                      AddType text/xml xbl
                      AddType text/x-component htc

                      <Location /pls/apex>
                      Order deny,allow
                      PlsqlDocumentPath docs
                      AllowOverride None
                      PlsqlDocumentProcedure wwv_flow_file_mgr.process_download
                      PlsqlDatabaseConnectString 127.0.0.1:1521:orcl ServiceNameFormat
                      PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
                      PlsqlAuthenticationMode Basic
                      SetHandler pls_handler
                      PlsqlDocumentTablename wwv_flow_file_objects$
                      PlsqlDatabaseUsername APEX_PUBLIC_USER
                      PlsqlDefaultPage apex
                      PlsqlDatabasePassword mannah
                      Allow from all
                      </Location>

                      Browser URL used as

                      http://127.0.0.1:7777/pls/apex/apex_admin

                      Getting Error Message as
                      =================

                      Service Temporarily Unavailable
                      The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
                      --------------------------------------------------------------------------------

                      Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server Server at ELITE-PC Port 7777

                      lsnrctl status as follows
                      ===================
                      LSNRCTL> status
                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
                      STATUS of the LISTENER
                      ------------------------
                      Alias LISTENER
                      Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
                      ction
                      Start Date 07-MAR-2008 22:15:52
                      Uptime 0 days 0 hr. 15 min. 13 sec
                      Trace Level off
                      Security ON: Local OS Authentication
                      SNMP OFF
                      Listener Parameter File C:\oracle\product\10.2.0\db_1\network\admin\listener.o
                      ra
                      Listener Log File C:\oracle\product\10.2.0\db_1\network\log\listener.log

                      Listening Endpoints Summary...
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                      Services Summary...
                      Service "PLSExtProc" has 1 instance(s).
                      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                      The command completed successfully

                      access_log has the following message
                      =================================
                      127.0.0.1 - APEX_PUBLIC_USER [07/Mar/2008:22:29:13 -0500] "GET /pls/apex/apex_admin HTTP/1.1" 503 441

                      Can you please advise where I am going wrong...
                      appreciate your help!

                      Thanks
                      :Amos
                      • 23. Re: 503 Service Temporarily Unavailable
                        joelkallman-Oracle
                        Amos,

                        Can you now please look at the most recent entries in the Oracle HTTP Server error log?

                        Joel
                        • 24. Re: 503 Service Temporarily Unavailable
                          627297
                          Hi Joel,

                          This is the most recent entry in the HTTP Server error log


                          [Fri Mar 07 22:29:13 2008] [error] [client 127.0.0.1] [ecid: 1204946953:10.10.10.10:4484:248:1,0] mod_plsql: /pls/apex/apex_admin HTTP-503 ORA-12514

                          ORA - 12514 is this something related to Listener..?

                          Thanks
                          :Amos
                          • 25. Re: 503 Service Temporarily Unavailable
                            369783
                            Amos,

                            The 12514 error message and the results of your lsnrctl status command show that your listener does not know about your database. If everything was configured properly, one of the lsnrctl message would have shown the connection to "orcl".

                            What does your listener.ora file look like and also your tnsnames.ora file?

                            Bill Ferguson
                            • 26. Re: 503 Service Temporarily Unavailable
                              627297
                              Hi Bill,

                              Here is the contents of listener.ora and tnsnames.ora...

                              listener.ora
                              =============

                              SID_LIST_LISTENER =
                              (SID_LIST =
                              (SID_DESC =
                              (SID_NAME = PLSExtProc)
                              (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
                              (PROGRAM = extproc)
                              )
                              )

                              LISTENER =
                              (DESCRIPTION =
                              (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
                              )


                              tnsnames.ora
                              ============
                              ORCL =
                              (DESCRIPTION =
                              (ADDRESS_LIST =
                              (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
                              )
                              (CONNECT_DATA =
                              (SERVICE_NAME = orcl)
                              )
                              )


                              EXTPROC_CONNECTION_DATA =
                              (DESCRIPTION =
                              (ADDRESS_LIST =
                              (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                              )
                              (CONNECT_DATA =
                              (SID = PLSExtProc)
                              (PRESENTATION = RO)
                              )
                              )

                              Please see if something is missing...

                              Thanks
                              :Amos
                              • 27. Re: 503 Service Temporarily Unavailable
                                369783
                                Amos,

                                It looks like you are missing a decsription in your listener.ora file.

                                Replace the first part of your listener.ora with this (remember to make a copy first!):
                                SID_LIST_LISTENER =
                                (SID_LIST =
                                     (SID_DESC =
                                        (SID_NAME = PLSExtProc)
                                             (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
                                         (PROGRAM = extproc)
                                    )
                                    (SID_DESC =
                                      (GLOBAL_DBNAME = orcl)
                                      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
                                      (SID_NAME = orcl)
                                    )
                                )
                                I think I have all of the parenthesis in there.
                                Bill Ferguson
                                • 28. Re: 503 Service Temporarily Unavailable
                                  330976
                                  Hi Amos,

                                  Here some examples of my tnsnames.ora and listerner.ora.
                                  Hope this helps.

                                  Leo

                                  examples:
                                  # tnsnames.ora Network Configuration File: C:\oracle\db_102\network\admin\tnsnames.ora
                                  # Generated by Oracle configuration tools.

                                  ORCL =
                                  (DESCRIPTION =
                                  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
                                  (CONNECT_DATA =
                                  (SERVER = DEDICATED)
                                  (SERVICE_NAME = orcl)
                                  )
                                  )

                                  EXTPROC_CONNECTION_DATA =
                                  (DESCRIPTION =
                                  (ADDRESS_LIST =
                                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                                  )
                                  (CONNECT_DATA =
                                  (SID = PLSExtProc)
                                  (PRESENTATION = RO)
                                  )
                                  )

                                  # listener.ora Network Configuration File: C:\oracle\db_102\network\admin\listener.ora
                                  # Generated by Oracle configuration tools.

                                  SID_LIST_LISTENER =
                                  (SID_LIST =
                                  (SID_DESC =
                                  (SID_NAME = PLSExtProc)
                                  (ORACLE_HOME = C:\oracle\db_102)
                                  (PROGRAM = extproc)
                                  )
                                  )

                                  LISTENER =
                                  (DESCRIPTION_LIST =
                                  (DESCRIPTION =
                                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                                  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
                                  )
                                  )
                                  • 29. Re: 503 Service Temporarily Unavailable
                                    627297
                                    Thanks Bill,

                                    Change of the Listener.ora file worked and opened the ApEx Admin screen..

                                    Any clue..what the administration userID/Password to be used...?
                                    In which table I can find this information...


                                    Thanks Leo for the examples...

                                    Thanks
                                    :Amos