1 2 Previous Next 17 Replies Latest reply: Dec 23, 2011 9:26 AM by JimG RSS

    Invalid username or password when trying to start/stop SES

    JimG
      I've recently taken over this project as the previous person left the company. Last week everything was running just fine. This week, when I tried to go to either the search page or the admin page, I see:

      Internet Explorer can not display the Webpage.

      It seems something died on the server.

      When I exectue the searchctl.bat, I get the following error.

      oracle.search.config.OESException: Error while executing action: "stopall"
      Caused by: oracle.search.config.OESException: Invalid username or password. Unable to connect to Oracle SES.
      at oracle.search.config.Ctl.run(Ctl.javva:2119)
      at oracle.search.config.Ctl.main(Ctl.java:2173)
      Caused by: oracle.search.config.OESException: Invalid username or password. Unable to connect to Oracle SES.

      I'm not promoted for a username/password so I don't know if it's trying to use my windows login or if it's reading from a config file somewhere. If it's the former, then I need to give myself access (I do have the admin username/password).

      Version info:
      Oracle Database 10g Enterprise Edition Release 10.1.0.5.0

      SES 10.1.8

      Windows Server 2002 SP 2

      The server was patched and restarted over the weekend.

      I also tried rebooting the server to see if it would automatically startup, and it didn't.

      Edited by: 903593 on Dec 20, 2011 4:00 PM
        • 1. Re: Invalid username or password when trying to start/stop SES
          damorgan
          You are working with software so old it is in desupport mode.

          Has your company paid for extended support?

          If not I'd recommend starting with a phone call to your local sales rep and getting a CSI number you can use to open an SR.
          • 2. Re: Invalid username or password when trying to start/stop SES
            Roger Ford-Oracle
            You should have an option in your start menu to start SES.

            If that doesn't work, try starting the services manually.

            Go to Control Panel -> Administrative Tools -> Services, and start the following services in this order:

            OraclesesTNSListener
            OracleServiceSES

            Then from a command prompt, run:
            sqlplus sys/<password> as sysdba
            startup
            quit

            (it may tell you the database is already started - that's fine)
            then go back to Services and start:

            OraclesesOC4J

            If your server name was created as something other than "ses" then the service names will vary.
            • 3. Re: Invalid username or password when trying to start/stop SES
              JimG
              damorgan,

              Sounds about right. We strive to stay two full releases behind.
              • 4. Re: Invalid username or password when trying to start/stop SES
                JimG
                Roger,

                Yes, the option is in the help menu, however it didn't work. Cmd window opens some text scrolls by (too fast to read) then it closes. Web site still fails to open. The start menu option really runs the searchctl.bat file with the parameter startall. Executing that manually from the command prompt, allows me to see the error I posted at the top of the thread.

                So next I tried your manual steps. The first two processes were already running. When I try to enter sqlplus as sysdba I get insufficient privileges.

                I went with the assumption that the db was already started so I then started the OracleSESOC4J Service, but I still can't open the website.
                • 5. Re: Invalid username or password when trying to start/stop SES
                  Roger Ford-Oracle
                  It's done funny things with the formatting there so I'm not sure what you actually entered. You can't do
                  sqlplus / as sysdba
                  You must do
                  sqlplus sys/password as sysdba
                  Where password is the SES admin password

                  Does that help at all?
                  • 6. Re: Invalid username or password when trying to start/stop SES
                    JimG
                    Your directions were fine.
                    The only admin account I have is eqsys, not sys. And this account was able to connect to the Admin page last week before the server restart.

                    I entered
                    sqlplus eqsys/[pwd] as sysdba
                    It returns:

                    SQL*Plus: Release 10.1.0.5.0 - Production on Wed Dec 21 08:04:01 2011

                    Copyright (c) 1982, 2005, Oracle. All rights reserved.

                    ERROR:
                    ORA-01031: insufficient privileges


                    Enter user-name:

                    If I insetad enter
                    sqlplus eqsys/[pwd]
                    It connects just fine (but doesn't have sysdba privlege).
                    So, of course if I enter
                    SQL> startup

                    I get
                    ORA-01031: insufficient privileges

                    Edited by: 903593 on Dec 21, 2011 8:12 AM
                    • 7. Re: Invalid username or password when trying to start/stop SES
                      Roger Ford-Oracle
                      You can't NOT have a sys account.

                      You will have sys, system and eqsys. Only sys can run sqlplus if the database isn't started, and only using "sys/password as sysdba".

                      However, if eqsys is able to connect, the database is probably started. I would still recommend doing as I said though.

                      Once the database is started you can try just

                      searchctl start ( not startall ). It should prompt you for a password.
                      • 8. Re: Invalid username or password when trying to start/stop SES
                        JimG
                        Hmm... I only have eqsys at this point. I'll have to dig through the notes for the other two.

                        Connected to sql as eqsys and entered start, I was not prompted for a password. It just immediately returned with the SQL> prompt

                        Update:
                        Oops I misread the previous post.

                        I ran
                        searchctl.bat start
                        I was not prompted for a password.
                        It returned
                        The OracleSESOC4J service is starting.
                        The OracleSESOC4J service was started successfully.

                        Still can't connect to the website, and when I look at services OracleSESOC4J is not running.

                        Edited by: 903593 on Dec 21, 2011 9:46 AM

                        Edited by: JimG on Dec 21, 2011 10:54 AM
                        • 9. Re: Invalid username or password when trying to start/stop SES
                          JimG
                          As I said earlier, OracleServiceSES and OracleSESTNSListener were both already started.

                          When I start OracleSESOC4J, it looks like it starts, however if I wait about 10 seconds, and refresh the Services dialog, it shows that it is not running.

                          Just for fun I stopped the other two services as well, and restarted in the correct order. Same issue with OracleSESOC4J. It appears to start just fine, but after 10 seconds or so, refreshing the dialog shows that it's not running.
                          • 10. Re: Invalid username or password when trying to start/stop SES
                            Roger Ford-Oracle
                            The password is - or should be - the same for eqsys, sys and system.

                            Sorry, you're right, "searchctl start" doesn't prompt for a password.

                            If the service starts but then stops again something has probably caused it to crash. Check the logfile in

                            <ses_installation_dir>\oc4j\j2ee\OC4J_SEARCH\log\oc4j.log
                            • 11. Re: Invalid username or password when trying to start/stop SES
                              damorgan
                              Unfortunately your organization is not alone. My recommendation to practitioners of the dark arts is to keep their skills current.

                              While you can not force your employer to upgrade ... you can upgrade your resume by finding a job with an organization that values their employees and demonstrates it by working with fully supported hardware and software.
                              • 12. Re: Invalid username or password when trying to start/stop SES
                                JimG
                                Now we're gettings somewhere, thanks Roger.

                                I see this pattern over and over in the log file ever since the reboot on Friday.

                                11/12/16 19:26:25 oracle.hooks: Loading extensions
                                11/12/16 19:26:25 oracle.hooks: Loading extension class: oracle.oc4j.extensions.CreateStartupCheckpointFile with arguments: startoc4jwaitfile
                                11/12/16 19:26:54 Error initializing server: Unable to start HTTP-Server. default-web-site configuartion may not be valid.
                                11/12/16 19:26:55 Fatal error: server exiting

                                Edited by: JimG on Dec 21, 2011 1:00 PM
                                • 13. Re: Invalid username or password when trying to start/stop SES
                                  JimG
                                  damorgan,

                                  After losing my job with a startup that tried to stay on the leading edge, but did a horrible job keeping it's income & expenses in some kind of reasonable balance, I'm happy to be with an organization that shows it values it's employees by making payroll on a timely basis even if my desktop is still running XP and I'm maintaining classic ASP websites.
                                  • 14. Re: Invalid username or password when trying to start/stop SES
                                    Roger Ford-Oracle
                                    Note sure what would cause that. Can you post the contents of the following two files:
                                    <ses_install_dir>\oc4j\j2ee\OC4J_SEARCH\config\http-web-site.xml
                                    and
                                    <ses_install_dir>\oc4j\j2ee\OC4J_SEARCH\config\data-sources.xml

                                    Make sure that any server names listed look correct.

                                    You might also want to run
                                    lsnrctl status
                                    from a command prompt and check that the service name there matches the service name in the SESConnectionPool towards the end of data-sources.xml.
                                    1 2 Previous Next